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
Mega Sage

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"
1 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

View solution in original post

9 REPLIES 9

valarmathi_kann
ServiceNow Employee
ServiceNow Employee

Hi Nilanjan,

The error clearly says 'Found duplicate records in table [cmdb_ci_hardware] using fields [name]'

1. You could check the 'CI Identifier' on the hardware table on what basis a hardware CI is identified.

2. Check the hardware table if there are duplicate 'name' in the hardware CI. 

3. Check the i/p payload from pattern to see if the Identification engine payload has duplicate 'name'.

4. you could find the identification engine payload from 'HorizontalDiscoveryProbe' 

Hello Valar, 

 

1. You could check the 'CI Identifier' on the hardware table on what basis a hardware CI is identified.

Screenshot from CI Identifier Attached for your reference. 

2. Check the hardware table if there are duplicate 'name' in the hardware CI. 

DO you mean is there any rule ?

3. Check the i/p payload from pattern to see if the Identification engine payload has duplicate 'name'.

There is no duplicate entry

4. you could find the identification engine payload from 'HorizontalDiscoveryProbe' 

Akshata jamdar
Mega Guru
Hello Nilanjan,
 
 
While discovery, it founds the record with similar details in it which is already present in [cmdb_ci_hardware]
as hardware is a parent of IP switch class so ci identification rules will applied to all child class if is written on parent.
 
Now what exactly you want to do with this record? It will not going to create or update the existing record.
 
 
Hope this will helps.



Kindly mark an answer as correct and helpful if it will resolve your query.

Regards,

Akshata
 

 

Hello Akshata, 

 

I want to Update the record....? It is has already been discovered. But I am not able to identify the device with its name.