cancel
Showing results for 
Search instead for 
Did you mean: 

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

arnabbanerjee
Member
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.host:aks-gej972pjh1-33264970-vmss00005t kubernetes.pod_id:8e7f2b20-f6f5-49b5-8f9f-a33c5c0852b6 kubernetes.container_name:platform



Accepted Solutions (0)

Answers (1)

Answers (1)

sriramsbg
Active Contributor
0 Kudos

Hi Arnab

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

Regards

SS