Open Forum

Expand all | Collapse all

Lots of DB locks in planning worksheet

  • 1.  Lots of DB locks in planning worksheet

    TOP CONTRIBUTOR
    Posted 26 days ago
    Hi All

    We are in middle of our CRP. We only have about 6 active users and one person running planning worksheet. A few time now we have seen a lot of database locks. The only way I've found to resolve the situation so far is to kill the session ins SQL (SSMS), which is clearly not something a user can do

    Anyone else seeing this? Is there a way a user can resolve it themselves?

    Error
    Locks
    Locks


    ------------------------------
    Mark Anderson
    Director of ERP Systems
    Clesen Wholesale
    Evanston, IL
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Lots of DB locks in planning worksheet

    Posted 25 days ago
    We've had locking issues with the planning engine for over 12 years. MS always recommended to us to try to run it off hours when possible, or to plan for fewer items at time by way of filtering. Not what you want to hear, I know.

    ------------------------------
    Jason Luchka
    Senior Enterprise Applications Analyst
    siffron
    Twinsburg OH
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Lots of DB locks in planning worksheet

    TOP CONTRIBUTOR
    Posted 25 days ago

    Thanks

     

     

     

    Mark Anderson | Director of ERP Systems

     

    Mobile 312.576.4332 | Direct 847.448.4202

     

     




    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role