Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Table does not exist error generated by ProcessPurging agent

SA-45413

Summary



The ProcessPurging agent, which runs on a daily basis, generates an SQLSyntaxErrorException. The agent deletes the Data-BatchOutPRXX classes and their corresponding BatchOutPRXX tables.


Error Messages



java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist


Steps to Reproduce

  1. Run a few campaigns.
  2. Check the existence of the generated Data-BatchOutPRXX class, where XX is the Program ID (typically represented as P-XX during the campaign run).
  3. Check if the ProcessPurging Agent of the PegaMKT-Engine ruleset is enabled.
  4. Allow the agent to run at its scheduled time. Check the logs from the Agent execution timestamp.


Root Cause



Lack of exception handling by the ValidateDeleteInternal activity. This occurred because the table was deleted first and subsequently the class during instance count checking.


Resolution



Apply HFix-37511 to resolve this issue for Pega 7.2.2.


Suggest Edit

Published December 18, 2017 - Updated December 2, 2021

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us