Sage 300 2020 Order Entry Modules Lock Up

Hello Everyone,

For a number of years we have suffered this problem where all Order Entry modules lock up and every user is met with this loading bar. 

But for other users who are using modules outside of order entry they have no problems. 

We recently upgraded the ram on the SQL database to 32GB hoping it would help the issue but it still continues. 

All servers in our network typically sit around the 20%-30% usage range so they are nice and healthy. 

I'm at a loss on what could be causing the issue and how to fix it. 

Parents
  • +1 for what Django and Jay said. But if that still isn't cutting the mustard, go to Help > Current Users > Show Screens Users Have Open. Look for instances of I/C Location Details. Ask those users to close their Location Details screens.

    I don't have enough evidence yet, as it happens so infrequently, but I think there is some sort of opportunistic record locking phenomenon happening with the Location Details screen. And as soon as we start closing those Location Details screens, O/E comes back to life.

Reply
  • +1 for what Django and Jay said. But if that still isn't cutting the mustard, go to Help > Current Users > Show Screens Users Have Open. Look for instances of I/C Location Details. Ask those users to close their Location Details screens.

    I don't have enough evidence yet, as it happens so infrequently, but I think there is some sort of opportunistic record locking phenomenon happening with the Location Details screen. And as soon as we start closing those Location Details screens, O/E comes back to life.

Children