Skip to main content

Notifications

Microsoft Dynamics RMS forum

I am having an issue with a 250 worksheet.

Posted on by

I am having an issue with a 250 worksheet.  We are running RMS 2.0 sp2.  If we run a 250 worksheet with a few hundred items the worksheet finishes with no problems.  If we run a 250 worksheet with 10,000 items on a remote store the worksheet tries to run, but never finishes and never has any errors. A local store running on the same computer as the HQ completes the 250 worksheet with no problems no matter how many items are in it. We are running SQL server 2005 express.  The HQ is about 2GB in size and the two store databases are close to 1GB.  The HQ database has about 125,000 items.  The computer the HQ and one store is running on is a one year old Dell with 2GB of memory.  I ordered another 4GB of memory today for the server.  I bumped up the timout setting to 120 seconds in the HQ Client.  Does anyone else have any ideas why we are having this problem?

*This post is locked for comments

  • Arun J Profile Picture
    Arun J 75 on at
    Re: I am having an issue with a 250 worksheet.

    To solve this problem, please divide updating items by departments / category and send through many 250 worksheets. I mean, in 250 WS, you have option to filter items. So add 100-200 items in a single WS and make communication with store. Hope this will make sense.

  • Greg Gouveia Profile Picture
    Greg Gouveia on at
    Re: I am having an issue with a 250 worksheet.

    Slow internet may be the problem.  They have a fairly slow DSL connection.  Perhaps they can upgrade.

    Greg

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: I am having an issue with a 250 worksheet.

    It's probably the network connection speed giving the delay and causing the timeout.  You will need to run multiple smaller worksheets, or figure out if there is a smaller set of items that need to be updated and just run those.  Last recourse would be to export a new database from HQ and copy that to the store to replace their current data.

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,818 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,147 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans