Process and Trigger

Anonymous — Sat, 16 Nov 2024 11:05:09 GMT

Hi All,
I am working on Talend 561 for MDM with Bigdata edition.

I have a requirement in Talend MDM - "To update Timestamp with current date automatically whenever user tries to update a record in MDM UI manually".
I have tried with Before saving process to update a timestamp with current date.
I was able to get the value but it is not getting saved in MDM.

I created a job using tMDMTriggerInput -->txmlmap --> tMDMTriggerOutput --> tlogrow --> tBufferOutput

xml structure in txmlmap
<exchange>
<report>
<Update>
<UserName>xxxxx</UserName>
<Source>genericUI</Source>
<TimeInMillis>1440113141834</TimeInMillis>
<RevisionID>null</RevisionID>
<DataCluster>xxxxx</DataCluster>
<DataModel>xxxxx</DataModel>
<Concept>T_AMA_STATE_CODE</Concept>
<Key>0555</Key>
<Item>
<path>CDE_STUS_CDE</path>
<oldValue>ACTIVE</oldValue>
<newValue>PENDING</newValue>
</Item>
<OperationType>UPDATE</OperationType>
</Update>
</report>
<item>
<T_AMA_STATE_CODE>
<ST_CDE>0555</ST_CDE>
<ST_DESC>DESCRIPTION MISSING</ST_DESC>
<CDE_STUS_CDE>PENDING</CDE_STUS_CDE>
<LAST_UPD_TSTMP></LAST_UPD_TSTMP>
</T_AMA_GENDER_CODE>
</item>
</exchange>

I was able to see the value for LAST_UPD_TSTMP(with currentdate) in mdm server console.
|MDM_Message |<?xml version="1.0" encoding="UTF-8"?>
<exchange><report><Update><UserName>xxxxx</UserName><Source>genericUI</Source><TimeInMillis>1440113141834</TimeInMillis><RevisionID>null</RevisionID><DataCluster>xxxxx</DataCluster><DataModel>xxxxx</DataModel><Concept>T_AMA_STATE_CODE</Concept><Key>0555</Key><Item><path>CDE_STUS_CDE</path><oldValue>ACTIVE</oldValue><newValue>PENDING</newValue></Item><OperationType>UPDATE</OperationType></Update></report><item><T_AMA_STATE_CODE><ST_CDE>0555</ST_CDE><ST_DESC>DESCRIPTION MISSING</ST_DESC><CDE_STUS_CDE>PENDING</CDE_STUS_CDE><LAST_UPD_ID>xxxx</LAST_UPD_ID><LAST_UPD_TSTMP>2015-08-20</LAST_UPD_TSTMP></T_AMA_STATE_CODE></item></exchange>|

But when I try to save in MDM, It is giving following exception
"The Validation process did not return the expected message, the record was not saved."

Can any one let me know the solution for this?

Thanks
Silpa

Re: Process and Trigger

Anonymous — Tue, 25 Aug 2015 08:11:23 GMT

Hi Silpa,

[color=#1f497d][font=Verdana, Helvetica, Arial, sans-serif]We saw that your topic has been resolved by yourself. If it is fixed, would you mind sharing your solution with us?[/font][/color]

[color=#1f497d][font=Verdana, Helvetica, Arial, sans-serif]Best regards[/font][/color]
[color=#1f497d][font=Verdana, Helvetica, Arial, sans-serif]Sabrina[/font][/color]

Re: Process and Trigger

_AnonymousUser — Fri, 25 Nov 2016 07:46:32 GMT

Can you please tell me how did you add the output_item in the before save process.?

topic Process and Trigger in Talend Data Catalog

Process and Trigger

Re: Process and Trigger

Re: Process and Trigger