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

One Star

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

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!!
One Star

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

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

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

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!!!
One Star

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

Try using single quotes in your SQL statement.
Two Stars

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

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

Iam getting this error

String literal is not properly closed by a double-quote

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download