| Neal Walters 2005-08-04, 5:56 pm |
| Getting this error in HAT & Event Log:
Service Name: Microsoft.BizTalk.DefaultPipelines.XMLReceive
[The Host is an SQL Adpater Host]
"The Messaging Engine encountered an error publishing a batch of "1"
messages to the Message Box database for the transport adatper "SQL". Please
refer to HAT ... for more detailed information.. and checkd the endpoint
bindings are correctly configured. "
You got love the message that tells you to look in HAT when you are in HAT.
But anyway, I have no idea what is causing this problem.
We have SQL ports that poll a database looking for "jumpStart" rows that
basically are there to signal a start of an orchestration. For example, we
want to receive orders from our vendor, so we add a row to our "JumpStart"
table. A Biztalk receive port polls this table every x minutes.
So it looks to me that Biztalk is LOSING DATA when this error occurs. I
have to stop/start several hosts, then re-add the row to the "JumpStart"
table.
This only seems to happening on our QA system.
Any ideas - anyone?
Thanks,
Neal Walters
http://Biztalk-Training.com
|