Hi there,
I have a very simple hardware import. It's a Scheduled Data Import and runs each morning at 03:00 a.m..
The data source is a database view of some servers. It's an SQL - JDBC database view.
We have a Transform Map as well, which maps all the source fields to their ServiceNow target fields.
There is a coalesce active at source field "u_name" and target field "name".
Since the 11th of january it happens out of nothing, that some servers (CI, "cmdb_ci_computer") is created again each time this scheduled job runs. I cannot find any cause for now. Someone any ideas about it?
I was looking to the Import Set Log's and when I lookup the created CI (by "SYS_ID"), I see things like here below (please see screenshot 1). As seen, it seems that no "Target Record" can be found, so no coalesce is happening, right? Then the server is inserted as new (please see screenshot 1 and 2).
Screenshot 1:
Screenshot 2:
Screenshot 3 (this server is created 44 times):
Thanks in advance for any ideas!
