x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 16 replies
  • Subscribers 133 subscribers
  • Views 10702 views
  • Users 0 members are here
Browse Forums
Announcements
270
topics
260
replies
Databases and Operating Systems
760
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
852
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
876
topics
3k
replies
Sage CRM for Sage 300
183
topics
412
replies
Jim Love

Sage 300 RemoteApp Sessions Freezing

Posted By

One of our clients using Sage 300 2014 through RemoteApp on Windows Server 2012 has been experiencing occasional session freezes. It happens to several different users (the ones who work in Accpac the most), but not everyone.  It most often (but not always) happens when the Print button is clicked to print a Crystal form or report. The client has two locations. This happens at both locations, but at one, they tell us that if they wait a few minutes, they can resume work. At the other location, where freezes occur more often, someone with the Admin password (usually me) has to force the user's Accpac session to close, using that function in the Current Users screen. The client has two beefy servers, one dedicated to SQL Server, the other dedicated to Sage 300, both hosted at Rackspace. We have other clients with the same setup (but not at Rackspace) who have no such issues. We have so far not been able to pin this down. Any ideas?  Thanks.

Parents Reply Children
  • 0 in reply to Django
    VM running Windows 2012 R2 Sage 300 2012 PU4. User access using RDP and run Sage without a Windows desktop. AP batch entry clerk hangs most regular and on some days it could be five mins between working hanging being signed off and then hanging again. No signs of any issues with other users and the server has plenty of free ram. SQL memory fixed at 4gb. Other users work fine when an AP batch user hangs. Not always the same login as the AP batches are occasionally entered by another user who also hangs. When the user hangs the UI Continer is the only Sage item loaded other than sign on and desktop. Not sure if printing to screen is used as I have seen some issues caused by Crystal.
  • 0 in reply to oakley
    Just a bunch of generic troubleshooting questions:

    You said SQL memory fixed at 4gb. Is the SQL server prevented from using more than 4gb?

    Does the issue occur at the same times during the day?

    Does the event viewer show any issues occurring at the same time?

    Is it happening when they are in invoice entry or payment entry or just when trying to create a bath from the batch listing?

    Does it happen after entering a vendor number or when entering any other field data in particular?

    How are the sql indexes? Have they been rebuilt recently?

    Are there any SQL maintenance routines that could be running during that time?
  • 0 in reply to Django
    In one particular bad case the customer reported freezes every hour on the hour.... it did not take long to find an SQL backup scheduled to run every hour on the hour. Strange what some IT people do....
  • 0 in reply to Django
    You said SQL memory fixed at 4gb. Is the SQL server prevented from using more than 4gb? Yes

    Does the issue occur at the same times during the day? No

    Does the event viewer show any issues occurring at the same time? Nothing that relates to the user or Sage

    Is it happening when they are in invoice entry or payment entry or just when trying to create a bath from the batch listing? Payment entry

    Does it happen after entering a vendor number or when entering any other field data in particular? Not sure

    How are the sql indexes? Have they been rebuilt recently? SQL maint job runs nightly and rebuilds indexes

    Are there any SQL maintenance routines that could be running during that time? No
  • 0 in reply to 49153
    No backups running only over night

*Community Hub is the new name for Sage City