Transform Maps - unable to insert data into table

[Paul125]

Hello - I am importing data from a SQL server so I created a Data Source and everything working fine until pulling the data into import set table. When I test load 20 records I can see the data in the import table. but I just mapped a string field but transform maps unable to create a single record. I make sure this record doesn't exist in table. Also, Coalesce is false. I don't know if I am missing something here but I can't even insert a single record.

[SanjivMeher]

Any errors in the import log?

[Paul125]

Here is history Sanjiv.

[SanjivMeher]

It should show error in the import log, if there was an error. 

If you see, even the ignored record is 0. So if you had a record in that import set, it should have at least set ignored to 1. So I assume, there is an error, or may be there is some onInsert Business rule on the target table which is restricting it from inserting the record. Also make sure both import set table and target table are in same scope.

[Paul125]

I thought of Business Rule but I tried this on multiple table but still doesn't work. Thanks for looking into this.

[Paul125 · Accepted solution]

Figured out: https://hi.service-now.com/kb_view.do?sysparm_article=KB0563963