Showing results for 
Search instead for 
Did you mean: 

Deadlock found while doing data migration for few tables (eg pgrels )

0 Kudos

We are using data migration extension (commercemigration) to copy few tables and data from SAP CCV2 MSSQL database to another instance of MSSQL database which is not hosted on cloud. When the migration job is running ,its giving below deadlock error and causing the failure. When the data is migrated to another oracle database from SAP CCV2 MSSQL database, issue in not occurring. This issue is occurring for migration of data to MSSQL database instance.

PFB the error from logs:-

log:ERROR [MigrationMonitor] [CustomClusterDatabaseCopyScheduler] {migrationID=cc356648-390e-4f64-b041-7d4100824ce7, pipeline=processes->processes, clusterID=6} 1435/2435 processed. FAILED in {-1}. Cause: {java.lang.RuntimeException: SQLServerException: Transaction (Process ID 143) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.} Last Update: {2023-09-26T21:30:13.727} @timestamp:Sep 27, 2023 @ 03:00:18.112 kubernetes.pod_id:8e7f2b20-f6f5-49b5-8f9f-a33c5c0852b6 kubernetes.container_name:platform

Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

Hi Arnab

Try to restart the system (SAP and DB instance) and retry the same phase.