Multi Statement Execution - Snowflake

siddardh_eon — Sun, 05 Sep 2021 17:36:21 GMT

Hi Everyone,

I am running multiple statements with tDBRow component(snowflake). I am getting a snowflake error. I tried adding additional parameters(allowMultiQueries=True) but still getting the error. Please let me know if there is any workaround.

[FATAL] 17:29:37 ah_snowflake.test_0_1.test- tDBRow_2 UNEXPECTED_EXCEPTION

org.talend.components.api.exception.ComponentException: UNEXPECTED_EXCEPTION

at org.talend.components.snowflake.runtime.SnowflakeRowStandalone.throwComponentException(SnowflakeRowStandalone.java:117) ~[components-snowflake-runtime-0.32.1.jar:?]

at org.talend.components.snowflake.runtime.SnowflakeRowStandalone.runAtDriver(SnowflakeRowStandalone.java:91) ~[components-snowflake-runtime-0.32.1.jar:?]

at ah_snowflake.test_0_1.test.tDBRow_2Process(test.java:1215) [classes/:?]

at ah_snowflake.test_0_1.test.runJobInTOS(test.java:2300) [classes/:?]

at ah_snowflake.test_0_1.test.main(test.java:1563) [classes/:?]

Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: Actual statement count 6 did not match the desired statement count 1.

at net.snowflake.client.jdbc.SnowflakeUtil.checkErrorAndThrowExceptionSub(SnowflakeUtil.java:124) ~[snowflake-jdbc-3.13.1.jar:3.13.1]

at net.snowflake.client.jdbc.SnowflakeUtil.checkErrorAndThrowException(SnowflakeUtil.java:64) ~[snowflake-jdbc-3.13.1.jar:3.13.1]

at net.snowflake.client.core.StmtUtil.pollForOutput(StmtUtil.java:434) ~[snowflake-jdbc-3.13.1.jar:3.13.1]

at net.snowflake.client.core.StmtUtil.execute(StmtUtil.java:338) ~[snowflake-jdbc-3.13.1.jar:3.13.1]

at net.snowflake.client.core.SFStatement.executeHelper(SFStatement.java:482) ~[snowflake-jdbc-3.13.1.jar:3.13.1]

at net.snowflake.client.core.SFStatement.executeQueryInternal(SFStatement.java:194) ~[snowflake-jdbc-3.13.1.jar:3.13.1]

at net.snowflake.client.core.SFStatement.executeQuery(SFStatement.java:131) ~[snowflake-jdbc-3.13.1.jar:3.13.1]

at net.snowflake.client.core.SFStatement.execute(SFStatement.java:737) ~[snowflake-jdbc-3.13.1.jar:3.13.1]

at net.snowflake.client.core.SFStatement.execute(SFStatement.java:635) ~[snowflake-jdbc-3.13.1.jar:3.13.1]

at net.snowflake.client.jdbc.SnowflakeStatementV1.executeInternal(SnowflakeStatementV1.java:287) ~[snowflake-jdbc-3.13.1.jar:3.13.1]

at net.snowflake.client.jdbc.SnowflakeStatementV1.execute(SnowflakeStatementV1.java:337) ~[snowflake-jdbc-3.13.1.jar:3.13.1]

at org.talend.components.snowflake.runtime.SnowflakeRowStandalone.runAtDriver(SnowflakeRowStandalone.java:80) ~[components-snowflake-runtime-0.32.1.jar:?]

... 3 more

[statistics] disconnected

Re: Multi Statement Execution - Snowflake

Anonymous — Mon, 06 Sep 2021 03:53:43 GMT

Hello,

Is your Snowflake DB connection OK with you? No issue with network?

Could you please check out "Die on error" option in basic settings of tSnowflakeRow component to stop the execution of the Job to see if there is any error?

Best regards

Sabrina

topic Multi Statement Execution - Snowflake in Talend Studio

Multi Statement Execution - Snowflake

Re: Multi Statement Execution - Snowflake