Layout incorrect when using ReportViewer

Please can someone help me with this.

I have created a very simple SQL report which has a title, Image, 3 subtitles and some data fields.

When I view it is my VS designer and preview it looks perfect, however when I deploy and view the the report through my ReportViewer control all the labels get moved around and the entire thing is a mess.

If I then export it to PDF it looks perfect again... I am sure I am missing something obvious but I can't find it.

I have done absolutely no expression formatting or coding at all. It's a plain SQL query and plain result textboxes.

Could be that something is overlapping in your report. Make sure that none of the components or fields are overlapping even slightly with each other. Overlapping items usually do not get rendered correctly when viewed on HTML.

-Aayush

|||

Aayush Goyal wrote:

Could be that something is overlapping in your report. Make sure that none of the components or fields are overlapping even slightly with each other. Overlapping items usually do not get rendered correctly when viewed on HTML.

-Aayush

It actually turned out to be a combination of two things, I had some overlapping but it still failed after I fixed that. I then checked it in IE and it worked this time.

Now I need to find out why it is not working in Firefox?

LastPeriods() Function producing incorrect results

I am using the LastPeriods Function to SUM the Last 12 periods at a month level:

MEMBER [Measures].[Last 12 Months] As
'SUM(LastPeriods(12, [Time].[Calendar Year].[Year].[2006].[Q4-06].&[December]), [Measures].[Total TEUS]) '

This should equal out to be [Time].[Calendar Year].[Year].[2006] but for some reason, the totals are different.

I thought it might be an issue with solve order so I took all other calculations out and it is still incorrect.
I am not sure what to look for now in fixing this problem. Is my syntax structure wrong here? Hopefully it is something small I am missing here.

Regards,

-Troy

What is the aggregation function for [Measures].[Total TEUS] - is it a "sum" measure?|||

Deepak,

Actually, this issue was a user error on my part. Turns out I was comparing it with a different Time Dimension.

The numbers are actually coming out correctly. Sorry for that. The problem I am seeing now is when using this member and a SET for the TopCount() function.

For Example:

WITH

MEMBER [Measures].[LastPeriod] AS
'SUM(LastPeriods(12, [Time].[Calendar Year].[Year].&[2006].&[Q4-06].&[December]), [Measures].[Total TEUS]) '

SET [TopShipline] AS
'NONEMPTY({TOPCOUNT([Ship Line].[Shiplines].[SHIPLINE].Members, 5, [Measures].CurrentMember)})'

SELECT {[Measures].[LastPeriod]} ON COLUMNS,
[TopShipline] ON ROWS
From [Account Level Aggregates]
WHERE ([Domestic Companies].[Domestic Company].[Company Name].[Some Company])

The results are as follows:

LastPeriod
ShiplineA 772.0
ShiplineB 7,738.5
ShiplineC 3,976.7
ShiplineD 2,158.1
ShiplineE 4,707.9

ShiplineA should not be in the results here. If I change to TopCount count to 6. The result is correct, minus ShiplineA.

LastPeriod
ShiplineA 772.0
ShiplineB 7,738.5
ShiplineC 3,976.7
ShiplineD 2,158.1
ShiplineE 4,707.9
ShiplineF 1,660.0

TopCount() for other dimensions that use this time dimension have similar results. This is only when using LastPeriods().

If I use say:

SET [TopPorts] AS
'NONEMPTY({TOPCOUNT([US Port].[US Port Name].Children, 5, [Measures].CurrentMember)})'

LastPeriod
PortA 2,690.7
PortB 5,036.4
PortC 6,124.4
PortD 5,542.2
PortE 513.7

In this case, PortE does not belong and the sort order of my measure is not as it should be. Again, changing the count to 6 from five brings the correct fifth Port, PortF

|||

Let me add one last piece to this and this is this apears to only be an issue when my [Domestic Company] dimension is used in the where clause:

WHERE ([Domestic Companies].[Domestic Company].[Company Name].[Some Company])

If I use a different dimension in the WHERE clause, the results are correct.

This is a somewhat large, flat dimension with about 600,000 members.

|||

Keeping in mind that the named set will be computed only in the context of the "where" slicer axis, which doesn't include a measure, you should explicitly specify [Total TEUS], like:

