Catastrophic upgrade failure | MobiControl On-Prem 15.4.1 Build 4828

J
Joakim
Essity

When trying to install a new on-prem server with MobiControl 15.4.1 Build 4828 on a Microsoft Server 2019, where the DB is located on a separate Server 2016 with SQL Server 2016 SP3 we face an error during the installation phase. 

All System Requirements are verified to be met according to the help section area (Link)

Error seen on the installation Wizard and part of the log seen below. 

Any idea why this might be happening?

 

2021/11/02 07:37:43.070(0x00001ff0): EVENT: Add shared file: type=9, name=trimble_apk_enrollment.png
2021/11/02 07:37:43.102(0x00001ff0): EVENT: Add shared file: type=9, name=unitech_apk_enrollment.png
2021/11/02 07:37:43.117(0x00001ff0): EVENT: Add shared file: type=9, name=urovo_apk_enrollment.png
2021/11/02 07:37:43.117(0x00001ff0): EVENT: Add shared file: type=9, name=vuzix_apk_enrollment.png
2021/11/02 07:37:43.133(0x00001ff0): EVENT: Add shared file: type=9, name=winmate_apk_enrollment.png
2021/11/02 07:37:43.149(0x00001ff0): EVENT: Add shared file: type=9, name=xplore_technology_apk_enrollment.png
2021/11/02 07:37:43.164(0x00001ff0): EVENT: Add shared file: type=9, name=zebra_apk_enrollment.png
2021/11/02 07:37:43.180(0x00001ff0): EVENT: Add shared file: type=9, name=zebra_concierge.png
2021/11/02 07:37:43.180(0x00001ff0): EVENT: Add shared file: type=9, name=zebra_ET1_GB.png
2021/11/02 07:37:43.195(0x00001ff0): EVENT: Add shared file: type=9, name=zebra_MC36_apk_enrollment.png
2021/11/02 07:37:43.211(0x00001ff0): EVENT: Add shared file: type=9, name=zte_apk_enrollment.png
2021/11/02 07:37:43.227(0x00001ff0): EVENT: Add shared file: type=48, name=AzureTOUResources.zip
2021/11/02 07:37:43.305(0x00001ff0): EVENT: Reading file "C:\Users\USERID~1\AppData\Local\Temp\2\{37D25AE5-5AA3-4A50-A848-A8EAA76B1726}\{C3D9886D-256E-42B7-8026-8625E505C3C4}\InstallerInfo.xml" in order to determine the build number.
2021/11/02 07:37:43.305(0x00001ff0): EVENT: Determined the build number: 4828.
2021/11/02 07:37:43.321(0x00001ff0): EVENT: Reading file "C:\Users\USERID~1\AppData\Local\Temp\2\{37D25AE5-5AA3-4A50-A848-A8EAA76B1726}\{C3D9886D-256E-42B7-8026-8625E505C3C4}\InstallerInfo.xml" in order to determine the build number.
2021/11/02 07:37:43.399(0x00001ff0): EVENT: Determined the build number: 3829.
2021/11/02 07:37:43.414(0x00001ff0): WARNING: DBLoad: Failed to read SSL Mode from Settings table rc = 2
2021/11/02 07:37:43.414(0x00001ff0): WARNING: DBLoad: Failed to read root CA from Settings table rc = 2
2021/11/02 07:37:43.430(0x00001ff0): WARNING: DBLoad: Failed to read iOS Intermediate CA from Settings table rc = 2
2021/11/02 07:37:43.430(0x00001ff0): WARNING: DBLoad: Failed to read iOS Profile signing cert ID from Settings table rc = 2
2021/11/02 07:37:43.430(0x00001ff0): WARNING: DBLoad: Failed to read cloud link cert ID from Settings table rc = 2
2021/11/02 07:37:44.820(0x00001ff0): WARNING: DeleteCertWithSubjectContainCN Failed to delete from 'ROOT', hr=1
2021/11/02 07:37:44.883(0x00001ff0): ERROR: CryptImportKey failed with 5
2021/11/02 07:37:44.883(0x00001ff0): ERROR: CMCCertUpdate::CreateRootCert: Failed to import the MobiControl root certificate ID 1.
2021/11/02 07:37:44.883(0x00001ff0): ERROR: OLEDB error: [80004005, 3903] The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.
2021/11/02 07:37:44.883(0x00001ff0): ERROR: SQL state: [3903] 25000
2021/11/02 07:37:44.899(0x00001ff0): ERROR: CMCDbAccess::CheckResult:The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

Edited 4 years ago
SOTI MobiControl
ANSWERS
T
TMMOD@SOTI
4 years ago

Hello Joakim,

Thanks for posting on Soti central.

While running the installer and choosing the options, did you manage to choose the correct data base since your DB is on a different server ?

RK
Radim Kadlec
a year ago

I encountered a similar problem when upgrading MobiControl. The moment I set full permissions for the user accessing the database (sa) the update ran fine.