Biztalk HAT query for sent messages time out

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Biztalk HAT query for sent messages time out

Viewing 2 reply threads
  • Author
    Posts
    • #18331

      Hi,

      I have a problem with checking if messages has been sent on a specified send port.

      I tried to use the query in the HAT to look for messages sent during the past 24 hours but this query seems to be unable to execute when lots and lots of messages has been sent – it always time out. Does anyone know a way to optimize this query? Im not using the HAT, i run the query directly against the biztalk database.

    • #18334

      Can you try limiting your time frame further meaning can you break it into smaller time intervals of 3 to 4 hours etc.

      Also if there are any other factors you can limit your query by like the schema name of message like (usually method name of web service call..)

      then it might execute faster. You can just begin with the query in HAT and work further on it..

    • #22968

      increase  time  limit

Viewing 2 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.