100
I keep getting 250 worksheets which show as green flagged for stores, but that haven't been processed correctly. If you check the event log they are red crossed, usually deadlocked on resources. This is quite annoying as the first time you tend to discover it is when another worksheet goes pink because the info in the 250 hasn't been updated.
Does anyone else get this? We are running HQ v2.0 0155
*This post is locked for comments
Hello Andy,
If you wish to test this further without removing the customizations from the live database, you could create a test environment by using a sample database on the Store side and the Sample HQ on the HQ side. You can switch out the HQ Server and HQ Client for a time and run some 250 worksheets. This is a little more cumbersome but can help in finding out if the issues are being caused by a customization, or the multple HQ Servers.
Best Regards,
Shawn with Microsoft Retail Support.
(Hello Andy,
Another case where I have seen deadlocks occur is when a third party customization is in use and it tries to write to a table that the program is writing to. If you have any third party customizations have you tried to disable them for a store that having frequent problems to eliminate this possibility?
Also, are you using Headquarters Client or Headquarters Server as a service?'
Best regards,
Shawn with Microsoft Retail Support.)
Hi Shawn
Thats interesting, we do have a reasonable amount of customizations done by our partner. They are all there for a purpose so I am not sure about disabling them.
We run Hq client and server as applications not services.
Thanks
Andy
Hello Andy,
You are correct, we actually recommend not using a worksheet 260 in almost every circumstance. For the most part there are other worksheets that will accomplish what you are after. The worksheet 260 will create new items at the store level based on HQ inventory, but it often causes issues with quantities as the Headquarters is not always completly accurate.
When creating a new item, we do very much recommend using the worksheet 250 as you are doing. The 260 worksheet being disabled is a good thing, especially if you are have a partner that you use for assistance, and let them decide when a 260 worksheet should be used.
Best Regards,
Shawn with Microsoft Retail Support.
Hi Spencer
I am a little confused about the 250 or 260 worksheet issue. We have never used a 260, in fact they were disabled using the security settings by our Microsoft reseller when the program was installed 4 years ago. We always use a 250 to update the stores with new items created at Hq, and this generally works fine.
I have read other threads which also suggest not using 260 worksheets, but I am unsure as to why.
Andrew
Hi Andy,
I know this doesn't address the error in the logs or the mis-colored worksheets, and judging by the fact that you said it only occurs once a week I'm fairly sure you know this and it isn't the issue, but I figured I'd mention it just to preclude an easy fix: you said it "usually occur[s] when we are creating new items and there are a lot of 250 and 308 worksheets being put through". Worksheet 250 can only be used to update existing items, not download newly created ones (which should be done with a 260). If you were attempting to download new items with a 250, it would explain why your 308s fail to find items in a store's database.
As I said, just throwing it out there.
-Spencer
Hello Andy,
Another case where I have seen deadlocks occur is when a third party customization is in use and it tries to write to a table that the program is writing to. If you have any third party customizations have you tried to disable them for a store that having frequent problems to eliminate this possibility?
Also, are you using Headquarters Client or Headquarters Server as a service?'
Best regards,
Shawn with Microsoft Retail Support.
Hi Shawn
99 times out of a 100 the error in the HQ event log is a deadlocked on resources error.
The error in the Hq event log is listed next to 'store' rather than 'HQ'.
It happens on lots of different stores.
Thanks
Andy
Hello Andy,
So when you get a red flagged worksheet or a green that didnt' complete is it always accompanied with an error in the HQ Event Log? Are those errors always a deadlock error?
The deadlock error message that occurs if you are using multiple HQ Server could very well be showing on the HQ Client side. One thing to help narrow this down is:
Does this issue only happen on one store or all stores?
Hi Shawn
Thanks for the response.
We are running 3 instances of Hq server. This is something that was instigated by our RMS reseller to alleviate polling issues. The deadlock error is usually listed against the store not hq in the event log, and I am guessing that having multiple HQ servers wouldn't affect the store database as each store is assigned to one Hq server.
I am not sure how many stores were polling at the same time. We have 14 and they are all set to poll in a 10 minute window every hour. Please note the worksheets weren't red flagged, that’s the problem. They should have been red flagged as the event log shows an error, but the worksheet history doesn't show an error and they are green flagged. Subsequent 308 worksheets went pink (items not found in store database), on investigation the error in the event log was discovered.
Our 250 worksheets vary from a few, to a few hundred items. We try to keep them below 1000. Of the three that should have been red flagged but weren't, 1 had 353, 1 had 118, and 1 had 4 items in.
We get red worksheets very frequently, sometimes several a day. Green worksheets that should be red are less frequent but more annoying. Maybe 1 a week on average. They usually occur when we are creating new items and there are a lot of 250 and 308 worksheets being put through.
If we run another identical 250 it has always gone through.
thanks
Andy
Hello Andy,
Often times deadlocks occur because of mutlple HQ Servers.
Are you using more than one?
Also, how many stores are processing at any given time, and do you know how many were processing when the worksheet red flagged?
How many items are you adding to the worksheet 250?
How often does this occur?
If you run another 250 that is identical, does it go through?
Best of wishes,
Shawn with Microsoft Retail Support.
#1
André Arnaud de Cal...
291,431
Super User 2024 Season 2
#2
Martin Dráb
230,503
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
