Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \\)

Highlighted
Four Stars

Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \\)

Hi Community, 

 

we get the error Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \\) when we click "Guess schema". 

We don't change the query and we get it in every job.

We are use a Microsoft SQL Server and Microsoft Server 2016 Datacenter. 

I tried to reproduce the error. I don't get the error. 

 

Talend Version: 6.3.1.20161216_1026 

 

 

I hope you have any ideas how we can fix that.

 

Thanks & Regards

Selina

Seven Stars skh
Seven Stars

Re: Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \\)

Could you please click on the Code section and let us know whats the entire Error its returning. In Java the backslash character \ is an escape character. The compiler thinks that you are attempting to escape the next character. I would request you to try checking the settings in each and every component and check whether you have given any invalid entry unexpectedly.

 

Thanks,

skh

 

 

Four Stars

Re: Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \\)

Hi skh,

 


@skh wrote:

Could you please click on the Code section and let us know whats the entire Error its returning.  


I can't send you the code section cause i don't run the job i only click on "guess schema".

You can see it on the screenshot. 

 

It's just a simple job. 

We import the data from the database into a log file. 

We don't have any changes in the TMAP.

 

Thanks

Sevania

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

Downloads and Trials

Test drive Talend's enterprise products.

Downloads