Skip to main content
Planview Customer Success Center

Problem migrating production (V2012)

Symptoms
When performing an upgrade to version 2012, the upgrade.dtsx package fails, and cannot complete.
 
Error/Warning Messages
Error 1: declare @dbname as..." failed with the following error: "StartService() returned error 5040, 'The cluster node already exists.'". Possible failure

Error 2: failed with the following error: "The filegroup 'dbChangepoint_PT1' cannot be removed because it is not empty.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.  


Resolution
Resolution to Error 1:

You need to use the name of the Active Server node in the upgrade.ini file, you should be able to get this information from the SQL DBA on site.

Resolution to Error 2:

Check to see if the PT file group is empty using the following query:

select c.Name, b.name AS 'FileGroup'
from sys.indexes a inner join sys.tables c
on a.object_id = c.object_id
inner join sys.data_spaces b on a.data_space_id = b.data_space_id
WHERE b.Name = 'dbChangepoint_PT1'
ORDER BY 2, 1

Change the Name to the applicable PT filegroup # noted in the error.

If the PT tables are not used, they can be manually deleted in SQL management studio by browsing to the Properties of the Changepoint database and selecting FileGroups.