Support Article
Unable to install a hotfix using Hotfix Manager
SA-59761
Summary
Unable to install a hotfix using the Hotfix Manager.
Error Messages
Last SQL: {call DATA2.sppc_data_uniqueid (?,?,?,?)}
java.sql.SQLException: ORA-06550: line 1, column 16:
PLS-00905: object DATA2.SPPC_DATA_UNIQUEID is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Steps to Reproduce
Run the Hotfix Manager.
Root Cause
A defect or configuration issue in the operating environment.
The environment was restored from the database backup using database tools. During restoration, the schema name was remapped from DATA to DATA2. The database tools remapped the signature of stored procedures, triggers, etc. However, nothing was remapped within the object body.
In this usecase, the stored procedure sppc_data_uniqueid had references within the body that included the old schema name. These references must be updated to reference the new schema name.
Resolution
Make the following change to the operating environment:
Modify the stored procedure body to update all references where DATA must be DATA2 instead.
For example,
Modify the below,
Select pyLastReservedID into tpyLastReservedID from DATA.pc_data_uniqueid where pzInsKey = tpzInsKey for update;
to,
Select pyLastReservedID into tpyLastReservedID from DATA2.pc_data_uniqueid where pzInsKey = tpzInsKey for update;
Published February 15, 2019 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.