Map issue – Deadlocked Transaction
I periodically receive the following errors when a scheduled map is run. These errors were generated from different runs of the same map.
Can anyone point me in the right direction as to why I might be receiving the messages. Is there some sort of timeout parameter that I may need to adjust within SQL or SmartConnect?
SC version: 20.13.1.95 SQL Server version 11.0.3128
Transaction (Process ID ???) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Transaction (Process ID ???) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Answers
Best Answer
What type of update are you doing at the time you get the error? Are you updating Dynamics GP data or another destination? A deadlock is going to occur when trying to update a destination that is locked by another process. There isn't a setting in SmartConnect that can be changed other than to run the SmartConnect Map at a different time in the day.