Identity Manager archiveTaskPersistence Error: Invalid object name 'tasksession12_5'

Products

• CA Identity Manager
• CA Identity Suite

Issue/Introduction

When manually executing a cleanup of submitted tasks using the archiveTaskPersistence command, the process fails with the following error: ERROR MESSAGE: Invalid object name 'tasksession12_5'

This issue typically occurs when the Task Persistence and Archive databases are configured separately and the required cross-database script has not been applied to the correct instance.

Environment

• Product: CA Identity Manager
• Releases: 14.4, 14.5, 14.5.1

Cause

The archive_crossdb_sqlserver.sql or archive_crossdb_oracle.sql script was either not executed or was executed on the Task Persistence (TP) database instead of the Archive database.

Resolution

To resolve the invalid object error, the cross-database script must be applied to the Archive database:

1. Locate the archive_crossdb_sqlserver.sql or archive_crossdb_oracle.sql under the <IM_Tools>/db/taskpersistence/
2. Connect to your Archive Database instance using a SQL management tool.
3. Execute the archive_crossdb_sqlserver.sql or archive_crossdb_oracle.sql script against the Archive DB.
4. Once completed, retry the task cleanup process from the Identity Manager User Console.

 

 

Additional Information

Follow the instructions from Cleanup Submitted Tasks Tab on how to run the archive_crossdb_sqlserver.sql script.