Found duplicate records in table [cmdb_ci_hardware] using fields [name],Too many other errors,Abandoning processing payload item '{"className":"dscy_switchport","values":{"discovery_source":"ServiceNow","mac_address":"70:01:b5:04:b9:b1","port_number"

[Nilanjan1]

Hello All, 

I have a query, during a discovery of a IP switch I faced a CI Identification error. The error is defined as follows, can someone please help on this urgently? 

"Found duplicate records in table [cmdb_ci_hardware] using fields 
[name],Too many other errors,Abandoning processing payload item 
'{"className":"dscy_switchport","values":{"discovery_source":"ServiceNow","mac_address":"70:01:b5:04:b9:b1","port_number":"456","interface_name":"Port-channel1","name":"Port-channel1","type":"53","interface_number":"5001",
"sys_class_name":"dscy_switchport","status":"1"}}', 
since its depends on payload item"

[Ashutosh Munot1]

HI,

Have you check the duplicate relationship on dscy_switchport table for that CI.

Thanks,
Ashutosh

[Akshata jamdar]

Hello Nilanjan,

What is the CI identification criteria you can find the record only with unique identifier.

Regards,

Akshata

[Ashutosh Munot1]

HI,

Check 

dscy_switchport for duplication relationship.

Thakns,
Ashutosh

[Nilanjan1]

Thank you Ashu, but what I need to look into it I checked for Duplicate of could not find any...Attached screenshot for your reference. 

[Ashutosh Munot1 · Accepted solution]

HI,

Try this:

https://hi.service-now.com/kb_view.do?sysparm_article=KB0696156

When i carefully see your error message the duplicate is in cmdb_ci_hardware table so run the script mentioned in this knowledge article which will remove your duplicate and help you.

Thanks,
Ashutosh