Skip to main content
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

SQL error when installing patch 18.00.129.000

  1. Last updated
  2. Save as PDF

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