UTF-8 Migration failing at the INITIAL step at PCK.AUTOMIC_UTF-8.MIG-STEP02.CHECK.TABLESPACE.DST

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

UTF-8 Migration failing at the INITIAL step at PCK.AUTOMIC_UTF-8.MIG-STEP02.CHECK.TABLESPACE.DST with below error. 

U00012112 Task 'PCK.AUTOMIC_UTF-8.MIG-STEP02.CHECK.TABLESPACE.DST' (RunID '0707038352') terminated with script error.

Environment

AE 24.4.3

SQL 2019

Cause

Source and Destination database Filegroups not matching. The script compares the logical Filegroups of the Source database against the Target database.

Resolution

The script PCK.AUTOMIC_UTF-8.MIG-STEP02.CHECK.TABLESPACE.DST compares the filegroups (MSSQL)  of the Source database against the Target database. It fails if the Target database is missing filegroups that exist in the Source.

Check with your DBA to compare the Source and Destination database file groups before retrying the migration.