How to avoid deadlock while running data migration using sap-commerce-migration-toolkit?

[former_member681238]

Hello All,

We are exploring commerce-migration-toolkit while running it we are frequently getting below error.

2023-02-08T11:02:44.184Z | renderertemplatelp->renderertemplatelp | 259 / 259 | FAILED! Reason: Transaction (Process ID 74) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Due to this migration is failing.

I can see in logs same table is appearing multiple times.

2023-02-08T11:02:30.217Z | renderertemplatelp->renderertemplatelp | 0 / 259 | In progress...

2023-02-08T11:02:40.514Z | renderertemplatelp->renderertemplatelp | 259 / 259 | In progress...

2023-02-08T11:02:44.184Z | renderertemplatelp->renderertemplatelp | 259 / 259 | FAILED! Reason: Transaction (Process ID 74) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Please share if anyone faced this issue and is there any configuration available to avoid such deadlock.

Regards,

Amrita