Skip to main content
Planview Customer Success Center

Error during upgrade from version 2010 to 2012

Symptoms
When running the DTSX package upgrading from V2010 to v2012, the following message is generated:
The Delete statement conflict with reference constraint "FK_ReportSharedProviders_Report1"
"The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.


Answer
In version 2012, the Recruitment Management report has been dropped due to low usage. Thus the report category for these reports should be modified.

1. SELECT ReportID, Name FROM Report WHERE ReportCategory = ‘67CF8A3C-9392-4C1A-8B21-5FB7D95450FE’ . This categoryID is recruitment management report category guid.

2. Run this script:
UPDATE d SET d.LookupId = NULL , d.LinkId = NULL, d.SourceColumnLookupId = NULL, d.LinkUrl = NULL, d.EntityType = NULL, d.EntityId = NULL
FROM DataSourceColumns d
INNER JOIN DataSourceColumnLookupType t
ON d.LookupId = t.LookupId
WHERE t.LookupObject LIKE ‘%Requisition%’

3. Identify the reports assigned to the Recruitment Management report category ID
SELECT ReportID, Name FROM Report WHERE ReportCategory = ‘67CF8A3C-9392-4C1A-8B21-5FB7D95450FE’

4. Look for the available categories that you can chnge the reports to:
SELECT * FROM ReportCategoryDescription

5. Update the Report tables for the impacted reports and assign them (returned from the select statement below) to a new CategoryID
UPDATE Report SET ReportCategory = WHERE ReportID IN (…)