Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I just downloaded version 7.3.1 and now I'm getting an error with the type password in context variables.
I use type password for the connection to a MSSQL base:
Context
Component
When I launch the job from TOS, it's running fine.
But if I export the job and launch the .bat, I got this error:
tMSSqlInput_3;com.microsoft.sqlserver.jdbc.SQLServerException:Login failed for user...
I never got this issue with version 7.2.1
I just saw that the encryption value is different between :
7.2.1 =>ENC\:[xxxxxx]
7.3.1 =>enc\:routine.encryption.key.v1\:xxxxxx
Any idea please ?
@Fernandez, I have made a testing on my side and I can't reproduce the issue with v7.3.1, the job works also when I export the job script. As I did, you export all the parameter as context variable. The difference is I am using Open Source JTDS driver.
Regards
Shong
Hello All,
I am also facing the same issue. When i make type of password as "password", my job throws an error:
xception in component tDBOutput_1 (job_Staging_000_sylius_Address)
java.sql.SQLNonTransientConnectionException: [Amazon][JDBC](10100) Connection Refused: [Amazon][JDBC](11640) Required Connection Key(s): PWD; [Amazon][JDBC](11480) Optional Connection Key(s): AccessKeyID, AuthMech, AutoCreate, BlockingRowsMode, ClusterID, DbGroups, DisableIsValidQuery, DriverLogLevel, EndpointUrl, FilterLevel, IAMDuration, Language, loginTimeout, OpenSourceSubProtocolOverride, plugin_name, profile, Region, SecretAccessKey, selectorProvider, selectorProviderArg, SessionToken, socketTimeout, ssl, sslcert, sslfactory, sslkey, sslpassword, sslrootcert, SSLTruststore , SSLTrustStorePath, tcpKeepAlive, TCPKeepAliveMinutes, unknownLength
But when i change the type to "String" in context, job works perfectly fine. i am using Talend 7.2.
Can you please suggest what should i change in context to make this work?
Hi,
I found the issue.
Each time we export jobs, the value of the encrypted password change with v7.3.1.
And i copied/pasted context variables from precedent export when I deployed on servers.
@Fernandez : didnt understand you completely. Are you also facing this issue? OR you could resolve this issue? Can you suggest a solution for this? how do i define the password? I am using TOS 7.2
Actually there was no issue.
I don't know how helping.
I define the password like this:
and when I export my job, I get the encrypted value in my context file :
@Fernandez: whats your version of TOS? i do not know what is issue with TOS 7.2.
I'm using 7.3.1 version.
And before 7.2.1