topic Re: tMDMOutput cannot insert records when i check 'Is Update' in Talend Data Catalog

tMDMOutput cannot insert records when i check 'Is Update'

Anonymous — Mon, 07 Apr 2014 16:02:49 GMT

When i check the 'Is update' , it gives me an exception when i try to insert new records .
The exception is : cannot update document ... with id ... because it does not exist.

Re: tMDMOutput cannot insert records when i check 'Is Update'

Anonymous — Mon, 07 Apr 2014 16:46:07 GMT

You ticked "Is Update": MDM expects you're updating an existing record. Since MDM can't find the record you wish to update (which is expected in your case since you're creating the record), it throws an exception since "Update" doesn't have the meaning "Update or create".

Re: tMDMOutput cannot insert records when i check 'Is Update'

Anonymous — Mon, 07 Apr 2014 16:53:44 GMT

So how can i implement the update or create ? Do i have to use the tMDMOutput twice ?

Re: tMDMOutput cannot insert records when i check 'Is Update'

Anonymous — Mon, 07 Apr 2014 17:07:43 GMT

True, you should change the logic of your job to separate creations from updates.

Re: tMDMOutput cannot insert records when i check 'Is Update'

Anonymous — Wed, 25 May 2016 15:11:06 GMT

Does the non Primary Key fields get updated at entity level without using any join (tXMLmap)/comparison and just by ticking the IsUpdate option in tMDMOutput component?