Cannot run OOTB reports since joining tables
SummaryWhen joining two tables in OOTB summary views, error shown on running those views.
Error MessagesThere 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 CauseThe 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.
Published December 12, 2016 - Updated December 14, 2016