https://community.qlik.com/t5/Talend-Studio/How-to-update-table-with-tDBOutput/m-p/2348767#M115845 first link tdbCommit_1 with a "on subjob Ok" link.<BR /> Fri, 13 Jul 2018 09:54:22 GMT fdenis 2018-07-13T09:54:22Z https://community.qlik.com/t5/Talend-Studio/How-to-update-table-with-tDBOutput/m-p/2348764#M115842 <P>Hello,</P> <P>&nbsp;</P> <P>I tried to update data from a postgreSQl database using tDBOutput method and I have a mistake when I run the job.</P> <PRE>L'élément du batch 0 UPDATE "public"."places" SET "expiration_date" = 2015-12-31 00:00:00.000000 +01:00:00 WHERE "null" = FRREGI_72 a été annulé. Appeler getNextException pour en connaître la cause. caused by: ERROR: column "null" does not exist</PRE> <P>Can you help me please.</P> Thu, 12 Jul 2018 12:20:13 GMT https://community.qlik.com/t5/Talend-Studio/How-to-update-table-with-tDBOutput/m-p/2348764#M115842 Anonymous 2018-07-12T12:20:13Z https://community.qlik.com/t5/Talend-Studio/How-to-update-table-with-tDBOutput/m-p/2348765#M115843 can you add print screen of your component? Thu, 12 Jul 2018 14:22:29 GMT https://community.qlik.com/t5/Talend-Studio/How-to-update-table-with-tDBOutput/m-p/2348765#M115843 fdenis 2018-07-12T14:22:29Z https://community.qlik.com/t5/Talend-Studio/How-to-update-table-with-tDBOutput/m-p/2348766#M115844 <P>I think I may have a problem with the connection. Because when I restarted the job few hours later it's worked but today I have the same mistake for an insertion.</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="insertion" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LzGF.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154315i587C1B3F7362E083/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LzGF.png" alt="0683p000009LzGF.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">insertion</SPAN></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="update" style="width: 986px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lyss.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/135491i602BBF1ACDA5EB13/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lyss.png" alt="0683p000009Lyss.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">update</SPAN></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="update" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LzGK.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/137714iE49F5CAEB21DCCC2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LzGK.png" alt="0683p000009LzGK.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">update</SPAN></SPAN></P> Fri, 13 Jul 2018 09:42:07 GMT https://community.qlik.com/t5/Talend-Studio/How-to-update-table-with-tDBOutput/m-p/2348766#M115844 Anonymous 2018-07-13T09:42:07Z https://community.qlik.com/t5/Talend-Studio/How-to-update-table-with-tDBOutput/m-p/2348767#M115845 first link tdbCommit_1 with a "on subjob Ok" link.<BR /> Fri, 13 Jul 2018 09:54:22 GMT https://community.qlik.com/t5/Talend-Studio/How-to-update-table-with-tDBOutput/m-p/2348767#M115845 fdenis 2018-07-13T09:54:22Z https://community.qlik.com/t5/Talend-Studio/How-to-update-table-with-tDBOutput/m-p/2348768#M115846 <P>Thanks it's working</P> Fri, 13 Jul 2018 12:41:49 GMT https://community.qlik.com/t5/Talend-Studio/How-to-update-table-with-tDBOutput/m-p/2348768#M115846 Anonymous 2018-07-13T12:41:49Z