Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
RLagrange
Contributor III
Contributor III
‎2021-07-16 09:59 AM

Encryption issues

Hello everyone,

I am facing issues with the export of my jobs on one of my servers, and I think this is due to the encryption system that must have changed since I have upgraded Talend Open Studio from version 7.1 to 7.3.

Indeed, if I am launching my job on my local computer, or its exported version, my output PostGreSQL database has inserted rows, but if I copy and paste the exported job on my server, I have the following error in the cmd :

C:\Windows\system32>C:

C:\Windows\system32>cd C:\Users\adminetl\Desktop\TEST_0.1\TEST\

C:\Users\adminetl\Desktop\TEST_0.1\TEST>java -Dtalend.component.manager.m2.repos

itory="C:\Users\adminetl\Desktop\TEST_0.1\TEST/../lib" -Xms256M -Xmx1024M -cp .;

../lib/routines.jar;../lib/log4j-slf4j-impl-2.12.1.jar;../lib/log4j-api-2.12.1.j

ar;../lib/log4j-core-2.12.1.jar;../lib/ojdbc7.jar;../lib/talend-oracle-timestamp

tz.jar;../lib/postgresql-42.2.9.jar;../lib/crypto-utils.jar;../lib/slf4j-api-1.7

.25.jar;../lib/dom4j-2.1.1.jar;test_0_1.jar; jobs.test_0_1.TEST --context=Defau

lt

[FATAL] 15:52:43 jobs.test_0_1.TEST- tDBInput_1 ORA-01017: nom utilisateur/mot d

e passe non valide ; connexion refusÚe

java.sql.SQLException: ORA-01017: nom utilisateur/mot de passe non valide ; conn

exion refusÚe

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) ~[ojdbc

7.jar:12.1.0.1.0]

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:392) ~[ojdbc

7.jar:12.1.0.1.0]

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:385) ~[ojdbc

7.jar:12.1.0.1.0]

       at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:938) ~[ojdbc

7.jar:12.1.0.1.0]

       at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthentica

te.java:480) ~[ojdbc7.jar:12.1.0.1.0]

       at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655) ~[ojdbc7.jar

:12.1.0.1.0]

       at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) ~[ojdbc7.jar:1

2.1.0.1.0]

       at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.ja

va:416) ~[ojdbc7.jar:12.1.0.1.0]

       at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.ja

va:825) ~[ojdbc7.jar:12.1.0.1.0]

       at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:596) ~[ojdb

c7.jar:12.1.0.1.0]

       at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:

715) ~[ojdbc7.jar:12.1.0.1.0]

       at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385) ~[ojd

bc7.jar:12.1.0.1.0]

       at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio

n.java:30) ~[ojdbc7.jar:12.1.0.1.0]

       at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564) ~[ojdb

c7.jar:12.1.0.1.0]

       at java.sql.DriverManager.getConnection(Unknown Source) ~[?:1.8.0_131]

       at java.sql.DriverManager.getConnection(Unknown Source) ~[?:1.8.0_131]

       at jobs.test_0_1.TEST.tDBInput_1Process(TEST.java:1169) [test_0_1.jar:?]

       at jobs.test_0_1.TEST.runJobInTOS(TEST.java:2049) [test_0_1.jar:?]

       at jobs.test_0_1.TEST.main(TEST.java:1863) [test_0_1.jar:?]

Exception in component tDBInput_1 (TEST)

java.sql.SQLException: ORA-01017: nom utilisateur/mot de passe non valide ; conn

exion refusée

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:392)

       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:385)

       at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:938)

       at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthentica

te.java:480)

       at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)

       at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)

       at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.ja

va:416)

       at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.ja

va:825)

       at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:596)

       at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:

715)

       at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385)

       at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio

n.java:30)

       at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564)

       at java.sql.DriverManager.getConnection(Unknown Source)

       at java.sql.DriverManager.getConnection(Unknown Source)

       at jobs.test_0_1.TEST.tDBInput_1Process(TEST.java:1169)

       at jobs.test_0_1.TEST.runJobInTOS(TEST.java:2049)

       at jobs.test_0_1.TEST.main(TEST.java:1863)

