syntax error insert " ]" to complete Expression

[Anonymous]

Hello Community,

I do get the following error message while running a job; "Syntax error, insert " ]" 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?

Thank you in advance!

[Anonymous]

Hi
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.

Regards
Shong