Five Stars

Problem when Loading dimension from an ODS table

Hello folks, I am new with Talend and I have faced a problem when I was trying to load my dimension from an ODS table. So  I am using Talend open studio Version: 6.3.0. 

You can find bellow a screenshot from my job, my t_map configuration and the data inside my ODS table.

Thanks for your help in advance !

 

error1.PNGerror2.PNGerror3.PNG

  • Data Integration
2 ACCEPTED SOLUTIONS

Accepted Solutions
Eight Stars

Re: Problem when Loading dimension from an ODS table

The error "Invalid escape sequence" usually occurs when you have a String containing a "\" in a component setting.  See if one of the settings in your database output component contains a "\" and if it's meant to be a literal slash, change it to "\\".

Six Stars

Re: Problem when Loading dimension from an ODS table

Hi,

First execute the below query replacing the context variables in SQL server. If it works then copy the same in your input component sql query property and execute the job. Let me know your findings.

"select "+context.ODS2_Schema+".fournisseurDim.CodeFournisseur as CodeFournisseur,"+context.ODS2_Schema+".fournisseurDim.NomFournisseur as NomFournisseur from "+context.ODS2_Schema+".fournisseurDim"

Thanks,
Sid
Please like the post if it is useful
Please put to resolved if it resolves your issue.

8 REPLIES
Eight Stars

Re: Problem when Loading dimension from an ODS table

The error "Invalid escape sequence" usually occurs when you have a String containing a "\" in a component setting.  See if one of the settings in your database output component contains a "\" and if it's meant to be a literal slash, change it to "\\".

Six Stars

Re: Problem when Loading dimension from an ODS table

Hi Mohamed

Goto "Code" Tab. Here you will see the java code. kindly mouse over the red markers and it will show you the error. share the screen shot of it.

Also share your oracle output connection properties with a scrennshot.
Five Stars

Re: Problem when Loading dimension from an ODS table

Thank you for your answer!

Actually I have used the same settings for configuring another TMSSqlOutput component in another job, and I didn't had any issue with that. You will find in the links bellow a screenshot of the two TMSSqlOutput components configuration and the one for source code error.

Links:

1-Data Warehouse TMSSqlOutput configuration component (the one with the error) : http://hpics.li/67495cf

2- ODS  TMSSqlOutput configuration component : http://hpics.li/fd30b83

3- The source code error : http://hpics.li/6bb32dd

 

 

Five Stars

Re: Problem when Loading dimension from an ODS table

Thank you for your  answer ! 

I have only find the caracter "\"  in my TMSSqlOutput component settings and I have tried to replace it with "\\" as you have suggested. That have resolved the connexion with the Output component but it seems like I have a new issue now.

 

Here is the string with "\" link: http://hpics.li/9360888

Here is the link with the new error: http://hpics.li/d73c8e3

Six Stars

Re: Problem when Loading dimension from an ODS table

Share your input query
Five Stars

Re: Problem when Loading dimension from an ODS table

Six Stars

Re: Problem when Loading dimension from an ODS table

Hi,

First execute the below query replacing the context variables in SQL server. If it works then copy the same in your input component sql query property and execute the job. Let me know your findings.

"select "+context.ODS2_Schema+".fournisseurDim.CodeFournisseur as CodeFournisseur,"+context.ODS2_Schema+".fournisseurDim.NomFournisseur as NomFournisseur from "+context.ODS2_Schema+".fournisseurDim"

Thanks,
Sid
Please like the post if it is useful
Please put to resolved if it resolves your issue.

Five Stars

Re: Problem when Loading dimension from an ODS table

Thank you so much ! It's working and I can finally load the dimension table.