An error similar to the following appears in a popup when attempting to add the SQL PI extension to a database agent
"Failed to enable SQL PI monitoring extension for Oracle agent HOSTNAME-INSTANCE.
Failed to register the monitoring instance INSTANCE to the SQL PI repository on REPOSITORYHOST"
or
"Failed to enable SQL PI monitoring extension for SQL Server agent HOSTNAME-INSTANCE.
Failed to register the monitoring instance INSTANCE to the SQL PI repository on REPOSITORYHOST"
An error similar to the following appears in the Oracle or SQL Server installer log file
THIS SCRIPT WILL DROP ANY HISTORICAL DATA ALREADY IN THE SQL SERVER PI REPOSITORY. PLEASE TAKE A BACKUP OF THE SQL PI REPOSITORY BEFORE RUNNING THIS SCRIPT.
Please run one of the following two scripts in the SQL Server based PI repository to check for and create any of the missing required objects for SQL PI functionality.
