oi_connector - alarm reconciliation doesnt work and throws NullPointerException

Products

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

Issue/Introduction

The alarm reconciliation feature of oi_connector (v1.52) doesn’t work and I can see this error message in its log.

The oi_connector works fine except for this issue and  there is no other error in it's log file.

 Integration working fine except for the reconciliation part in oi_connector.

Logs show:

 [attach_socket, oi_connector] Total UIM Open Alarms for Reconciliation Query Execution Time :: 26 Milliseconds..
[attach_socket, oi_connector] java.lang.NullPointerException
    at com.nimsoft.probe.gateway.oi_connector.utils.ResultSetToJsonConvertor.convertToJSON(ResultSetToJsonConvertor.java:51)
    at com.nimsoft.probe.gateway.oi_connector.dao.impl.DBCIDaoImpl.getAllOpenUIMAlarmsForReconciliationForTimeRange(DBCIDaoImpl.java:995)
    at com.nimsoft.probe.gateway.oi_connector.reconciliation.Reconciliation.getUIMAlarms(Reconciliation.java:260)
    at com.nimsoft.probe.gateway.oi_connector.reconciliation.Reconciliation.runForDefaultTenant(Reconciliation.java:107)
    at com.nimsoft.probe.gateway.oi_connector.reconciliation.Reconciliation.run(Reconciliation.java:92)
   at com.nimsoft.probe.gateway.oi_connector.utils.CallbackUtils.cbReconciliation(CallbackUtils.java:95)
    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:225)
    at com.nimsoft.nimbus.NimServerSession$NimServerSessionThread.handleMessage(NimServerSession.java:178)
    at com.nimsoft.nimbus.NimServerSession$NimServerSessionThread.run(NimServerSession.java:123)

This null pointer exception is triggered for each alarm to be processed.

Environment

• DX UIM version 20.4 CU9 integrated with on-prem oi_connector version 23.2

Resolution

oi_connector v1.52T2.zip which is attached to this case.