Support Article
ORA-00942: table or view does not exist
SA-45693
Summary
ORA-00942 error in the PegaRULES log file when executing the 'ProcessPurging' agent.
Error Messages
Last SQL: select count (*) as "pyCount" from PEGA_MKT.BatchOutPRTest11 where pxObjClass = 'Data-BatchOutPRTest11'
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
Steps to Reproduce
Run the ProcessPurging agent.
Root Cause
A defect in Pegasystems’ code or rules.
Resolution
Apply HFix-37145.
Tags:
Published December 17, 2017 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.