SQL Server: PCK.AUTOMIC_UTF-8.MIG-STEP05.COPY.INIT.DATA.NOILM.DST blocked

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

We have a UTF-8 migration pack issue in job PCK.AUTOMIC_UTF-8.MIG-STEP05.COPY.INIT.DATA.NOILM.DST

It fails with:

PLOG:

2025-06-18 16:42:14 - U02012003 10147761 row(s) affected
2025-06-18 16:42:14             insert into UC4TEUTF8.dbo.XRO select * from UC4_SOURCE.UC4TE.dbo.XRO where XRO_AH_Idnr between 42134002 and 119816787
2025-06-18 16:42:14 - U02012003 0 row(s) affected
2025-06-18 16:42:14             insert into UC4TEUTF8.dbo.MELD select * from UC4_SOURCE.UC4TE.dbo.MELD where meld_timestamp <= convert(datetime,'2025-06-17T00:00:00',126)
2025-06-18 16:42:25 - U02012003 1307751 row(s) affected
2025-06-18 16:42:25             insert into UC4TEUTF8.dbo.XAO select * from UC4_SOURCE.UC4TE.dbo.XAO where xao_timestamp1 <= convert(datetime,'2025-06-17T00:00:00',126)
2025-06-18 16:42:31 - U02012003 560325 row(s) affected
2025-06-18 16:42:31             SET XACT_ABORT ON
2025-06-18 16:42:31             update UC4_SOURCE.UC4TE.dbo.uc_migration set transfered='Y' where mig_run=1 and transfered='N'
2025-06-18 16:56:02             The operation could not be performed because OLE DB provider "MSOLEDBSQL" for linked server "UC4_SOURCE" was unable to begin a distributed transaction.
2025-06-18 16:56:02 - U02004025 Job-script execution was aborted.
2025-06-18 16:56:02 - U02012006 SQL Rollback executed

Report:

OLE DB provider "MSOLEDBSQL" for linked server "UC4_SOURCE" returned message "No transaction is active.".

Environment

SQL Server

Cause

IP addresses of both database servers could not be mutually resolved.

Resolution

Add the IP addresses of each database server to the host file on both database servers.