Direct links to fixes
APAR status
Closed as program error.
Error description
You observe the system becomes unresponsive due to an SQL query that exceeds the maximum SQL size limit. You may see stack trace like the following in log file. 00000594 EJBWorkflowMa E com.lombardisoftware.server.ejb.workflow.EJBWorkflowManagerBean doResumeWorkflowEngine An exception occurred in Service Flow with name "Get Tasks". Details: org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [SELECT DEFINITION_VERSION_ID, INSTANCE_VERSION, JDATA FROM BPM_SHARED_OBJECT_INSTANCE WHERE (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?)) OR (DEFINITION_VERSION_ID=? AND INSTANCE_VERSION=(SELECT MAX(INSTANCE_VERSION) FROM BPM_SHARED_OBJECT_INSTANCE WHERE DEFINITION_VERSION_ID=? AND INSTANCE_VERSION>?))]; DB2 SQL Error: SQLCODE=-101, SQLSTATE=54001, SQLERRMC=1, DRIVER=4.26.14; nested exception is com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-101, SQLSTATE=54001, SQLERRMC=1, DRIVER=4.26.14 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator. doTranslate(SQLStateSQLExceptionTranslator.java:105) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTra nslator.translate(AbstractFallbackSQLExceptionTranslator.java:73 ) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTra nslator.translate(AbstractFallbackSQLExceptionTranslator.java:81 ) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTra nslator.translate(AbstractFallbackSQLExceptionTranslator.java:81 ) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate. java:660) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.ja va:695) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.ja va:727) . . . Caused by: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-101, SQLSTATE=54001, SQLERRMC=1, DRIVER=4.26.14 at com.ibm.db2.jcc.am.b7.a(b7.java:815) at com.ibm.db2.jcc.am.b7.a(b7.java:66) . . . com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-101;54001;1, DRIVER=4.26.14 at com.ibm.db2.jcc.am.b7.a(b7.java:815) at com.ibm.db2.jcc.am.b7.a(b7.java:66) . . . PRODUCTS AFFECTED IBM Business Automation Workflow
Local fix
Problem summary
No additional information is available.
Problem conclusion
A fix is available or will be available that assures the SQL queries are executed in chunks so it does not exceed the limit by running a single query for all SBOs involved in a running process.
Temporary fix
Comments
APAR Information
APAR number
JR63452
Reported component name
BUS AUTO WORKFL
Reported component ID
5737H4100
Reported release
J00
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-03-17
Closed date
2021-06-02
Last modified date
2021-06-02
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
BUS AUTO WORKFL
Fixed component ID
5737H4100
Applicable component levels
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS8JB4","label":"IBM Business Automation Workflow"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"19.0.0.1"}]
Document Information
Modified date:
20 August 2021