Search indexes are not updating automatically for archived work items
I reaching out to the community to see if anyone helps me in fixing an issue with our pega application. Our pega application has two module one utilizes CSHC where as other module doesn't use CSHC but just Pega Platform.
We have archiving(archiving using stored procedures) in place for both the modules, but, the interesting thing here is, whenever a work item is purged and archived, it's no longer visible to search. I mean the search indexing for those cases getting updated automatically.
Where as in other module where we don't use CSHC, whenever a work item is archived, it's search index is not getting update and when we search for the work item in global search, application is finding it, but when it tries to open it to show, throwing an error message saying can't open the object using given inputs.
I have tried running "RecreateIndexesForClass", which didn't help. One other thing, I want to note here, whenever we do full re-index of work items in search landing page, we are not getting that error for so far archived items but still coming for newly archived items.
I really appreciate your help in providing any insights or solutions to the problem.
Is the purge and archive process done exactly the same way for both modules?
Can you provide more specifics as to how exactly the purge and archiving is happening? Is the purging and archiving done using Pega at all, or is it all outside of the Pega application?
If a work object is removed from the its work table, the index doesn't necessarily know that has happened. When you do full reindex, it starts from scratch and so anything not in the table won't be added back in. It is possible to remove entries from the index, so I suspect that CSHC is doing this automatically in some way. Solutions to this may depend on how the purge and archiving is done...
One possibility is to create an agent and activity that will remove items from the index that were or are about to be purged and archived.
Thanks for your response and my apologies for late response as I didn't get any notification saying there is a response to my post.
Yes, purging and archiving is done exactly the same way for both the modules and it's outside of pega, i.e using stored procedures and agents to call them out.
I am not sure if there is any OOTB activity is there that will let you remove these purged and archived work objects. I really appreciate your help and insight into it. Thank you once again for prompt response.