Symantec IGA

  • 1.  Reset task persistence database

    Posted 12-06-2018 10:56 AM
    CA Identity Manager14.
    IAM Framework400.
    Patch LevelCP-IM-140200-0002


    With the system task named "Cleanup Submitted Tasks" I'm not able to reset (to empty completely) the TP database.

    Is there any SQL statement or procedure to accomplish that result?




  • 2.  Re: Reset task persistence database

    Posted 12-06-2018 11:40 AM

    Hi Gabriele


    There is a procedure that archive the data from task persistence to the archive database. I used these procedures on version 12.6.2:

    Stuck In Progress Tasks / Events & Garbage Collection 


    I don't know if in version 14.2 will work, but you can try this in a non-production environment, or, you can open a support case, they sent it to me when I needed it.


    Kind regards,


    Gustavo Viggiano

  • 3.  Re: Reset task persistence database

    Posted 12-06-2018 11:51 AM

    It is important to know that there are some RDBMS structural changes from 12.6 to 14.2 for Task Persistence. Please review the scripts against the SQL/DDL to ensure that all the items are covered.

  • 4.  Re: Reset task persistence database
    Best Answer

    Broadcom Employee
    Posted 12-07-2018 05:32 AM


    If purpose is to completely empty the Task Persistence db tables then I guess the easiest way is to recreate them through the script (Microsoft SQL Server: C:\Program Files\CA\Identity Manager\IAM Suite\Identity\tools\db\taskpersistence\sqlserver\idm_db_sqlserver.sql) used to install them in separate database.


    refers to IM Guide

    Run the SQL Scripts - CA Identity Manager - 14.2 - CA Technologies Documentation 


    best regards