Cannot open the configuration interface of snmpcollector probe in AC

Products

• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Unable to open the configuration interface of the SNMP collector probe in Admin Console:

Error displayed:

"Remote Request Error: Remote /<uim_domain>/<uim_hub>/<uim_robot>/snmpcollector probe

processing of operation get_ctd_configuration Failed

Please check both the PPM and remote probe log file for additional detail"

Logged error:

Nov 20 09:57:31:857 [Timer-1, snmpcollector] SNMPCollector is ready for operation
Nov 20 09:58:38:463 [attach_socket, snmpcollector] Error while processing getCtdConfigurationCallback
Nov 20 09:58:38:464 [attach_socket, snmpcollector] javax.jdo.JDODataStoreException: Error executing SQL query "SELECT DEVICEID FROM SNMPDEVICE".
    at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:543)
    at org.datanucleus.api.jdo.JDOQuery.executeInternal(JDOQuery.java:388)
    at org.datanucleus.api.jdo.JDOQuery.execute(JDOQuery.java:225)
    at com.nimsoft.probes.network.snmpcollector.database.SnmpDeviceDAO.getAllDeviceIds(SnmpDeviceDAO.java:132)
    at com.nimsoft.probes.network.snmpcollector.ctd.SnmpDeviceHelper.addDevicesToGraph(SnmpDeviceHelper.java:94)
    at com.nimsoft.probes.network.snmpcollector.ctd.GetGraphHelper.getCTDGraphObject(GetGraphHelper.java:165)
    at com.nimsoft.probes.network.snmpcollector.ctd.GetGraphHelper.getCTDGraphString(GetGraphHelper.java:84)
    at com.nimsoft.probes.network.snmpcollector.ctd.GetGraphHelper.getCTDGraph(GetGraphHelper.java:57)
    at com.nimsoft.probes.network.snmpcollector.callback.GetCtdConfigurationCallback.getCtdConfigurationCallback(GetCtdConfigurationCallback.java:156)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at com.nimsoft.nimbus.NimServerSession$NimServerSessionThread.performCallback(NimServerSession.java:216)
    at com.nimsoft.nimbus.NimServerSession$NimServerSessionThread.handleMessage(NimServerSession.java:169)
    at com.nimsoft.nimbus.NimServerSession$NimServerSessionThread.run(NimServerSession.java:123)
NestedThrowablesStackTrace:
org.h2.jdbc.JdbcSQLException: Table "SNMPDEVICE" not found; SQL statement:
SELECT DEVICEID FROM SNMPDEVICE [42102-197]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)

Environment

• UIM version 20.4.x
• Component: snmpcollector v4.04hf1

Cause

• Possibly ppm probe was hung or in a bad state, or there was a temporary database connectivity issue

Resolution

• Restart of the ppm probe on the Primary hub robot resolved the issue