Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

related_conversation_group uid not same as GET CONVERSATION GROUP

41 views
Skip to first unread message

skg

unread,
Feb 9, 2009, 5:05:01 PM2/9/09
to
Gurus -
I am finding that the conversion groupid in the target proc is not the same
with what i am entered data in the queue using begin dialog conversion.

can any one explain why?

select * from sys.conversation_endpoints shows the correct
conversion group which i sending in the queue


Input data into the queue
========================
begin transaction

BEGIN DIALOG CONVERSATION @dh
FROM SERVICE [SourceService]
TO SERVICE 'TargetService'
ON CONTRACT [XMLValidationContract]
with related_conversation_group = 'A079C5FF-28D7-457C-B669-8066BEE8F06D',
encryption = off;

SEND ON CONVERSATION @dh MESSAGE TYPE [XMLValidationTemplate]
(<Info>12345</Info>)

commit transaction

Target que proc
=============================

create proc TargetProc
as
declare @ConversationGroupID uniqueidentifier

WAITFOR (
GET CONVERSATION GROUP @ConversationGroupID FROM TargetQueue),
TIMEOUT 1000

if(@ConversationGroupID <>'A079C5FF-28D7-457C-B669-8066BEE8F06D')
begin

raiseerror('Error".....

end

Bob Beauchemin

unread,
Feb 14, 2009, 2:07:06 PM2/14/09
to
Converation group ids are different on each side of a conversation. Take a
look at sys.conversation_endpoints to see this in action. Also, specifying
related_conversation_group on a initiator (source) does not mean the
conversation ids are going to be the same on the target.

You can specify the converation group id on the initiator (source), but not
on the target. If you need to serialize messages so that the receives are
serialized on the target side, use a single conversation. If you need to
serialize the receives of the responses from different targets on the
initiator side, use a conversation group.

Hope this helps,
Bob Beauchemin
SQLskills


"skg" <s...@discussions.microsoft.com> wrote in message
news:1E4CF7F1-08F1-4078...@microsoft.com...

s...@nospamxyz.com

unread,
Feb 15, 2009, 12:00:17 PM2/15/09
to
Thx a lot Bob! i read a lot on conversation groups. You response helped
clear lot of my understanding.

"Bob Beauchemin" <no_bob...@sqlskills.com> wrote in message
news:uHbR0dtj...@TK2MSFTNGP05.phx.gbl...

0 new messages