SQL PI dashboard stuck / frozen when loading Activity Highlights (4226878)

When entering the PI dashboard page the performance hangs with no changes when the Activity Highlight view is the default loaded view.

An auto-Thread Dump may be generated on the FMS.

The FMS must be restarted to clear the hanging threads.

An error message similar to the following may be found in the database agent log files

CAUSE 1

Activity Highlights spawn redundant threads to query same data from PI repository several times, this could cause some blocking.

CAUSE 2

The host name could not be resolved correctly by the JDBC driver.

RESOLUTION

Workaround

1. Navigate to Dashboards | Configuration | Definitions | All Definitions
   
2. Search "Activity Highlights Tab Container - New", then click Edit.
3. Select “Context” tab, and check checkbox “Evaluate Once” for progress
   
4. Then Save the change.

Note: The Cartridge Developer role may be necessary to make changes to this view.