Under certain circumstances, PA dashboard pages are not loading correctly. A white page is displayed and the dashboard dropdown list does not load. The server log indicates a NullPointerException.
Steps to Reproduce
Navigate to System Definition > Tables and access the Dashboard Permissions (pa_dashboards_permissions) table.
Filter the list on the sys_id of a dashboard.
In one of the records, in the Type field, replace the existing correct value (1, 2 or 3) with an invalid value, for example, 0 or 10.
- Navigate to Performance Analytics > Dashboards and try opening the altered dashboard.
Note that the incorrect value causes the NullPointerException error.
Create a fix script.
- Navigate to System Definition > Fix Scripts.
- Click New.
- Copy the content of the attached script.
- Define the fix script by completing the fields on the form. (The Name field is required. Run once should be unchecked.)
- Click Submit.
From Related Links, click Run Fix Script.
Invalid referenced roles, groups, users and types in the pa_dashboards_permissions table are identified.
You can manually remove the invalid references based on the displayed sys_ids and tables or edit the script and run it again to remove the invalid references automatically.
To remove the invalid references automatically, in line 4 of the script, change the value of var deleteInvalidRecord from false to true.
If no invalid references are found, the message 'There are no permissions records that contain invalid references' is displayed.
Related Problem: PRB917832