on 2008 Nov 18 6:19 PM
Hi All,
We are on SQL 2005 and windows. Our delta load from ERP to BW is erroring out with Database error 1204.
I can see 2 entries in DB02 Deadlock Monitor? How do I relase these deadlock from SAP or SQLServer?
Please help!
Thanks,
Antarpreet
On which object does this deadlock occur?
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You are having a look at the deadlock statistics apparently.
Check note 111291 - FAQ: SQL server analysis and avoiding deadlocks
In most cases deadlocks are caused by the application (so in this case the BI), get in contact with your BI developer and search for notes with the content name containing this table.
Markus
Hi Experts,
Please help on this!
We have even bounced back the BI system but the deadlock entry in ST04 still remains. Although the process seems to be zombie and does not exist at OS level (windows), Is there a way we could delete this entry from ST04 Deadlock Monitor? What would be the best way to clear this entry?
Thanks,
Antarpreet
Hi,
ST04 transaction is showing the deadlock statistics.
So these are historic entries that normally are kept for 7 days in the system and then cleaned out automatically.
(Checkup with SAP note [75158|http://service.sap.com/sap/support/notes/75158])
I believe you don't have to worry, there is no actual problem in your system, as the deadlocks are already solved / cleaned out. There should also be messages in your system log (Transaction SM21) about this......
Regards
Rolf
User | Count |
---|---|
69 | |
9 | |
8 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.