The input Oracle connection is refused, but I am sure that the rights are correctly defined (it worked before). It must be the translation of the password which doesn't work.

Here is the content of my studio.keys file :

# studio encryption keys

# Tue Jul 06 14:04:22 CEST 2021

system.encryption.key.v1=ObIr3Je6QcJuxJEwErWaFWIxBzEjxIlBrtCPilSByJI\=

routine.encryption.key.v1=YBoRMn8gwD1Kt3CcowOiGeoxRbC2eNNVm7Id6vA3hrk\=

Is there a way to generate these keys in the exported job in order to give the "good" credentials as I am exporting the job on my server or any other way to "translate" the password in the exported job ?

Thank you very much for your answers.

Labels (2)
Labels
491 Views
0 Likes
1 Solution

Accepted Solutions
RLagrange
Contributor III
Contributor III
‎2021-08-27 02:44 AM
Author

Hello,

 

For the record, TalendForge found the solution to the issue : my jre/jdk version on the server was below the 1.8.0_161. After an update, it's now working !

 

Best regards.

View solution in original post

491 Views
0 Likes
15 Replies
Anonymous
Not applicable
‎2021-07-20 02:44 AM

Hello,

How are you passing your connection details? Context variables? Literals?

Best regards

Sabrina

318 Views
0 Likes
RLagrange
Contributor III
Contributor III
‎2021-07-20 03:12 AM
Author

Hello,

Thank you for your answer.

I am using a tDBConnection component for my PostGreS database, and a tDBInput for my Oracle input :

0695b00000H7me3AAB.png0695b00000H7msIAAR.pngBest regards

318 Views
0 Likes
Anonymous
Not applicable
‎2021-07-20 04:09 AM

In response to RLagrange

Hello,

Set the password filed with a context variable (password type), the default value will be stored as an encrypted data. eg:

password=enc\:routine.encryption.key.v1\:5cBz7N96rJ180ZT6tHREHAPg6d1/FU75sW69/+/1NmZdRg\=\=

When you export the job bat file, uncheck the 'Item' box, it will not contain the job items. Without the the item files, others can only run the job and cannot import the job.0695b00000H7nXzAAJ.jpg

318 Views
0 Likes
RLagrange
Contributor III
Contributor III
‎2021-07-20 07:13 AM
Author

In response to Anonymous

I still got the same error, I think I don't use the context properly :

 0695b00000H7oeDAAR.pngBtw, how do I display the "items" checkbox on the building menu ? I don't have this option.

318 Views
0 Likes
Anonymous
Not applicable
‎2021-07-20 11:19 PM

In response to Anonymous

Hello,

Please have a look at this online documentation about: TalendHelpCenter: Building Jobs and select the build type as standalone job.

Best regards

Sabrina

 

 

318 Views
0 Likes
RLagrange
Contributor III
Contributor III
‎2021-07-21 04:11 AM
Author

In response to Anonymous

Hello,

I checked the documentation (thank you for the link), I added the classpath jar in the build, but still I do not have the option "Items" in the building menu, and by default the job was exported as Standalone.

 

It it still not working with the same error.

 

I think the "Items" checkbox might be the solution, but I don't find online the option to enable its display on the building menu...

 

Best regards, and thank you for all your advices.

 

Rémy

318 Views
0 Likes
Anonymous
Not applicable
‎2021-07-21 05:32 AM

In response to Anonymous

Hello,

Are you able to create a new job in V 7.3.1 and export it as a standalone one to see if it works?

We are suspecting that there might be something wrong with you migration task from V 7.1 to V 7.3.

Best regards

Sabrina

318 Views
0 Likes
RLagrange
Contributor III
Contributor III
‎2021-07-21 08:02 AM
Author

In response to Anonymous

Hello,

 

I am able to create it, and it's perfectly working if I am lauching the .bat file on my local computer.

 

Best regards,

 

Rémy

318 Views
0 Likes
RLagrange
Contributor III
Contributor III
‎2021-07-22 03:26 AM
Author

In response to Anonymous

*But still not on the server dedicated to schedule the builded jobs.

318 Views
0 Likes