Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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.

↑ Back to the top


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.

↑ Back to the top


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

↑ Back to the top


Status

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

↑ Back to the top


More Information

For more information about how to monitor BizTalk Server, visit the following MSDN website:
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

↑ Back to the top


Keywords: kbqfe, kbexpertiseadvanced, kbsurveynew, kbfix, kbbtsadmin, kb

↑ Back to the top

Article Info
Article ID : 2452550
Revision : 2
Created on : 9/10/2018
Published on : 9/11/2018
Exists online : False
Views : 376