Portal User asked a question.
I am looking to troubleshoot some errors we are getting during that data Import / Transform process. For example, how would I troubleshoot this?
Error[SNOW_CMDB] SoftwarePackage transform : createOrUpdateCI failed.ImportSetTransformer (CsvSoftwarePackage
or
Identification and Reconciliation Result: {"items":[{"className":"cmdb_ci_spkg","sysId":"Unknown","identifierEntrySysId":"Unknown","errors":[{"error":"MISSING_MATCHING_ATTRIBUTES","message":"In payload missing minimum set of input values for criterion (matching) attributes from identify rule for table [cmdb_ci_spkg]. Add these input values in payload item '{\"className\":\"cmdb_ci_spkg\",\"values\":{\"discovery_source\":\"SnowSoftware\",\"name\":\"Radeon ProRender MaxPlugin\",\"x_snsab_snow_sam_i_snow_application_id\":\"5a75c17f-d153-4b6a-bd00-09ed9e991615\",\"manufacturer\":\"f3311ef7db483f846402db85ca961941\"},\"internal_id\":\"807a2c45ba6de414e94dc7235434db77\",\"sys_object_source_info\":{\"source_name\":\"SnowSoftware\"},\"settings\":{},\"sys_ire_info\":{\"ire_received_time\":\"2021-01-04 22:34:16\"}}'"},{"error":"ABANDONED","message":"Too many other errors"}],"identificationAttempts":[{"attemptResult":"SKIPPED","identifierName":"Software","attributes":["key"],"hybridEntryCiAttributes":[],"searchOnTable":"cmdb_ci_spkg"}],"errorCount":2,"markers":[],"inputIndices":[0],"mergedPayloadIds":[]}],"additionalCommittedItems":[],"relations":[],"additionalCommittedRelations":[],"logContextId":"087a2c45db6de414961e4d9c13961977"}ImportSetTransformer (CsvSoftwarePackage
Hi @Mark Walther,
Are you generating these errors through the Snow for ServiceNow Connector? Or is this output from a bespoke integration between SLM and ServiceNow?
/F
SNOW for SN Connector. I see these in the Import Status under Errors.
BTW: Also looking at definitions for those Import Status row headers (besides the obvious).
Updates - assuming this is updating an existing record
Inserts - assuming this is inserting a new record that is not already there
Ignored - Not sure what this really means, why would something be ignored?
Skipped - Why would something be skipped?
Errors - Obviously errors, but how do I revolve or further troubleshoot?
Can you confirm if your connector is set up in line with the Snow for ServiceNow Connector user guide? Are all the correct identifiers in place to successfully complate a match between the two systems, the above error contains the following:
MISSING_MATCHING_ATTRIBUTES - In payload missing minimum set of input values for criterion (matching) attributes from identify rule for table [cmdb_ci_spkg]
Yes, that document was used. And it worked perfectly before the 3.3 to 4.0 upgrade.
Thanks for confirming. Did you also use the following "User Guide: Upgrade from Snow for ServiceNow 3.3 to 4.0" and were all the steps followed?
Yes, those mainly focused on removal of the old transforms. The ones ending in _ (underscore). But that was done as well.
The published error relates to ServiceNow Identity and Reconciliation module, so have there been any changes to your ServiceNow instance since you upgraded to Snow for ServiceNow 4.0 Connector?
Hi @Mark Walther,
I have had your error reviewed internally and it would appear that you have not created rules in the ServiceNow Identification & Reconciliation engine to identify Software Packages, instructions to do so are found in the guided setup (Step 2.5 in the guided setup for the CMDB app). Hope this helps.
Hi,
I am having similar problems.
My question is, how can we identify for which device this error log is generated?