Database errors may occur when upgrading TIBCO iProcess Engine version to 11.6.0
Article ID: KB0092869
Updated On:
| Products | Versions |
|---|---|
| TIBCO iProcess Engine (Oracle) | - |
| Not Applicable | - |
Description
Description:
During the upgrade to TIBCO iProcess Engine (iPE) v11.6.0, the uorai115_00_tok.sql script fails with a "PLS-00201: identifier 'DBMS_LOB' must be declared" error.
Symptoms:
Warning: Procedure created with compilation errors.
swpro.migrate_proc_by_procid(ai.proc_id,ai.node_id);
*
ERROR at line 7:
ORA-06550: line 7, column 10:
PLS-00905: object SWPRO.MIGRATE_PROC_BY_PROCID is invalid
ORA-06550: line 7, column 4:
PL/SQL: Statement ignored
Procedure dropped.
dbms_lob.append(dest_lob, ci.uservalue);
*
ERROR at line 17:
ORA-06550: line 17, column 9:
PLS-00201: identifier 'DBMS_LOB' must be declared
ORA-06550: line 17, column 9:
PL/SQL: Statement ignored
Cause:
SWPRO user does not have the EXECUTE permissions for sys.DBMS_LOB.
During the upgrade to TIBCO iProcess Engine (iPE) v11.6.0, the uorai115_00_tok.sql script fails with a "PLS-00201: identifier 'DBMS_LOB' must be declared" error.
Symptoms:
When the uorai115_00_tok.sql script is executed during the upgrade of TIBCO iProcess Engine to 11.6.0, the following error is logged in the uorai115_00-******.tablelog file.
Warning: Procedure created with compilation errors.
swpro.migrate_proc_by_procid(ai.proc_id,ai.node_id);
*
ERROR at line 7:
ORA-06550: line 7, column 10:
PLS-00905: object SWPRO.MIGRATE_PROC_BY_PROCID is invalid
ORA-06550: line 7, column 4:
PL/SQL: Statement ignored
Procedure dropped.
dbms_lob.append(dest_lob, ci.uservalue);
*
ERROR at line 17:
ORA-06550: line 17, column 9:
PLS-00201: identifier 'DBMS_LOB' must be declared
ORA-06550: line 17, column 9:
PL/SQL: Statement ignored
Cause:
SWPRO user does not have the EXECUTE permissions for sys.DBMS_LOB.
Issue/Introduction
Database errors may occur when upgrading TIBCO iProcess Engine version to 11.6.0
Environment
Product: TIBCO iProcess Engine (Oracle)
Version: 11.6.0
OS: All Supported Operating Systems
--------------------
Resolution
Below are the resolution steps -
- Grant the EXECUTE permissions for sys.DBMS_LOB to the SWPRO (iProcess database owner) user
- Perform the upgrade again.
Additional Information
https://community.oracle.com/thread/2171917?tstart=0
http://mahajanrishi.blogspot.com/2009/09/pls-00201-identifier-dbmslob-must-be.html
http://mahajanrishi.blogspot.com/2009/09/pls-00201-identifier-dbmslob-must-be.html
Feedback
Yes
No
Powered by
