topic Re: Qlik Replication ODBC SQL_ERROR Connection Failed in Qlik Replicate

Qlik Replication ODBC SQL_ERROR Connection Failed

AgusBudianto — Thu, 28 Aug 2025 01:09:19 GMT

Tasks using Simba ODBC connections to Databricks Lakehouse (Delta) Target get error messages, but the tasks still run:

Logs message 1:

RetCode: SQL_ERROR SqlState: 08S01 NativeError: 115 Message: [Simba][Hardy] (115) Connection failed with error: HTTP Response code: 400 , BAD_REQUEST: Invalid SessionHandle: Session [01f08224-d2bc-1feb-b4e2-750c939abc40] is closed.
Failed (retcode -1) to execute statement: REFRESH TABLE `sky_raw_mirror_lfa`.`attrep_changesAD716FF52F3078F7`

Logs message 2:

Allocated 150 ODBC statement handles

Re: Qlik Replication ODBC SQL_ERROR Connection Failed

DesmondWOO — Thu, 28 Aug 2025 07:42:04 GMT

Hi @AgusBudianto ,

It seems that the connection has expired. Was the Databricks cluster restarted? We need to check your task log for analysis. I recommend creating a support ticket for further assistance.

Regards,
Desmond

Re: Qlik Replication ODBC SQL_ERROR Connection Failed

AgusBudianto — Thu, 28 Aug 2025 07:57:27 GMT

Hi @DesmondWOO

ok I will try Submit a ticket, but is there any connection limitation using ODBC?

Re: Qlik Replication ODBC SQL_ERROR Connection Failed

DesmondWOO — Thu, 28 Aug 2025 08:19:15 GMT

Hi @AgusBudianto ,

This issue should not be related to ODBC limitations, but my guess is that it could be due to a network issue or idle timeout. Regardless, we need to check the task log to see what happened.

Regards,
Desmond