cancel
Showing results for 
Search instead for 
Did you mean: 

Error : Production Order change status : CLOSE

ganghan
Discoverer
0 Kudos
178

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

Accepted Solutions (0)

Answers (3)

Answers (3)

williamwachholz
Participant

Hello,

You can try to deactivate all the approval procedures too.

Best regards

ganghan
Discoverer
0 Kudos
Thanks for the advice, but my system didn't have approval process. I found error message on log : Business Object Event: GetByKey failed, err number is -2028 # # TID=7716 _BusinessObjectMethods.h 34
LoHa
Active Contributor
0 Kudos

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

ganghan
Discoverer
0 Kudos
After rebooting database server, remain the same problem. That only applies to documents that need change status to closed
williamwachholz
Participant
0 Kudos

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