Question Arpit Arora (ArpitA49) Areteans Areteans AU View Profile ArpitA49 Member since 2015 1 post Areteans Posted: Nov 16, 2023 Last activity: Nov 16, 2023 Posted: 16 Nov 2023 1:13 EST Last activity: 16 Nov 2023 1:13 EST Best way to handle Inflight cases on Production for Index Report View translated message Hi, we have created a new Declare Index and used that in join in Report Definition. Now we are deploying it to Production and it's not working for old cases. What is the best way to handle it if we have 2 million cases on Production ? Suggested approach : For now we run a job scheduler in which we use an activity which picks up the old cases, opens it and set the property .pzReIndex to true and then save it. While using this approach we would acquire lock on the case and it should not interfere with cases opened by Production users, so this should be done in offline hours what can be done if our application is Global application ? ( Can we handle by logging those cases on which we did not acquire lock and trying the same later ? ) Any other approach which could be used here as an alternative ***Edited by Moderator Marissa to add Capability tags*** To see attachments, please log in. Pega Platform Case Management Reporting Reply Like (0) Share Share this page Facebook Twitter LinkedIn Email Copy link Copying... Copied!