Coalesce error

[naxis alx]

Hello,

I'm using import set to try to update alm_hardware records

Step1:

I import the sheet from the list view. After import with no Asset tag, a BR creates Asset tag. 

After import I set coalesce on Asset tag field

Step1:

I export the records with Asset tag and change some fields

Step3: 

I want to import the sheet with the changes being updated according the coalesce but I 'm getting the following error.

Error: Duplicate Entry - Matching Configuration Item found

This is the sheet I try to import

[mdash]

Hi @naxis alx ,

Can you show the field map for Configuration Item? It is trying to create a CI when it is already there. That might be the cause.

[naxis alx]

Hi @mdash ,

the CI is the one on the image I sent.

For example when I remove the Model category and Model fields, the error moves to Asset tag field that is used s coalesce field.

java.sql.BatchUpdateException: (conn=70730) Duplicate entry 'HWCP-2312-0000026' for key 'asset_tag_2'

It  looks like this is due to the fact those fields (Asset and CI) are in the cmdb_ci_computer but why even though coalesce is set the record is not just updated in Alm_hardware?

[mdash]

It kind of looks like the circular relation issue (CI creates Asset, Asset creates CI> results in duplicate error)

In your transform record, (where you are setting coalesce true for Asset tag), there should be an entry for the configuration item mapping, right? If there is, you can write a script there to glide to the cmdb_ci table and find the CI WHERE Asset is your current asset. Then grab that sys id and map to your Configuration Item field. 

Can you try that?

[reshmapatil]

Hi @naxis alx ,

It might be there is an identification rule running.

Check below link:

https://www.servicenow.com/community/in-other-news/duplicate-configuration-items-in-the-servicenow-c...

Regards,

Reshma

**Please mark my answer correct or helpful based on the impact**