Cleanup Submitted tasks fails with error Invalid object name 'tasksession12_5'.

Document ID : KB000129221
Last Modified Date : 13/03/2019
Show Technical Document Details
Question:
When running a scheduled task for 'Cleanup Submitted tasks' it fails with an error "Failed to execute CleanupSubmittedTasksEvent. ERROR MESSAGE: Invalid object name 'tasksession12_5'." The Cleanup Submitted task runs without issue if invoked manually. IM 14.2 JBoss EAP 6.4 Windows 2016
Environment:
CA Identity Manager R14.X
Answer:
In this section of the documentation is exaplains that if the Task Persistence and Archive are both on different databases,
then you should uncheck the Cleanup via Stored Procedure Box

It is exaplined below in the documentation

https://docops.ca.com/ca-identity-manager/14-1/EN/administrating/system-management/cleanup-submitted-tasks/cleanup-submitted-tasks-tab

User-added image