Target Record is empty during Import Process

anubhavkapoor76
ServiceNow Employee
ServiceNow Employee

Hi All,

After executing the Transform Map the Import set has "Target Record" set to NULL instead of the description.

This happens for INSERTED records only and not for UPDATED Records.

 

10 REPLIES 10

Yeah. That can give you insights.

asifnoor
Kilo Patron

Hi Anubhav,

Check if the records are created in the target table?

If not, then there could be an error. Check the import log once.

Yes records are created in target table, however one of fields have missing values.

Import log says: total: 245, inserts 14, updates 231, processed 0, ignored 0, skipped 0, errors 0

And those 14 inserted records have that 1 field value missing.

When importing, disable Business rules and run the import and see if you are still facing the issue.

sure let me do that. The missing field is neither there in Field Maps and neither in Transform Script.

So I am suspecting that it should be filled in Business Rules.

I am checking the Business Rules.