All users Freeze while working in OE

Configuration

- Sage 300 SP2 (and upgraded to SP3 no difference)

- remote services configuration 2012 R2

- approximately 5 active users processing daily orders and cash transactions in OE

- 15 users overall access sage

Frequently (5 or 6 times a day) one user will freeze and when that happens all users working in OE AR receipt batches and some IC inquiries or bank rec will also freeze.  All users remain frozen until we disconnect the original user that first got frozen and then everyone starts working again.   If a users is not actively working without any screens open when the freeze happens they are able to move around successfully in AP or GL but the minute the access a AR receipts batch and most things we have tested in OE they will also freeze.  

Has anyone seen this before and have ideas for resolution.   

Based on my monitoring till now i strongly believe it is related to when the OE people choose to record the payment with the ship all function of an order and access a cash batch.  In this environment we have 3 locations that do this and they all access a different cash batch (one for each location) which shouldn't cause a record locking issue but i belive it is related.   When we load bank services and start clearing deposits we can almost always bring on the lock/freeze.  The lock/freeze can happen first thing in the morning when the only people that are there are the OE sales people the rest of the accounting staff doesn't' come in till later so we know its not load related.  

Parents
  • i did remove bank services history and there hasn't been any real Difference.  I am now getting more feedback from the users.  It appears that they quite frequently get a UI error, they close it and just try again and everything works.  Today when running a day end we received errors indicating that there was a record lock with EFT and it couldn't continue and to try again later.  I went to current users to see who might be in EFT.  It turned out only 3 users were listed on the lanpak tab.  But we knew that there was more like 10 or 12 users in sage.  We isolated a single computer that was not listed on the lanpak users screen and that computer could move around open ar customers bring up customers – account activity etc.   I would click on open company check the userid, confirm it was the user I was tracking, attach again.  Still not in lanpak users.  I exited sage, exited my RDP connection to the server and re-established my remote connection and into sage and then that user was on the lanpak users list.  If I did open company and go out and attach to sage as a different user the user was removed from lanpak and listed as the new user everything was as expected.   Users continued to have ongoing record lock errors for approximately 2 or 3 hours.  We forced all users to go out completely back in so their names were all in the lanpak list.  While I was watching this list – right before my eyes. There was a blink of the screen, like the refresh when it looks for new users, and everyone was gone completely from the list and I was frozen.  I went to task manager forced a close, went back in and the only user in lanpak was me.  All users again had to go all the way out and back in they re-registered in the lanpak list and now have been working fairly successfully over the last 2 hours. 

    Does anyone have any ideas what may be going on.  Is the list of lapak user not reliable and others have seen that this means nothing and I shouldn’t focus my attention on this.  Or is this an indicator that Sage has lost track of a user that could be locking files and is causing all these strange conflicts and record locks.

     

    Does anyone know why users show up on the “other” tab.  This customer has many users on the Other tab and I have never seen that before.  I have only ever seen users listed on the lanpak tab.

  • in reply to ValerieH

    Question: Are the users signing in using the workstation from their own PC OR are they first of all signing into a server with RDP that has the workstation installed.

    If the above is the case, then this is a known problem with windows 2012 R2 servers.  You have to have the programs also installed on the workstation RDP server as well. (I have upgraded many clients from windows 2008 to 2012 R2 and I get this problem where the WS RDP server loses the sage connection to the main application server - so I then installed the programs on the RDP server and the problem goes away)

    If this is not the case, then I have never seen this from PC workstations.

  • in reply to IDLSystems

    they remote into a server and run the program files from the server they are remoted into.  But interesting to hear you have seen the issue i am seeing before and was related to a delay between program files and access to shared files so that would leave me to believe that what i posted above may be the right direction.

  • in reply to ValerieH

    for anyone following this incident.  The change i made to have the lanpack.bin and semephor file on the same server has in fact appeared to resolve the problem.  Those two servers are local to each other in the same hosting facility which in my mind does not make sense but I can't argue with results.   

  • in reply to ValerieH

    They should never have been on separate servers in the first place, there should only be one SITE folder.

  • in reply to ValerieH

    Ditto... you should always only have one SITE folder. No wonder you were having issues.

    You are also violating Sage licensing if you have multiple SITE folders for the same installation.

  • in reply to 49153

    not sure what your saying.  I always only had one site folder.  It just didn't reside on the the same physical server as the program files.  

  • in reply to ValerieH

    I think when you described that you moved lanpack.bin and semaphor.bin to the same server it sounded odd.  Did you change the SharedData folder in the registry to be on the same server as the ProgramFiles folder in the registry? Or did you have something more complicated in your setup?

Reply
  • in reply to ValerieH

    I think when you described that you moved lanpack.bin and semaphor.bin to the same server it sounded odd.  Did you change the SharedData folder in the registry to be on the same server as the ProgramFiles folder in the registry? Or did you have something more complicated in your setup?

Children
No Data