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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

No talend job is running, Error in Connection

Hi All,
I have recently started exploring Talend Open Studio for integration On Premise database (Vertica) but haven't been able to get it to work. I have tried a really job of getting few records from excel and loading them into Vertica but I am gettting following error when I run the job
I am using the latest version of Talend Studio

Exception in thread "main" java.lang.Error: Unresolved compilation problems: 
SecretKey cannot be resolved to a type
The method getSecretKey() from the type PasswordEncryptUtil refers to the missing type SecretKey
Cipher cannot be resolved to a type
Cipher cannot be resolved
Cipher cannot be resolved to a variable
at routines.system.PasswordEncryptUtil.decryptPassword(PasswordEncryptUtil.java:67)
at local_project.onboardingdemojob_0_1.OnBoardingDemoJob.tFileInputExcel_1Process(OnBoardingDemoJob.java:809)
at local_project.onboardingdemojob_0_1.OnBoardingDemoJob.runJobInTOS(OnBoardingDemoJob.java:1648)
at local_project.onboardingdemojob_0_1.OnBoardingDemoJob.main(OnBoardingDemoJob.java:1505)
disconnected

I am successfully able to create connection to each object and they are added to metadata object and schema is created but I am not able to run any job.

Labels (3)
5 Replies
jeoste
Creator II
Creator II

Hello,
I'm not sure but it looks like some "import" missing (the import which contains SecretKey)
Try to import this javax.crypto.* at the beginning of your job to include it in your job's environment
Take a look at this link if it helps : Import java 

 

If you share some screenshots of your error / job it could be useful to resolve your problem with more details

Anonymous
Not applicable
Author

Hello Jeoste,

I have downloaded the latest version of talend and while extablishing a connection with database it gives me following error.

Plus i am using the latest version of JDK and also set the path of environment variables.

0683p000009M8Az.png

Anonymous
Not applicable
Author

Hi,

 

    Could you please check the JRE version used in Talend under Windows -> Preferences?

 

     If you are using Talend 7.2, you should use either Java 11 or Java 8. In the screen shot below, I am using Java 8 to connect to the studio.

0683p000009M8B4.png

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

 

Anonymous
Not applicable
Author

Dear Nikhil Thampi,

Please find below the setting i have done in Talend. As you mentioned i have already apply the settings but error still exists.

0683p000009M8BJ.png0683p000009M86f.png0683p000009M7p7.png

Please go through it and let me know if ther is any change required in talend settings.

Anonymous
Not applicable
Author

Hi,

 

    Did you restart the Studio and whether the issue persist? Could you please also try to reinstall the Studio with right JRE from the beginning itself?

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved