Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
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 ID: 2452550 - View products that this article applies to.
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:
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.
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
Sql Severity 15
Sql Message ID 102
Operator Net sent
Retries Attempted 0
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.
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.
Cumulative update informationFor more information about how to obtain the cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/2497789/ )Cumulative update package 1 for BizTalk 2010
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information about how to monitor BizTalk Server, visit the following MSDN website:
How to monitor BizTalk ServerFor more information about BizTalk Server hotfixes, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/2003907/ )Information about BizTalk Server hotfixes