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

[adpaiks]

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. 

[shashi_holla · Accepted solution]

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.

[adpaiks]

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.

[Steve_Nguyen]

@adpaiks

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

[Nanda_Ravindra]

@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