SET [TopShipline] AS
'NONEMPTY(TOPCOUNT([Ship Line].[Shiplines].[SHIPLINE].Members, 5, [Measures].[Total TEUS]))'

|||

Thanks for reply. I have resolved this. What I needed to do was use the Measure for my TopCount() function that I created as my calculated member.

MEMBER [Measures].[Last 12 Months] AS

'..........'

So, instead of:

SET [TopShipline] AS

'NONEMPTY( {TOPCOUNT( [Ship Line].[Shiplines].Children, 5, [Measures].[Total TEUS])})'

I needed to use:

SET [TopShipline] AS

'NONEMPTY( {TOPCOUNT( [Ship Line].[Shiplines].Children, 5, [Measures].[Last 12 Months])})'

Last part of deadlock

I hv taken over a Jboss 2.4.11 installation which keeps getting deadlocks
for various reasons. Most of them related to incorrect use of triggers and
has been resolved except the last part!! I hv managed to trace the deadlock
below with 1204 flag. Any hints would be most helpful.
many thks
--=============================
Wait-for graph
Node:1
Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
Exchange Wait Type :e_etypeClose
SPID: 53 ECID: 0 Statement Type: EXECUTE Line #: 1
Input Buf: RPC Event: sp_cursoropen;1
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
Node:2
PAG: 5:1:188796 CleanCnt:2 Mode: IX Flags: 0x2
Wait List:
Owner:0x6b37a260 Mode: S Flg:0x0 Ref:1 Life:00000000 SPID:53
ECID:1
Requested By:
ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:2 Ec0x22AD2098)
Value:0x6be534c0 Cost0/0)
Node:3
PAG: 5:1:188796 CleanCnt:2 Mode: IX Flags: 0x2
Grant List 1::
Owner:0x6be44dc0 Mode: IX Flg:0x0 Ref:1 Life:02000000 SPID:54
ECID:0
SPID: 54 ECID: 0 Statement Type: INSERT Line #: 1
Input Buf: RPC Event: sp_executesql;1
Requested By:
ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:1 Ec0x22ACE098)
Value:0x6b37a260 Cost0/0)
Node:4
PAG: 5:1:72287 CleanCnt:1 Mode: S Flags: 0x2
Grant List 1::
Owner:0x6be52ce0 Mode: S Flg:0x0 Ref:0 Life:00000001 SPID:53
ECID:0
Requested By:
ResType:LockOwner Stype:'OR' Mode: IX SPID:54 ECID:0 Ec0x249CD4F0)
Value:0x6b37b960 Cost0/1BC)
-- next branch --
Node:1
Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
Exchange Wait Type :e_etypeClose
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:1
Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
Exchange Wait Type :e_etypeClose
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
Node:9
Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:9
Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:9
Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:1
Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
Exchange Wait Type :e_etypeClose
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
Node:15
Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:15
Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:15
Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:1
Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
Exchange Wait Type :e_etypeClose
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
Victim Resource Owner:
ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:1 Ec0x22ACE098)
Value:0x6b37a260 Cost0/0)
Message posted via http://www.sqlmonster.com
I recommend following article to analyze deadlocks:
http://support.microsoft.com/?kbid=832524
"BH Ong via SQLMonster.com" wrote:

