BizTalk Server Administration Console Troubleshooting: Common Issues and Resolutions
Introduction
This article describes common issues and resolutions when using the 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:
Microsoft BizTalk Server Management Pack for System Center Operations Manager 2007
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.
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:
- Troubleshooting Issues When Monitoring BizTalk Server Using System Center Operations Manager 2007** **
Additional Issues
BizTalk group membership
Many common tasks like creating a BizTalk host or stopping a send port requires specific rights within BizTalk and SQL Server. If you are unable to perform certain functions within BizTalk Administration, you may be a missing membership to a BizTalk group. For the specific details of the group or role requirements, visit the following link:
Minimum Security User Rights - http://msdn.microsoft.com/en-us/library/aa559845(BTS.10).aspx
SQL Server
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.
Network
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 host's file on all BizTalk servers in the group. The host's 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 host's 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 host's 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 host's 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.
Network protocol
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: http://msdn.microsoft.com/en-us/library/ms187892.aspx
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:
- Go to Start, Run and type wbemtest.
- Click the Connect button and change the Namepace to root. Click Connect.
- Click the Enum Instances… button and enter __ProviderHostQuotaConfiguration. Click OK.
- Double-click __ProviderHostQuotaConfiguration=@.
- 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.
- Restart the Windows Management Instrumentation service.
For more information, refer to the links below:
- Memory and Handle Quotas in the WMI Provider Service - http://blogs.technet.com/askperf/archive/2008/09/16/memory-and-handle-quotas-in-the-wmi-provider-service.aspx
- __ProviderHostQuotaConfiguration Class - http://msdn.microsoft.com/en-us/library/aa394671(VS.85).aspx
Available Hotfixes
| 2272583 | List of WMI related hotfixes post Service Pack 2 for Windows Server 2003 |
| 2028814 | 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 |
| 981960 | FIX: Changes that are made to adapter handlers are not displayed unless you restart BizTalk Server 2009 Administration Console |
| 981327 | FIX: Resource artifacts may take very long time to load in BizTalk Server 2009 Administration Console |
| 977141 | 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 |
| 976927 | FIX: SQL connections to BizTalk databases are not cleaned up or reused when you use the BizTalkOperations class in BizTalk Server 2006 R2 |
| 954906 | 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 |
| 954814 | FIX: Importing an .msi file may take a very long time or you may get a "Timeout expired" error |
| 952947 | 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 |
| 952310 | 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 |
| 942966 | 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)" |
| 942251 | 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:
Capture a BizTalk trace
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
PrivateTrace
Configure the PrivateTrace registry key to enable WMI tracing in the BizTalk Administration console using the steps below:
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
Create a new DWORD value named PrivateTrace and set it to 1.
Restart the Windows Management Instrumentation service.
This creates the "c:\BizTalkAdminDbgLog.txt" log file. The log file path and file name cannot be changed.
SQL Server Profiler trace
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 |
Network Monitor captures
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.