cancel
Showing results for 
Search instead for 
Did you mean: 

how to remove deadlock

Former Member
0 Kudos
2,219

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

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
0 Kudos

On which object does this deadlock occur?

Markus

Former Member
0 Kudos

Hello Markus,

Deadlock Monitor is showing deadlock in table /BIC/FZCOPA_C53

The PIDs that it mentions are: 6,308 4656 but both are currently not bieng used at os level!

Thank You,

Antarpreet

markus_doehr2
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

rolfc_weber
Contributor
0 Kudos

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

Answers (0)