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

[Anonymous]

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

[hami1]

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

[Anonymous]

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

[MDDrake]

I had something similar recently and found that it was because I had pasted a file path from Windows Explorer where "\" denotes a change in level as opposed to the "/" that Talend expects, it was therefore expecting me to specify an Escape Sequence