Failed to execute clean up submitted task manually

Products

• CA Identity Manager

Issue/Introduction

Failed to execute archiveTaskPersistence with ERROR MESSAGE: Invalid object name 'tasksession12_5

Environment

Identity Manager 14.4 and 14.5

Cause

This is due to running the script archive_crossdb_sqlserver.sql on the wrong DB 

Resolution

Run the script archive_crossdb_sqlserver.sql on Archive DB instead of TP DB.

 

Additional Information

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