topic Re: error message String literal is not properly closed by a double-quote in Talend Studio

error message String literal is not properly closed by a double-quote

Anonymous — Thu, 29 Mar 2012 16:57:26 GMT

I got this error message "String literal is not properly closed by a double-quote" in my job. But I could run the same job in my local without any problem. That means I don't have that stupid mistake in the expression writing. When I deployed it to the server, it ended with this error message. I took a look at the line specified in the log. But I didn't see any mistake. Any suggestion? Or what else info are needed?
Thanks!!

Re: error message String literal is not properly closed by a double-quote

PYUR-QLIK-TALEND — Thu, 29 Mar 2012 17:12:30 GMT

Perhaps it's helpful to look at your code (klick on the red marker at right).

Re: error message String literal is not properly closed by a double-quote

Anonymous — Thu, 12 Apr 2012 22:36:33 GMT

After I narrowed down the scope, I only kept two components in the job and the error message still came up. So I think it should be the sql issue.
My revised job is as follows:
tOracleInputRow - row - tLogRow
I attached one picture for the query I used. The column name "file_name" seems in orange color. I don't know if it's a reserved words in somewhere. I guess that might be problem.
But this job works fine at my local which is window OS. It doesn't work on the server, which is linux OS. I wonder how to modify it so that it's able to work under linux system.
Thanks!!!

Re: error message String literal is not properly closed by a double-quote

Anonymous — Fri, 13 Apr 2012 01:05:05 GMT

Try using single quotes in your SQL statement.

Re: error message String literal is not properly closed by a double-quote

Anonymous — Thu, 05 Sep 2019 10:36:05 GMT

"PrimarySalesAggData_AnalysisTeam_"+TalendDate.formatDate("yyyy-MM",TalendDate.getCurrentDate())"

Iam getting this error

String literal is not properly closed by a double-quote