Question
Intact Financial Corporation
CA
Last activity: 21 Aug 2018 8:31 EDT
Pre-requisites for Pega Purge/Archive process
Hi
I am looking to understand pre-requisites of Pega Purge process. I read Pega v7.2.2 Help documentation but looking to get more information around:
1. Steps to follow when planning purge in production environment. E.g. full database backup prior to running purge etc.
2. Can purge be run concurrently along with users using application? Or is this a process to be run during application maintenance window when no users are online?
3. In case purge encounters a failure, would the process exit or continue? What action is required for database consistency?
Appreciate your help in providing your recommendations on the above.
Thanks,
Naveen
Pegasystems Inc.
IN
Intact Financial Corporation
CA
Hi
Thanks for your detailed response. Regarding your response for taking no DB backup required in case of Purge/Archive, could you also provide recommendation when only Purge process is being planned. I understand that if we are running just Purge then the archive to zip folder process is not performed. In such case do you recommend full database backup prior to running Purge?
Thanks
Tata Consultancy Services
IN
Hi Naveen,
1) You don't need to take a DB backup as during the process of purge and archive all the cases will get archived to a zip folder and purge will happen only once the archive folder gets created. You need to make sure the settings mentioned in below config are properly updated.
2) As purge and archive process have a huge dependency on DB tables, its always suggested performing this activity during the off hours else there might be a chance of occurring performance issues.
3) In case of failure scenarios, enable debug on this key activity Rule_Obj_Activity.ProcessConfig.PegaAccel_Management_Archival.Action to get more information as stated below in logs.
In general the failure scenario occurs if a parent case has 2 child case references, but during the purging process if the respective child case entry is not found in DB, then it is considered to be a failure case and the system will not purge that case and proceed with the next case as per the criteria provided.
Incase if there is no clue you are getting from the logs, you can raise an SR to GCS for further investigation.