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
For Oracle
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();
Quest Support and Development recommend always making a backup of the current Foglight installation and database prior to execution of any scripts that may modify it.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center