Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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

  1. Customize CSR summary reports by joining with another table.
  2. Login to the system and launch CSR Manager portal. 
  3. Open ‘Analytics’ tab in the portal. 
  4. Now click on any reports by joining it with another table. 
  5. 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.

 

Suggest Edit

Published December 15, 2016 - Updated December 2, 2021

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us