Article Content
Article Number | 000036586 | ||
Applies To | RSA Product Set: Archer RSA Product/Service Type: Archer RSA Version/Condition: 6.x | ||
Issue | During an upgrade, an error occurs.
This also shows on the website as well: Server Error in '/' Application. The DELETE statement conflicted with the REFERENCE constraint "FK_tblPackageExportObject_tblPackage". The conflict occurred in database "database name here", table "dbo.tblPackageExportObject", column 'package_id'.The statement has been terminated.SQL statement: usp_delete_package @userToken = 'xxxxxxx', @packageId = xxx Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: ArcherTech.Web.UI.ArcherException: The DELETE statement conflicted with the REFERENCE constraint "FK_tblPackageExportObject_tblPackage". The conflict occurred in database "UAT2_INST_ARCHER", table "dbo.tblPackageExportObject", column 'package_id'.The statement has been terminated.SQL statement: usp_delete_package @userToken = 'xxxxxxx', @packageId = xxx Source Error:
Stack Trace:
| ||
Cause | There may be either
| ||
Resolution | Ensure that you have a pre-upgrade backup of the instance DB. Ensure you have a mid-upgrade backup of the instance DB. DELETE all values from
|