One Star

Running into runtime issues for Talend Open Studio Big Data Integratio

Java Version - "1.8.0_60"
Talend Open Studio for Big Data (6.0.0)
OS - OS X Yosemite Version 10.10.3
I am getting the following error when I try to run my job, which does (at least try to do the following):
1. Connect to MySQL db
2. tForeach (name - example "F7", "A1", "T2" etc.)
3. tForeach (month, eg., "Jan 2015", "Feb 2015", "Mar 2015"....)
4. tMySQLInput (extract rows matching the name and month - 2 & 3)
4. tSortRow
5. tAggregateRow
6. tMap
7. tMySQLInput (lookup)
8. tFileOutputDelimited (write to output file) or tS3Put or tGSPut
9. tBigQueryOutput
To me it looks like the Java Version on Mac is causing issues in Talend. Previously I had TOS DI 5.4.1 with Java 1.7 version and it ran fine. Currently the TOS DI 5.4.1 version does not run my previously executable jobs. Not sure how to resolve this. Please help.
Error Message from running the job:
connecting to socket on port 3809
connected
objc: Class JavaLaunchHelper is implemented in both /Library/Java/JavaVirtualMachines/jdk1.8.0_60.jdk/Contents/Home/bin/java and /Library/Java/JavaVirtualMachines/jdk1.8.0_60.jdk/Contents/Home/jre/lib/libinstrument.dylib. One of the two will be used. Which one is undefined.
Exception in thread "main" java.lang.Error: Unresolved compilation problems: 
tmp_tForeach_2 cannot be resolved to a variable
tmp_tForeach_1 cannot be resolved to a variable
Syntax error on tokens, delete these tokens
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
disconnected
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
aggregated_row_tAggregateRow_1 cannot be resolved to a variable
String literal is not properly closed by a double-quote
Syntax error, insert ")" to complete MethodInvocation
Syntax error, insert ")" to complete Expression
at fusionseven.data_extracts_0_1.data_extracts.tForeach_2Process(data_extracts.java:3900)
at fusionseven.data_extracts_0_1.data_extracts.tMysqlConnection_1Process(data_extracts.java:6998)
at fusionseven.data_extracts_0_1.data_extracts.runJobInTOS(data_extracts.java:8430)
at fusionseven.data_extracts_0_1.data_extracts.main(data_extracts.java:8216)
Job data_extracts ended at 13:04 30/09/2015.
1 REPLY
Moderator

Re: Running into runtime issues for Talend Open Studio Big Data Integratio

Hi,
Did you import your job created on TOS DI 5.4.1 into Talend Open Studio for Big Data (6.0.0)? Have you already checked the document about:TalendHelpCenter:Requiring a JDK installation to build jobs starting from version 6.0?
Make sure that java settings must point to the root JDK folder, and not the JRE.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.