You’re offline. This is a read only version of the page.
Hi,
Does anyone have this deadlock issue with HQ Client?
"transaction(Process ID 59) was deadlocked on lock resources with another process and has been choosen as the deadlock victim.Return the transaction"
I am having this issue at few of my HQ Client stores. It occur couple of times a day.
I use query - "SET DEADLOCK_PRIORITY NORMAL; GO' and this did not help. I always backdate 401 worksheet so it will upload data again. Otherwise, it will not upload any data at all.
I am currently running two different server computers.
Server1 - Running SQL Server 2008 / Windows Server 2008
Server2 - Running WIndows Server 2008 / 6 Different HQ Servers with a different server ports
Stores x 23 - Each HQ Servers running 4 store connections and each store connection time is 10mins apart from each store connection
Is there any Hotfix that will fix this issue?
-Danny
*This post is locked for comments
Scott, I have upgraded to CU5 and Hotfix#40 and it still giving me a deadlock error from HQ Client.
Store connection times are different from each stores. they are 10 mins apart.
Like I mentioned, I am running 6 different HQ Server app from one machine.
they all have different port numbers and each server contains 5 different stores to connect. Stores connect every hours with 10/20/30/40/50 min. And other server apps are same connection settings.
Connect at XX minutes past the hour.
Port# 34000
S1 - 10min
S2 - 20min
S3 - 30min
S4 - 40min
S5 - 50min
Port#34100
S1 - 10min
S2 - 20min
S3 - 30min
S4 - 40min
S5 - 50min
Port#34200
S1 - 10min
S2 - 20min
S3 - 30min
S4 - 40min
S5 - 50min
I have 6 servers connection like this to HQ servers.
Does connection time must be different even they are connecting to different server?
Hi Scott,
We are currently using FP2 and my RMS ver 2.0.1005.
I am running Headquarter Server and Database server separately two different machine.
On the HQ Server machine, I am running 6 different HQ Servers using HQServer command.
Do you recommend using separate machine running each servers?
Also, my HQ Client is running on same machine where Store Database is also it runs the POS as well.
I will separate those programs.
Hello Danny,
Thank you for your question.
A number of Deadlock errors were resolved on Cumulative Update 5, which will bring you up to version 2.0.2000.
Also make sure that your stores are not connecting to headquarters at the same time by staggering the connections times and that Headquarters Client is not running on the same computer that hosts the store database and that Headquarters Server is not on the computer hosting the Headquarters database.
Thank you,
Scott Wardzinski
Microsoft Dynamics RMS & POS Support Engineer
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (