dbTalk Databases Forums  

sqlserver 2000 DTS Message queue task timeout error

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss sqlserver 2000 DTS Message queue task timeout error in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
isabelledc
 
Posts: n/a

Default sqlserver 2000 DTS Message queue task timeout error - 02-05-2004 , 07:20 AM






Hello,


If we write to a public queue using a message queue task this works....then
reading from that public queue using a message queue task
...no problem...
When the message is sent from another application (biztalk in our case) in
another domain.... we get a timeout error message.
What could be causing this?

Thx for Your reply......

Isabelle





Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: sqlserver 2000 DTS Message queue task timeout error - 02-05-2004 , 07:43 AM






If the DTS task is timing out, then I think it is reasonable to assume that
it cannot find the message. Have you manually inspected the queue to check
that a message is there? Journaling would also be useful to show this
history of messages through that queue.

Have you checked the format of the message to make sure it is appropriate
for DTS? If the format does not match watch DTS expects then it will be
ignored. The format expected depends on the message type set in the task

--
Darren Green
http://www.sqldts.com

"isabelledc" <isabelle_king (AT) hotmail (DOT) com> wrote

Quote:
Hello,


If we write to a public queue using a message queue task this
works....then
reading from that public queue using a message queue task
...no problem...
When the message is sent from another application (biztalk in our case) in
another domain.... we get a timeout error message.
What could be causing this?

Thx for Your reply......

Isabelle







Reply With Quote
  #3  
Old   
isabelledc
 
Posts: n/a

Default Re: sqlserver 2000 DTS Message queue task timeout error - 02-05-2004 , 10:26 AM



Hello Darren,


this issue was solved by giving the message the label 'String Message'.
Which is also the message type that was set in the task.
Could it be that the message-label has to be = to the message type
for instance Data Message for Message type Data Message, etc....
Is that what You mean bij message-format?


Thx,

Isabelle


"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

Quote:
If the DTS task is timing out, then I think it is reasonable to assume
that
it cannot find the message. Have you manually inspected the queue to check
that a message is there? Journaling would also be useful to show this
history of messages through that queue.

Have you checked the format of the message to make sure it is appropriate
for DTS? If the format does not match watch DTS expects then it will be
ignored. The format expected depends on the message type set in the task

--
Darren Green
http://www.sqldts.com

"isabelledc" <isabelle_king (AT) hotmail (DOT) com> wrote in message
news:eM2sJr%236DHA.2416 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
Hello,


If we write to a public queue using a message queue task this
works....then
reading from that public queue using a message queue task
...no problem...
When the message is sent from another application (biztalk in our case)
in
another domain.... we get a timeout error message.
What could be causing this?

Thx for Your reply......

Isabelle









Reply With Quote
  #4  
Old   
Darren Green
 
Posts: n/a

Default Re: sqlserver 2000 DTS Message queue task timeout error - 02-05-2004 , 02:54 PM



In message <ejKFaTA7DHA.1852 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, isabelledc
<isabelle_king (AT) hotmail (DOT) com> writes
Quote:
Hello Darren,


this issue was solved by giving the message the label 'String Message'.
Which is also the message type that was set in the task.
Could it be that the message-label has to be = to the message type
for instance Data Message for Message type Data Message, etc....
Is that what You mean bij message-format?


Yes. DTS formats messages in a certain way, this includes the body and
encoding in particular. If you don't get it right, it doesn't recognise
it. Use DTS to put a message on the queue, and copy what it does when
you write your queue poster code, that is what I always do.

Cheers
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.