Unable to Run Task Persistence Cleanup Task: ORA-06550: line 1, column 7: PLS-00905

Products

• CA Identity Suite

Issue/Introduction

When trying to run the TP cleanup, we receive the following error:

Failed to execute CleanupSubmittedTasksEvent. ERROR MESSAGE: ORA-06550: line 1, column 7: PLS-00905: object EBCIJMS.GARBAGECOLLECTTASKPERSISTENCE is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored

 

Environment

Release : 14.4

Component : CA IDENTITY SUITE (VIRTUAL APPLIANCE)

Cause

The corrupt stored procedure needs to be recompiled.

Resolution

The errors do indicate that, at the least, the GARBAGECOLLECTTASKPERSISTENCE stored procedure is corrupt. I'm not sure how or when the corruption occurred. Regardless, the stored procedure(s) needs to be recompiled.

The scripts for the stored procedures are included in the task persistence DB creation script located in the Tools folder of the IM windows tools.

/opt/CA/IdentityManager/IAM_Suite/IdentityManager/tools/db/taskpersistence/oracle9i

The script is "idm_db_oracle.sql."

To recompile, grab the stored proc sql code from idm_db.oracle.sql and run it like this, for example: