Common Issues and Resolutions With the BizTalk Server Administration Console

Common Issues and Resolutions With the BizTalk Server Administration Console


Introduction

This article describes common issues and resolutions when using BizTalk Administration, including the following:
  • Potential issues when using the BizTalk Management Pack in System Center Operations Manager (SCOM)
  • Additional Issues
  • Available Hotfixes
  • Troubleshooting

More Information

When using System Center Operations Manager (SCOM) 2007 with the BizTalk Management Pack, you may notice the following issues:
 

Issue 1: Expanding BizTalk Group causes the MMC to stop responding.

Resolution:

·        

Confirm the BizTalk Management Pack is configured correctly. For example, you must specify a Run As Account for the BizTalk Server Monitoring Account and BizTalk Server Discovery Account profiles within SCOM. For the specific details, refer to the BizTalk Server Management Pack Guide available at the link below:
 

·          

The BizTalk Management pack runs a script for every artifact type (send port, receive port, receive location, send port group, orchestration, etc.) per host. If there are 50 hosts, then there will be 50 scripts executed against WMI per artifact type. In this scenario, WMI can become overloaded. This querying may keep the BizTalk WMI provider running continuously.
 
To prevent this, increase the monitoring intervals within SCOM to a higher value. For example, increase the monitoring intervals by picking a random 5-7 minute difference between the scripts:
 
Script
Time (seconds)
Adapter Availability Monitor
420
Host Availability Monitor
780
Host Instance Availability Monitor
1140
Orchestration Availability Monitor
1500
Receive Location Availability Monitor
1860
Receive Port Availability Monitor
2220
Send Port Availability Monitor
2580
Send Port Group Availability Monitor
2940
 


Issue 2: Clicking Refresh or expanding Handlers may return the following error message:

 
Unable to load adapter handlers for Adapter adapter. (Microsoft.BizTalk.Administration.SnapIn)
 <
Additional information<
Failed to create a CLSID_BiztalkPropertyBagFactory COM component installed with a BizTalk server. A Dynamic Link Library (DLL) initialization routine failed. (WinMgmt)
 
Resolution: BizTalk Server Administration relies on Windows Management Instrumentation (WMI); more specifically, the BizTalk WMI Provider (BTSWMIProvider.dll).
 
The BizTalk WMI Provider relies on the ClearAfter property within the WMI root namespace. The default ClearAfter
property is 30 seconds (00000000000030.000000:000). If this value has been changed to a larger value, like 500 seconds (00000000000500.000000:000), then this error may be returned.

 

To set the ClearAfter property, use wbemtest on all BizTalk servers in the group using the steps below:

a) Go to Start, Run and type wbemtest.
b) Click the Connect button and change the namespace to root. Click Connect.
c) Click the Query button and type: select * from __CacheControl. Click Apply.
>d) Double click each item and select the ClearAfter property. Confirm they have the following values:
 
__EventConsumerProviderCacheControl=@
00000000000030.000000:000
__EventProviderCacheControl=@
00000000000030.000000:000
__EventSinkCacheControl=@
00000000000015.000000:000
__ObjectProviderCacheControl=@
00000000000030.000000:000
__PropertyProviderCacheControl=@
00000000000030.000000:000
 
If any value exceeds the values listed above, click the Edit Property button to change it. Click Save Property. Click Save Object.
e) Restart the Windows Management Instrumentation service.


Issue 3: On the SCOM server, you attempt to stop an orchestration. This may return the following error message:

Error encountered when attempting to stop orchestration processing.
 
Could not stop orchestration 'Orchestration, Version=4.12.1.1, Culture=neutral, PublicKeyToken=1710edac7131301e'. A database failure occurred due to database connectivity problems. (HRESULT: 80131600).
 
On the BizTalk Server around the same time as the SCOM server error, the following error message is logged:
 
Event Type: Error
Event Source: COM+
Event Category: (98)
Event ID: 4791
Description
The COM+ Services DLL (comsvcs.dll) was unable to load because allocation of thread local storage failed.
Process Name: wmiprvse.exe
Error Code = 0x80070008 : Not enough storage is available to process this command.
COM+ Services Internals Information:
File: d:\nt\com\complus\src\comsvcs\comsvcs\comsvcs.cpp, Line: 334
Comsvcs.dll file version: ENU 2001.12.4720.4045
 
Resolution: To resolve this, follow the steps in the link below to modify the registry key and install the appropriate hotfix:
 

Additional Issues

1. Many common tasks like creating a BizTalk host or stopping a send port require specific rights within BizTalk and SQL Server. If you are unable to perform certain functions within BizTalk Administration, you may be missing membership to a BizTalk group. For the specific details of the group or role requirements, visit the following link:
 
Minimum Security User Rights
2. If SQL Server is configured to listen on a port other than 1433, you may see the following behavior: 
  • Expanding BizTalk Group takes longer than expected and shows a red circle.
  • Expanding Applications takes longer than expected.
  • Adding a Resource takes longer than expected.
  • Selecting Send Ports takes longer than expected for them to display.
  • Expanding All Artifacts shows a red circle.
Resolution: Confirm the SQL Server Browser service is started on all the BizTalk servers in the group. Also on all BizTalk servers in the group, open SQL Server Configuration Manager and create an Alias:
 
a) Expand SQL Native Client Configuration and select Aliases
b) Right-click Alias and choose New Alias. Enter the following:
 
Alias Name
SQL Server name
Port No
TCP port used by SQL Server
Protocol
TCP/IP
Server
SQL Server name
 
For example, if your SQL Server computer is named MySQL and listening on port 40090, then you would specify the following:
 
Alias Name
MySQL
Port No
40090
Protocol
TCP/IP
Server
MySQL
 
c) Click OK.
 
Note In this scenario, a Network Monitor capture may show connections to port 1433 continually being reset. This typically occurs if SQL Server is not listening on port 1433. To confirm the SQL Server port, run netstat -ano on the SQL Server. Look for the sqlservr.exe Process ID (PID) in the netstat output to determine the port number.
 
3. When BizTalk and SQL Server are remote, the network layer could be responsible for some delays. Consider the following:
 

·          

If there are any delays or issues with name resolution within DNS, the BizTalk Administration console will be impacted. As a work-around, you can add the SQL Server IP address to the hosts file on all BizTalk servers in the group. The hosts file is located in the following directory:
 
32-bit server: %systemroot% \system32\drivers\etc
64-bit server: %systemroot% \SysWOW64\drivers\etc
 
For example, the SQL Server IP address is 1.1.1.1 and the SQL Server name is MySQL. You would add the following to the hosts file:
 
1.1.1.1       MySQL
 
 
BizTalk Administration runs as a 32-bit process on a 64-bit server. As a result, the issue described in KB article 973839 may impact the MMC:
 
973839  32-bit applications do not use the Domain Name System (DNS) cache on a computer that is running an x64-based version of Windows Server 2003 or of Windows XP
 
If a remote server is specified in a receive location or a send port that is running in a 32-bit host, the DNS query for this server could also be impacted. In this scenario, you can add the remote server to the hosts file. For example, the remote server IP address is 1.1.1.1 and the remote server name is MyServer. You would add the following to the hosts file:
 
1.1.1.1       MyServer
 
 
To reset the hosts file back to the default, refer to the following KB article:
 
972034  How do I reset the hosts file back to the default?

·          

The Speed & Duplex value on the Network Interface Card (NIC) and additional network layers (e.g. router) can impact performance. If the Speed & Duplex value on the SQL Server NIC is set to 100 MB Half and the Speed & Duplex value on the BizTalk Server NIC is set to 1GB Full, then a delay will probably occur.
 
Confirm the Speed & Duplex value of all network layers involved (NIC, router, etc) are the same. In the scenario above, configure the SQL Server NIC and the router to 1 GB Full.
 
To test this scenario, copy/paste a file from the BizTalk Server to a folder on the SQL Server, and vice versa. If this copy process takes a while, then something in the network layer is causing an issue.

·          

When connecting to the SQL Server Database Engine, a network protocol must be enabled. For BizTalk, confirm the TCP/IP protocol is enabled.
 
Choosing a Network Protocol
 
4. You may get an OutOfMemory exception when working within BizTalk Administration. WMI has a __ProviderHostQuotaConfiguration class that applies to the BizTalk WMI namespace. This class consists of the following properties:
  • HandlesPerHost
  • MemoryAllHosts
  • MemoryPerHost
  • ProcessLimitAllHosts
  • ThreadsPerHost
