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

book

Article ID: 129221

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal

Issue/Introduction



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

Resolution

In this section of the documentation is explains that if the Task Persistence and Archive are both on different databases,
then you should uncheck the Cleanup via Stored Procedure Box

It is explained below in the documentation

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-identity-and-access-management/identity-manager/14-3/administrating/system-management/cleanup-submitted-tasks/cleanup-submitted-tasks-tab.html

Attachments

1558688906820000129221_sktwi1f5rjvs16fr6.jpeg get_app