Unable to get incidents for UIM alarms

[MADANRAJ SIVAGNANAM]

For Alarm Id: QH77790515-47366 incident creation failed in CASDM with error:{"Error":{"ErrorCode":154,"ErrorMessage":"Exception occurred during operation Get objects .- this is the error message seen for hub

[MADANRAJ SIVAGNANAM]

Hi all ,

Please respond quickly a we are unable to get the incident for UIM alarm .


rl in POST :: [http://localhost:50338/ca-nim-sm/api/v2/Incident]rl in POST :: [http://localhost:50338/ca-nim-sm/api/v2/Incident]Dec 05 14:26:00:964 [pool-32-thread-3, sdgtw] payload/Content-Length :: 1099Dec 05 14:26:00:964 [pool-32-thread-3, sdgtw] payload for create is{"rowId":"","affectedCIID":"chclplcommrestore02","affectedServiceCIID":"","affectedCIName":"","affectedServiceName":"","assigneeUserID":"","description":"Alarm from chclplcommrestore02 : Total cpu is now 85.85%, which is above the warning threshold (80%).Top Processes [clBackup[27181]-(208.00%)];[clBackup[27182]-(190.00%)];[cvfwd[2537]-(5.20%)];[[kswapd0][62]-(0.40%)];[[rcu_sched][9]-(0.10%)]","impact":"MultipleGroups","name":"Total cpu above warning threshold","priority":"MEDIUM-LOWPriority","severity":"HDMgrEscalation","status":"","urgency":"Quickly","ticketID":"","ticketType":"","assigneeCompany":"","assigneeGroup":"ServiceDesk","assigneeGroupId":"","category":"","subCategory":"","ciType":"","closedByUserID":"","creationUserID":"","customProperties":[],"impactedUserContactPhone":"","impactedUserFirstName":"","affectedEndUserID":"","impactedUserLastName":"","impactedUserLocation":"","impactedUserOrganization":"","incidentType":"","reportedByUserID":"","resolution":"","resolutionFixType":"","resolvedByUserID":"","originatingID":"","templateID":"","tenantID":"","updatedByUserID":""}Dec 05 14:26:00:964 [pool-32-thread-3, sdgtw] :: Going to get output stream on this connection ::Dec 05 14:26:03:310 [pool-32-thread-3, sdgtw] responseCode :: [500] response message :: [Internal Server Error]Dec 05 14:26:03:311 [pool-32-thread-3, sdgtw] Error while calling the createIncident of 'nimClient'java.lang.Exception: {"Error":{"ErrorCode":154,"ErrorMessage":"Exception occurred during operation Get Objects Using Filter","DetailErrorMessage":"Error fetching: AHD03053:Bad where clause: Parse error at : \"name='chclplcommrestore02' and tenant.name=''\" (Attr not found or not atomic)","HTTPResponseCode":"INTERNAL_SERVER_ERROR","HTTPResponseCodeValue":500}}
at com.ca.integration.normalization.client.HttpRequestHandler.parseResponse(HttpRequestHandler.java:182) at com.ca.integration.normalization.client.HttpRequestHandler.submit(HttpRequestHandler.java:93) at com.ca.integration.normalization.client.HttpRequestHandler.post(HttpRequestHandler.java:75) at com.ca.integration.normalization.client.NIMRestClient.create(NIMRestClient.java:106) at com.ca.integration.normalization.client.NIMRestClient.createIncident(NIMRestClient.java:223) at com.nimsoft.probe.gateway.sdgtw.AlarmEventProcessor.processAlarmEvent(AlarmEventProcessor.java:229) at com.nimsoft.probe.gateway.sdgtw.AlarmEventProcessor.run(AlarmEventProcessor.java:116) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745).Retrying create incidentDec 05 14:26:06:240 [attach_clientsession, sdgtw] Into onMessageDec 05 14:26:06:240 [attach_clientsession, sdgtw] Processing an event from the queue 'tickets'Dec 05 14:26:06:240 [attach_clientsession, sdgtw] ALARM UPDATEDec 05 14:26:06:240 [attach_clientsession, sdgtw] currentTicketDetails : IN PROGRESS$CASDMDec 05 14:26:06:240 [attach_clientsession, sdgtw] old Severity: alarmId : incidentId

[Kathy Maguire]

Madanraj -

From the posted log we see that you are encountering the following error:

Error fetching: AHD03053:Bad where clause: Parse error at : \"name='chclplcommrestore02' and tenant.name=''\" (Attr not found or not atomic)","HTTPResponseCode":"INTERNAL_SERVER_ERROR","HTTPResponseCodeValue":500}}

This is addressed in the following Knowledge Document:

KB139411 : sdgtw 2.20 submits a bad SOAP query to CA SDM - breaking ticket integration

Open a support case to get a copy of the sdgtw hot fix that addresses this issue.

------------------------------
Kathy Maguire
Technical Support Engineer 4
Broadcom
------------------------------