> I hv taken over a Jboss 2.4.11 installation which keeps getting deadlocks
> for various reasons. Most of them related to incorrect use of triggers and
> has been resolved except the last part!! I hv managed to trace the deadlock
> below with 1204 flag. Any hints would be most helpful.
> many thks
>
> --=============================
> Wait-for graph
> Node:1
> Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
> Exchange Wait Type :e_etypeClose
> SPID: 53 ECID: 0 Statement Type: EXECUTE Line #: 1
> Input Buf: RPC Event: sp_cursoropen;1
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> Node:2
> PAG: 5:1:188796 CleanCnt:2 Mode: IX Flags: 0x2
> Wait List:
> Owner:0x6b37a260 Mode: S Flg:0x0 Ref:1 Life:00000000 SPID:53
> ECID:1
> Requested By:
> ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:2 Ec0x22AD2098)
> Value:0x6be534c0 Cost0/0)
> Node:3
> PAG: 5:1:188796 CleanCnt:2 Mode: IX Flags: 0x2
> Grant List 1::
> Owner:0x6be44dc0 Mode: IX Flg:0x0 Ref:1 Life:02000000 SPID:54
> ECID:0
> SPID: 54 ECID: 0 Statement Type: INSERT Line #: 1
> Input Buf: RPC Event: sp_executesql;1
> Requested By:
> ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:1 Ec0x22ACE098)
> Value:0x6b37a260 Cost0/0)
> Node:4
> PAG: 5:1:72287 CleanCnt:1 Mode: S Flags: 0x2
> Grant List 1::
> Owner:0x6be52ce0 Mode: S Flg:0x0 Ref:0 Life:00000001 SPID:53
> ECID:0
> Requested By:
> ResType:LockOwner Stype:'OR' Mode: IX SPID:54 ECID:0 Ec0x249CD4F0)
> Value:0x6b37b960 Cost0/1BC)
> -- next branch --
>
> Node:1
> Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
> Exchange Wait Type :e_etypeClose
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:1
> Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
> Exchange Wait Type :e_etypeClose
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> Node:9
> Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:9
> Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:9
> Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:1
> Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
> Exchange Wait Type :e_etypeClose
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> Node:15
> Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:15
> Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
> Node:15
> Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:1
> Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
> Exchange Wait Type :e_etypeClose
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> Victim Resource Owner:
> ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:1 Ec0x22ACE098)
> Value:0x6b37a260 Cost0/0)
> --
> Message posted via http://www.sqlmonster.com
>

Last part of deadlock

I hv taken over a Jboss 2.4.11 installation which keeps getting deadlocks
for various reasons. Most of them related to incorrect use of triggers and
has been resolved except the last part!! I hv managed to trace the deadlock
below with 1204 flag. Any hints would be most helpful.
many thks
--=============================
Wait-for graph
Node:1
Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
Exchange Wait Type :e_etypeClose
SPID: 53 ECID: 0 Statement Type: EXECUTE Line #: 1
Input Buf: RPC Event: sp_cursoropen;1
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
Node:2
PAG: 5:1:188796 CleanCnt:2 Mode: IX Flags: 0x2
Wait List:
Owner:0x6b37a260 Mode: S Flg:0x0 Ref:1 Life:00000000 SPID:53
ECID:1
Requested By:
ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:2 Ec:(0x22AD2098)
Value:0x6be534c0 Cost:(0/0)
Node:3
PAG: 5:1:188796 CleanCnt:2 Mode: IX Flags: 0x2
Grant List 1::
Owner:0x6be44dc0 Mode: IX Flg:0x0 Ref:1 Life:02000000 SPID:54
ECID:0
SPID: 54 ECID: 0 Statement Type: INSERT Line #: 1
Input Buf: RPC Event: sp_executesql;1
Requested By:
ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:1 Ec:(0x22ACE098)
Value:0x6b37a260 Cost:(0/0)
Node:4
PAG: 5:1:72287 CleanCnt:1 Mode: S Flags: 0x2
Grant List 1::
Owner:0x6be52ce0 Mode: S Flg:0x0 Ref:0 Life:00000001 SPID:53
ECID:0
Requested By:
ResType:LockOwner Stype:'OR' Mode: IX SPID:54 ECID:0 Ec:(0x249CD4F0)
Value:0x6b37b960 Cost:(0/1BC)
-- next branch --
Node:1
Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
Exchange Wait Type :e_etypeClose
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:1
Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
Exchange Wait Type :e_etypeClose
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
Node:9
Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:9
Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:9
Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:1
Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
Exchange Wait Type :e_etypeClose
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
Node:15
Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:15
Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:15
Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:1
Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
Exchange Wait Type :e_etypeClose
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
Victim Resource Owner:
ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:1 Ec:(0x22ACE098)
Value:0x6b37a260 Cost:(0/0)
--
Message posted via http://www.sqlmonster.comI recommend following article to analyze deadlocks:
http://support.microsoft.com/?kbid=832524
"BH Ong via SQLMonster.com" wrote:
> I hv taken over a Jboss 2.4.11 installation which keeps getting deadlocks
> for various reasons. Most of them related to incorrect use of triggers and
> has been resolved except the last part!! I hv managed to trace the deadlock
> below with 1204 flag. Any hints would be most helpful.
> many thks
>
> --=============================> Wait-for graph
> Node:1
> Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
> Exchange Wait Type :e_etypeClose
> SPID: 53 ECID: 0 Statement Type: EXECUTE Line #: 1
> Input Buf: RPC Event: sp_cursoropen;1
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> Node:2
> PAG: 5:1:188796 CleanCnt:2 Mode: IX Flags: 0x2
> Wait List:
> Owner:0x6b37a260 Mode: S Flg:0x0 Ref:1 Life:00000000 SPID:53
> ECID:1
> Requested By:
> ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:2 Ec:(0x22AD2098)
> Value:0x6be534c0 Cost:(0/0)
> Node:3
> PAG: 5:1:188796 CleanCnt:2 Mode: IX Flags: 0x2
> Grant List 1::
> Owner:0x6be44dc0 Mode: IX Flg:0x0 Ref:1 Life:02000000 SPID:54
> ECID:0
> SPID: 54 ECID: 0 Statement Type: INSERT Line #: 1
> Input Buf: RPC Event: sp_executesql;1
> Requested By:
> ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:1 Ec:(0x22ACE098)
> Value:0x6b37a260 Cost:(0/0)
> Node:4
> PAG: 5:1:72287 CleanCnt:1 Mode: S Flags: 0x2
> Grant List 1::
> Owner:0x6be52ce0 Mode: S Flg:0x0 Ref:0 Life:00000001 SPID:53
> ECID:0
> Requested By:
> ResType:LockOwner Stype:'OR' Mode: IX SPID:54 ECID:0 Ec:(0x249CD4F0)
> Value:0x6b37b960 Cost:(0/1BC)
> -- next branch --
>
> Node:1
> Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
> Exchange Wait Type :e_etypeClose
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:1
> Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
> Exchange Wait Type :e_etypeClose
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> Node:9
> Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:9
> Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:9
> Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:1
> Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
> Exchange Wait Type :e_etypeClose
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> Node:15
> Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:15
> Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
> Node:15
> Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:1
> Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
> Exchange Wait Type :e_etypeClose
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> Victim Resource Owner:
> ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:1 Ec:(0x22ACE098)
> Value:0x6b37a260 Cost:(0/0)
> --
> Message posted via http://www.sqlmonster.com
>

