Hello all,
I have been trying to use the spath command correctly to create a pie chart divided by type of errors received. When I create the search and click on the object, the field where the error message is, it's in JSON format. Looks like this:
/XXX/projects/Sales_PostSales_processPostSaleOrder_VIP_CCT:{
"Service":"Enterprise Sales",
"Date":"09/11/2017 10:48:35.947",
"Environment":"XXX",
"Debug":"Error",
"Source":"PostSalesIntegration",
"Description":"Error::processPostSaleOrder_VIP_CCT. Error occurred while trying to process the message. {resultType=FAILED, postsalesId=null, message=Error Message: Upsert failed. First exception on row 0; first error: REQUIRED_FIELD_MISSING, Required fields are missing: [LastName]: [LastName]\n\nError Stack Trace: Class.CctDataloadServices.processRestRequest: line 239, column 1\nClass.CctDataloadServices.ProcessRestRequest.processRequest: line 62, column 1\nClass.CommonService.executeRequest: line 118, column 1\nClass.CommonService.doPost: line 37, column 1, contactId=null, accountId=null}",
"Message_Unique_Id":null,
"Message_qualifier":null,
"JMSMessageID":null,
"Detail":{
"error":{
"message":{
"resultType":"FAILED",
"postsalesId":null,
"message":"Error Message: Upsert failed. First exception on row 0; first error: REQUIRED_FIELD_MISSING, Required fields are missing: [LastName]: [LastName]\n\nError Stack Trace: Class.CctDataloadServices.processRestRequest: line 239, column 1\nClass.CctDataloadServices.ProcessRestRequest.processRequest: line 62, column 1\nClass.CommonService.executeRequest: line 118, column 1\nClass.CommonService.doPost: line 37, column 1",
"contactId":null,
"accountId":null
},
"reason":null,
"resolution":null
}
},
"stacktrace":{
"tracking":null,
"error":{
"resultType":"FAILED",
"postsalesId":null,
"message":"Error Message: Upsert failed. First exception on row 0; first error: REQUIRED_FIELD_MISSING, Required fields are missing: [LastName]: [LastName]\n\nError Stack Trace: Class.CctDataloadServices.processRestRequest: line 239, column 1\nClass.CctDataloadServices.ProcessRestRequest.processRequest: line 62, column 1\nClass.CommonService.executeRequest: line 118, column 1\nClass.CommonService.doPost: line 37, column 1",
"contactId":null,
"accountId":null
}
}
}
and the field for this object is titled "msg".
The specific error message I want is in Detail.message.
Right now I have:
index="ips_snaplogic""postsales" lvl="ERROR"| spath| timechart by "msg.Detail.error.message.message"
I'm just not getting anywhere with this. I hope my question is clear. Can anyone help?
Thank you
... View more