topic Re: Error in Manage Data Mart : SYS-E-SQLERR, Sql statement produced the following error: CommitTransaction() called without BeginTransaction(). in Qlik Compose

Error in Manage Data Mart : SYS-E-SQLERR, Sql statement produced the following error: CommitTransaction() called without BeginTransaction().

adpaiks — Fri, 14 Mar 2025 20:49:07 GMT

Hi,

We are using Qlik compose and get below error when accessing Manage Data Mart page:

SYS-E-SQLERR, Sql statement produced the following error: CommitTransaction() called without BeginTransaction().

No idea why this error is generated. I tried below:

1. Clearing metadata cache by using DataWarehouse -> Drop & Recreate -> Metadata cache

2. Commit, Create deployment package & re-deploy using this package

however the error persists. This is on dev environment & this error occurs many times. Usually re-deploy used to help but this time the error is persisting.

Please help to check.

Re: Error in Manage Data Mart : SYS-E-SQLERR, Sql statement produced the following error: CommitTransaction() called without BeginTransaction().

shashi_holla — Fri, 18 Feb 2022 18:46:24 GMT

I saw an old case created by your team mate on similar issue in Stage environment. Since this is happening again I think it's better to open a new Support case and the team should be able to find the root cause and fix it.

Re: Error in Manage Data Mart : SYS-E-SQLERR, Sql statement produced the following error: CommitTransaction() called without BeginTransaction().

adpaiks — Fri, 08 Jul 2022 06:00:00 GMT

Thanks. Just providing an update just incase it helps someone: Ya, we raised multiple tickets with support for this issue. They suggested to upgrade to a newer version. After the upgrade we are now facing other issues.

Re: Error in Manage Data Mart : SYS-E-SQLERR, Sql statement produced the following error: CommitT...

Steve_Nguyen — Mon, 11 Jul 2022 15:16:52 GMT

@adpaiks

if you have case open with support, please work on case with our support team.

Re: Error in Manage Data Mart : SYS-E-SQLERR, Sql statement produced the following error: CommitTransaction() called without BeginTransaction().

Nanda_Ravindra — Wed, 13 Jul 2022 21:49:46 GMT

@adpaiks is the original error (CommitTransaction() called without BeginTransaction") still coming back after the upgrade apart from seeing other issues? If so, please raise a case with support and we will work thru the issue.

Thanks,

Nanda