Automatic add of quotes around context.Xxx in tMsSqlConnection

[Anonymous]

Hi there,

I've just been added to a Talend existing project and I have the following issue.

This project had been created in Talend 6.4, and a migration in Talend 7.0.1 has been done recently.

Connections in this project have been defined as shown on PJ1.

My problem is the following one :

- when I open a job, Talend ask me to update some context variables (see PJ2) ; I can click on Ok or Cancel, it seems to be the same ;

- then, when I look at my tMsSqlConnection, everything seems to be fine (idem PJ1) ;

- now, when I try to run the job, Talend ask me again something else and to choose between Ok or Cancel (see PJ3) ;

- if I chose Cancel, everything works fine ; if I chose Ok, Talend add quotes around every context.Xxx of my metadata (see PJ4), and my job fail with this error :

Exception in component tMSSqlConnection_2 (////myJobHidden////)
com.microsoft.sqlserver.jdbc.SQLServerException: La chaîne de connexion contient un nom ou une valeur au format incorrect.

My problem : when I chose Cancel, everytime I want to run the job, Talend ask me the same question than PJ3.

Anybody knows how I can fixe that ?

Thanks a lot !

[Anonymous]

Hello,

We are not able to open your screenshots. Could you please check it to see if it is OK with you from your side?

Best regards

Sabrina

[Anonymous]

Hello Sabrina,

Thank you for your reply, I can open my snapshot correctly.

I try to put them again in this post.

Best regards