Upgrade to V24 failed with "Step04 - failed in DESTINATION DB" 'Status_Text' modified from 'Job ended' to 'SRC: 306 DST: 305'

Products

• CA Automic One Automation

Issue/Introduction

The error message is "Step04 - failed in DESTINATION DB" and this is happening at the initial phase of the upgrade. 
The post condition report shows a mismatch of the table counts between the SRC and DST:
'Status_Text' modified from 'Job ended' to 'SRC: 306 DST: 305'. 

Environment

Upgrade from 21.0.9 to 24.4.1
Database: MSSQL Server 

Cause

In this case, the Source Database has 306 tables and Destination database has 305 tables.

Resolution

• With the help of DBA identify the table which is mismatch
• In this case the source database has a system table "dtproperties" table which is non-Automic table and so it is not migrated to Destination database
• Check with DBA to drop the table from source database
• Remove and recreate the destination database
• Run migration pack again