Errors when running delete statement
search cancel

Errors when running delete statement

book

Article ID: 92988

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Restored our production database to a test environment.  When clearing the tables mentioned here for ITAM:
https://docops.ca.com/ca-service-management/14-1/en/implementing/how-to-move-the-ca-mdb-data-from-the-source-to-the-target-systems/move-the-ca-mdb-database-on-microsoft-sql-server

delete from al_apmp_def Msg 547, Level 16, State 0, Line 1 The DELETE statement conflicted with the REFERENCE constraint "al_apmp_progress_al_apmp_fk1". The conflict occurred in database "mdb", table "dbo.al_apmp_progress", column 'apmp_id'. The statement has been terminated.

delete from al_apmp_operation Msg 547, Level 16, State 0, Line 1 The DELETE statement conflicted with the REFERENCE constraint "al_apmp_def_al_apmp_opera_fk1". The conflict occurred in database "mdb", table "dbo.al_apmp_def", column 'operation'. The statement has been terminated. delete from al_apmp_progress_status Msg 208, Level 16, State 1, Line 1 Invalid object name 'al_apmp_progress_status'.

delete from al_apmp_run_stage Msg 547, Level 16, State 0, Line 1 The DELETE statement conflicted with the REFERENCE constraint "al_apmp_progress_al_apmp_fk2". The conflict occurred in database "mdb", table "dbo.al_apmp_progress", column 'stage_id'. The statement has been terminated.

Environment

CA Asset Portfolio Management 14.x, 17.x

Cause

The documentation has a missing table and a misspelled table name. 

Resolution

Run the following deletes, in this order:
delete from al_apmp_content_types
delete from al_apmp_progress
delete from al_apmp_record_filter
delete from al_apmp_run_stage
delete from al_apmp_def
delete from al_apmp_operation