Troubleshooting
Problem
Performance of a BPD or service is impacted by the growth of data in BPM database tables: LSW_BPD_INSTANCE, LSW_TASK, LSW_SNAPSHOT, and LSW_PO_VERSION
Symptom
You notice slower performance on a business process or a service. You might even detect lock timeout exceptions when trying to lock a bpd instance
Caused by: com.lombardisoftware.core.TeamWorksException:
PreparedStatementCallback; bad SQL grammar [SELECT BPD_INSTANCE_ID FROM
LSW_BPD_INSTANCE WHERE BPD_INSTANCE_ID = ? FOR UPDATE]; nested exception
is java.sql.SQLSyntaxErrorException: ORA-02049: timeout: distributed
transaction waiting for lock
The lock timeout exceptions vary depending on the database server being used.
For IBM DB2, SQLState, a lock timeout error is SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 68
For Oracle, a lock timeout error is the ORA-02049 error.
For Microsoft SQLServer, a lock timeout error is com.microsoft.sqlserver.jdbc.SQLServerException: Lock request time out period exceeded.
Document Location
Worldwide
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSFPJS","label":"IBM Business Process Manager"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5;8.6","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Type":"SW","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS8JB4","label":"IBM Business Automation Workflow"},"ARM Category":[{"code":"a8m50000000CcSSAA0","label":"Process and Service Engine-\u003EBPD Engine-\u003EPerformance-\u003EProcess Performance"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]
To view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
28 April 2025
UID
ibm10882776
Manage My Notification Subscriptions