IBM Support

A stored procedure error occurs after upgrading an Oracle database for IBM Business Process Manager (BPM) V7.5.1

Troubleshooting


Problem

A compile error for the LSW_ERASE_TASK stored procedure occurs within the Oracle database after you upgrade it from IBM Business Process Manager Version 7.5.0.x to Version 7.5.1

Symptom

In addition to the compilation error for the LSW_ERASE_TASK stored procedure, you see the following exception when you try to delete the process instances in the Process Inspector view:

java.sql.SQLException: ORA-06550: line 1,
column 7: PLS-00905: object PCS.LSW_BPD_INSTANCE_DELETE is invalid
ORA-06550: line 1, column 7: PL/SQL: Statement ignored

This problem does occur for an Oracle database that is created with new database scripts that are generated for new IBM Business Process Manager Version 7.5.1 profiles.

[{"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Migration","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.5.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSFTBX","label":"IBM Business Process Manager Express"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Migration","Platform":[{"code":"PF016","label":"Linux"},{"code":"","label":"Linux zSeries"},{"code":"PF033","label":"Windows"}],"Version":"7.5.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in 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 Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
28 April 2025

UID

swg21578872

Page Feedback