CMDB Identification Error: Found invalid sys_id in payload. No record with sys_id [XXXXXXXXXX] exist in table [cmdb_ci_server] or is a duplicate record with [duplicate_of] field set to a master CI

[Kavita Kulkarni]

 I am trying to discover is HP c7000 OA Module (should be classified as server) and the ports open for device are 443 (https), 161(SNMP) and 22 (ssh) and 80(http).

Our instance is on Orlando and I am getting the error "CMDB Identification Error: Found invalid sys_id in payload. No record with sys_id [XXXXXXXXXX] exist in table [cmdb_ci_server] or is a duplicate record with [duplicate_of] field set to a master CI"

Server already exist in cmdb_ci_server with the same sys_id mentioned in the error.

I renamed the existing server and rerun Discovery, yet getting the same error. Has anyone seen this error?

[DaveHertel]

Hi -- renaming the server won't help... this issue is likely a duplication issue, based on criteria in the CI identifier rules, most likely serial # dups (I'm guessing)

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

Hope this helps some?

[Kavita Kulkarni]

Thanks Dave for the quick response. I tried with removing duplicate serial number, however it gives same error. Adding Discovery logs:

[DaveHertel]

Check both the serial number field on the CI as well as the cmdb_serial_numbers table (related list to the CI), which can store multiple serial #'s per CI. 

 Take a look at de-duplication tasks too and see if this CI is in there, flagged as a dup.  Since the error implies that's a likely cause "a duplicate record with [duplicate_of] field set to a master CI".  my best guess...

[Ashutosh Munot1]

Hi,

This field duplicate_of is also needs to be cleared out.

Thakns,
Ashutosh