topic Re: INVALID_STATE: Invalid SessionHandle: SessionHandle [01f18796-eb22-1cc1-97b2-2e12e5eb4036 in Qlik Replicate

INVALID_STATE: Invalid SessionHandle: SessionHandle [01f18796-eb22-1cc1-97b2-2e12e5eb4036

gopikrishnan06 — Mon, 27 Jul 2026 11:46:46 GMT

hi All,

Am getting frequent disconnection from the Qlik replicate using target as Databricks delta lakehouse.

Error as 115 invalid_state: invalid session Handle: session handle.

Target: (Databricks Lakehouse (Delta)) Error Code: 1022502 Error details: Failed to start bulk apply transaction Failed to execute merge table statement

RetCode: SQL_ERROR SqlState: 08S01 NativeError: 115 Message: [Simba][Hardy] (115) Connection failed with error: HTTP Response code: 400 , INVALID_STATE: Invalid SessionHandle: SessionHandle [01f18796-eb22-1cc1-97b2-2e12e5eb4036].

Failed (retcode -1) to execute statement: MERGE INTO `sap_p01`.`mch1

Re: INVALID_STATE: Invalid SessionHandle: SessionHandle [01f18796-eb22-1cc1-97b2-2e12e5eb4036

john_wang — Tue, 28 Jul 2026 01:46:57 GMT

Hello @gopikrishnan06 ,

I'm not certain whether the error occurs after a fixed period of inactivity or randomly during periods of heavy replication. However, there are several possible causes that can lead to the same error:

SQL Warehouse terminating idle sessions (most common)

If you're connecting to a Databricks SQL Warehouse, please check:
- Auto Stop timeout settings
- Auto Scaling events
- SQL Warehouse restart events
Network interruption

Even a brief network interruption between Qlik Replicate and Databricks can invalidate the session, resulting in an Invalid SessionHandle error.

As part of the investigation, I recommend enabling Databricks ODBC tracing. The trace logs can help determine whether the issue is caused by network connectivity, session timeouts, or an ODBC driver-related problem.

Hope this helps.

John.

Re: INVALID_STATE: Invalid SessionHandle: SessionHandle [01f18796-eb22-1cc1-97b2-2e12e5eb4036

gopikrishnan06 — Tue, 28 Jul 2026 05:49:50 GMT

Hi John,

I already checked with the Databricks compute.

1) there are no auto stop timeout at that time. Monday we got error, Compute restarted on last saturday

2) no auto scalling events

3) Sql warehouse restart on last saturday.

4) ODBC Trace already shared with the Qlik Vendor # 00464651 - Need help on Qlik Replicate#

@John kindly check if any IP need to add to fix the network glitch. Daily we are getting network disconnection it wont stop the tasks but we are getting multiple ticket.

Re: INVALID_STATE: Invalid SessionHandle: SessionHandle [01f18796-eb22-1cc1-97b2-2e12e5eb4036

john_wang — Tue, 28 Jul 2026 14:23:15 GMT

Hello @gopikrishnan06 ,

Thanks for the update. Our support team will be more than happy to assist you with this case and work with you to investigate and resolve the issue.

thanks,

John.

Re: INVALID_STATE: Invalid SessionHandle: SessionHandle [01f18796-eb22-1cc1-97b2-2e12e5eb4036

gopikrishnan06 — Wed, 29 Jul 2026 06:00:02 GMT

Hi All,

In Support team the ticket moved to R&D team, It will take some time too. Anyone faced this type of issues Kindly share the suggestions.

Thank you,

Re: INVALID_STATE: Invalid SessionHandle: SessionHandle [01f18796-eb22-1cc1-97b2-2e12e5eb4036

gopikrishnan06 — Mon, 10 Aug 2026 12:15:49 GMT

Got Solution from Qlik and Databricks Vendor.

Installed the new Databricks ODBC Driver 2.12.1 to resolve the Invalid session timeout error.

Re: INVALID_STATE: Invalid SessionHandle: SessionHandle [01f18796-eb22-1cc1-97b2-2e12e5eb4036

john_wang — Mon, 10 Aug 2026 13:42:04 GMT

Thank you so much for your outstanding support! @gopikrishnan06