How to clear or remove stranded Sage line 50 users

Share on Facebook

I found very little information available online on the subject and so felt the need to write a few lines to save someone else the agony.

The problem occurs with Sage Line 50 using data files running off a mapped server drive. In such a setup, if a user on a workstation for whatever reason looses connection with the server, the users session (linked to the particular workstation ID) is kept open in the user session database file. This stranded user session then prevents access to major maintenance tasks and backups.

If the user wasn't updating any files at the time of disconnection, then it is possible to logon to any workstation as the sage user and re-connect to the stranded session, and thereby terminate it.  If however the user was updating files when the disconnect happened, then in most cases it is possible to logon to the specific workstation concerned (provided it is available and the workstation ID has not changed) and re-connect to the session.

Consider a scenario where for some reason, the workstation ID changes (due to domain migration or upgrade), or the workstation is de-commissioned and is no longer available. This was the situation I faced. The situation was triggered by Microsoft's WSUS system which pushes volumes of windows updates onto the Server and Workstations. After such an update rollout and reboot, some workstation IDs changed for Sage line 50 (I don't know why and would value any info on how sage deduces its workstation IDs) and I was unable to log back into a session in order to terminate it. I searched online for some options or fixes for the situation but found no way to do this. I then had to hunt through the Sage data files in the ACCDATA folder to find a data file holding the data. I tried a few without joy, and then finally with some stroke of ingenuity, I replaced the QUEUE.DTA file with a copy from a fresh sage install, fired up sage and the stranded user was gone!!

I definitely hope it saves someone the headache, especially when working with impatient users. 

Digg It!DZone It!StumbleUponTechnoratiRedditDel.icio.usNewsVineFurlBlinkListkick it on DotNetKicks.comTwitThis

Comments

July 17. 2009 05:28 PM

foxy

Wow! Thank you! I always wanted to write in my site something like that

United Kingdom foxy

October 8. 2009 12:28 PM

Combi boilers

Happy I chanced upon this how to article.  How to clear or remove stranded Sage line 50 users  - I have been looking for data on how to take on this at the moment  and was drawn in by the headline of the item in a search engine.  Reading text books and journals has not been at all helpful but a couple of web lookups has produced a resolution which should assist me greatly.  What would we do without the Internet.  Thank you, I will use the info and must keep your internet site as a source.

United Kingdom Combi boilers

November 1. 2009 03:32 AM

personal loans

Yea nice Work !Laughing

United States personal loans

December 6. 2009 11:22 AM

faxless payday loans

thanks!  very helpful post!! like the template btw ;)

United States faxless payday loans

December 22. 2009 04:07 AM

cash loans

Thank you for your help!

United States cash loans

December 28. 2009 03:01 AM

fast payday loans

Searching for this for some time now - i guess luck is more advanced than search engines Smile

United States fast payday loans

December 30. 2009 01:18 AM

James Ferguson

Hello'

very useful content. I really thanks for this content. Really nice.

http://www.go4hosting.com/

United States James Ferguson

January 14. 2010 06:32 PM

no fax payday loans

Where much is expected from an individual, he may rise to the level of events and make the dream come true.

United States no fax payday loans

January 17. 2010 07:01 AM

fast advance

Obstacles are those frightful things you see when you take your eyes off your goal.

United States fast advance

Add comment


(Will show your Gravatar icon)

  Country flag

Click to change captcha
biuquote
  • Comment
  • Preview
Loading



About Me

When not scratching my head for solutions to software challenges, I spend my time playing with my little boy - Michael Jnr.

Quotations

"All great things are simple, and many can be expressed in single words: freedom, justice, honor, duty, mercy, hope."
Sir Winston Churchill

Donate with PayPal - it

Calendar

<<  March 2010  >>
MoTuWeThFrSaSu
22232425262728
1234567
891011121314
15161718192021
22232425262728
2930311234

View posts in large calendar

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2005 - 2010

Search