Table does not exist error generated by ProcessPurging agent
The ProcessPurging agent, which runs on a daily basis, generates an SQLSyntaxErrorException. The agent deletes the Data-BatchOutPRXX classes and their corresponding BatchOutPRXX tables.
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
Steps to Reproduce
- Run a few campaigns.
- Check the existence of the generated Data-BatchOutPRXX class, where XX is the Program ID (typically represented as P-XX during the campaign run).
- Check if the ProcessPurging Agent of the PegaMKT-Engine ruleset is enabled.
- Allow the agent to run at its scheduled time. Check the logs from the Agent execution timestamp.
Lack of exception handling by the ValidateDeleteInternal activity. This occurred because the table was deleted first and subsequently the class during instance count checking.
Apply HFix-37511 to resolve this issue for Pega 7.2.2.