Support Article
Cannot run OOTB reports since joining tables
SA-31302
Summary
When joining two tables in OOTB summary views, error shown on running those views.
Error Messages
There was a problem getting a list: code: 904 SQLState: 42000 Message: ORA-00904: "op"."PXOBJCLASS": invalid identifier
Steps to Reproduce
- Customize CSR summary reports by joining with another table.
- Login to the system and launch CSR Manager portal.
- Open ‘Analytics’ tab in the portal.
- Now click on any reports by joining it with another table.
- Showing an error message.
Root Cause
The developer wants to display Access Group, User Name and Operator Id in all the reports. Tables(summary_views of the OOTB) access the OOTB pr_operators table to display these columns.
While running the summary view they are facing an exception.
Using join for the same OOTB summary views causes the same error in out in-house system. Found that for Ageing reports there is problem with 'getContentAgeing' activity where we missed to add join function in JAVA step.
And regarding other reports(Summary Views), we have different activities used. For example for Quality reports, we have 'getContentQuality' activity. For CAResolutionAnalysis Summary View, we have 'getContentResolutionAnalysisPCA' activity and many other activities for other reports. In some of these activities also the JOIN function was missed.
So corrected the JAVA step to use JOIN function so that the query is properly built.
Resolution
Apply HFIX-30707.
Published December 15, 2016 - 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.