Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Fernandez
Creator II
Creator II

Issue with type Password in context

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

0683p000009M9Xi.png

 

Component

0683p000009M9cR.png

 

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 ?

 

 

 

Labels (2)
7 Replies
Anonymous
Not applicable

@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

sushantk19
Creator
Creator

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?


Password_issue.docx
Fernandez
Creator II
Creator II
Author

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.

sushantk19
Creator
Creator

@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

Fernandez
Creator II
Creator II
Author

Actually there was no issue.

I don't know how helping.

I define the password like this:

 0683p000009MA6L.png

and when I export my job, I get the encrypted value in my context file :

0683p000009MA6Q.png

 

 

 

 

 

sushantk19
Creator
Creator

@Fernandez: whats your version of TOS? i do not know what is issue with TOS 7.2.

Fernandez
Creator II
Creator II
Author

I'm using 7.3.1 version.

And before 7.2.1