Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, I am currently encountering an issue when I run a Talend Job that read a query from Snowflake which is able to run in my local PC Talend but not in a Remote Engine that I have connected in Talend Portal. Here is the log:
tDBInput_1 Error processing query: SELECT TO_VARCHAR(MAX(DATE_VALID),'yyyyMMdd') FROM CURRENCY_EXCHANGE;
java.io.IOException: Error processing query: SELECT TO_VARCHAR(MAX(DATE_VALID),'yyyyMMdd') FROM CURRENCY_EXCHANGE;
at org.talend.components.snowflake.runtime.SnowflakeReader.start(SnowflakeReader.java:138)
at org.talend.codegen.flowvariables.runtime.FlowVariablesReader.start(FlowVariablesReader.java:73)
at fpi_dw.tcurr_0_1.TCURR.tDBInput_1Process(TCURR.java:3704)
at fpi_dw.tcurr_0_1.TCURR.tDBRow_1Process(TCURR.java:2622)
at fpi_dw.tcurr_0_1.TCURR.runJobInTOS(TCURR.java:7710)
at fpi_dw.tcurr_0_1.TCURR.main(TCURR.java:7142)
Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver internal error: exception creating result java.lang.ExceptionInInitializerError at net.snowflake.client.jdbc.internal.apache.arrow.memory.UnsafeAllocationManager.<clinit>(UnsafeAllocationManager.java:27).
at net.snowflake.client.jdbc.SnowflakeStatementV1.executeQueryInternal(SnowflakeStatementV1.java:243)
at net.snowflake.client.jdbc.SnowflakeStatementV1.executeQuery(SnowflakeStatementV1.java:131)
at org.talend.components.snowflake.runtime.SnowflakeReader.start(SnowflakeReader.java:135)
... 5 more
From my PC, works perfectly:
Talend Portal:
Appreciate with any advice and feedback, thank you!
Hello
It looks like a Java issue. If the Remote Engine runs with Java 17, you have to install the 8.0 R2023-10 Talend Studio monthly update or a later one, and re-build the jobs using Java 17, please read the Pay attention to the following before working with Java 17 section in this documentation page.
Regards
Shicong