a month ago
Have a problem closing a production order which changes status from release to close. That show error message :
The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions.
But some production order which changes status from plan to release to close is not problem.
Firstly : Checking database : sessionid or processid is not LOCK.
Pls. help to solve this problem. SAP 9.3 PL11, MSSQL 2014
Request clarification before answering.
Hello,
You can try to deactivate all the approval procedures too.
Best regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
it seems to me that you have a high traffic in your database.
While processing something, for SAP it is necessary to lock different tables to perform the requested job. Like item movement or document numbering. If there are to many requests in a row it is possible that it causes dealocks or transactions cannot be done like in your case
reagards Lothar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Check if there is TransactionNotification or PostTransaction running in ProductionOrder, if you have, disabled them and disabled all the addons too. Then try again.
Best regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
126 | |
9 | |
8 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.