Errors when running delete statement

Document ID : KB000092988
Last Modified Date : 25/04/2018
Show Technical Document Details
Issue:
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