Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
spradeepreddys
Starting Member
1 Post |
 Posted - 2008-12-02 : 02:56:08
|
| HI All,Could you all please look into this and help me out in solvinmg the issue.Database:sql server 2000sap : ECC 6.0Windows NT serverin sap level when i create a sales document and trying to edit it then i get a error message like the document is locked by the same user.but the document is getting released after few seconds like 20-30 sec.Its manily due to the database inconsistencythe error lies here- when the user created the document and saved it and trying to edit from the same screen basically its taking time to save and meanwhile user is trying to edit n geeting the error message and after 20-30 sec the document got saved and hes able to edit and the lock for the documebt is released.this is due to sql server database inconsistency.could you pls tell me whhat can be done to improve the performance of the sql server database so that the error doersnot occur.quick response is highy appreciated.Thanks in advancePradeep Srigirispradeep |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-02 : 10:26:09
|
| Looks like Deadlock,locking is the issue. |
 |
|
|
|
|
|
error when trying to edit the document