JDBC driver encountered communication error. Message: HTTP status=400

[AbhishekBoga]

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

[Prakhar1]

Hi, not sure but you can try to use proxy setting to check if that can help you

[AbhishekBoga]

Hi Prakhar,

Thanks for your reply.

Could you please elaborate more on proxy settings. I don't see any option in tDBConnection or tDBRow component.

[AbhishekBoga]

Hi Everyone,

Can anyone please reply on this issue

Thanks.

[Anonymous]

Are you able to access Snowflakes Web console from browser in production? If you need to configure proxy in production, you can use tSetproxy component to configure the proxy in the begin of job.