https://community.qlik.com/t5/Talend-Studio/Duplicate-Key-Violation-Handling/m-p/2340974#M108960 <P>I have a job whereby an insert into a non-transactional table throws up duplicate key errors.&nbsp; Clearly, I can handle this with a dedupe of the data before it is loaded but where this does occur I'd like an exception / warning to be thrown and captured so that I can have a message sent to our log server to flag a violation has occured.&nbsp; At the moment it has been silently failing.</P> <P>&nbsp;</P> <P>Any ideas?</P> <P>&nbsp;</P> <P>Thanks</P> <P>Dave</P> Wed, 29 May 2019 15:17:57 GMT Anonymous 2019-05-29T15:17:57Z https://community.qlik.com/t5/Talend-Studio/Duplicate-Key-Violation-Handling/m-p/2340974#M108960 <P>I have a job whereby an insert into a non-transactional table throws up duplicate key errors.&nbsp; Clearly, I can handle this with a dedupe of the data before it is loaded but where this does occur I'd like an exception / warning to be thrown and captured so that I can have a message sent to our log server to flag a violation has occured.&nbsp; At the moment it has been silently failing.</P> <P>&nbsp;</P> <P>Any ideas?</P> <P>&nbsp;</P> <P>Thanks</P> <P>Dave</P> Wed, 29 May 2019 15:17:57 GMT https://community.qlik.com/t5/Talend-Studio/Duplicate-Key-Violation-Handling/m-p/2340974#M108960 Anonymous 2019-05-29T15:17:57Z https://community.qlik.com/t5/Talend-Studio/Duplicate-Key-Violation-Handling/m-p/2340975#M108961 <P>What database are you using and which Talend component to access it?&nbsp; Can you show a screenshot of your job and the details of the database component?&nbsp; Thanks.</P> Fri, 31 May 2019 01:52:18 GMT https://community.qlik.com/t5/Talend-Studio/Duplicate-Key-Violation-Handling/m-p/2340975#M108961 nfz11 2019-05-31T01:52:18Z