New parameters for garbageCollectTaskPersistence in IM 12.6.8

book

Article ID: 76596

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal

Issue/Introduction

Customers upgrading to Identity Manager 12.6.8, who are running the garbageCollectTaskPersistence stored procedure manually, will encounter the following error

Procedure or function 'garbageCollectTaskPersistence' expects parameter '@task_limit', which was not supplied. [SQLSTATE 42000] (Error 201).

Environment

IDM 12.6.8 and higher

Resolution

You can set both parameters as an empty string and get the purge to execute: 

@task_limit = '' 
@totalTasks = '' 

If you do want to take advantage of these two new required parameters, this is how those parameters are used: 

Task limit is a number that would limit the number of tasks that would get archived. It's useful mainly when you don't know the volume of tasks that qualify (which at times can be millions), and you want to limit the amount of resources the DB was need over this. So you'd say, for example, 10000, meaning after it cleans up 10k tasks it would stop even though there are more qualified transactions under your criteria. The total tasks parameter is an output parameter - when a task gets archived it increases this by one and when it's completed you'd get Total Tasks output saying how many transactions got cleaned up. Please let me know if you have further questions in this thread. IDM 12.6.8