Skip to main content
Planview Customer Success Center

Importing CSP file fails with error on table ResourceProjects while upgrading to V2014

Symptomshe upgrade to Changepoint V2014 fails during the import of the CSP file.

Error/Warning Messges
Cannot drop the table '#ResourceProjects' because it does not exist or you do not have permission.

Reason
The upgrade tries to fix an inconsistency in the ProjectCoManageManager by finding the correct workgroup for each project/comanager.
If the workgroup information itself is inconsistent, this can fail and the upgrade aborts.


Resolution
This can be solved by fixing the workgroup data for the concerned resources before the upgrade.

1. The concerned resources can be found using this script

Select distinct resourceid, name, c as WorkgroupCount
From (
SELECT distinct p.ResourceID, r.name, p.ProjectID,
(select count(*) From WorkgroupHistoryMember wm
Where p.ResourceID = wm.ResourceID
AND wm.EffectiveDate < GETDATE()
AND ISNULL(wm.EndDate, GETDATE() + 1) > GETDATE()) c
FROM ProjectCoManageMember p
JOIN Resources r
ON p.resourceID = r.resourceID
AND r.deleted = 0
JOIN WorkgroupHistoryMember wm
ON p.ResourceID = wm.ResourceID
AND wm.EffectiveDate < GETDATE()
AND ISNULL(wm.EndDate, GETDATE() + 1) > GETDATE()
WHERE (r.TerminationDate IS NULL OR r.TerminationDate > GETDATE())
AND wm.WorkgroupHistoryMemberType <> 'uns' ) te
where c != 1

2. For each concerned resources, do a

exec WorkgroupMembershipAnalysis '<resourceid>',1

Please use WorkgroupMembershipAnalysis that we provided under patch # 16.02.128.000

Before launching the upgrade again, rerun the query to make sure it does not return any rows any more.