FIX: "Monitor BizTalk Server" SQL Server Agent job might not work after you add seven or more BizTalk hosts to a BizTalk group in BizTalk Server 2010

Article translations Article translations
Article ID: 2452550 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

After you add seven or more BizTalk hosts to a BizTalk group in Microsoft BizTalk Server 2010, the Monitor BizTalk Server SQL Server Agent job does not run at the Check issues in all MessageBoxes and DTA step. Additionally, an error message that resembles the following is logged in the job history:
Date Date time
Log Job History (Monitor BizTalk Server (BizTalkMgmtDb))
Step ID 1
Server Server name
Job Name Monitor BizTalk Server (BizTalkMgmtDb)
Step Name Check issues in all MessageBoxes and DTA
Duration 00:00:02
Sql Severity 15
Sql Message ID 102
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message

Executed as user: user. Unclosed quotation mark after the character string 'u'. [SQLSTATE 42000] (Error 105) Incorrect syntax near 'u'. [SQLSTATE 42000] (Error 102). The step failed.
Note The number of hosts that are required to encounter this issue varies, depending on the length of the host names. If each host name is one character long, this issue occurs when you add nine or more hosts to a BizTalk group.

CAUSE

This issue occurs because the maximum character length of a variable that is used in the Monitor BizTalk Server SQL Server Agent job is small.

When many hosts exist in a BizTalk group, the character length of this variable exceeds the maximum character length.

RESOLUTION

Cumulative update information

For more information about how to obtain the cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
2497789 Cumulative update package 1 for BizTalk 2010

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information about how to monitor BizTalk Server, visit the following MSDN website:
How to monitor BizTalk Server
For more information about BizTalk Server hotfixes, click the following article number to view the article in the Microsoft Knowledge Base:
2003907 Information about BizTalk Server hotfixes

Properties

Article ID: 2452550 - Last Review: May 23, 2011 - Revision: 1.0
APPLIES TO
  • Microsoft BizTalk Server Enterprise 2010
Keywords: 
kbqfe kbexpertiseadvanced kbsurveynew kbfix kbbtsadmin KB2452550

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com