2447912 - PI CBMA alerts - Unable to write job information to database

• You have configured Component Based Message Alerting (CBMA) in your Process Integration (PI) or Process Orchestration (PO) system
• The alerts are not being sent to the mail clients as would be expected
• In the NWA -> Operations-> Jobs -> Java Scheduler - AlertConsumerJob has several different statuses; UNKNOWN; ERROR; STARTING and RUNNING (as well as COMPLETED);
• In the defaultTrace, you can see entries like:
  Unable to write job information to database. Job 'AlertConsumerJob' not queued.
  com.sap.sql.exception.OpenSQLException: DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011, SQLERRMC=null, DRIVER=4.19.26
  OpenSQLExceptionCategories: [NON_TRANSIENT, DB_ADMINISTRATOR_REQUIRED]
  at com.sap.sql.exception.SQLExceptionFactory.createOpenSQLException(SQLExceptionFactory.java:167)
  at com.sap.sql.exception.SQLExceptionFactory.wrapChainedSQLException(SQLExceptionFactory.java:72)...
  ...Caused by: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011, SQLERRMC=null, DRIVER=4.19.26

• SAP enhancement package 1 for SAP NetWeaver 7.3
• SAP NetWeaver 7.4
• SAP NetWeaver 7.5

Process Integration 7.0, PI 7.0, PI 7.01, PI 7.02, Process Integration 7.10, PI 7.10, Process Integration 7.11, PI 7.11, Process Integration 7.30, PI 7.30, Process Integration 7.31, PI 7.31, Process Orchestration 7.4, PI 7.4, PO 7.4, Process Orchestration 7.5, PI 7.5, PO 7.5, XI, AEX, SQL0964, tlogs, DB2, DB6, IBM , KBA , BC-XI-ALR-CBA-JAV , Java , BC-NWA-XPI , Process Integration (PI) Monitoring , Problem