topic Re: Problem when Loading dimension from an ODS table in Talend Studio

Problem when Loading dimension from an ODS table

Anonymous — Thu, 20 Apr 2017 12:13:45 GMT

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 !

Re: Problem when Loading dimension from an ODS table

cterenzi — Thu, 20 Apr 2017 13:57:17 GMT

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 "\\".

Re: Problem when Loading dimension from an ODS table

Sid3 — Thu, 20 Apr 2017 15:04:13 GMT

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.

Re: Problem when Loading dimension from an ODS table

Anonymous — Thu, 20 Apr 2017 15:41:34 GMT

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

Re: Problem when Loading dimension from an ODS table

Anonymous — Thu, 20 Apr 2017 15:56:21 GMT

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

Re: Problem when Loading dimension from an ODS table

Sid3 — Thu, 20 Apr 2017 15:59:59 GMT

Share your input query

Re: Problem when Loading dimension from an ODS table

Anonymous — Thu, 20 Apr 2017 16:05:46 GMT

http://hpics.li/1237f8e

Re: Problem when Loading dimension from an ODS table

Sid3 — Thu, 20 Apr 2017 16:13:48 GMT

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.

Re: Problem when Loading dimension from an ODS table

Anonymous — Thu, 20 Apr 2017 16:22:33 GMT

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