"No Dimension Activity" can be seen for Oracle RAC agents in SQL PI but the nodes display data (4309272)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

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.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title