ORA-00904: "PXOBJCLASS": invalid identifier on data table open
SummaryDatabase error in pega logs due to accessing of blocked rules.
ORA-00904: "PXOBJCLASS": invalid identifier , ORA-00942: table do not exists
Steps to Reproduce
Root CauseA 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.
Published February 20, 2017 - Updated February 21, 2017