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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

JVM compatiability error with simple MS SQL Server to Redshift integra

I am getting the following error when trying to test a simple integration between MS SQL Server and Amazon RedShift: 
Execution failed : Job compile errors 
At least job "TestingJob" has a compile errors, please fix and export again.
Error Line: 582
Detail Message: rowCounttRedshiftOutput_1 cannot be resolved to a variable
There may be some other errors caused by JVM compatibility. Make sure your JVM setup is similar to the studio.
For the MS SQL server input I am just trying to test a single column integration, "select id from <table>"
On the RedShift Output item I am using "Drop and Create table" as the Action on Table.  
I am running Studio Version 6.3.1, and when I check Preferences --> Installed JREs, jre1.8.0_121 is installed, and this is the only version installed on the machine. 
Any ideas? I wasn't able to find much information on this error other than checking the installed JREs as I have mentioned here.  
Labels (3)
11 Replies
Anonymous
Not applicable
Author

Hi,
It still doesn't work with Output to RedShift or PostGreSQL.  

What's the error message you are getting? Is it still JVM compatiability issue?
Best regards
Sabrina

Hi, yes - it is the same error.  
Anonymous
Not applicable
Author

Hi,
Could you please try to re- install your studio V 6.3.1 to see if it works after you  update Talend to use the JDK ?
Feel free to let us know if it is Ok with you.
Best regards
Sabrina