Troubleshooting: Summary View Drill-Down displays with Oracle databases
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
- Compare properties specified in the Drill Down tab with properties exposed in the targeted database table or view.
- Identify any that are not exposed as columns in the table or view.
- 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.