Skip to main content

Notifications

Microsoft Dynamics RMS forum

Best way to achieve stability in connection between stores?

Posted on by Microsoft Employee

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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Best way to achieve stability in connection between stores?

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Best way to achieve stability in connection between stores?

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Best way to achieve stability in connection between stores?

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Best way to achieve stability in connection between stores?

    Is their a way to on issue an sql command to reindex all tables in the SO database from a script?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Best way to achieve stability in connection between stores?

    "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.

    mbs2.microsoft.com/.../KBDisplay.aspx

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Best way to achieve stability in connection between stores?

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Best way to achieve stability in connection between stores?

    Good to know that separate HQServer from DB will help alot! I am separating the server ASAP. Thanks for the info!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Best way to achieve stability in connection between stores?

    Nope. FP2 will not fix Zip File Error problem.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Best way to achieve stability in connection between stores?

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Best way to achieve stability in connection between stores?

    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....

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,782 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,067 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,150

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans