Data import issue

[nareshTT]

Hello ,

I am trying to import Records in cmdb_ci_computer table ( fresh new records)  using "Load Data" functionality. But i am able to import is successfully. Then i run transform and it is also shows successful. But when i check record it never gets inserted in the target table . Error is Unable to resolve target record, coalesce values not present: serial_number  and error code is 800. I have serial number in my template. Not sure why system is not detecting it. Could you please share your thoughts on it? 

Thanks.

[Ankur Bawiskar]

@nareshTT 

what's the state of that import set row? Is it Inserted or Ignored?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[nareshTT]

Hello Ankur,

system shows it as  ignored. 

Thanks. 

[Ankur Bawiskar]

@nareshTT 

then it won't get inserted or updated

Did you check coalesce is on which field and if the record found in target table with same coalesce value then if all the fields are with same value as that of source?

if yes then it will be marked as ignored as there is nothing to update.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[nareshTT]

Hello Ankur,

I am trying to insert new record. coalesce is set on serial number and i am providing data in for this column. Hence there is no question of that record will exists in Target table i.e. computer. 

Thanks.