Retention ??

[GiJeet]

I have set RETENTION = ON on both the Initiator queue and Target queue
to get an idea of what's going on, but I only see records being
retained in the Target queue. I have initiated a message from the
Initiator which was sent successfully to the Target, the Target then
sent a response back to the Initiator - all successful.

In the Target queue I see 3 messages:
The initial message received with Status = 0
The messages sent back with Status = 3
And an EndDialog message with Status = 0

This Target queue looks like the way I expected.

However, in the Initiator queue I don't see ANY messages retained in
the queue.
I know the Initiator received the response message from the Target
because the trigger SP that fires when a new message comes into the
queue did indeed fire and I have it inserting the message in a custom
state table but I expected to see that message maintained in the
Initiator queue since Retention was set ON but it's not there.

Any suggestions on this behavior?

Gi

[Bob Beauchemin]

Hi Gi,

Sounds like the initiator sent an end dialog message to the target.
Retention=on only holds on to the messages until the conversation dialog has
ended.

Hope this helps,
Bob Beauchemin
SQLskills

"GiJeet" <gij...@yahoo.com> wrote in message
news:f7549690-49d9-40dd...@v18g2000vbb.googlegroups.com...

[GiJeet]

> On Feb 20, 2:52 pm, "Bob Beauchemin" <no_bobb_s...@sqlskills.com> wrote:
> Sounds like the initiator sent an end dialog message to the target.
> Retention=on only holds on to the messages until the conversation dialog has
> ended.

Yes, the initiator did send and end dialog. But I'm still not getting
this behavior. Seems to me like the response sent back to the
initiator by the target should be retained so there should be 1 record
in the initiator queue. Confusing.

Thanks
Gi

[Bob Beauchemin]

Hi Gi,

If you don't send end dialog from the initiator, you'll see all of the
sent/received messages on the initiator queue. If you don't send end dialog
from the target, you'll see all of the sent/received messages on the target
queue. If you call end dialog on either side, you won't see messages on that
side's queue, No responses or sent messages will be retained, regardless of
where they come from. So not seeing "the response sent back to the initiator
by the target" is the expected behavior if the target has already called end
dialog.

Hope this helps,
Cheers,
Bob Beauchemin

"GiJeet" <gij...@yahoo.com> wrote in message

news:bf8246fb-87ef-42d1...@q25g2000vbn.googlegroups.com...

[GiJeet]

>On Feb 21, 12:12 pm, "Bob Beauchemin" <no_bobb_s...@sqlskills.com> wrote:
> Hi Gi,
>
> If you don't send end dialog from the initiator, you'll see all of the
> sent/received messages on the initiator queue. If you don't send end dialog
> from the target, you'll see all of the sent/received messages on the target
> queue. If you call end dialog on either side, you won't see messages on that
> side's queue, No responses or sent messages will be retained, regardless of
> where they come from. So not seeing "the response sent back to the initiator
> by the target" is the expected behavior if the target has already called end
> dialog.

OK, thanks for clearing that up for me. Much appreciated.

Gi