New shop HQ client first 401 worksheet error

(0) Share

Report

Posted on by Community Member Microsoft Employee

This started to happen in last year, when ever we created new shop and its Sync fine with HQ. But when we issue very first 401 worksheet to shop and connect the HQ client it tries uploads complete master back to HQ database. It never gets completes after taking hours. Any idea why its happening and how to stop upload complete master to HQ database. We haven't done any update query to table after creating the store.

This error message appears after HQ client try to transfer data for nearly 2 hours.

[SnapShotQuantity] = #Temp.[SnapShotQuantity], [ItemDynamic].[SnapShotQuantityCommitted] = #Temp. [SnapShotQuantityCommitted], [ItemDynamic].

*This post is locked for comments

All responses (5)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: New shop HQ client first 401 worksheet error

Hi Jeff

Yea i meant 920k. But we have another HQ database for another country which is having 420k. once shop has created and sync is completed. I issued 401 worksheet. within 2 seconds 401 got completed and there s no item update lines on Log. Its strange that why this thing happening sometime only for 420k items HQ database and almost always for 920k items HQ database shops. Yea we are been very careful when running script especially in HQ database. That s the last option when you are frustrated issuing like 10 worksheets and still 401 processes didn’t get complete after taking 1+ hours for each.

Regards
Jeff @ Check Point ... 13,380 on at

Like (0)

Report

Re: New shop HQ client first 401 worksheet error

SDDXB,

Not that I'm aware of. Database creation doesn't mean anything, the HQ Client is sending all new info back to the HQ Server, of which in a new store, everything is new!

G4 as in Apple? You will find that MDR doesn't support much becasue they what to get involved in the big iron. 92k isn't much, but you are sending 920k items. Look back at the picture you posted.

Think through the process, depending on your sending computer's (HQ Client) speed, your Internet connection, the reciving computer's speed (HQ Server) to manipulate the data (SQL), and then send the results back, takes some time.

You could archive some of the old data, there are add-ons available.

You really need to be careful update tables directly, There is a lot of interaction with HQ tables that are not real obvious. One wrong move and poof!
Community Member Microsoft Employee on at

Like (0)

Report

Re: New shop HQ client first 401 worksheet error

Thanks Jeff & Brandon.

Is there any way to stop updating, Qty on Hand, Min/Max, etc as we are not using inventory in RMS. Only for sales. Wonder why its updating all when it was just extracted from HQ database.

Yes we have a G4 server. Need to change it soon. Again virtual was a better option if it was supported by RMS. I dont think handling 92K items is a issue for SQL database or RMS?

Then again only option is to inactive items where deleting is not recommended by RMS. Even if it s inactive it will get transfer to new store and it s available for selling as well...

When above issue happens, we update item dynamic table in HQ last update to getdate for newly created store and issue a another 401. sometimes it works. withing 45 seconds 401 get completes. but then again updating last update in item dynamic takes 1 hour + and Database should be idle.
Community Member Microsoft Employee on at

Like (0)

Report

Re: New shop HQ client first 401 worksheet error

Jeff, of course, is correct. We've only got 36K items in our DB but it still fails on us depending on the connectivity of the remote store. For this reason I export new store databases on the same server as HQ so the export takes only a couple of minutes. Then I run my initial 401 while the HQ DB and SO DB are still on the same server by pointing the store's HQ Client at the database on the hq server. Once it's processed I just back up the database and detatch it then copy the mdf and ldf over to the remote store via network or USB key. Typically we build out all the stores on-site in our corporate location before we ship them to the stores, so it only takes a couple of minutes to copy the DB from one server to the other on the LAN.

You should seriously look at your item table and see if you can figure a way to reduce the number of entries.
Jeff @ Check Point ... 13,380 on at

Like (0)

Report

Re: New shop HQ client first 401 worksheet error

SDDXB,

I think its updating HQ as to the Store's info, Qty on Hand, Min/Max, etc.

If you really need to have 920,000 + items in your database, either get a faster connection, a more robust SQL Server machine or do the first 401 while connected locally.