search cancel

"Server was unable to processrequest. ---> System.Exception: insert into snmpqlProfiles" error message is seen when trying to rediscover or refresh a router and/or in the WatchdogLog causing SNMP polling to fail for devices and Watchdog System Status.


Article ID: 3968


Updated On:


CA Network Flow Analysis (NetQos / NFA)


WatchDog and/or SNMP Polling of Routers may fail with the Errors below despite using the correct SNMP Community string and verifying SNMP connectivity between all devices.

The WatchdogLogXXXX-XX-XX.log shows errors similar to the one below:

Processes - Error getting SNMP processes list :
System.Web.Services.Protocols.SoapException: Server was unable to process
request. ---> System.Exception:
insert into snmpqlProfiles (
snmpqlProfilesUserName, snmpqlProfilesContext,
snmpqlProfilesAuthProtocol, snmpqlProfilesAuthPassword,
snmpqlProfilesPrivProtocol, snmpqlProfilesPrivPassword)
values ('profileId=44444',2,161,'1trilli0n42','',0,0,'',0,'') --->
System.Data.Odbc.OdbcException: ERROR [IM003] Specified driver could not be
loaded due to system error 126 (RedPoint SnmpQL Driver).

Rediscovering or Refreshing Routers in the Enable Interfaces screen will throw the following error:

<Please see attached file for image>

Figure 1

<Please see attached file for image>

Figure 2

<Please see attached file for image>

Figure 3



RA 9.0


This is due to incorrect or missing registry settings on the RA console server and the Harvester servers if you are receiving this when trying to rediscover/refresh devices in a distributed architecture.

To fix this follow the steps below.

  1. Run "regedit" to open your registry editor

  2. Go to one of the following registry paths on the RA console and each Harvester server if you are using a distributed architecture.

    • On 32 bit Operating Systems go to:

    • On 64 bit Operating Systems go to:

  3. Check to make sure the following values are set and not missing.

    Also make sure they are set correctly to the path that matches the actual paths to the bin directly and DLL file below.

    **Note that the paths may be different if you installed to a non-default drive or path**

    DIIDirectory with data=D:\netqos\proxyservices\bin
    DLLDirectory with data=D:\netqos\proxyservices\bin
    Driver with data=D:\netqos\proxyservices\bin\odbcsnmp.dll

    <Please see attached file for image>

    src="/servlet/servlet.FileDownload?file=0150c000004AKSrAAO" alt="Figure 4" width="650" height="259">

  4. Once the changes are made, recycle services and test the WatchDog settings and Rediscovering routers again.

    It may be necessary to reboot in some cases for the changes to take effect.


1558708515525000003968_sktwi1f5rjvs16r4b.gif get_app
1558708513568000003968_sktwi1f5rjvs16r4a.gif get_app
1558708511572000003968_sktwi1f5rjvs16r49.gif get_app
1558708508291000003968_sktwi1f5rjvs16r48.gif get_app