Transform Map - 800 Error code

[Ruchi19]

Any one has any idea about the 800 Error Code in Transform Maps?
I get this error while running the Transform Maps in Import Sets application?

[narendrand]

Coalesce empty field is unchecked here.

[Mike Allen]

If you have it unchecked, you are saying that you will always pass a coalesce value, or update a record and not insert.   Your error is that you are not passing the coalesce value, or trying to insert.   To use the same transform map for insert and update, that has to be checked.

[narendrand]

Thanks for your response Mike.

FYI-after this transform map runs I have seen 373 records where inserted, 3188 records where updated, 2981 records where ignored and 24 records where skipped....these skipped records only having that error code 800. My question here is, you said like if we have this checkbox unchecked means it wont allow to insert new records but here we are having 373 new records. Could you please clarify me on this

Cheers,

Narendran.D

[narendrand]

Hi Mike,

I am also having one more doubt here,   please share me the details why usually the records will get Ignored during transform map.

Thanks & Appreciation in Advance

Cheers,

Narendran.D

[Mike Allen]

Unfortunately, I don't have the answers for these things.   It has always baffled me a little why the transform skips things, inserts things, ignores things, etc.   Sometimes it seems random.   My best advice is to go into Transform History and Transform Errors under System Import Sets and see what was skipped and try to understand why on a case-by-case basis.