Getting error ("QUEST_SC_MSSQL_INSTANCE_STAT_FACT" is not a constraint when upgrading Performance Analysis for SQL Server
Please run the upgrade.sql script against the Performance Analysis for SQL Server Repository database that is in the attached winzip file and then the post_install.sql script.
Then please re - start the PA Agent Installer for Performance Analysis for SQL Server 7.0.
If the above does not resolve your issue, then please contact Quest Support.
If the 7.0.206 LSI was used when the QUEST_SC_MSSQL_INSTANCE_STAT_FACT error was encountered, the manual upgrade scripts will work; however, an alternative to running the upgrade sql manually is to run the upgrade using the latest LSI version (7.0.207 or above) as this issue is fixed in the latest release.