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 ServerFor 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
