Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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