Performance Investigator (PI) is showing only old data but no new collected data. The following error appears in the dashboard:
---
Failed to execute SQL: SELECT SUM(wait_configuration) AS sum_wait_configuration, SUM(cpu_time) AS sum_cpu_time, SUM(wait_system_io) AS sum_wait_system_io, SUM(wait_other) AS sum_wait_other, SUM(wait_commit) AS sum_wait_commit, SUM(wait_network) AS sum_wait_network, SUM(active_time) AS sum_active_time, SUM(wait_queueing) AS sum_wait_queueing, SUM(executions) AS sum_executions, SUM(wait_user_io) AS sum_wait_user_io, SUM(elapsed_time) AS sum_elapsed_time, SUM(wait_cluster) AS sum_wait_cluster, SUM(wait_concurrency) AS sum_wait_concurrency, SUM(wait_scheduler) AS sum_wait_scheduler, SUM(wait_administrative) AS sum_wait_administrative, SUM(wait_application) AS sum_wait_application, MIN(sample_starttime) AS min_sample_starttime, MAX(sample_endtime) AS max_sample_endtime FROM spiora_instance_stat_fact_1m_201810220600 WHERE sample_starttime BETWEEN ? AND ? AND instance_key = ? Param: [2018-10-22 08:00:00.000+0200, 2018-10-22 08:48:08.891+0200, 17] Connection Details: PostgresProfile: host [egsrvu081.company.ds.inet], port [5029], database [spioracle-3a021c3e-9b01-48f4-bfc5-2c7a5c488f4e], user [postgres] Cause: ERROR: relation "spiora_instance_stat_fact_1m_201810220600" does not existPosition: 758 Error Code: 0 SQL State: 42P01
---
When looking at the table listing in the PI repository database the table mentioned in the error does not exist.
After creating the table manually, the error comes up with another table name.
The DBSS-SPIRepository or DBO-SPIRepository agents have one of the following ASP settings configured.
spirpRunRepManager=0
and/or
spirpEnable=0
Run the following script to activate the repository manager. Before running the script, make sure the correct host name has been entered in line: agent_name="";
Here the script:
configService = server.get("ConfigService");
agentService = server.get("AgentService");
agent_name=""; // for example: DBO-SPIRepository-myHost.com
def modifyAgentPropertiesPrimary() {
def primary = configService.getAgentInstancePrimaryAsp(agent.getAgentNamespace(), agent.getTypeId(), agent.getId());
primary.setValueByString("spirpEnable", "true");
primary.setValueByString("spirpRunRepManager", "true");
println("spirpEnable:"+primary.getBoolean("spirpEnable"));
println("spirpRunRepManager:"+primary.getBoolean("spirpRunRepManager"));
configService.saveConfig(primary);
}
def getAgentByName() {
agents = agentService.findByName(agent_name);
if ((agents != null) && (agents.size() > 0)) {
return agents.get(0);
} else {
return null;
}
}
agent = getAgentByName();
if (agent != null){
modifyAgentPropertiesPrimary();
} else {
return "Agent '" + agent_name + "' not found" ;
}
return true;
In the logfiles the following should appear after the script ran:
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center