SQL error when installing patch 18.00.129.000
Symptoms
The patch installation fails with an error message in the Changepoint.DatabaseServices.DBMigrations.dll log file:
!!! CREATE DATABASE statement not allowed within multi-statement transaction.
Importing Changepoint SQL code failed.
Exit Code:-1
Reason
This error occurs if the Changepoint_CPExtended database does not exist when the patch is installed. Every valid Changepoint installation must have a Changepoint_CPExtended database.
Resolution
Before installing the patch, recreate the CPExtended database by running the following statement in the Changepoint database:
Exec DBM_SetupCPExtended