The following error message may occur when trying to publish or delete a workspace: Message: The DELETE statement conflicted with the REFERENCE constraint "defn_ver_associ_fk_defnv_to". The conflict occurred in database "fpscdb001", table "fpscdb001_system.defn_ver_association", column 'to_defn_ver_id'. |
When getting the error about the "imp_user_wksp_role", there is an import task that is referencing the container that is being deleted. The fix is to delete or edit the problem user import to remove the reference to the problem container. If this this is not successful, following the SQL scripts will also address the problem. +++ These scripts are designed to fix a delete or publish container problem when a message such as this is received: Message: The DELETE statement conflicted with the REFERENCE constraint "defn_ver_associ_fk_defnv_to". The conflict occurred in database "fpscdb001", table "fpscdb001_system.defn_ver_association", column 'to_defn_ver_id'. Exception Type: java.sql.SQLException Error Code: 016 Facility: Business.Container Build Number: 22 Download the attached ZIP file for your database platform. After extracting the attached scripts, The steps are: MAKE A BACKUP OF THE DB PRIOR TO THESE STEPS!
The example below, shows the first script updated to use a database of 'fpscdb002' and a Schema suffix of 'fpscdb002'. NOTE: You would need to update the names in all three scripts prior to executing them. USE [fpscd002]; --Note: The database name may need to be changed if your database name is different GO; alter table fpscdb002_system.defn_ver_association nocheck constraint defn_ver_associ_fk_defnv_to; alter table fpscdb002_system.defn_ver_association nocheck constraint defn_ver_associ_fk_defnv_from; |