I am facing the error
java.lang.Exception:An unexpected error occurred. while trying to insert the data into CRM dynamics. for specific columns.
when i am loading the data excluding the id columns(which are causing issues,i assume) it is working fine.
Could any one please help me out here what are the reasons causes this issue. java.lang.Exception:An unexpected error occurred.
Thanks in Advance.
Are you talking about GUID?
If so, I think (not a Dynamics user) this field cannot participate to an insert operation as it is auto-calculated by Dynamics to ensure unicity.
What you are stating is true and applies to columns identified as identifiers ..the issue I have come across is fo columns that are defined as "EntityName" or recordtypes referencing an entity record - for example transactioncurrencyid
Thanks for your time !
Could you please indicate on which build version you got this issue?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Take a look at this technical overview video of Talend API Designer
Find out how to get started with APIs