Error Invalid object name cmpl_tasksession12_5

book

Article ID: 101837

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal

Issue/Introduction

To manage runtime tasks effectively, CA Identity Manager 14.0 introduces a new type of tables named Completed Task Session tables. From CA Identity Manager release 14.0 onward, any new tasks that have reached the Completed state are moved to the new Completed Task Session tables by an automated server process. The automated server process is a background process that is periodically invoked, checks for completed data and if found, moves the data to the Completed Task Session tables.

When invoking the cleanup task in CA Identity Manager 14.1 the task may fail with an error:  Failed to execute CleanupSubmittedTasksEvent - Invalid object name cmpl_tasksession12_5

<Please see attached file for image>

Failed to execute CleanupSubmittedTasksEvent - Invalid object name cmpl_tasksession12_5
 

Environment

CA Identity Manager 14.1 CP1 - CP4

 

Resolution

The Move Completed tables feature was completely dropped in the cumulative patch 5 (CP5) as this feature causes tasks to go into progress.

Attachments

1558698988336000101837_sktwi1f5rjvs16jkv.png get_app