For the past three years we have been using RMS. My question is, as stated in the subject. What is the best practice to achieve stability in the connection between stores?? It seems that I have to be on top of every store little client application. I think the longest we have had the systems without connection downtime has been 14 days approximately.. Our setup couldnt be simpler. All stores connect via vpn and the "server" is a Win7. Thanks!
*This post is locked for comments
After lots of searching and testing, I found out that Microsoft Security Essentials was conflicting with my connection. Removed MSEssentials and gone. I dont even have to reboot my systems anymore!! Steady connection and no lose of connectivity. Hope this helps anyone out there having connectivity issues.
Initially we thought the same thing. We were not expecting to run into some additional expenses on getting additional PC's. We have four stores and 7 pos total (2 pos per store and 1 warehouse), 3 back office computers and last but not least 1 server which holds HQ. So basically the POS systems dont hold any data, the backoffice holds everything and the server for the HQ.
well thanks for the info!! we didnt do the FP2 because we thought it was risky and we are "content" with how our systems are running. I have not had that zip error in a long time. What did I do for it? I ran a series of command prompt commands I found online. I think it was a command and a registry change. It worked for a while then we got the zip error and probably we havent had it for a few months now.
Is their a way to on issue an sql command to reindex all tables in the SO database from a script?
"Nope. FP2 will not fix Zip File Error problem."
Have you tried using the the -q command line switch for HQClient that was added in Hotfix 32/2.0.1001? We haven't seen any Dynazip errors since we did that.
Not to harp on things, but I'm still not clear on where to put things. It sounds like I need a lot of PCs....
My DB server is a 64 bit machine with 2 30GB hard drives and 4 GB memory. The only things on it are 3 databases (2 store databases and 1 HQ database). It is running full SQL Server 2008 R2 (not Express) I only have 2 stores to connect to and probably only 1 or 2 times a day. Will HQ server really be that taxing?
Besides that server, I have another server that holds another application. It will have much more activity but I can put something else on it.
Then I have 2 store PCs (NCR 50s), and a back office computer at each store. It would seem to keep HQ Server and Client off machines that someone else will be using, but I'm not sure where else to put them.
Thanks.
Good to know that separate HQServer from DB will help alot! I am separating the server ASAP. Thanks for the info!
Nope. FP2 will not fix Zip File Error problem.
DR.RYU Isnt the Feature Pack 2 supposed to fix the Zip File error? We get that error as well but we dont have the FP2 installed. I am a firm believer that the system works more stable on a separate environment. From the moment we separated HQServer from DB, alot of our issues were gone instantly.
we never restarted the computer. But only issue we have is, Sometime we get Zip File error on HQ Client. Other side problem we have is when Client upload the data to HQ Server, Server will receive the data and send the data to SQL. During that time, HQ Manager will freeze up for couple second. sometime it could freeze up for more than 15 seconds. So I am going to separate the HQ Server and DB server.
That is the only thing other than that, everything works great.
oh... sometime, POS gets crash and it won't open so we have to kill the process from Task Manager to reopen. So I use RoC program to run the POS all the time even they shutdown the POS.
HQ Client, there's no software that kill the Zip File Error. Even RoC will not kill the process and restart the program....
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,782 Super User 2024 Season 2
Martin Dráb 229,067 Most Valuable Professional
nmaenpaa 101,150