Skip to main content
Planview Customer Success Center

Database error regarding isolation levels when upgrading

Symptoms
When trying to upgrade the database an error occurs.

Error/Warning messages
Importing Changepoint SQL code failed.

You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels.

Reason
Data replication prevented the upgrade from completing.


Resolution
Drop database replication and upgrade will go through without issue.

A sample Microsoft article describing how this is done is shown below:

http://support.microsoft.com/kb/324401

Note: The dropping of database replication must be done by the customers SQL database administrator.