Getting "The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION"

book

Article ID: 210941

calendar_today

Updated On:

Products

Ghost Solution Suite

Issue/Introduction

While trying to rename a Job or Task, this error  "The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION"  

started happening after:

1. Scenario one: attaching the GSS database from another SQL server but using a different account than the original one:

Restored a copy of his existing database to a newly installed GSS 3.3 RU6 server.

The account used for their ghost database on the original SQL server was ".\ghost3svc"

On the new SQL server,  the account is "domain\svcGhost"

2. Scenario 2: upgrading using a different SQL account: (for example, they used SA originally and they were using nt authentication during the upgrade).

SA account was originally used to connect to the database and during the upgrade they were using NT Authentication. 

Cause

The customer's problem is an incorrect user configuration in the 'eXpress' database:

1. Have GSS 3.3 RU3 using SQL Instance 1 with configured Login (account1)
2. Backed up eXpress db and restored it to another SQL Instance 2 with configured Login (domain account2)
3. Run GSS 3.3 RU6 installation to new clean machine using SQL Instance 2 and domain account2.

Environment

GSS 3.3 RUx

Resolution

Try to perform the following steps to resolve issue:

1. Login new SQL instance as admin
2. Run the following query(instead of 'sa' you may put another login that is sysadmin for current SQL instance)
use [eXpress]
go
exec sp_changedbowner 'sa'
go

3. Under SQL instance Open Security > Logins
4. Select login account customer would like to use. In example, "domain\svcGhost". If it does not exist, please create it (it may be Windows local user or domain account or sql login)
5. in "Properties" of selected Login, Ensure that [eXpress] DB is selected under User Mappings and it has [public] + [db_owner] and apply changes


6. Under eXpress DB, Open Security > Users
7. Ensure user is created, under General properties has Login Name selected in Step4, under Membership properties has db_owner.