To check the MemoryPerHost value, use wbemtest on all BizTalk servers in the group:
a) Go to Start, Run and type wbemtest.
b) Click the Connect button and change the Namepace to root. Click Connect.
c) Click the Enum Instances… button and enter __ProviderHostQuotaConfiguration. Click OK.
d) Double-click __ProviderHostQuotaConfiguration=@.
e) If the MemoryPerHost value is less than 512 MB (536870912), double-click MemoryPerHost and set the value to 536870912. Click Save Property, click Save Object and Exit.
f) Restart the Windows Management Instrumentation service.
 
For more information, refer to the links below:
 
Memory and Handle Quotas in the WMI Provider Service
 
__ProviderHostQuotaConfiguration Class

Available Hotfixes

 
List of WMI related hotfixes post Service Pack 2 for Windows Server 2003
FIX: A BizTalk Server Group Hub page takes a long time to refresh after one node goes offline in a BizTalk 2009 & BizTalk Server 2006 R2 host clustering environment
FIX: Changes that are made to adapter handlers are not displayed unless you restart BizTalk Server 2009 Administration Console
FIX: Resource artifacts may take very long time to load in BizTalk Server 2009 Administration Console
FIX: "Tracked message with id: <message id> should not exist in multiple locations" error message when you try to view message details for a tracked message event in BizTalk Server 2009
FIX: SQL connections to BizTalk databases are not cleaned up or reused when you use the BizTalkOperations class in BizTalk Server 2006 R2
FIX: The number of connections to SQL Server may increase to over 500 when you try to import the same BizTalk application .msi file again in BizTalk Server 2006 R2
FIX: Importing an .msi file may take a very long time or you may get a "Timeout expired" error
FIX: A user in the BizTalk Server Operators group cannot enable or disable a SQL Server or MSMQ receive location in BizTalk Server 2006 R2
FIX: BizTalk Server Administration displays incorrect or blank application name for some orchestration instances after you add a new MessageBox database in BizTalk Server 2006 R2
Error message when you try to create a new host in the BizTalk Administration console in BizTalk Server 2006 R2: "The parameter is incorrect (WinMgmt)"
Error message when you perform a task in BizTalk Server 2006 R2: "Not Enough storage is available to complete the operation"

Troubleshooting

If BizTalk support assistance is needed, please collect the following data while reproducing the issue:
 
1. Capture a BizTalk trace using the -all option while reproducing the issue. The steps in KB article 835451 provide the specific steps:
 
835451  How to use the BizTalk Adapter Trace Utility in BizTalk Server
 
2. Configure the PrivateTrace registry key to enable WMI tracing in the BizTalk Administration console using the steps below:
 
a) Open the registry and go to the following key:
 
32-bit server: HKEY_LOCAL_MACHINE\Software\Microsoft\BizTalk Server\3.0\Administration
64-bit server: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\BizTalk Server\3.0\Administration
 
b) Create a new DWORD value named PrivateTrace and set it to 1.
c) Restart the Windows Management Instrumentation service.
 
This creates the "c:\BizTalkAdminDbgLog.txt" log file. The log file path and file name cannot be changed.
 
3. Capture a SQL Server Profiler trace with the following Events:
 
Errors and Warnings
All events
Locks
Lock:Deadlock
Lock:Escalation
Lock:Timeout
Security Audit
Audit Login
Audit Login Failed
Audit Logout
Sessions
ExistingConnection
Stored Procedures
SP:Completed
SP:Starting
SP:StmtCompleted
SP:StmtStarting
TSQL
SQL:StmtCompleted
SQL:StmtStarting
Transactions
DTCTransaction
SQL Transaction
 
4. Capture simultaneous Network Monitor captures on the BizTalk and SQL servers while reproducing the issue. More information on Network Monitor 3 is available at the link below:
 
933741  Information about Network Monitor 3 

Applies To

This article is applied to:

  • BizTalk Server 2010
  • BizTalk Server 2009
  • BizTalk Server 2006 R2

See Also

Read suggested related topics:
Another important place to find a huge amount of BizTalk related articles is the TechNet Wiki itself. The best entry point is BizTalk Server Resources on the TechNet Wiki.
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Nice article, very informative

  • Excellent

  • Sandro Pereira edited Revision 15. Comment: Fixing text format (different fonts are used) and set links to open in a new window

  • I love this topic, great article