WORKAROUND
For versions below 5.9.7.10, disconnect the PI extensions, delete the SQL PI agents, and then reconnect the PI extensions
- Navigate to the Databases Dashboard
- Select all of the SQL Server agents with the SQL PI extension enabled that require the credential change to the repository
- Select Settings | Administration
- Navigate to the Performance Investigator menu
- Select all of the database agents of this type
- Click the Disable button
- Navigate back to the main databases dashboard
- Repeat steps 2-7 for Azure SQL, Oracle, and MySQL database agents
- Remove the SSAS agents from monitoring
- Navigate to Administration | Agents | Agent Status
- Delete the SPI-Repository, DB_SQL_Server_SPI_Repository, DB_Oracle_SPI_Repository, DB_Azure_SQL_SPI_Repository, and SSAS_SPI_Repository agents for the Agent Managers connected to the SQL PI repository instance.
- Navigate back to the databases dashboard
- Add the SQL PI extension to the database agents using the new connection information and when prompted to choose the schema, use the pulldown list to select the database previously configured to maintain each agent's specific type of data
- Recreate the SSAS agents
STATUS
Enhancement ID FOM-35 was created to add a new Manage PI repositories dashboard beginning in the 5.9.7.10 and higher releases of the database cartridges. Please review KB 322778 for more details on this new dashboard.