Hi,
I am trying to execute 'Truncate table' statement in tDBRow component in Talend Studio 7.1 version. It was working fine from Studio and in UAT env. But when it was executed in production the job failed due to below error:
tDBRow_1 = UNEXPECTED_EXCEPTION
[ERROR]: net.snowflake.client.jdbc.RestRequest - Got error response: http status=400, request=GET https://[Snowflake DB Domain]/queries/XXXXX-XXXX-XXXX-XXXX-XXXX/result?requestId=xxxxx-xxxx-xxcc-cccc-sadasdas&request_guid=sdffsdf-asssadsa-sdfs-werwe-eweweew HTTP/1.1
[ERROR]: net.snowflake.client.core.HttpUtil - Error executing request: GET https://[Snowflake DB Domain]/queries/XXXXX-XXXX-XXXX-XXXX-XXXX/result?requestId=xxxxx-xxxx-xxcc-cccc-sadasdas&request_guid=sdffsdf-asssadsa-sdfs-werwe-eweweew HTTP/1.1
[ERROR]: net.snowflake.client.core.HttpUtil - Response status line reason: Bad Request
[ERROR]: net.snowflake.client.core.HttpUtil - Header name: Cache-Control, value: must-revalidate,no-cache,no-store
[ERROR]: net.snowflake.client.core.HttpUtil - Header name: Date, value: Mon, 30 Nov 2020 23:53:33 GMT
[ERROR]: net.snowflake.client.core.HttpUtil - Header name: Strict-Transport-Security, value: max-age=31536000
[ERROR]: net.snowflake.client.core.HttpUtil - Header name: X-Content-Type-Options, value: nosniff
[ERROR]: net.snowflake.client.core.HttpUtil - Header name: X-Frame-Options, value: deny
[ERROR]: net.snowflake.client.core.HttpUtil - Header name: Content-Length, value: 0
[ERROR]: net.snowflake.client.core.HttpUtil - Header name: Connection, value: keep-alive
[ERROR]: net.snowflake.client.core.HttpUtil - Response content:
[FATAL]: project.job_XXXX.job_child_job - talendStats_DB UNEXPECTED_EXCEPTION:{message=JDBC driver encountered communication error. Message: HTTP status=400.}
org.talend.components.api.exception.ComponentException: UNEXPECTED_EXCEPTION:{message=JDBC driver encountered communication error. Message: HTTP status=400.}
at org.talend.components.jdbc.CommonUtils.newComponentException(CommonUtils.java:567)
at org.talend.components.jdbc.runtime.writer.JDBCOutputInsertWriter.open(JDBCOutputInsertWriter.java:49)
at project.job_XXXX.job_child_job.talendStats_STATSProcess(job_child_job.java:35012)
at project.job_XXXX.job_child_job.runJobInTOS(job_child_job.java:39091)
at project.job_XXXX.job_child_job.main(job_child_job.java:38564)
Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered communication error. Message: HTTP status=400.
at net.snowflake.client.core.HttpUtil.executeRequestInternal(HttpUtil.java:395)
at net.snowflake.client.core.HttpUtil.executeRequest(HttpUtil.java:318)
at net.snowflake.client.core.HttpUtil.executeRequest(HttpUtil.java:290)
at net.snowflake.client.core.StmtUtil.getQueryResult(StmtUtil.java:648)
at net.snowflake.client.core.StmtUtil.getQueryResult(StmtUtil.java:607)
at net.snowflake.client.core.StmtUtil.pollForOutput(StmtUtil.java:540)
at net.snowflake.client.core.StmtUtil.execute(StmtUtil.java:370)
at net.snowflake.client.core.SFStatement.executeHelper(SFStatement.java:474)
at net.snowflake.client.core.SFStatement.executeQueryInternal(SFStatement.java:230)
at net.snowflake.client.core.SFStatement.executeQuery(SFStatement.java:172)
at net.snowflake.client.core.SFStatement.describe(SFStatement.java:191)
at net.snowflake.client.jdbc.SnowflakePreparedStatementV1.<init>(SnowflakePreparedStatementV1.java:114)
at net.snowflake.client.jdbc.SnowflakeConnectionV1.prepareStatement(SnowflakeConnectionV1.java:621)
at org.talend.components.jdbc.runtime.writer.JDBCOutputInsertWriter.open(JDBCOutputInsertWriter.java:47)
... 3 more
The above job executes 4 table load parallelly. Source system is MSSQL DB and Target system is Snowflake DB.
Can anyone help me on this as I have to close this on high priority
