Troubleshooting — Reports and charts

Diagnosis

Actions

A report intended to present information about work objects, contains no selected data (or all counts are zero), but the objects for the report were created earlier.

Make sure that the correct application appears in the Application Selector.

Make sure that the Operator ID provides access to the RuleSet versions that make up the application.

Use the Class Explorer to confirm that instances of the work classes exist.

Review class group data instances and the corresponding Database Table instances to confirm that the work objects are mapped to the pc_work table (or to another table with similar columns). 

Diagnosis

Actions

Oracle or SQL errors arise when a user attempts to execute a report.

Make sure that the correct application appears in the Application Selector.

Review class group data instances and the corresponding Database Table instances to confirm that the work objects are mapped to the pc_work table (or to another table with similar columns).

Using the Class Explorer, review a few work objects in the application; confirm that they all have a common owner organization.

Diagnosis

Actions

A report fails with a message "Not a database column."

Make sure that the correct work pool appears in the work pool selector.

Review class group data instances and the corresponding database table instances to confirm that the work objects are mapped to the pc_work table (or to another table with similar columns).

Open and save the list view rule or summary view rule to confirm that all properties that must be exposed as columns are so exposed.

See Troubleshooting — Property not a database column.

Diagnosis

Actions

Oracle or SQL errors arise when a user attempts to execute a report.

Make sure that the correct application appears in the work pool selector before running the report.

Review class group data instances and the corresponding database table instances to confirm that the work objects are mapped to the pc_work table (or to another table with similar columns).

Using the Class Explorer, review a few work objects in the application; confirm that they all have a common owner organization.

Diagnosis

Actions

Cannot render image charts, server is based on UNIX and lacks Java component AWT

Add the option

-Djava.awt.headless=true

to the JAVA_OPTS line in the setenv.bat file, and restart the system.

On UNIX systems with no X11 display confirm that the third-party JAR files pja.jar and pjatools.jar (from eTeks.com) for Pure Java AWT are available to the server. See Pega Developer Network article PRKB-12461 Troubleshooting: Use Pure Java AWT on UNIX hosts to enable chart displays

Diagnosis

Action

The user attempted to run a list view or summary view report but the Access of Role to Objects rules for the user do not allow access to the objects to be reported on.

Open the access group for the Operator ID of the user to identify the access roles it provides (on the Access tab).

Identify the Applies To key part of the list view or summary view report.

Find the Access of Role to Object rule that has the access role as a first key part and the class (or a parent class) as second key part.

Review the Search Instances and Execute Activities fields on this Access of Role to Object rule. Update the rule to enable these operations, or create an additional Access of Role to Object rule that conveys these operations.