Support Article
ORA-00904: "PXOBJCLASS": invalid identifier on data table open
SA-33919
Summary
Database error in pega logs due to accessing of blocked rules.
Error Messages
ORA-00904: "PXOBJCLASS": invalid identifier , ORA-00942: table do not exists
Steps to Reproduce
Not Applicable
Root Cause
A defect in Pegasystems’ code or rules .The proposed hotfix will modify the activity pxCountInstances such that before making the DB call for getting count of instances. It will check whether it is internal or external table.If it is internal table the present query will work. If it is external table present query is modified such that where class is removed. By which for all external table separate query is being fired by which error is resolved as well as count is being shown for external table in data table landing page.
Resolution
Apply HFix-31585
Published February 21, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.