web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics RMS (Archived)

Unable to process worksheet 401

(0) ShareShare
ReportReport
Posted on by 1,511

Hi All,

One of our RMS shops is able to process every worksheet style except style 401(Data upload)

What happens is that, whenever it contacts the HQ server, the memory on the HQ server shoots up to about 1GB(monitoring from the Task manager), beyond this point, the HQ server machine will throw an error message"Not enough memory" after taking so long. When you click OK,the HQ server will crash and close down,the HQ client at the store will also display an error message"Operation is not allowed when object is closed", but the memory on the HQ server is about 7GB

What I did was to take a backup of the store database restore it on a different environment and connected it to an HQ database(different from the live HQ). It worked in minutes. everything was uploaded successfully

 

Store Database= 600mb

HQ Database=54gb, space available=13gb Usage=75%

 

Can any one help out.

Its very urgent

 

Thanks in advance

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Jeff @ Check Point Software Profile Picture
    13,382 on at

    Michael,

    Try deleting all temp files, especially anything starting with QS*.tmp both at the store and HQ.

    Make sure you have enough RAM at both ends, at least 2 gig at the store and 3 or more at the HQ depending on the OS.

    SQL Express can use a maximum of 1 gig of RAM, all other versions are 3 or higher, plus whatever the other programs are running and the OS itself.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans