-
Title
SQL Scanner cannot find Performance Analysis repository; Error: "Object not found" -
Description
Im trying to create a SQL Scanner job to extract SQL statements from the Performance Analysis (PA) repository. Whatever I enter in the job details, the job invariably fails with Object not found.
-
Cause
Wrong database name for the PA repository
-
Resolution
The Scanner can only scan the Quest_Perf_Analysis database. Please make sure the PA SQL statements are all addressed at the Quest_Perf_Analysis database.
For SQL Optimizer version 7.0.0 it is planned to add the feature to choose the database that contains the PA SQL statements. -
Additional Information
Currently in the Release Notes you will find the following paragraph under Unknown Issues:
---
When scanning a SQL repository in Quest Performance Analysis, the SQL Scanner only looks for a database with the name of Quest_Performance_Repository. If another name was used for the SQL Repository database, the Scanner will not find it.
---
This is not correct and the Release Notes will be updated.