ORA-06550: line x, column y: PL/SQL: Statement ignored.

4 Years Ago
JorgeR
MANAGEMENT CONSOLE

Summary

After restoring an Oracle backup the Bizagi application does not start and the Event Viewer displays errors with code ORA-06550 and PLS-00905.

Applies to

Bizagi Engine 10.x using Oracle Database

Symptoms

After restoring an Oracle backup, the Bizagi application does not start and the Event Viewer displays the a trace like:

ORA-06550: line 1, column 7:
PLS-00905: object BIZAGIGO.SPBA_WFE_GETNEXTASYNCWIFORRUN is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

The affected stored procedure may vary and the failed line and column as well.

Cause

The problem occurs due to some of the stored procedures may have compilation errors. To identify the failing procedure, you may use an Oracle database tool for SQL development.

Solution

1. Run the following procedure in your database

grant execute on sys.dbms_lock to [usrBizagi]

In which, [usrBizagi] is the Bizagi user for the schema

2. Recompile the stored procedures that are failing.

3. Restart Bizagi services and test.


Details

Last Modified:4 Years Ago
Last Modified By: Andread
Type: ERROR
Level: Advanced
Rated 5 stars based on 1 vote
Article has been viewed 19.8K times.

Options