Quest has been named as an ASP "Ten Best Web Support Sites" award winner. Learn more.
The user clicks on "Databases | Overview | SQL Performance" and error message appears “Failed to retrieve data from SQL PI repository.”
More details from the error message:
Failed to execute SQL: SELECT SUM(active_time) AS sum_active_time, SUM(cpu_time) AS sum_cpu_time, MIN(sample_starttime) AS min_sample_starttime, MAX(sample_endtime) AS max_sample_endtime FROM pass_unique_stat_fact_1m_201504271800 WHERE sample_endtime >= ? AND sample_starttime <= ? AND instance_key = ? Param: [2015-04-27 13:48:13.012-0600, 2015-04-27 14:48:13.012-0600, 1] Connection Details: PostgresProfile: host [hostname, port , database [spimssql], user [postgres] Cause: ERROR: relation "pass_unique_stat_fact_1m_201504271800" does not exist Position: 170 Error Code: 0 SQL State: 42P01
You need to be signed in and under a current maintenance contract to view premium knowledge articles.