Network Management

Good afternoon, currently all devices have stopped polling via SNMP.

From the imcnetresdm log, I see that the problem is that a constant error occurs 2023-08-21 02:54:18.360 [ERROR (3127)] [THREAD(1148)] [CQvDBConnADP::executeSQL] Execute "insert into tbl_iproute_change_history(dev_id, dev_ip, ifindex,change_type, description, create_at) values(658,'172.22.255.128',700,3,'Device(IP: 172.22.255.128) decrease route destination(IP: 172.22.5.92), next hop(IP: 172.22.4.109 ), ifindex: 700.',convert(datetime,'2023-08-21 02:52:25',120))" failed, errorMsg: Invalid object name 'tbl_iproute_change_history'.

I also add a log. Please correct my actions and provide information on the tbl_iproute_change_history table. Possible solutions.

Attachment(s)

IMC 21.08.2023.txt   26 KB 1 version

Hello,

Which iMC version are you running? This would be helpful to figure out if you run into a known issue.

Is there any reason to suspect the SQL error beyond it being the latest error in the log? It refers to a missing table related to IP Route change history but I doubt that is relevant to iMC being able to poll devices.

I'd look at errors like the following as relevant instead:

2023-08-21 02:54:17.955 [ERROR (2013)] [THREAD(7664)] [CRefreshDev::updateDevCfgOrStatus] processConfigPollSimple error, and devID is 17725, devIP is:172.20.28.101

In this case you could investigate why iMC cannot poll via SNMP. Does an SNMP Settings Test from iMC on the devices work? Could something like a Firewall have turned on and be blocking the traffic? What does a packet capture on iMC show?

Good afternoon, for now the issue was resolved by restarting IMC and syncing the devices. The possibility of surveying devices due to additional software from the server where IMC is deployed was successfully tested. Before the restart, the SNMPv3 account template was verified successfully, but the device status remained Unknown. Attempts to synchronize the devices did not give results.
In the event of a repeat of the situation, I will definitely provide a traffic dump, the situation was critical, so it is currently unavailable...
Next, in the imcnetresdm log, there is only a repetition of the tbl_iproute_change_history entry until the restart.
If possible more details about tbl_iproute_change_history where it should be in the SQL architecture. Her features?
I also provide version iMC PLAT 7.3 (E0708P03).

2023-08-21 02:54:17.955 [ERROR (2013)] [THREAD(7664)] [CRefreshDev::updateDevCfgOrStatus] processConfigPollSimple error, and devID is 17725, devIP is:172.20.28.101

Hi UpEnemy,

you may have to open a support case as this type of issue requires in-depth analysis of packet traces.