topic Re: Unable to Connect to DB2 iSeries – Error in "SET TRANSACTION ISOLATION LEVEL" in Qlik Replicate

Unable to Connect to DB2 iSeries – Error in "SET TRANSACTION ISOLATION LEVEL"

EE_ — Wed, 18 Jun 2025 03:26:42 GMT

Dear Qlik Support,

My customer is experiencing an issue when connecting to a DB2 iSeries data source using the IBM i Access ODBC Driver (version: IBMiAccess_v1r1_WindowsAP_English). The following error message is displayed:

SYS-E-HTTPFAIL, Cannot connect to DB2 i Server.
SYS,GENERAL_EXCEPTION,Cannot connect to DB2 i Server,Error in SET TRANSACTION ISOLATION LEVEL READ COMMITTED
RetCode: SQL_ERROR
SqlState: HY000
NativeError: 19792
Message: [IBM][System i Access ODBC Driver][DB2 for i5/OS] - Error message text unavailable. Message can not be translated successfully.

RetCode: SQL_ERROR
SqlState: 42000
NativeError: -104
Message: [IBM][System i Access ODBC Driver][DB2 for i5/OS] - Error message text unavailable. Message can not be translated successfully.

Failed (retcode -1) to execute statement: SET TRANSACTION ISOLATION LEVEL READ COMMITTED

Could you please advise how we can adjust or troubleshoot this error?

Re: Unable to Connect to DB2 iSeries – Error in "SET TRANSACTION ISOLATION LEVEL"

Dana_Baldwin — Thu, 19 Jun 2025 00:04:14 GMT

Hi @EE_

Please advise regarding the full version number of Qlik Replicate, DB2i and driver that you are using. So far I'm not able to find information on native error 19792 or -104.

Is this a new endpoint connection?

Has the firewall been opened correctly? You may need to involve the DB2 DBA to know which ports need to be opened.

Are you running the task when this happens or just testing the connection in the endpoint configuration? If running the task set logging for Source_Capture to Trace to see if you can get additional details about the error.

Thanks,

Dana

Re: Unable to Connect to DB2 iSeries – Error in "SET TRANSACTION ISOLATION LEVEL"

EE_ — Thu, 19 Jun 2025 03:31:32 GMT

Hi @Dana_Baldwin

Thank you for your assistance.

Here is the requested information:

Qlik Replicate version: 2024 May
DB2i version: V7R5
ODBC driver version: 13.64.28
Is this a new endpoint connection? Yes
Firewall: Confirmed to be opened correctly
Current activity: We are just testing the connection in the endpoint configuration, not running the task yet.

Re: Unable to Connect to DB2 iSeries – Error in "SET TRANSACTION ISOLATION LEVEL"

john_wang — Thu, 19 Jun 2025 13:58:42 GMT

Hello @EE_ ,

It appears the issue is related to the IBM i Access ODBC Driver. Possible causes include:

Missing or outdated message files on the Windows client
Locale or language mismatch between the client and the IBM i system
Corrupted or misconfigured IBM i Access ODBC driver installation

Could you please try creating a 64-bit ODBC DSN and check whether the connection works?

If you're running on Linux, please share the contents of the file "/etc/odbcinst.ini" so we can review the driver configuration.

thanks,

John.

Re: Unable to Connect to DB2 iSeries – Error in "SET TRANSACTION ISOLATION LEVEL"

EE_ — Tue, 24 Jun 2025 03:37:27 GMT

Hi @john_wang ,

We have already adjusted the ODBC Driver settings and configured Qlik to use a DSN connection. However, the following error message still appears:

SYS-E-HTTPFAIL, Cannot connect to DB2 i Server.
SYS,GENERAL_EXCEPTION,Cannot connect to DB2 i Server, RetCode:
SQL_ERROR Sqlstate: HY000 NativeError: 79899
Message: [IBM][System i Access ODBC Driver][DB2 for i5/OS] - Error message text unavailable. Message cannot be translated successfully.

May I ask if there are any missing configurations in the ODBC Driver that could be causing this issue?

Looking forward to your reply.
Thank you.

Re: Unable to Connect to DB2 iSeries – Error in "SET TRANSACTION ISOLATION LEVEL"

john_wang — Tue, 24 Jun 2025 14:30:17 GMT

Hello @EE_ ,

It appears there may be an issue with the installation or configuration.

Could you please try testing the connectivity using a 64-bit ODBC DSN and check if a simple query can be executed successfully through the DSN?

thanks,

John.

Re: Unable to Connect to DB2 iSeries – Error in "SET TRANSACTION ISOLATION LEVEL"

R2JOE — Wed, 30 Jul 2025 00:49:58 GMT

Hello @EY_, I have the same problem. Have you solved it? Thank you.

Re: Unable to Connect to DB2 iSeries – Error in "SET TRANSACTION ISOLATION LEVEL"

EE_ — Wed, 30 Jul 2025 08:59:27 GMT

Hello @R2JOE, unfortunately, we're still working on it.

Re: Unable to Connect to DB2 iSeries – Error in "SET TRANSACTION ISOLATION LEVEL"

DesmondWOO — Thu, 31 Jul 2025 04:23:10 GMT

Hi @EE_ ,

I've installed iAccess 13.64.28, and I haven't encountered your issue with Qlik Replicate v2024.11.

Could you connect to the database using an ODBC tool, such as Excel?

Regards,
Desmond

Re: Unable to Connect to DB2 iSeries – Error in "SET TRANSACTION ISOLATION LEVEL"

R2JOE — Fri, 01 Aug 2025 03:35:03 GMT

Are you installing QlikReplicate on Windows 2022?
(My QlikReplicate Verison:2024.5.0.563,ODBC driver Verison:13.64.28)

Re: Unable to Connect to DB2 iSeries – Error in "SET TRANSACTION ISOLATION LEVEL"

DesmondWOO — Fri, 01 Aug 2025 07:53:03 GMT

Hi @R2JOE ,

My Qlik Replicate is running on Windows 11, but I have also tried it on Windows Server 2016.

Regards,
Desmond

Re: Unable to Connect to DB2 iSeries – Error in "SET TRANSACTION ISOLATION LEVEL"

R2JOE — Fri, 01 Aug 2025 08:04:40 GMT

Hello @EE_ ,Are you installing QlikReplicate on Windows 2022?
(My QlikReplicate Verison:2024.5.0.563,ODBC driver Verison:13.64.28)

Re: Unable to Connect to DB2 iSeries – Error in "SET TRANSACTION ISOLATION LEVEL"

R2JOE — Tue, 30 Sep 2025 02:20:27 GMT

Hi @EE_ .I have resolved the issue. First, I uninstalled the ODBC driver and Qlik Replicate, then reinstalled both. Everything is now working properly.I’m sharing this for your reference.