https://community.qlik.com/t5/Talend-Studio/The-executeUpdate-method-must-not-return-a-result-set/m-p/2375955#M138244 <P>Hello,</P> <P>Is there any update for your issue? Does AFTER UPDATE trigger cause this issue?</P> <P>Best regards</P> <P>Sabrina</P> Tue, 11 Sep 2018 10:49:37 GMT Anonymous 2018-09-11T10:49:37Z https://community.qlik.com/t5/Talend-Studio/The-executeUpdate-method-must-not-return-a-result-set/m-p/2375950#M138239 I am trying to import a csv file into MS SQL. I have a setup the mapping and I am able to insert records successfully. However if the record exists I get the error. The executeUpdate method must not return a result set. In the tMap I am importing the primary key as well and the schema of output table has the primary key defined. In the DBOutput I have specified the Action on data to Insert or update. I am assuming this handles the decision to insert or update based on the primary key being present in the table or not. Is this correct? Sat, 16 Nov 2024 07:52:42 GMT https://community.qlik.com/t5/Talend-Studio/The-executeUpdate-method-must-not-return-a-result-set/m-p/2375950#M138239 Anonymous 2024-11-16T07:52:42Z https://community.qlik.com/t5/Talend-Studio/The-executeUpdate-method-must-not-return-a-result-set/m-p/2375951#M138240 <P>Hello,</P> <P>Could you please also post your tMap component setting screenshot on forum?</P> <P>Best regards</P> <P>Sabrina</P> Wed, 01 Aug 2018 04:44:56 GMT https://community.qlik.com/t5/Talend-Studio/The-executeUpdate-method-must-not-return-a-result-set/m-p/2375951#M138240 Anonymous 2018-08-01T04:44:56Z https://community.qlik.com/t5/Talend-Studio/The-executeUpdate-method-must-not-return-a-result-set/m-p/2375952#M138241 Hi Sabrina, I have attached the tMap screenshot.<BR /><A href="https://community.qlik.com/legacyfs/online/tlnd_dw_files/0683p000009LtBg">tmap.PNG</A> Wed, 01 Aug 2018 19:04:44 GMT https://community.qlik.com/t5/Talend-Studio/The-executeUpdate-method-must-not-return-a-result-set/m-p/2375952#M138241 Anonymous 2018-08-01T19:04:44Z https://community.qlik.com/t5/Talend-Studio/The-executeUpdate-method-must-not-return-a-result-set/m-p/2375953#M138242 <P>Hello,</P> <P>Is there a trigger setting on the table? If so, are you able to change it?</P> <P>Best regards</P> <P>Sabrina</P> <P>&nbsp;</P> Wed, 15 Aug 2018 10:01:30 GMT https://community.qlik.com/t5/Talend-Studio/The-executeUpdate-method-must-not-return-a-result-set/m-p/2375953#M138242 Anonymous 2018-08-15T10:01:30Z https://community.qlik.com/t5/Talend-Studio/The-executeUpdate-method-must-not-return-a-result-set/m-p/2375954#M138243 Hi Sabrina, There are 4 triggers on the table and one of the AFTER UPDATE trigger seems to cause the exception. If I disable that trigger then I do not get this error. There is another AFTER UPDATE trigger that does not cause an issue. I will need to investigate the culprit trigger do find out where the issue arises. Thanks. Fri, 17 Aug 2018 15:33:17 GMT https://community.qlik.com/t5/Talend-Studio/The-executeUpdate-method-must-not-return-a-result-set/m-p/2375954#M138243 Anonymous 2018-08-17T15:33:17Z https://community.qlik.com/t5/Talend-Studio/The-executeUpdate-method-must-not-return-a-result-set/m-p/2375955#M138244 <P>Hello,</P> <P>Is there any update for your issue? Does AFTER UPDATE trigger cause this issue?</P> <P>Best regards</P> <P>Sabrina</P> Tue, 11 Sep 2018 10:49:37 GMT https://community.qlik.com/t5/Talend-Studio/The-executeUpdate-method-must-not-return-a-result-set/m-p/2375955#M138244 Anonymous 2018-09-11T10:49:37Z https://community.qlik.com/t5/Talend-Studio/The-executeUpdate-method-must-not-return-a-result-set/m-p/2375956#M138245 Hi Sabrina, Yes one of the AFTER UPDATE trigger was causing the error to occur. After I disabled the trigger the error went away. Tue, 11 Sep 2018 14:44:08 GMT https://community.qlik.com/t5/Talend-Studio/The-executeUpdate-method-must-not-return-a-result-set/m-p/2375956#M138245 Anonymous 2018-09-11T14:44:08Z