By accident the SQL PI repository has been removed. After creating a new PI repository on a new server, the agents cannot be assigned to the new repository.
Also, it is not clear which DB agents suppose to be originally linked to a SQL PI repository after a Foglight crash.
First all database agents PI configuration which are still pointing to the old repository needs to be disabled.
If Oracle and SQL Server agents are affected, this step needs to be done twice: Once for all Oracle agents and a second time for all SQL Server agents. First disable ALL agents before re-enabling them.
In addition, there are two groovy scripts attached to the KB in case you need to know which DB agent links to which SQL PI repository.