2447912 - PI CBMA alerts - Unable to write job information to database | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

Symptom

  • 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

Read more...

Environment

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

Product

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

Keywords

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 , Component-Based Message Alerting Java , BC-NWA-XPI , Process Integration Monitoring , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.