Last part of deadlock

I hv taken over a Jboss 2.4.11 installation which keeps getting deadlocks
for various reasons. Most of them related to incorrect use of triggers and
has been resolved except the last part!! I hv managed to trace the deadlock
below with 1204 flag. Any hints would be most helpful.
many thks
--=============================
Wait-for graph
Node:1
Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
Exchange Wait Type :e_etypeClose
SPID: 53 ECID: 0 Statement Type: EXECUTE Line #: 1
Input Buf: RPC Event: sp_cursoropen;1
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
Node:2
PAG: 5:1:188796 CleanCnt:2 Mode: IX Flags: 0x2
Wait List:
Owner:0x6b37a260 Mode: S Flg:0x0 Ref:1 Life:00000000 SPID:53
ECID:1
Requested By:
ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:2 Ec0x22AD2098)
Value:0x6be534c0 Cost0/0)
Node:3
PAG: 5:1:188796 CleanCnt:2 Mode: IX Flags: 0x2
Grant List 1::
Owner:0x6be44dc0 Mode: IX Flg:0x0 Ref:1 Life:02000000 SPID:54
ECID:0
SPID: 54 ECID: 0 Statement Type: INSERT Line #: 1
Input Buf: RPC Event: sp_executesql;1
Requested By:
ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:1 Ec0x22ACE098)
Value:0x6b37a260 Cost0/0)
Node:4
PAG: 5:1:72287 CleanCnt:1 Mode: S Flags: 0x2
Grant List 1::
Owner:0x6be52ce0 Mode: S Flg:0x0 Ref:0 Life:00000001 SPID:53
ECID:0
Requested By:
ResType:LockOwner Stype:'OR' Mode: IX SPID:54 ECID:0 Ec0x249CD4F0)
Value:0x6b37b960 Cost0/1BC)
-- next branch --
Node:1
Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
Exchange Wait Type :e_etypeClose
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:1
Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
Exchange Wait Type :e_etypeClose
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
Node:9
Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:9
Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:9
Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:1
Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
Exchange Wait Type :e_etypeClose
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
Node:15
Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:15
Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:15
Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
Exchange Wait Type :e_etypeCXPacket
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
-- next branch --
Node:1
Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator),
Exchange Wait Type :e_etypeClose
Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
Consumer List::
Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
Producer List::
Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
Victim Resource Owner:
ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:1 Ec0x22ACE098)
Value:0x6b37a260 Cost0/0)
Message posted via http://www.droptable.comI recommend following article to analyze deadlocks:
http://support.microsoft.com/?kbid=832524
"BH Ong via droptable.com" wrote:

