Return
-
Title
"No Dimension Activity" can be seen for Oracle RAC agents in SQL PI but the nodes display data -
Description
Using SQL PI with an Oracle RAC instance, displayed "No Dimension Activity" in the instance view of the performance tree and "There is no data to display" in the resource consumption chart.
When accessing the individual nodes, SQL PI is displayed correctly.
-
Cause
Duplicate rows were present in the spiora_instance_dim table of the SQL Server PI repository database used for the Oracle agents caused by a migration issue from the Infobright PI repository into the SQL Server PI repository. -
Resolution
Contact Support to assist with deleting any duplicate rows from the PI repository database.