"No agents found to be configured with SQL PI" in SQL PI dashboard (PI is paused) (4310869)

The PI dashboard does not show any data/agents that were previously configured. The dashboard only displays:

No agents found to be configured with SQL PI. To configure SQL PI go to the Database Administration | SQL Performance Investigator

Even after recreating a PI repository database the data is still not displayed

According to the log files the agents are working fine, no errors can be found.

The database agent contains a hidden parameter called spiecPaused which is being used to pause the PI activity of the database agent. 

WORKAROUND

Agent Status Property variables

The following ASP values can be review in the SQL Server and Oracle agent log files. A value of '1' indicates that the agent is paused or disabled.

For SQL Server

• paecEnable
• paecPaused

For Oracle

• spiecEnable
• spiecPaused

Unpause Script

The following script can be run from the script console in the FMS to unpause the SQL PI monitoring.

def out = new StringBuilder();
def agentService = server.get("AgentService");
def configService = server.get("ConfigService");
def agents = [];
agents.addAll(agentService.findByAdapterAndType("FglAM", "DB_SQL_Server"));
for (agent in agents) {
    def primaryASP = configService.getAgentInstancePrimaryAsp(agent.getAgentNamespace(), agent.getTypeId(), agent.getId());
    if (primaryASP && primaryASP.getBoolean("paecEnable")) {
         primaryASP.setValueByString("paecPaused", "0");
         configService.saveConfig(primaryASP);
         out.append(String.format("%s %s\n", agent.getRemoteClientId(), agent.getName()));
    }
}

agents.clear();
agents.addAll(agentService.findByAdapterAndType("FglAM", "DB_Oracle"));
agents.addAll(agentService.findByAdapterAndType("FglAM", "DB_Oracle_RAC_Instance"));
for (agent in agents) {
     def primaryASP = configService.getAgentInstancePrimaryAsp(agent.getAgentNamespace(), agent.getTypeId(), agent.getId());
     if (primaryASP && primaryASP.getBoolean("spiecEnable")) {
          primaryASP.setValueByString("spiecPaused", "0");
          configService.saveConfig(primaryASP);
          out.append(String.format("%s %s\n", agent.getRemoteClientId(), agent.getName()));
}
}

return out.toString();