Target Record is empty during Import Process
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2020 12:33 PM
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.
- Labels:
-
Scripting and Coding

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2020 01:02 PM
Yeah. That can give you insights.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2020 12:44 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2020 12:49 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2020 01:00 PM
When importing, disable Business rules and run the import and see if you are still facing the issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2020 01:05 PM
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.