Database errors may occur when upgrading TIBCO iProcess Engine version to 11.6.0

Database errors may occur when upgrading TIBCO iProcess Engine version to 11.6.0

book

Article ID: KB0092869

calendar_today

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:

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.

Environment

Product: TIBCO iProcess Engine (Oracle) Version: 11.6.0 OS: All Supported Operating Systems --------------------

Resolution

Below are the resolution steps - 

- Restore the file system and database back to the version prior to the upgrade 
- Grant the EXECUTE permissions for sys.DBMS_LOB to the SWPRO (iProcess database owner) user 
- Perform the upgrade again.

Issue/Introduction

Database errors may occur when upgrading TIBCO iProcess Engine version to 11.6.0

Additional Information

https://community.oracle.com/thread/2171917?tstart=0
http://mahajanrishi.blogspot.com/2009/09/pls-00201-identifier-dbmslob-must-be.html

Powered by Wolken Software