Duplicate CI entry, inserting from Import Set

[prabhur34]

I am inserting CIs using Web Services into Import Set tables. Transform maps is created to insert it in to different CI classes. After insertion, I am seeing a duplicate entry with class type u_computer_historical in the CI table. Refer the screenshot. CI is inserted into Windows Server, but there is a duplicate at the same time.

Anyone has came across this and what is the solution to remove these duplicates?

[prabhur34]

Hi Dave,

I am importing into cmdb_ci_server table. I agree that this will not coalesce.

Below is the extension of tables:

cmdb_ci_server extends Computer extends Hardware extends cmdb_ci

I have done similar insert earlier, where I do not have to add additional scripts/business rules to accomplish this.

[Dubz]

You could import to cmdb_ci and then define the CI class in the transform map, i've not tested so not sure if that would correctly populate the right tables though.

The advantage of having the business rule is that it will cover any manually added CI's as well as those imported.

[prabhur34 · Accepted solution]

Hi Dave,

This worked. I had Script within Transform Map which will define the sub-class of a CI record under cmdb_ci_server.

Initially, target table in Transform Maps was cmdb_ci_server. I updated this to cmdb_ci and left the Script in Transform Maps as it is.

Thanks for the hint!

[Dubz]

Lol ok you're welcome. Here's another hint; try marking correct the answer to your question rather than your response to the answer to your question!

[Jaspal Singh]

Hi Prabu,

Try changing the choice action for the coalesced field to Ignore.