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: 
Anonymous
Not applicable

Talend 5.6 bug for password field after clicking on JobScript

This looks like a bug in Talend 5.6.
I've seen it occur for both tSendMail and tOracleConnection, but I would expect it to also happen in any component that takes a password.
Drag a tSendMail onto the screen, click Need Authentication, and set the password field, either to a string value or to a context variable.
If it is a string value of "password", the following code is generated:

final String decryptedPassword_tSendMail_1 = routines.system.PasswordEncryptUtil
                                                    .decryptPassword("a54bbfcc1190b7e1f4f7aba1746784ea");


If it is a context variable of context.password with a value of "password", the following code is generated instead:

final String decryptedPassword_tSendMail_1 = context.password;


Everything is fine so far.
Now click on the Jobscript tab, then click back onto the Code tab. An error is revealed, as the decrypted password does not contain any quotation marks (note that if it doesn't work the first time, switch back to JobScript then to Code):
For a password of string "password":

final String decryptedPassword_tSendMail_1 = PoLvNyVG2XWndNDdLn696A==; 


For a context variable of context.password with a value of "password":

final String decryptedPassword_tSendMail_1 = 8pW6Nmy2kuczSBOgoJ7Ub24fQgd+SRSj;

It is also interesting to note that both decryted passwords are not identical.

The same problem occurs for tOracleConnection:
Before clicking on JobScript, a string value of "password" is:

final String decryptedPassword_tOracleConnection_1 = routines.system.PasswordEncryptUtil
                        .decryptPassword("a54bbfcc1190b7e1f4f7aba1746784ea");

After clicking on JobScript and then back to Code:
final String decryptedPassword_tOracleConnection_1 = PoLvNyVG2XWndNDdLn696A==; 

Before clicking on Jobscript, a context variable of context.password with a value of password is:

final String decryptedPassword_tOracleConnection_1 = context.password;

After clicking on Jobscript and back to code:
final String decryptedPassword_tOracleConnection_1 = 8pW6Nmy2kuczSBOgoJ7Ub24fQgd+SRSj; 





Here is the tSendMail in Talend 5.5, which does not cause any error:
Before clicking on JobScript, a string value of "password" is:

final String decryptedPassword_tSendMail_1 = routines.system.PasswordEncryptUtil
                                                    .decryptPassword("a54bbfcc1190b7e1f4f7aba1746784ea");

After clicking on JobScript and back to Code:

final String decryptedPassword_tSendMail_1 = routines.system.PasswordEncryptUtil
                                                    .decryptPassword("a54bbfcc1190b7e1f4f7aba1746784ea");

Before clicking on JobScript, a context variable of context.password with a value of password is:

final String decryptedPassword_tSendMail_1 = context.password;


After clicking on JobScript and back to Code:

final String decryptedPassword_tSendMail_1 = context.password;


How can I prevent this from occurring?

Thanks and best regards,

Matthew Moisen
Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hi mmoisen,

Are you using Talend Enterprise Subscription Version? Have you reported a ticket on Talend Support Portal so that our colleagues from support team will check it to see if it is a bug. If it is a bug on Talend 5.6, they will create a jira issue for you and give you a patch to fix it through support cycle.
http://support.talend.com/otrs/customer.pl
Best regards
Sabrina