Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Auto-sequence & Reports Freezes

Status
Not open for further replies.

car94401

IS-IT--Management
Mar 1, 2010
3
CA
I have situations where AS&R freezes randomly. I restart the SQL service on the server and all is well again. Does anyone have any idea why my SQL servce is running but Micros freezes. Locked record maybe? Thanks.
 
Hi,
Take a look at the time, and compare it to the server log.
The log tells what it is waiting for
 
What version are you running?

I reported a similar bug that was fixed in 4.3 or 4.4 There was a memory leak in res when the server had dual processors. It affected dual processors and windows 2003 sp2.

If your res server is runinng on xp then you might want to check how often your autosequences are running and make sure they are running and actually finishing. Also we had totals posting to the dashboard every 1 minutes and this caused the service to lock up and we were not able to run any reports.
 
In what way does it freeze?

Are you running an autosequence and it just has the first line of the autosequence saying starting. If so this was a problem in 3.2 when hyper threading was enabled on the server.
It happened randomly.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top