> I hv taken over a Jboss 2.4.11 installation which keeps getting deadlocks
> for various reasons. Most of them related to incorrect use of triggers and
> has been resolved except the last part!! I hv managed to trace the deadloc
k
> below with 1204 flag. Any hints would be most helpful.
> many thks
>
> --=============================
> Wait-for graph
> Node:1
> Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator)
,
> Exchange Wait Type :e_etypeClose
> SPID: 53 ECID: 0 Statement Type: EXECUTE Line #: 1
> Input Buf: RPC Event: sp_cursoropen;1
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> Node:2
> PAG: 5:1:188796 CleanCnt:2 Mode: IX Flags: 0x2
> Wait List:
> Owner:0x6b37a260 Mode: S Flg:0x0 Ref:1 Life:00000000 SPID:5
3
> ECID:1
> Requested By:
> ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:2 Ec0x22AD2098
)
> Value:0x6be534c0 Cost0/0)
> Node:3
> PAG: 5:1:188796 CleanCnt:2 Mode: IX Flags: 0x2
> Grant List 1::
> Owner:0x6be44dc0 Mode: IX Flg:0x0 Ref:1 Life:02000000 SPID:5
4
> ECID:0
> SPID: 54 ECID: 0 Statement Type: INSERT Line #: 1
> Input Buf: RPC Event: sp_executesql;1
> Requested By:
> ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:1 Ec0x22ACE098
)
> Value:0x6b37a260 Cost0/0)
> Node:4
> PAG: 5:1:72287 CleanCnt:1 Mode: S Flags: 0x2
> Grant List 1::
> Owner:0x6be52ce0 Mode: S Flg:0x0 Ref:0 Life:00000001 SPID:5
3
> ECID:0
> Requested By:
> ResType:LockOwner Stype:'OR' Mode: IX SPID:54 ECID:0 Ec0x249CD4F0
)
> Value:0x6b37b960 Cost0/1BC)
> -- next branch --
>
> Node:1
> Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator)
,
> Exchange Wait Type :e_etypeClose
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:1
> Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator)
,
> Exchange Wait Type :e_etypeClose
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> Node:9
> Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocki
ng
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocki
ng
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:9
> Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocki
ng
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocki
ng
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:9
> Port: 0x42be8180 Xid Slot: 2, EC: 0x22a4c098, ECID: 7 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocki
ng
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocki
ng
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:1
> Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator)
,
> Exchange Wait Type :e_etypeClose
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> Node:15
> Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocki
ng
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocki
ng
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:15
> Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocki
ng
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocki
ng
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
> Node:15
> Port: 0x42be8180 Xid Slot: 3, EC: 0x22a00098, ECID: 6 (Consumer),
> Exchange Wait Type :e_etypeCXPacket
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Not Blocki
ng
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Not Blocki
ng
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> -- next branch --
>
> Node:1
> Port: 0x42be8180 Xid Slot: -1, EC: 0x44cc54f0, ECID: 0 (Coordinator)
,
> Exchange Wait Type :e_etypeClose
> Coordinator: EC = 0x44cc54f0, SPID: 53, ECID: 0, Not Blocking
> Consumer List::
> Consumer: Xid Slot: 2, EC = 0x22a4c098, SPID: 53, ECID: 7, Blocking
> Consumer: Xid Slot: 3, EC = 0x22a00098, SPID: 53, ECID: 6, Blocking
> Producer List::
> Producer: Xid Slot: 0, EC = 0x22ad2098, SPID: 53, ECID: 2, Blocking
> Producer: Xid Slot: 1, EC = 0x22ace098, SPID: 53, ECID: 1, Blocking
> Victim Resource Owner:
> ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:1 Ec0x22ACE098)
> Value:0x6b37a260 Cost0/0)
> --
> Message posted via http://www.droptable.com
>