BizTalk Server General - encountered an error publishing a batch of "1" messages & "log not

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server General > July 2005 > encountered an error publishing a batch of "1" messages & "log not





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author encountered an error publishing a batch of "1" messages & "log not
Neal Walters

2005-07-21, 5:52 pm

What can cause this nasty message? It's happening about once a day on our QA
system only. When I start/stop the hosts, everything seems to recover.

Thanks,
Neal Walters
http://Biztalk-Training.com


Event Type: Error
Event Source: BizTalk Server 2004
Event Category: BizTalk Server 2004
Event ID: 5755
Date: 7/20/2005
Time: 5:36:00 PM
User: N/A
Computer: BTSRVQA
Description:
The Messaging Engine encountered an error publishing a batch of "1" messages
to the Message Box database for the transport adapter "SQL". Please refer to
Health and Activity Tracking tool for more detailed information on this
failure and check the endpoint bindings are correctly configured.

Event Type: Error
Event Source: BizTalk Server 2004
Event Category: BizTalk Server 2004
Event ID: 6912
Date: 7/20/2005
Time: 5:37:00 PM
User: N/A
Computer: BTSRVQA
Description:
The following stored procedure call failed: " { call
[dbo].& #91;bts_InsertMessageDirect_ReceiveAmazo
nSQLAdapterHostGroup]( ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}". SQL Server returned
error string: "The log for database 'BizTalkMsgBoxDb' is not available.".





Neal Walters

2005-07-26, 5:53 pm

We are still investigating this. Apparently this is some SQL blocking going
on, and eventually a stored proc times out - perhaps losing its precious xml
cargo?

Neal

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com