While trying to create or rename a Job and or Task, this error "The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION"
In another instance of this same issue, agent upgrade jobs automatically created by GSS had no tasks (blank) after an upgrade and Windows Event Viewer logs were full of the same error. Also, machines wouldn't check in because their agents wouldn't upgrade.
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.
3. New install of Ghost Solution Suite 3.3 RU 11 on Windows 2022 Server. Using SQL Express 2022 locally installed.
GSS 3.3 RUx
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.
In situation, SQL Express 2022 was installed locally with the Ghost Solution Suite server. SQL Server Express was installed correctly using a domain user account that is a local administrator on the server. To resolve this issue, SQL Express was removed and reinstalled, choosing Mixed Mode during the installation. This allows for the SA account to be used. SQL Express was still installed using the domain user account, and the error described in this article occurred.
To resolve, the following command was executed:
exec sp_changedbowner 'sa'
This will change the owner of the eXpress database from the domain user to the SA account. This is the only change that was required.
Comparing the SA account to the domain user, not apparent differences were present. Therefore, it was determined something environmental had caused this issue. Using SA as the database owner should be just fine.