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

AbhishekBoga — Sat, 16 Nov 2024 01:00:19 GMT

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

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

Prakhar1 — Fri, 04 Dec 2020 13:11:48 GMT

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

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

AbhishekBoga — Fri, 04 Dec 2020 13:54:52 GMT

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.

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

AbhishekBoga — Mon, 21 Dec 2020 12:27:07 GMT

Hi Everyone,

Can anyone please reply on this issue

Thanks.

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

Anonymous — Tue, 22 Dec 2020 08:38:55 GMT

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.

topic Re: JDBC driver encountered communication error. Message: HTTP status=400 in Talend Studio

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

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

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

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

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