Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

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.

Troubleshooting: Summary View Drill-Down displays with Oracle databases

Updated on September 20, 2019

Summary

On the Drill Down tab of the Summary View form, you can specify a property that is not exposed as a column in the corresponding database table.  This does not make the summary view rule invalid. However, if the PegaRULES database for the system is supported by Oracle, this can result in a blank display for the drill down list.

This article explains how to debug and correct the problem.


 

Analysis

If any of the properties specified on the Drill Down tab of a Summary View form is not exposed as a column in the targeted database table or view, then the resulting system-generated SQL specifies:

SELECT * FROM ...

--rather than, for example:

SELECT BaseAmount as "BaseAmount" ... FROM etc.

In an Oracle database environment, "Select * " returns to the clipboard property names in UPPERCASE LETTERS.  Because those do not match the properties specified in the Drill Down tab of the Summary View form, the resulting drill down report display is blank.

Suggested Approach

  1. Compare properties specified in the Drill Down tab with properties exposed in the targeted database table or view. 
  2. Identify any that are not exposed as columns in the table or view. 
  3. Either delete references to the properties not exposed as database columns from the Drill Down tab, or update the database structure to expose those columns. 

The result will be generated SQL that selects the property/column by name rather than through wildcard syntax -- and the drill down display will contain the expected results.

Tags

Pega Platform 7.1.1 - 7.4 Reporting Financial Services Healthcare and Life Sciences Insurance Communications and Media Government Healthcare and Life Sciences Consumer Services Consumer Services Manufacturing Consumer Services

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us