Direct links to fixes
APAR status
Closed as program error.
Error description
If a thousand or more timers are scheduled for the same date and time, a concurrency problem might occur in a clustered environment due to lock contention on the DB that results in a CWLLG0592E error. This problem might cause event manager tasks to be in state 2, meaning that they are ignored until the cluster restarts. [2/24/15 0:00:21:377 CET] 000000ad WSRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are: "". [2/24/15 0:00:21:378 CET] 000000ad WSRdbXaResour E DSRA0302E: XAException occurred. Error code is: XAER_NOTA (-4). Exception is: [jcc][t4][2041][12326][4.11.69] Error executing XAResource.rollback(). Server returned XAER_NOTA. ERRORCODE=-4203, SQLSTATE=null [2/24/15 0:00:21:378 CET] 000000ad XATransaction E J2CA0027E: An exception occurred while invoking rollback on an XA Resource Adapter from DataSource jdbc/TeamWorksDB, within transaction ID {XidImpl: formatId(57415344), gtrid_length(36), bqual_length(54), and [2/24/15 0:00:21:380 CET] 000000ad wle E CWLLG0592E: An exception occurred while executing task. org.springframework.dao.ConcurrencyFailureException: PreparedStatementCallback; SQL [ SELECT CURRENT TIMESTAMP, T.TASK_ID, T.SCHEDULED_TIME, CASE WHEN T.SCHEDULED_TIME > CURRENT_TIMESTAMP THEN T.SCHEDULED_TIME ELSE CURRENT_TIMESTAMP END AS DT, T.DISCRIMINATOR, T.DESCRIPTION, T.TASK_EXECUTION_CLASS, T.TASK_ARGUMENTS_STR, T.TASK_ARGUMENTS, T.IN_CLOSING_TRANSACTION, CASE WHEN (BC.IS_BLACKED_OUT = 1 OR CURRENT TIMESTAMP >= BC.NEXT_START) THEN 1 ELSE 0 END, T.BLACKOUT_CALENDAR_ID, T.BLACKOUT_BEHAVIOR, T.QUEUE_ID, T.RE_EXECUTE_COUNT, T.REPEAT_STRING, K.KEYWORD FROM ((LSW_EM_TASK T LEFT OUTER JOIN LSW_EM_TASK_KEYWORDS K ON T.TASK_ID = K.TASK_ID) LEFT OUTER JOIN LSW_BLACKOUT_CALENDAR BC ON T.BLACKOUT_CALENDAR_ID = BC.CALENDAR_ID) WHERE T.TASK_OWNER = ? AND T.TASK_ID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ,?,?,?,? ,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ]; DB2 SQL Error: SQLCODE=-911, SQLSTATE=40001, SQLERRMC=2, DRIVER=4.11.69; nested exception is com.ibm.db2.jcc.am.SqlTransactionRollbackException: DB2 SQL Error: SQLCODE=-911, SQLSTATE=40001, SQLERRMC=2, DRIVER=4.11.69 at org.springframework.jdbc.support.SQLExceptionSubclassTranslator. translate(SQLExceptionSubclassTranslator.java:52)
Local fix
Stop and restart the AppTarget cluster.
Problem summary
The problem occurs wherever there is a problem with the database while event manager acquires and tries to load event manager tasks.
Problem conclusion
A fix is available for IBM BPM that handles the exception properly and ensures the event manager reloads the event manager tasks later. On Fix Central (http://www.ibm.com/support/fixcentral), search for JR53006: 1. Select IBM Business Process Manager with your edition from the product selector, the installed version to the fix pack level, and your platform, and then click Continue. 2. Select APAR or SPR, enter JR53006, and click Continue. When you download fix packages, ensure that you also download the readme file for each fix. Review each readme file for additional installation instructions and information about the fix.
Temporary fix
Not applicable
Comments
APAR Information
APAR number
JR53006
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
850
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-04-02
Closed date
2015-06-02
Last modified date
2015-11-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
BPM STANDARD
Fixed component ID
5725C9500
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
31 August 2023