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.
Wrong database name for the PA repository
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.
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.