CA IT Asset ManagerCA Software Asset Manager (CA SAM)ASSET PORTFOLIO MGMT- SERVERCA Service Management - Asset Portfolio ManagementCA 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