all groups > sql server dts > february 2004 >
You're in the

sql server dts

group:

sqlserver 2000 DTS Message queue task timeout error


Re: sqlserver 2000 DTS Message queue task timeout error Darren Green
2/5/2004 1:43:58 PM
sql server dts: 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

[quoted text, click to view]

sqlserver 2000 DTS Message queue task timeout error isabelledc
2/5/2004 2:20:10 PM
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



Re: sqlserver 2000 DTS Message queue task timeout error isabelledc
2/5/2004 5:26:44 PM
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


[quoted text, click to view]

Re: sqlserver 2000 DTS Message queue task timeout error Darren Green
2/5/2004 8:54:37 PM
In message <ejKFaTA7DHA.1852@TK2MSFTNGP10.phx.gbl>, isabelledc
<isabelle_king@hotmail.com> writes
[quoted text, click to view]
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
AddThis Social Bookmark Button