https://community.qlik.com/t5/Talend-Studio/syntax-error-insert-quot-quot-to-complete-Expression/m-p/2203833#M4969 <P>Hello Community,</P> <P>&nbsp;</P> <P>I do get the following error message while running a job; "Syntax error, insert&nbsp;" ]" to complete Expression". A couple of weeks before this job was working fine. The only one thing that I have changed was SQL query inside (which works fine when I run t separately in MySQL ). The job itself consist of two components: tDBInput and tGoogleSheetOutput (please see screenshout attached). Could you please advice me how to handle it?</P> <P>&nbsp;</P> <P>Thank you in advance!</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ETL job.JPG" style="width: 789px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8gc.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/136433iD8AF70F43E8510B7/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M8gc.jpg" alt="0683p000009M8gc.jpg" /></span></SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Sat, 16 Nov 2024 03:15:08 GMT Anonymous 2024-11-16T03:15:08Z https://community.qlik.com/t5/Talend-Studio/syntax-error-insert-quot-quot-to-complete-Expression/m-p/2203833#M4969 <P>Hello Community,</P> <P>&nbsp;</P> <P>I do get the following error message while running a job; "Syntax error, insert&nbsp;" ]" to complete Expression". A couple of weeks before this job was working fine. The only one thing that I have changed was SQL query inside (which works fine when I run t separately in MySQL ). The job itself consist of two components: tDBInput and tGoogleSheetOutput (please see screenshout attached). Could you please advice me how to handle it?</P> <P>&nbsp;</P> <P>Thank you in advance!</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ETL job.JPG" style="width: 789px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8gc.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/136433iD8AF70F43E8510B7/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M8gc.jpg" alt="0683p000009M8gc.jpg" /></span></SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Sat, 16 Nov 2024 03:15:08 GMT https://community.qlik.com/t5/Talend-Studio/syntax-error-insert-quot-quot-to-complete-Expression/m-p/2203833#M4969 Anonymous 2024-11-16T03:15:08Z https://community.qlik.com/t5/Talend-Studio/syntax-error-insert-quot-quot-to-complete-Expression/m-p/2203834#M4970 Hi <BR />It is a compilation error, you have to fix it before you execute the job. Open the Code tab to open the generated Java code of job, you will see which line has the error. <BR /> <BR />Regards <BR />Shong Fri, 21 Feb 2020 10:11:38 GMT https://community.qlik.com/t5/Talend-Studio/syntax-error-insert-quot-quot-to-complete-Expression/m-p/2203834#M4970 Anonymous 2020-02-21T10:11:38Z