BizTalk Server: List of Errors and Warnings, Causes, and Solutions
Introduction
This article is intended to be a knowledge base of all Errors and Warnings, Causes and Solutions documented in all stages/components of BizTalk: different stages of development, deployment, adapters, runtime, setup and configuration…
Visual Studio Orchestration Design Issues
The following are the known errors/issues associated to Visual Studio Orchestration Design:
- Errors exist for one or more children.
- Typically this problem is usually associated with problems in Orchestration Designer “refactoring” or “graphical interpretation” and in a certain way it isn’t a “valid error”, ie, it doesn’t describe the real problem. Usually this error is followed with a red indicator on the shape; however this was not my case, I had no indicator, but had the same error.
- For more information see BizTalk Orchestration error: "Errors exist for one or more children"
- Typically this problem is usually associated with problems in Orchestration Designer “refactoring” or “graphical interpretation” and in a certain way it isn’t a “valid error”, ie, it doesn’t describe the real problem. Usually this error is followed with a red indicator on the shape; however this was not my case, I had no indicator, but had the same error.
- ‘varName‘: if shared data is updated in a parallel then all references in every task must be in a synchronized or atomic scope
- Assembly generation failed — Referenced assembly ‘…’ does not have a strong name
- This problem occurs when a type from an unsigned referenced assembly is used within an orchestration.
- ‘EmailPort’: property ‘Microsoft.XLANGs.BaseTypes.Address’ is read-only for non-dynamic ports
- The port bind is not specified as Dynamic.
- ‘System.String’ must be Xml serializable to be a message part type
- Despite what the error says - there's no further information in the event log as it suggests
- Use of Unconstructed Message ‘MessageName’
- Check if you have a reference to the message before its initialize
- An atomic scope may not contain a receive with a correlation filtration initialized in the same scope
- The error occurs because you have a Receive shape inside an atomic scope and this Receive shape follows a correlation set that is initialized within the same scope. This is not allowed, as explained here: http://msdn.microsoft.com/en-us/library/aa560115%28BTS.10%29.aspx.
- The transport proxy method MoveToNextTransport() failed for adapter WCF-Custom: Reason: "Messaging engine has no record of delivering the message to the adapter. This could happen if MoveToNextTransport() is called multiple times for the same message by the adapter or if it is called for a message which was never delivered to the adapter by the messaging engine". Contact the adapter vendor.
- A message sent to adapter "SMTP" on send port "port-name" with URI "mailto:*mail@domain.com" is suspended. Error details: Unknown Error Description
- If you are using Dynamic SMTP port and you use the SMTP.EmailBodyText property, you must set up the SMTP.EmailBodyTextCharset property.
- Symbol '@@@@' is already defined; the first definition is in assembly @@@.dll
- The error occurs when trying to rebuild an orchestration assembly in Visual Studio.Net 2010 in BizTalk 2010 environment. This behavior was seen already in BizTalk 2004 and a straight forward workaround exists which explains clearly what has to be done, to circumvent the situation.
- The source was not found, but some or all event logs could not be searched. Inaccessible logs: Security.
- This problem occurs because the user account that you used to log on does not have sufficient permissions.
- cannot resolve imported 'service'.
- So basically, the problem is: When compiling a BizTalk project, you get the "'projectname.orchestrationname': cannot resolve imported 'service'" error. This occurs when you are compiling a project that has an orchestration inside it, that calls another orchestration in another project that again calls an orchestration in a third project.
- Identifier ‘RetryCount’ does not exist in ‘myprojectnamespace’; are you missing an assembly.
- This problem occurs because we used a special keyword in the namespace used by BizTalk: “BTS” and when we try to compile the project the compiler is trying to get the property RetryCount from the namespace of the BizTalk project: ‘CompanyName.Project.Module.BTS‘ instead of namespace BTS associated with Microsoft.BizTalk.GlobalPropertySchemas assembly.
- Illegal 'activate' predicate: an 'activate' predicate rvalue must be a string, character, boolean or numeric literal.
- This problem may occurs when you try to set a filter on the initial receive shape without “double quotes”.
- you must specify at least one already-initialized correlation set for a non-activation receive that is on a non-selfcorrelating port
- This error can occur if your orchestration has no activating Receive shapes (Activate = true) or has no activating Receive shapes and is not called directly by another orchestration.
- A correlation may be initialized only once
- This error occurs if you are trying to initialize a correlation set in a loop.
- Preprocessor directive must appear as the first token on a line
- After a small amount of investigation, I discovered that the cause of this error was the Filter Expression that I had applied to the receive shape in my Orchestration. The missing " " were the cause of this interesting error.
- BizTalk Orchestration ItemTemplate missing from Visual Studio
- Orchestration Debugger crashes with error “Object reference not set to an instance of an object” for one particular Orchestration
- When I tried to open the orchestration debugger for one specific orchestration, it opened up a message box with error message “Object reference not set to an instance of an object”. I was more curious why this happened to only this orchestration and not to any other orchestration on the same server. I verified that the orchestration is working fine in runtime, i.e., the message are flowing from this orchestration as expected
- Creating project ‘BizTalk project name’… project creation failed.
- VSTS for Database Professionals Sql Server Data-tier Application
- Error while making orchestration as web service
- Error : There are no orchestrations with public receive ports in this BizTalk assembly New!
- This happens when you try to publish your Orchestration as a web service and none of the ports used in the Orchestration are set as Public. i.e. none of the ports are available which can be exposed as service.
- http://msdn.microsoft.com/en-us/library/bb743860.aspx
- Error : There are no orchestrations with public receive ports in this BizTalk assembly New!
- {ORCHESTRATION_NAME} encountered an error: Object reference not set to an instance of an object.
at Microsoft.XLANGs.Core.Service.ApplyTransform(Type mapRef, Object[] outParams, Object[] inParams)
at {ORCHESTRATION_NAME}.segment3(StopConditions stopOn)
at Microsoft.XLANGs.Core.SegmentScheduler.RunASegment(Segment s, StopConditions stopCond, Exception& exp) New!- Many times, this is the result of not deploying your DLL to the GAC, or not having a schema available in the Management Database.
- Message has not been initialized in construct statement New!
- When using the MessageAssignment orchestration shape, if the message you are using has not been instantiated by a map or a port then you must manually instantiate the message
Visual Studio Schema Design Issues
The following are the known errors/issues associated to Visual Studio Schema Design:
- Unexpected XML declaration. The XML declaration must be the first node in the document, and no white space characters are allowed to appear before it. Line x, position y.
- This problem may occurs if you have a single whitespace character on the first line of your schema before the start of the xml declaration or a single whitespace character on the first line of your XML file before the start of the xml declaration.
- Build failed. Compiler for file type ‘*.xsd’ failed. Value cannot be null. Parameter name: pUnk
- The error occurs if there is any *.xsd file added to the project.
- Unrecognized data in remaining stream.
- You can get this error while validating the flat-file instance in visual studio if you have specified a wrong value for Tag Identifier.
- This node can occur potentially multiple times in the instance document. Only nodes which are guaranteed to be unique can be promoted.
- Unfortunately, elements that can occur more than once can not be promoted.
- error BEC2004: Non Segment level : [71] Transaction Set or Group Control Number Mismatch.
- Message Reference Number in UNH segment must be equal to the existing in the UNT segment. Therefore change one of them to become equal and the problem will be solved.
- EC2004: Non Segment level : [29] Invalid count specified at interchange, group or message level.
- This error is a notification that the number of groups, messages, or segments does not match the number given in the UNZ, UNE, UNT, or UST segment; or that the length of an object or the length of encrypted data is not equal to the length stated in the UNO, UNP, USD, or USU segment, i.e., the control count does not match number of instances received.
- Schema item missing from Visual Studio BizTalk Project items.
- Well, unfortunately, I don’t know exactly why this problem occurred, but I believe that some dependence has become corrupted. To fix this issue, or similar problems, you need to repair Visual Studio 2010.
- BizTalk Error for Schemas With Hyphenated Root Node (BizTalk problem with schema elements which have hyphens)
- The solution was to open the properties dialog box for the root node (in this case there were two root nodes: one for the request and another for the response) and edit the RootNode TypeName property to remove the hyphens. This fixed the issue.
- This Operation Could Not Be Completed. Global Element Has Already Been Declared. New!
- This proved to be some Visual Studio contention issue. Close the .xsd file and reopen. This should allow you to create a Child Node, and select the proper (Reference) type, as expected..
Visual Studio Mapper Design Issues
The following are the known errors/issues associated to Visual Studio Schema Design:
- XSL transform error: (0,0) : Resolving of External URI’s was prohibited.
- This issue can occur if the XSLT file that is defined in the Custom XSL Path Grid Properties uses the <xsl:import> element or the <xsl:include> element to import or to include an external XSLT file.
- Cannot load source/destination schema: “schema_name”. Either the file/type does not exist, or if a project dependency exists, the dependent project is not built.
- For some reason, the BizTalk designer loses the schema reference and it is a little hard trying to “trick�� the designer into remembering the schema’s location.
- Value Cannot be Null. Parameter name: extension
- If you use external assembly in the scripting fucntiod MAP create an Extension Object file to keep the Details of the dll being referenced in the scripting functoid..
- The Messaging Engine failed while executing the inbound map for the message coming from source URL:"C:\.csv" with the Message Type "<some message type>". Details:"An error occurred when parsing the incoming document: "'.', hexadecimal value 0x00, is an invalid character. Line 1, position 275.".
- Turns out that the file contains nulls (hex 0x00) in some of the fields, in some of the records.
- Error 23 Exception Caught: Mapper Compiler: Functoid not found: guid ({5DE500CC-45BC-454B-A23D-24449899042C}) with functoid id (6124).
- It is usually associated with custom functoid, so you have to copy your functoid assembly to "%BTS%\Developer Tools\Mapping Extensions" folder, where %BTS% is the installation folder of BizTalk, to be able to use it in visual studio and then you have to GAC it to be able to use it during the run time.
- BizTalk Server 2010: The Messaging Engine failed while executing the inbound map for the message coming from source URL:”...” with the Message Type “...”. Details:”Cannot find the script or external object that implements prefix ‘ScriptNS0′.
- BizTalk Server 2010/Visual Studio 2010 have a bug (or issue): Visual Studio does not persist the path of Custom Extension XML property in the .BTM file.
- BizTalk Server 2013 Unit testing: "Transformation Failure".
- or "The type initializer for 'Microsoft.BizTalk.ScalableTransformation.BTSXslTransform' threw an exception."
- or "The type initializer for 'Microsoft.BizTalk.CommonSettings.CBizTalkSettingsLookup' threw an exception."
- or "Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))"
- Eventually, I found a solution to this. I added a test settings file to my solution and referenced this in the TEST menu so it was the active test settings. When I did this running the test with the BizTalk Unit Testing feature and running the test using C# to execute the map both worked fine. I didn't need to modify any settings in the test settings file, I just left them as the defaults.
- "Exception Caught: Cannot use a prefix with an empty namespace" New!
- When you use the Transform shape in a Microsoft BizTalk Server Orchestration to generate a map file after you have installed BizTalk Server 2004 Service Pack 1 (SP1), you may receive this error message when you try to validate the map.
- "Exception Caught: ‘ns1′ is an undeclared prefix. Line …, position …" New!
- Well unfortunately BizTalk Mapper Editor doesn’t like prefixes in inline XSLT code, although they exist he is not able to understand them without additional information in the code, which makes our work a little more difficult or we need to use a different strategy in our XSLT code.
- Cannot access to some Functoids in the grip page New!
- What I found out is that the configurations of working area (space) of the grid page, at least since BizTalk Server 2013, have changed. Open .btm file look for collection, change all X-Cell and Y-Cell coordinates to something like 1,1 2,2 … and save file. Open with VS and bingo functiods magically show at top of the page
BizTalk Visual Studio Common Issues
The following are the known common errors/issues associated to Visual Studio:
- "Cannot generate serialization assembly {AssemblyName}.XmlSerializers.dll because it already exists. Use /force to force an overwrite of the existing assembly."
- Some time if you have a traditional Web Service reference in your BizTalk Project this error may suddenly appear. It seems that when you try to build the solution the SGEN process is having some trouble deleting the original XMLSerializers.dll and in result will give you that error.
- "Cryptographic failure while signing assembly 'assembly name here' — 'Access is denied.'"
- This error appeared while trying to sign a .NET assembly with a strong name key file. The cause for this error is pretty obvious as being a permissions error. In this case, the error is caused by the current user not having ‘full control’ to the Key folder.
- “Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.BizTalk.Component.Interop.IComponentTypeInfo'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{CF0480A5-F484-415b-AEC6-0AB44855758B}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE))”
- PipelineObjects.dll is a pipeline tool provided with BizTalk SDK to perform BizTalk Unit testing. The first thing that we do when using this utility is to create an instance of pipelinefactory and create pipeline using the below code. However, from .net 4.0 onwards there has been a change in how .net calls the com component and now on, .net supports calling of com components using an entry in config file.
- “Could not load file or assembly ‘file:///C:\Program Files (x86)\Microsoft BizTalk Server 2013\Pipeline Components\BREPipelineFrameworkComponent.dll’ or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded”. New!
- We found that you needed to adjust the vstest.executionengine.exe.config file typically found in the “C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\CommonExtensions\Microsoft\TestWindow” folder, setting the useLegacyV2RuntimeActivationPolicy attribute on the startup element to true .
- ‘Deploy Solution’ option in my BizTalk Visual Studio Solution missing. New!
- Visual Studio allow you to store different configurations of solution and project properties to use in different kinds of builds. To create, select, modify, or delete a configuration, you can use the Configuration Manager option present in the solution context menu.
- “Unable to read the project file “…\MyProject.btproj.user”. The project file could not be loaded. Root element is missing.”. New!
- To solve this problem you just need to delete this User configuration file (*.btproj.user) from the file system and try to import de project or convert the solution again.
- “The namespace ‘[namespace]’ already contains a definition for ‘_MODULE_PROXY_’”. New!
- While the error seems obvious, in my case, the namespaces were indeed unique, such that the above error did not make much sense. The underlying issue was in fact that the type names of two of the orchestrations within the project were identical. It turns out that an orchestration was at one point duplicated, and only the namespace was changed. After making the type names unique, the project successfully compiled and deployed.
BizTalk Debugging Issues
The following are the known errors/issues associated to Debugging BizTalk Solutions:
- Tracking database doesn't have any records about the selected service instance yet.
- I received this error when trying to debug an orchestration using the Orchestration Debugger option and it would just show the above message. Things I did were:
- Enable global tracking, because that was turned off.
- Check all the tracking properties in the orchestration.
- Start the process by keeping the orchestration in the enlisted state only (That would force suspend the orchestration)
- Once it was suspended I resumed in debug mode.
- Then it went into the running state with a status of "In Breakpoint(Active)"
- Then right click the instance and click orchestration debugger and it worked.
- More reading can be done here: Troubleshooting Orchestrations
- I received this error when trying to debug an orchestration using the Orchestration Debugger option and it would just show the above message. Things I did were:
- Pipeline file name is already specified - Error 80131600.
- While trying to debug custom pipeline component using “Pipeline.exe” utility, I keep getting this error message.
- Importing Binding Files: Failed to create 'WCF-Custom' Transport Component. New!
- This error occurred during the importation of one of the binding files remotely. The solution: The Windows Communication Foundation Adapter runtime should also be installed on the local machine (in our case TFS Build Server).
BizTalk Deploy Issues
The following are the known errors/issues associated to Deploying BizTalk Solutions:
- Could not enlist orchestration ‘MyAssembley, Version=1.0.0.0, Culture=neutral, PublicKeyToken=776eb620b83c3d30′. Object reference not set to an instance of an object. (Microsoft.BizTalk.SnapIn.Framework)
- This problem maybe happens because the DLL’s presents in the GAC are not correct, or they are missing.
- Unable to copy file "…\Pipeline Components\MyPipelineComponent.dll" to "bin\Debug\ MyPipelineComponent.dll". The process cannot access the file "bin\Debug\ MyPipelineComponent.dll" because it is being used by another process
- This problem may occurs if: Visual Studio has a lock on the file in order to show the pipeline components in the toolbox; Some BizTalk process is running BizTalk host and have a lock on the file; or IIS AppPool has a lock on the file.
- Component ‘…’ could not be initialized. Pipeline component ‘…’ could not be resolved (is an assembly reference missing?)
- The specified module could not be found. (Exception from HRESULT: 0x8007007E)
- Your DLL (component) depend on other DLL’s to get its job done and if you didn’t copy or install those too, you’d indeed get this error message.
- You have selected an invalid pipeline component assembly. Please check security settings for the assembly if you are loading it from an UNC path.
- Unable to process create change request for BizTalk binding "BindingInfo.xml". Import bindings (overwrite) failed. (Microsoft.BizTalk.ResourceManagers)
- Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
- When developing BizTalk 2009 solutions using Visual Studio .NET 2008 on Windows Server 2008, you run into issues when deploying from within Visual Studio .NET.
- There was a failure executing the receive pipeline… failed to load. Verify the schema for this document specification is deployed and is in the Global Assembly Cache
- Because this error can happen for several reasons you may have many solutions to this problem. These are some steps that you should take to resolve the issue:
- There was a failure executing the receive pipeline… failed to load. Verify the schema for this document specification is deployed and is in the Global Assembly Cache
- XML Receive Pipeline throwing exception: Verify the schema for this document specification is deployed and is in the Global Assembly Cache
- Because this error can happen for several reasons you may have many solutions to this problem. These are some steps that you should take to resolve the issue:
- Failed to update binding information. Could not validate TransportTypeData, Address or Public Address properties for Receive Location <Receive Location Name>. Retrieving the COM class factory for component with CLSID {CFF09884-6582-49C2-A74F-0FD85849281E} failed due to the following error: 8007045a. and Failed to add resource(s). Change requests failed for some resources. BizTalkAssemblyResourceManager failed to complete end type change request. Failed to update binding information. Could not validate TransportTypeData, Address or Public Address properties for Receive Location <Receive Location Name>. Retrieving the COM class factory for component with CLSID {CFF09884-6582-49C2-A74F-0FD85849281E} failed due to the following error: 8007045a.
- These errors occur when trying to redeploy over BizTalk applications that use role links with send or receive ports. These deployments from Visual Studio have been attempted with the deployed BizTalk applications in both the enlisted/started and unenlisted/stopped states.
- Error: The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully.
- Exception thrown from: segment -1, progress -1. Inner exception: Could not load type ‘type name’ from assembly ‘assembly name, Version=1.0.0.0, Culture=neutral, PublicKeyToken=…’.Exception type: TypeLoadException.
- You didn’t install the assembly specified in the error; Your DLL depend on other DLL’s to get its job done and if you didn’t copy or install those too, you’d indeed get this error message; Or you have installed an older version of the assembly.
- Schema referenced by Map 'map_name' has been deleted. The local, cached version of the BizTalk Server group configuration is out of date. You must refresh the BizTalk Server group configuration before making any further changes.
- This problem occurs if: A schema referenced by a deployed map has not been deployed.
- Failed to add resource(s). Resource (…) is already in store and is either associated with another application or with another type.
- Inadvertently deployed it to another application, most likely to the default “BizTalk Application 1”;
- Someone have probably removed the previously existing name in “Application Name” property from the project properties.
- There was a failure executing the receive pipeline: "xxxxxxxxx, xxxxxxxx, Version=1.0.0.0, Culture=neutral, PublicKeyToken=xxxxxxx" Source: "Flat file disassembler" Receive Port: "xxxxxxxxx" URI: "C:\BizTalk Folders\xxxxxxxxx\.csv" Reason: Cannot access a disposed object. Object name: 'DataReader'..
- The following error was encountered when consuming a flat file through a pipeline that made use of the Flat File Disassembler pipeline component; This was resolved by settling 'RecoverableInterchangeProcessing' to True in the Receive Pipeline Properties on the Receive Location.
- **The error occurred during the removing of a send port from a party: Sendport Reference [Microsoft.BizTalk.B2B.PartnerManagement.SendPortReference] cannot be deleted as it is use by agreement [Microsoft.BizTalk.B2B.PartnerManagement.SendPortReference]. (Microsoft.BizTalk.B2B.PartnerManagement) **
- Based on a forum thread on MSDN, this seems to be a bug in the BizTalk console, but has never been officially announced or patched. The forum thread suggests waiting for the next cumulative update for BizTalk server [link: cumulative updates BizTalk]. But even when I applied an update for BizTalk to the next version, the problem didn't got solved.
- Error 25 Failed to add resource(s). Change requests failed for some resources. BizTalkAssemblyResourceManager failed to complete end type change request. Failed to update binding information. Party 'PartyName' enlisted under role
'ResaleReportReceiver(MyCompany.B2B.ResaleReport.Process.SendResaleReportRoleLink_Type)' has not bound all the operations of role link port types - Failed to update binding information. (mscorlib). Party 'PartyName' enlisted under role 'Provider(MyRoleLinkType)' has not bound all the operations of role link port types. (Microsoft.BizTalk.ExplorerOM)
- Schema referenced by Map has been deleted. The local, cached version of the BizTalk Server group configuration is out of date.
- Error 26 Failed to add resource(s). Change requests failed for some resources. BizTalkAssemblyResourceManager failed to complete end type change request. Failed to update binding information. Could not enlist orchestration 'Orchestration.UpdateRequestStatus,Orchestration, Version=1.0.0.0, Culture=neutral, PublicKeyToken=f96e91b6b75bb727'. Could not enlist orchestration 'Orchestration.UpdateRequestStatus'. All orchestration ports must be bound and the host must be set.
- error MSB3073: The command "BTSTask.exe AddResource -Type:BizTalkAssembly -Source:"..\ApplicationName>\bin\Debug\ApplicationName>.dll" -ApplicationName:"<ApplicationName>" -Options:GacOnAdd,GacOnImport,GacOnInstall" exited with code 1. […\ApplicationShortName>\Deployment\Deployment.btdfproj].
- The problem was in the AssemblyInfo.cs file which is under the Properties folder of the project. For some reason, this file was not stored in the source control and was not moved to the upgraded project.
- An error occurred while attempting to install the BizTalk application: World Wide Web service (W3SVC) on host "localhost" not available.
The following Windows component may not be installed: Application Server -> Internet Information Services (IIS) -> Common Files.
Unknown error (0×80005000)
Unknown error (0×80005000).- The problem this time was that IIS 6 Management Compatibility role services was not installed. Due to IIS 7.0/7.5 includes significant change on the configuration system, on Windows Server 2008 and above, we need to enable IIS 6 Management Compatibility role services: IIS Metabase and IIS 6 configuration compatibility, IIS 6 WMI Compatibility and IIS 6 Scripting Tools to allow System.DirectoryServices code work on modifying IIS configurations on IIS7.x..
- A file not found exception occurred while reflecting a BizTalk assembly.
- A file not found exception occurred while reflecting BizTalk assembly "{0}". This problem may occur if one or more dependencies are not available. To correct this problem, try one of the following: 1. Copy the dependencies of the assembly to the same folder. 2. Install the missing dependencies into the Global Assembly Cache.
- This error indicates the BizTalk Assembly that is being published references another assembly that is not in the Global Assembly Cache (GAC) or in the same directory.
- http://msdn.microsoft.com/en-us/library/bb727689.aspx
- A file not found exception occurred while reflecting BizTalk assembly "{0}". This problem may occur if one or more dependencies are not available. To correct this problem, try one of the following: 1. Copy the dependencies of the assembly to the same folder. 2. Install the missing dependencies into the Global Assembly Cache.
- A security exception occurred while reflecting BizTalk assembly "{0}". This problem may occur if the assembly is located in a shared network folder. To correct this problem, try one of the following: 1. Copy the assembly and its dependencies to the local machine. 2. Adjust the .NET Configuration Runtime Security policy to permit access.
- This error will occur when trying to publish a BizTalk assembly that is on a network share without the right .NET policy.
- Unable to load assembly "{0}". New!
- This error indicates the assembly used is not a valid BizTalk assembly.
- “Failed to add resource(s). Change requests failed for some resource. BizTalkAssemblyResourceManager failed to complete end type change request. Failed to update binding information. Cannot update receive port “”. Transform “” not found”. New!
- Visual Studio uses cached binding files when deploying BizTalk applications. Removing these cached binding files will result in a ‘clean’ deployment that should resolve any binding related deployment errors. The files are stored in %APPDATA%\Microsoft\BizTalk Server\Deployment\BindingFiles\ Clearing the contents of this directory should resolve any deployment issues related to cached bindings.
- “Failed to add resource(s). Change requests failed for some resources. BizTalkAssemblyResourceManager failed to complete end type change request. Cannot update assembly”. New!
- Visual Studio uses cached binding files when deploying BizTalk applications. Removing these cached binding files will result in a ‘clean’ deployment that should resolve any binding related deployment errors. The files are stored in %APPDATA%\Microsoft\BizTalk Server\Deployment\BindingFiles\ Clearing the contents of this directory should resolve any deployment issues related to cached bindings.
- “Failed to add resource(s). Change requests failed for some resources. BizTalkAssemblyResourceManager failed to complete end type change request. Failed to update binding”. New!
- Visual Studio uses cached binding files when deploying BizTalk applications. Removing these cached binding files will result in a ‘clean’ deployment that should resolve any binding related deployment errors. The files are stored in %APPDATA%\Microsoft\BizTalk Server\Deployment\BindingFiles\ Clearing the contents of this directory should resolve any deployment issues related to cached bindings.
- "The following items could not be matched up to hosts due to name and/or trust level mismatches".
- There could be two reasons behind this. Check for the name of host. Make sure the spelling matches with what has been provided in the binding file. If there is a mismatch then either change the name in your binding file or correct it on you host name, or Check for the receive and send handlers on the adapter settings.Check on the binding file and see what handler is being used there, once identified go to the adapter settings and look if the handler is created.
BizTalk Adapters Issues
The following are the known errors/issues associated to BizTalk Adapters:
- WCF: Exception: System.ServiceModel.ServiceActivationException: The service ‘/MyService/Service.svc��� cannot be activated due to an exception during compilation. The exception message is: That assembly does not allow partially trusted callers.. —> System.Security.SecurityException: That assembly does not allow partially trusted callers.
- A message received by adapter "FILE" on receive location "Receive Location3" with URI "C:\..\In\.xml" is suspended. Error details: The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
- The HTTP send adapter cannot complete the transmission within the specified time
- This error occurred for Solicit-response send port when the HTTP adapter does not receive the response within the time specified for Request timeout. for details see: Error: "The HTTP send adapter cannot complete the transmission within the specified time"
- "The operation has timed out", "Request timed out."
- This error is caused when the BizTalk performance get degraded and it start responding slow
- For details see Error: "The operation has timed out", "Request timed out."
- This error is caused when the BizTalk performance get degraded and it start responding slow
- HTTP/SOAP:The underlying connection was closed: An unexpected error occurred on a receive.
- You might get this error in case of solicit response send port if AppPool get recycled before receiving the response message
- FTP: Unable to receive the file
- This error can be caused by blocking of incoming connection by Firewall
- For details see: FTP adapter issue: Unable to receive the file ""
- This error can be caused by blocking of incoming connection by Firewall
- The one-way operation returned a non-null message with Action=”...".
- A WSDL file with a true one-way operation results in a WCF client that expects an IsOneWay=true interaction pattern. However, BizTalk doesn’t support true one-way interactions. It supports operations that return no data (e.g. “void”) only. So, by putting a hand-built WSDL that demanded an asynchronous service on a BizTalk receive location that cannot support it, we end up with a mismatch.
- WCF-Oracle Transport Properties. Error loading properties. (System.MissingMethodException) Method not found: ‘System.Configuration.ConfigurationElement Microsoft.BizTalk.Adapter.Wcf.Converters.BindingFactory.CreateBindingConfigurationElement(System.String, System.String)’.
- "E-PSFT0029: JVM was not started" or "Unable to find JAVA_HOME"
- It's common to get this kind of errors when we try to connect Enterprise Applicatons with BizTalk Adapters
- The adapter "WCF-Custom" raised an error message. Details "System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
- The adapter failed to transmit message going to send port “WcfSendPort_SqlAdapterBinding_TypedProcedures_MyDB” with URL “mssql://MYSRVSQ01//MyDB?”. It will be retransmitted after the retry interval specified for this Send Port. Details:”Microsoft.ServiceModel.Channels.Common.MetadataException: Object [dbo].[uspInsertRecords] of type StoredProcedure does not exist
- The above message can be quite confusing especially when the stored procedure does exist in your database. The above basically means the BT host account does not have execute permissions on the stored procedure being called. You need to restart the BT host instance after setting permissions.
- **The adapter failed to transmit message going to send port “WcfSendPort_SqlAdapterBinding_TypedProcedures_MyDB” with URL “mssql://MYSRVSQ01//MyDB?”. It will be retransmitted after the retry interval specified for this Send Port. Details:”System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object ‘uspInsertRecords’, database ‘MyDB’, schema ‘dbo’ **
- If you are using a WCF SQL adapter in your solution, it is imperative to set permissions on the stored procedures you call from within BizTalk.
- **The adapter failed to transmit message going to send port “System.ServiceModel.ProtocolException: The content type text/xml of the response message does not match the content type of the binding (application/soap+xml; charset=utf-8). If using a custom encoder, be sure that the IsContentTypeSupported method is implemented properly." **
- The TextMessageEncodingBindingElement of WCF supports only the UTF-8, UTF-16 and Big Endean Unicode encodings. If the web service returns response in some other encoding then you need to create custom text encoder.
- **Microsoft.ServiceModel.Channels.Common.ConnectionException:Details: ErrorCode=RFC_OK. ErrorGroup=RFC_ERROR_LOON_FAILURE. SapErrorMessage=User account not in validity date. AdapterErrorMessage=.----> Microsoft.Adapters.SAP.RFCException: Details: ErrorCode=RFC_OK. ErrorGroup=RFC_ERROR_LOON_FAILURE. SapErrorMessage=User account not in validity date. **
- **Error details: The FILE send adapter cannot open file < > for writing. Details: Access is denied. **
- Make sure you specified the file name correctly
- "A message received by the adaptor "<<Adapter type>>" on the received location "<<Receive Location Name>>" with the uri "<<Location path>>" is suspended. Operation was not executed because of previous failures".
- You may have some more warnings/errors in the event log along with this error which may give some idea about the issue. Microsoft's suggestion: Check for other previous events in the event log. If the problem persists, please run trace and contact Support along with the Trace Dump
- Microsoft's post: Operation was not executed because of previous failures
- You may have some more warnings/errors in the event log along with this error which may give some idea about the issue. Microsoft's suggestion: Check for other previous events in the event log. If the problem persists, please run trace and contact Support along with the Trace Dump
- Failed to create ‘WCF-SQL’ Transport Component Microsoft.BizTalk.ExplorerOM.BtsException: Failed to create ‘WCF-SQL’ Transport Component
at Microsoft.BizTalk.ExplorerOM.BtsCatalogExplorer.SaveChangesWithTransaction(Object transactionObj)
at Microsoft.BizTalk.ExplorerOM.BtsCatalogExplorer.SaveChanges()- The main cause for this issue is due to the dependency on one of the run-time dll’s (Microsoft.BizTalk.Adapter.WCF.Runtime.dll) that gets installed only when you install all the components of BizTalk Server. Since in our case we only installed BizTalk Admin components, that dll was missing in the server and hence the error.
- Known Issues with the File Adapter
- This section contains information that may help you avoid errors.
- The Messaging Engine failed to add a receive location “XXX XXXX Relay Service Location” with URL “https://zzzzzzzz.servicebus.windows.net/httprelay/zzzzzservice” to the adapter “WCF-BasicHttpRelay”. Reason: “System.ServiceModel.CommunicationException: Unable to reach scabiztalkintegration.servicebus.windows.net via TCP (9351, 9352) or HTTP (80, 443)
- While using WCF-BasicHttpRelay to connect to Azure Service Bus over a proxy, it is important to set the default proxy configuration in BTSNTSvc*.exe.config file.
- Event Source: System.ServiceModel 3.0.0.0
Description: WebHost failed to process a request. Sender Information: System.ServiceModel.ServiceHostingEnvironment+HostingManager/20508338 Exception: System.ServiceModel.ServiceActivationException: The service '/service.svc' cannot be activated due to an exception during compilation. The exception message is: Receive location for address "/service.svc" not found. (The BizTalk receive location may be disabled.). ---> Microsoft.BizTalk.Adapter.Wcf.AdapterException: Receive location for address "/service.svc" not found. (The BizTalk receive location may be disabled.)- This issue could happen when you have two receive locations that are configured with two different receive handlers (isolated hosts), but they run in the same isolated host instance (w3wp.exe). The issue can be resolved by running the two receive locations in two different isolated instances.
- System.Net.WebException: The operation has timed out
- Typically this problem is usually associated with network problems or lack of Error Handling inside Orchestrations.
- Windows cannot access \path
Check the spelling of the name. Otherwise, there might be a problem with your network. To try to identify and resolve network problems, click Diagnose.
Error code: 0×80004005- The problem is not related to BizTalk layer, but to Windows Server 2012-based or Windows 8-based computer that fail to connect to a third-party file server that supports the SMBv2 file protocol. To allow the ports configured on multiple BizTalk hosts to works fine, you have to disable SMBv2 and SMBv3 protocol forcing the communications on SMBv1.
- The Messaging Engine failed to add a receive location "name" with URL "URL" to the adapter "WCF-Custom". Reason: "System.PlatformNotSupportedException: Operation is not supported on this platform.
at System.Net.HttpListener..ctor()
at System.ServiceModel.Channels.SharedHttpTransportManager.OnOpen()
at System.ServiceModel.Channels.TransportManager.Open(TransportChannelListener channelListener)
at System.ServiceModel.Channels.TransportManagerContainer.Open(SelectTransportManagersCallback selectTransportManagerCallback)
at System.ServiceModel.Channels.HttpChannelListener.OnOpen(TimeSpan timeout)
at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
at System.ServiceModel.Dispatcher.ChannelDispatcher.OnOpen(TimeSpan timeout)
at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
at System.ServiceModel.ServiceHostBase.OnOpen(TimeSpan timeout)
at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfReceiveEndpoint.Enable()
at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfReceiveEndpoint..ctor(BizTalkEndpointContext endpointContext, IBTTransportProxy transportProxy, ControlledTermination control)
at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfReceiver`2.AddReceiveEndpoint(String url, IPropertyBag adapterConfig, IPropertyBag bizTalkConfig)".- The receive location was handled by a BizTalk Server Host Instance which was running on two different machines. The receive location was getting enabled when we were run the host instance only on one of the machines but giving the above error while enabling the host instance on the other machine.
- Source: BizTalk Server
A response message sent to adapter "MLLP" on receive port "..." with URI "localhost:21000" is suspended.
Error details: There was a failure executing the response(send) pipeline: "BTAHL72XPipelines.BTAHL72XSendPipeline, BTAHL72XPipelines, Version=1.3.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Source: "BTAHL7 2.X Assembler" Receive Port: "..." URI: "localhost:21000" Reason: Message had parse errors, can not be serialized.- At the first sight, you may think that the message I am sending is wrongly formed and is not a correct HL7 message. I did several checks on my message and it looked good. After doing a bit of research and troubleshooting, I came to know that the problem was with the party configuration that I had in the “BTAHL7 Configuration Explorer”.
- System.Transactions.TransactionException: The operation is not valid for the state of the transaction. --->
System.TimeoutException: Transaction Timeout
--- End of inner exception stack trace ---
at System.Transactions.TransactionState.EnlistVolatile(InternalTransaction tx, IEnlistmentNotification enlistmentNotification, EnlistmentOptions enlistmentOptions, Transaction atomicTransaction)
at System.Transactions.Transaction.EnlistVolatile(IEnlistmentNotification enlistmentNotification, EnlistmentOptions enlistmentOptions)
at Microsoft.BizTalk.Adapter.Wcf.Runtime.TransmitTxnBatch..ctor(IBTTransportProxy transportProxy, ControlledTermination control, Transaction transaction)
at Microsoft.BizTalk.Adapter.Wcf.Runtime.BizTalkDeleteTxn.Execute(BizTalkExecutionContext executionContext).- After some research I found that the connection is broken if the operation takes more time than that specified in the SendTimeout of the WCF-SAP send port properties..
- A message sent to adapter "WCF-SQL" on send port "SendPortName" with URI "mssql://SQL-SERVER-1:50105//DbName?FailoverPartner=SQL-SERVER-2" is suspended.
Error details: Microsoft.ServiceModel.Channels.Common.ConnectionException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.
Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---> System.Data.SqlClient.SqlException: A
network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.
Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---> System.ComponentModel.Win32Exception: Logon failure: unknown user name or bad password- The logic here is that if we have a default instance of SQL Server then it should run on the default port (1433/1434). However, the named instance could run on any port. So in case of we have default instance of the SQL Server running on a different port, we need to create the alias for the same.
- The Messaging Engine failed while executing the inbound map for the message coming from source Details:"Loading property information list by namespace failed or property not found in the list. Verify that the schema is deployed properly." New!
- When the sap adapter is deployed, it is supposed to deploy this assembly: Microsoft.Adapters.SAP.BizTalkPropertySchema.dll, however it does not, so you need to add it as a resource to BizTalk..
- The Messaging Engine failed to add a receive location …. to the adapter "WCF-SAP". Reason: "Microsoft.ServiceModel.Channels.Common.ConnectionException: Details: ErrorCode=RFC_OK. ErrorGroup=RFC_ERROR_BUSY. SapErrorMessage=CMALLC : rc=2 > Connect from SAP gateway to RFC server failed
Connect_PM DEST=BIZTALK_2, TPNAME=BIZTALK_2 New!- Check you have a receive location setup, with your program ID, go into the SAP GUI and check via the /nsmgw command, look for your host, it will be the one running the BTSNTSvc command. You need to have it appear here first, get a receive location hooked up to this… if not there is your problem.
- The receive location "SAPxyz" with URL "sap://CLIENT=100;LANG=ENxyz&ListenerProgramId=BIZTALK_2&RfcSdkTrace=False&AbapDebug=False" is shutting down. Details:"The Messaging Engine failed while notifying an adapter of its configuration. ". New!
- This error is related to the previous one, check you have a receive location setup, with your program ID, go into the SAP GUI and check via the /nsmgw command, look for your host, it will be the one running the BTSNTSvc command. You need to have it appear here first, get a receive location hooked up to this… if not there is your problem.
- The Messaging Engine failed to add a receive location "SAPxyz" with URL "sap://CLIENT=100;LANG=EN;@a/xyz…&ListenerProgramId=BIZTALK_2&RfcSdkTrace=False&AbapDebug=False" to the adapter "WCF-SAP". Reason: "Microsoft.Adapters.SAP.RFCException: Details: ErrorCode=RFC_OK. ErrorGroup=RFC_ERROR_SYSTEM_FAILURE. SapErrorMessage=Open file 'saprfc.ini' failed: 'No such file or directory'. New!
- Read what it says in the description panel, for destination name, there are two of these… make both blank, it will stop asking you for the saprfc.ini.
- Microsoft.ServiceModel.Channels.Common.XmlReaderGenerationException: An error occurred when trying to convert the byte array [30-00-30-00-30-00-30-00-30-00-30-00-30-00-30-00] of RFCTYPE RFCTYPE_DATE with length 8 and decimals 0 to XML format. Parameter/field name: REF_DATE Error message: Year, Month, and Day parameters describe an un-representable DateTime. ---> System.ArgumentOutOfRangeException: Year, Month, and Day parameters describe an un-representable DateTime. New!
- When sending a document to SAP, or making a RFC or BAPI call you may get this error. Add Generated Items/Add Adapter Meta Data/WCF-SAP and Under the Configure Button are three tabs, set up your connection on the first two, and then there is binding properties. Look at the metadata section, change the Enable Safe Typing to true, this will generate your schema with safe types, its a fancy way of saying that all of the types generated will be of type string, rather than of type datetime, long, int, etc... SAP does not seem to care, it will do the conversion correctly now. AT RUN TIME: Ensure your send or receive port also has the same setting or it will not work.
- System.Data.SqlClient.SqlException: The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction. New!
- We had a WCF-SQL send port that was to insert a large data set into the database, and then execute a stored procedure when done, this can all be sent as one message to sql and it works it out. We looked around and found that the timeout for the msdtc controller was in the machine.config. You may find this already in there, we had 00:30:00 as the timeout, we increased this, and it worked.
- BizTalk WCF-SQL Adapter: The columns “…” are either duplicated or not in a sequence. Each column can only be selected one time, and columns must be selected in sequence. New!
- You have two options to solve this problem: You can either rectify the order of the elements in your schema to respect the order that exist in the database or you need to change the value that you are passing to the Columns element inside your map to return the result in the right order of your schema.
BizTalk WCF-SAP Adapter
- Adapter message: Details: ErrorCode=RFC_EXCEPTION. ErrorGroup=RFC_ERROR_APPLICATION_EXCEPTION. SapErrorMessage=SEGMENT_UNKNOWN. AdapterErrorMessage=Error returned by RfcCallReceiveEx while calling RFC: IDOCTYPE_READ_COMPLETE New!
- Well the only solution is to contact you SAP team and they must be sure that all segments of the IDOC that you are trying to import are released correctly.
- The adapter "WCF-SAP" raised an error message. Details "Microsoft.Adapters.SAP.RFCException: Details: ErrorCode=RFC_INVALID_HANDLE. AdapterErrorMessage=An exception has occurred on the listener while executing RfcWaitForRequest. New!
- This are generic error messages and does not provide what is really the problem. These warnings occurs, normally, when BizTalk is trying to connect to a SAP system to receive the IDOC and, again, most of the times these are related with connectivity issue or permissions between BizTalk and SAP.
- The adapter "WCF-SAP" raised an error message. Details "System.ServiceModel.CommunicationObjectFaultedException: The communication object, Microsoft.Adapters.Internal.LayeredChannelBindingElement.LayeredInboundChannel cannot be used for communication because it is in the Faulted state.
- The adapter "WCF-SAP" raised an error message. The communication object…. cannot be used for communication because it is in the Faulted state (Part II)
- This are generic error messages and does not provide what is really the problem. These warnings occurs, normally, when BizTalk is trying to connect to a SAP system to receive the IDOC and, again, most of the times these are related with connectivity issue or permissions between BizTalk and SAP.
- The adapter "WCF-SAP" raised an error message. Details "The WCF service host at address "sap://CLIENT=[SAPClientID];LANG=[LANG];@A/\[SAPServer]/[SystemID]?ListenerGwServ=[GWServer]&ListenerGwHost=[GwHost]&ListenerProgramId=[ProgID]&RfcSdkTrace=True&AbapDebug=False" has faulted and as a result no more messages can be received on the corresponding receive location. To fix the issue, BizTalk Server will automatically attempt to restart the service host. New!
- This are generic error messages and does not provide what is really the problem. These warnings occurs, normally, when BizTalk is trying to connect to a SAP system to receive the IDOC and, again, most of the times these are related with connectivity issue or permissions between BizTalk and SAP.
- The adapter "WCF-SAP" raised an error message. Details "System.ServiceModel.CommunicationObjectFaultedException: The communication object, Microsoft.Adapters.Internal.LayeredChannelBindingElement.LayeredInboundChannel cannot be used for communication because it is in the Faulted state.
- The adapter "WCF-SAP" raised an error message. The communication object…. cannot be used for communication because it is in the Faulted state (Part II)
- This are generic error messages and does not provide what is really the problem. These warnings occurs, normally, when BizTalk is trying to connect to a SAP system to receive the IDOC and, again, most of the times these are related with connectivity issue or permissions between BizTalk and SAP.
- The adapter "WCF-SAP" raised an error message. Details "System.ServiceModel.CommunicationObjectFaultedException: The communication object, Microsoft.Adapters.Internal.LayeredChannelBindingElement.LayeredInboundChannel`1[System.ServiceModel.Channels.IReplyChannel], cannot be used for communication because it is in the Faulted state. New!
- This are generic error messages and does not provide what is really the problem. These warnings occurs, normally, when BizTalk is trying to connect to a SAP system to receive the IDOC and, again, most of the times these are related with connectivity issue or permissions between BizTalk and SAP.
- The adapter "WCF-SAP" raised an error message. Details "System.ServiceModel.CommunicationObjectFaultedException: The communication object, Microsoft.Adapters.Internal.LayeredChannelBindingElement.LayeredInboundChannel cannot be used for communication because it is in the Faulted state.
- The adapter "WCF-SAP" raised an error message. The communication object…. cannot be used for communication because it is in the Faulted state (Part II)
- This are generic error messages and does not provide what is really the problem. These warnings occurs, normally, when BizTalk is trying to connect to a SAP system to receive the IDOC and, again, most of the times these are related with connectivity issue or permissions between BizTalk and SAP.
BizTalk WCF-Oracle Adapters
- The adapter failed to transmit message going to send port “SEND_Oracle” with URL “oracledb://connection”. It will be retransmitted after the retry interval specified for this Send Port. Details:”System.IO.FileNotFoundException: Could not load file or assembly ‘Oracle.DataAccess, Version=2.112.1.2, Culture=neutral, PublicKeyToken=89b483f429c47342′ or one of its dependencies. The system cannot find the file specified. New!
- When installing the Oracle WCF Adapter for BizTalk there is a design time requirement to use Oracle.DataAccess Version 2.111.7.0.
BizTalk WCF-SQL Adapter
- A message sent to adapter “WCF-Custom” on send port “WCF.Timeout_1.0.0.0_WCF.Timeout.ProcessDataToSQL_Dyn_WCFTest_c495b1996f35b303″ with URI “mssql://xxxx//Test?” is suspended. New!
- On a recent engagement, I was developing a BizTalk 2013 solution that received XML-based data from several sources and ultimately inserted rows into a SQL Server database using a stored procedure. An additional requirement was that the database connection had to be dynamic.
- “WcfSendPort_SqlAdapterBinding_TypedProcedures_dbo_Custom” with URL “mssql://server/database?”. It will be retransmitted after the retry interval specified for this Send Port. Details:”System.Data.SqlClient.SqlException (0x80131904): The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction. New!
- I discovered the issue had to do with transactions between BizTalk and SQL Server, and a TRY/CATCH block within the stored procedure. Apparently, they don’t work well together unless you also use an explicit BEGIN/COMMIT/ROLLBACK transaction within the stored procedure.
BizTalk 2006 Adapters Issues
The following are the known errors/issues associated to BizTalk 2006 Adapters:
- FTP: The receive location “ErrorMonitor Location” with URL “ftp://IP:21//OUT/log_err_*” is shutting down. Details:”The error threshold was exceeded.
- First you need to understand the behavior of the BizTalk 2006 (R2) FTP Adapter:
- The BizTalk Server 2006 FTP adapter uses the FTP client protocol to poll the designated FTP server and retrieves data from the server “as is.” The FTP adapter does not validate any data that it retrieves. The FTP adapter sends the retrieved document to the BizTalk Messaging Engine for processing and then it deletes the original document from the FTP server.
- Second you need to understand the configure variables for an FTP Receive Location, in particularly this:
- Error Threshold: Specify the number of errors that BizTalk Server can encounter before the location is disabled. (Default value: 10)
- Therefore the first thing I checked was the permissions of my user on the folder of the FTP that I’m monitoring… the result was that I had only read privileges and this is what was causing me the problem, because as I said earlier, the behavior of the adapter is: deletes the original document from the FTP server.
- First you need to understand the behavior of the BizTalk 2006 (R2) FTP Adapter:
- "The import failed because the import file is larger than the maximum size allowed on your server. Contact your system administrator".
- The fix is simple and requires a change to the Web.Config file of the Commerce Server Catalog Web Service.
- The Messaging Engine failed to register the adapter for “SOAP” for the receive location {Location}”. Please verify that the receive location exists, and that the isolated adapter runs under an account that has access to the BizTalk databases.
- As this is a permission issue the error occurs because the web service is running on the application pool which security account user is not a member of the BizTalk Isolated Host Users group.
- BizTalk Adapter v2.0 for mySAP Business Suite. Description: Error in Check Transaction: Failed to load the runtime. (Exception from HRESULT: 0×80131700).
- This issue occurs after installing .NET Framework 4.0. The registration of the assembly used by mySAP Business Suite does not specify the correct version of the .NET Framework. When .NET Framework 4.0 is installed, the assembly will try to use the newer framework and then raise this error.
- The Messaging Engine could not find the receive location for URI:"/XXX_VirtualDirectory/Service.asmx".\
Please verify the receive location exists and is enabled. New!- If your BizTalk solution is mainly relying on HTTP/SOAP adapter (we are still in BTS 2006 - no WCF yet), you'll soon see weird errors popping up due to BizTalk isolated host instances / IIS Application pool configuration. In order to resolve this problem, you need to setup the Isolated Host Instances and the application pools correctly. The rules are simple:
1- You must create at least one IIS application pool for each isolated host.
2- A separate IIS application pool is not required if all of your receive locations use the same adapter (HTTP or SOAP) and same ReceiveHandler (ex: BizTalkServerIsolatedHost)
3- A separate IIS application pool is required if the receive locations use different adapters (HTTP/SOAP) and they run under the same ReceiveHandler (ex: BizTalkServerIsolatedHost)
4 -A separate IIS application pool is required if the receive locations run under different ReceiveHandler (ex: BizTalkServerIsolatedHost, BizTalkServerIsolatedHost_2)
- If your BizTalk solution is mainly relying on HTTP/SOAP adapter (we are still in BTS 2006 - no WCF yet), you'll soon see weird errors popping up due to BizTalk isolated host instances / IIS Application pool configuration. In order to resolve this problem, you need to setup the Isolated Host Instances and the application pools correctly. The rules are simple:
- Creating an instance of the COM component with CLSID {C34AE9CE-8410-4191-8205-900E08603EC2} from the IClassFactory failed due to the following error: 800706b9."
At the same time on the MQ server we noticed the below error: A COM+ application hangs with an 'Access violation' in amqmtmgr.dll and a dump is produced showing:
amqmtmgr.dll!_FreeHConn() + 0xd5 bytes
amqmtmgr.dll!_tmzstMQDISC() + 0x17d bytes.. New!
BizTalk Runtime Issues
The following are the known errors/issues associated to BizTalk Runtime:
This remoting proxy has no channel sink which means either the server has no registered server channels that are listening, or this application has no suitable client channel to talk to the server. The instance may have been completed or terminated already.
- This error may occur because you may have referenced COM+ component inside your project:
An unhandled exception (‘<System.StackOverflowException>’) occurred in BTSNTSvc.exe [2756]. Just-In-Time debugging this exception failed with the following error: Debugger could not be started because no user is logged on.
- It’s very common to use .NET code for orchestration support. A StackOverflowException exception is thrown when the execution stack overflows by having too many nested method calls.
- Tip: Make sure you do not have an infinite loop or infinite recursion.
“MIME/SMIME encoder” Send Port: “…” URI: “…” Reason: Unable to initialize. Please ensure that exsmime.dll has been registered in the system.
- This is a strange behavior occurs in a custom pipeline that uses MIME/SMIME encoder.
There was a failure executing the send pipeline: “Microsoft.BizTalk.DefaultPipelines.XMLTransmit, Microsoft.BizTalk.DefaultPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35″ Source: “XML assembler” Send Port: “portname” URI: “uri” Reason: This Assembler cannot retrieve a document specification using this type: namespace#rootnode …
- The Application made reference to another Application that contained one schema with same namespace#rootnode name
- The Application as different resources (dll) that contained more than one schema with same namespace#rootnode name
- Schema defined by namespace#rootnode does not exist (not my case, because it was deployed)
The maximum number of convoy set properties has been exceeded. A convoy set can only contain up to 3 properties.
- Now, you may very well ask, what is a convoy set? And yes, it is a bit confusing that the error message uses a term that is actually internal to BizTalk and not something your average BizTalk developer cares about. But a convoy set is simply a correlation set that is used in a convoy.
Inner exception: Received unexpected message type does not match expected type http://Namespace#RootNode. Exception type: UnexpectedMessageTypeException
The published message could not be routed because no subscribers were found.
- You can get this error if the subscription has not been created or context properties don’t match the subscription.
Arithmetic overflow error converting expression to data type int.[SQLSTATE 22003] (Error 8115) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.
- This issue is due to threshold of Sendhost has crossed the Int value. If I quickly check at the threshold of the SendHost I could find that it already reached Int value. If you look at the Store procedures which has supported for the above job, It cleared said the data type used for nID as INT in stored procedure. But actually in table it declared as BigInt..
Retrieving the COM class factory for component with CLSID {254B4003-2AA7-4C82-BB2E-18BA7F22DCD2} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).
- When you use BizTalk in 64 bit version, and the Mime/Smime encoder you’ve got this error. To resolve it, just put your pipeline on a 32 bit Host.
Receive pipeline rejected incoming message due to the following RNIF exception: UNP.SCON.VALERR : A failure occurred while validating the service content.
- It turns out that the RNDisassembler does in-fact attempt to validate the message contained within the Service Content against a deployed schema just like the standard XmlDisassembler. The message that our trading partner was sending did not validate and hence the RosettaNet Accelerator threw this error message; once we had corrected the schema and redeployed, the error went away.
Could not load file or assembly ‘file://Microsoft.Solutions.BTAHL7.HL72fDasm.dll’ or one of its dependencies. An attempt was made to load a program with an incorrect format.
- Make sure that your host is running under 32bit mode, if it is running in 64 bit mode, you will get this error.
Exhausted the network retry attempts. Error code 5649.
- This error occurs when you have to many connections towards one location that exceeds the limit of allowed connections.
“Cannot open database ‘…’ requested by the login. The login failed” or “The EXECUTE permission was denied on the object ‘…’, database ‘…’, schema ‘dbo’”.
- This problem occurs because the user account that you used to access database or that tries to execute stored procedure does not have sufficient permissions.
“The Messaging Engine failed to add a receive location "..." with URL "sap://CLIENT=010;LANG=EN;@a/SAPSERVER/00?..." to the adapter "WCF-SAP". Reason: "Microsoft.Adapters.SAP.RFCException: Details: ErrorCode=RFC_OK. ErrorGroup=RFC_ERROR_SYSTEM_FAILURE. SapErrorMessage=Open file 'C:\SAPINI\saprfc.ini' failed: 'No such file or directory'. AdapterErrorMessage=Error accepting incoming connection. RfcAccept returned RFC_HANDLE_NULL.”
- The RFC library will read the saprfc.ini file to find out the connection type and all RFC-specific parameters needed to connect to an SAP system, or to register an RFC server program at an SAP gateway and wait for RFC calls from any SAP system.
xlang/s engine event log entry: Uncaught exception (see the ‘inner exception’ below) has suspended an instance of service
Exception type: TypeInitializationException
The following is a stack trace that identifies the location where the exception occurred
Loading this assembly would produce a different grant set from other instances. (Exception from HRESULT: 0×80131401)- After some research I found out that the Loading this assembly would produce a different grant set from other instances part normally represents a failure with 32bit vs 64bit. I then checked the host-instance, and to my surprise the default value for the host-instance was 32bit only, even though the server was 64bit. So I created a new host-instance that was 64bit, changed the orchestration to use this host instance, and with that the issue was resolved.
There was a failure executing the receive pipeline: "Microsoft.BizTalk.Edi.DefaultPipelines.EdiReceive, Microsoft.BizTalk.Edi.EdiPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken1bf3856ad364e35" Source: "EDI disassembler" Receive Port: "..." URI: "...\.*" Reason: No Disassemble stage components can recognize the data.
- This error occurs because the message does not contain the EDIFACT interchange envelope segments (UNB and UNZ). An EDIFACT interchange begins with a UNB. It contains version release information, syntax information, and partner information. An interchange ends with a UNZ.
A failure occurred when executing a Windows service request. Service request: Start. BizTalk host name: BizTalkProcess. Windows service name: BTSSvs$BizTalkProcess.
- We sometimes need to make small changes in BizTalk configuration files (BTSNTSvc.exe.config). Check out the configuration file and ensure there are no wrong custom entries.
The message found multiple request response subscriptions. A message can only be routed to a single request response subscription.
- When trying to send a message to multiple request response ports you can receive this type of error.
- BizTalk error: ‘The message found multiple request response subscriptions’
- http://support.microsoft.com/kb/923632
- When trying to send a message to multiple request response ports you can receive this type of error.
BizTalk Host Instance stuck in ����Stop pending” state when trying to restart the instance
- When trying to restart BizTalk Host Instance one of the host instances got stuck in “Stop pending” state
Inner exception: There was a failure executing pipeline "ODH.BTBiDirectional.Orchestrations.HL7TargetRSPSendPipeline". Error details: "Body schema is missing".
- The reason we get the above error is due to the fact that message type property for multi-part message is not available in the context of the message. To overcome this problem you also need to copy the context value from incoming message to multi-part message in the assignment shape while creating the multi-part message.
"A response message sent to adapter "SOAP" on receive port "ReceiveCreateUserProfile" with URI "/WebServicePort.asmx" is suspended. Error details: Safe handle has been closed”.
- The issue was with the BackupBizTalkServer job not being configured and enabled. In another case there were issues with the DTAPurgeAndArchive job where the tracking spool table was very heavy.
Could not find a matching subscription for the message. This error occurs if the subscribed orchestration schedule or send port has not been started, or if some of the message properties necessary for subscription evaluation have not been promoted. Please refer to Health and Activity Tracking tool for more detailed information on this failure.
- It means the message was recognized by BizTalk, because BizTalk knows of its type. But there is no one subscription to this message.
WCF Send Port: System.InvalidOperationException: There were not enough free threads in the ThreadPool to complete the operation.
**The Messaging Engine encountered an error during the processing of one or more inbound messages **
- Several causes:
- Disposing the memory stream for creating a message inside a custom pipeline component
- Trying to write to the context of the incoming message in a pipeline
- Several causes:
"An instance of the FreeThreadedDOMDocument class cannot be created"
"Failed to create a CLSID_BizTalkPropertyBagFactory".- The solution is simple: Restart the Windows WMI Service.
- A batch item failed persistence Item-ID c715fbf1-6eed-4781-8061-85b4088b0efb OperationType MAIO_CommitBatch Status -1061151998 ErrorInfo. The published message could not be routed because no subscribers were found.
- Several causes:
- Double subscriptions: http://geekswithblogs.net/VishnuTiwariBlog/archive/2009/12/07/exception-occurred-when-persisting-state-to-the-database.aspx
- Send Ports without filter: http://bencops.blogspot.nl/2006/02/persistence-exception-routing-failure.html
- Several causes:
- Application: BTSNTSvc64.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an internal error in the .NET Runtime at IP 000007FDED170BC1 (000007FDECE00000) with exit code 80131544.- Periodically, your BizTalk host process crashes with the following errors in the eventlogs. Note the error code is 80131544. There is a change in the .NET 4.5 CLR that results in the BizTalk process crashing during XLANG AppDomain shutdown. XLANG AppDomain Shutdown is when the .NET AppDomain that contains the Orchestration Engine tears itself down during periods of inactivity or idleness.
- Faulting application name: BTSNTSvc64.exe, version: 3.10.229.0, time stamp: 0x50fe567a
Faulting module name: clr.dll, version: 4.0.30319.19106, time stamp: 0x51a512d4
Exception code: 0x80131544
Fault offset: 0x0000000000370bc1
Faulting process id: 0xca8
Faulting application start time: 0x01ceb6394f1dd32a
Faulting application path: C:\Program Files (x86)\Microsoft BizTalk Server 2013\BTSNTSvc64.exe
Faulting module path: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clr.dll- Periodically, your BizTalk host process crashes with the following errors in the eventlogs. Note the error code is 80131544. There is a change in the .NET 4.5 CLR that results in the BizTalk process crashing during XLANG AppDomain shutdown. XLANG AppDomain Shutdown is when the .NET AppDomain that contains the Orchestration Engine tears itself down during periods of inactivity or idleness.
- The BizTalk Service BizTalk Group : BTSOrchHost service terminated unexpectedly. It has done this 2 time(s). The following corrective action will be taken in 60000 milliseconds: Restart the service.
- Periodically, your BizTalk host process crashes with the following errors in the eventlogs. Note the error code is 80131544. There is a change in the .NET 4.5 CLR that results in the BizTalk process crashing during XLANG AppDomain shutdown. XLANG AppDomain Shutdown is when the .NET AppDomain that contains the Orchestration Engine tears itself down during periods of inactivity or idleness.
- There was a failure executing the receive pipeline: “Microsoft.BizTalk.DefaultPipelines.XMLReceive, Microsoft.BizTalk.DefaultPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35″ Source: “XML disassembler” Receive Port: “XmlValidationReceivePort” URI: “C:\Folder\.xml” Reason: The document failed to validate because of the following error:”The ‘http://XmlValidationTest.CommonNamespace:Schema1′ element is not declared.”.
- To avoid having to add a new custom pipeline to the solution, even one as simple as containing a standard XmlValidator component. So instead, I opted to use port-based configuration by enabling validation within the XmlDissembler component in the existing XmlReceive pipeline. Of course, this does require specifying the list of specific schemas in the DocumentSpecNames property on the port instance.
- Could not load file or assembly 'Microsoft.BizTalk.Interop.SSOClient, Version=7.0.2300.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.
- I switched the application pool to Integrated and targeted the v4.0 Framework. This cleared the initial error, but then I was receiving a new error from IIS that the svc handler was not correctly mapped. I then realized that I needed to run the "aspnet_regiis.exe -I" command against the correct version of aspnet_regiis (the v4.0 framework version). Once I had done this, the service page loaded correctly and all was well again.
- “An error occurred while attempting to install the BizTalk application: World Wide Web service (W3SVC) on host “localhost” not available.
The following Windows component may not be installed: Application Server -> Internet Information Services (IIS) -> Common Files.
Unknown error (0×80005000)
Unknown error (0×80005000)”- The problem this time was that IIS 6 Management Compatibility role services was not installed.The Deployment Framework for BizTalk includes support for deploying application pools and virtual directories in IIS. Virtual directory and application pool deployment is fully active for server deployments.
Due to IIS 7.0/7.5 includes significant change on the configuration system, on Windows Server 2008 and above, we need to enable IIS 6 Management Compatibility role services: IIS Metabase and IIS 6 configuration compatibility, IIS 6 WMI Compatibility and IIS 6 Scripting Tools to allow System.DirectoryServices code work on modifying IIS configurations on IIS7.x.
- The problem this time was that IIS 6 Management Compatibility role services was not installed.The Deployment Framework for BizTalk includes support for deploying application pools and virtual directories in IIS. Virtual directory and application pool deployment is fully active for server deployments.
- BizTalk Server Administration Console fails to launch:
NullReferenceException
at Microsoft.BizTalk.ExceptionMessageBox.BtsExceptionMessageBox.ReprocessManagementException(Exception exception, Exception newInnerException)
at Microsoft.BizTalk.ExceptionMessageBox.BtsExceptionMessageBox.ReprocessSpecificExceptions(Exception exception, Exception newInnerException)
at Microsoft.BizTalk.ExceptionMessageBox.BtsExceptionMessageBox.ReprocessExceptionRecursive(Exception exception)
at Microsoft.BizTalk.ExceptionMessageBox.BtsExceptionMessageBox.set_Message(Exception value)
at Microsoft.BizTalk.ExceptionMessageBox.BtsExceptionMessageBox..ctor(Exception exception, ExceptionMessageBoxButtons buttons, ExceptionMessageBoxSymbol symbol)
at Microsoft.BizTalk.SnapIn.Framework.FrameworkNotification.Show(Exception exception, String caption, MessageBoxButtons buttons, MessageBoxIcon icon, Control staMarshaller, IWin32Window parent)
at Microsoft.BizTalk.SnapIn.Framework.FrameworkNotification.ShowError(Exception exception, Control staMarshaller, IWin32Window parent)
at Microsoft.BizTalk.SnapIn.Framework.FrameworkNotification.ShowError(Exception exception)
at Microsoft.BizTalk.Administration.SnapIn.GroupNode.FullRefresh(Object o, ResultsChangedEventArgs e)
at Microsoft.BizTalk.Administration.SnapIn.GroupNode.OnExpand(AsyncStatus status)
at Microsoft.ManagementConsole.NodeSyncManager.ProcessRequest(NodeRequestInfo info, IRequestStatus requestStatus)
at Microsoft.ManagementConsole.NamespaceSnapInBase.ProcessRequest(Request request)
at Microsoft.ManagementConsole.SnapIn.ProcessRequest(Request request)
at Microsoft.ManagementConsole.Internal.SnapInClient.Microsoft.ManagementConsole.Internal.IMessageClient.ProcessRequest(Request request)
at Microsoft.ManagementConsole.Internal.IMessageClient.ProcessRequest(Request request)
at Microsoft.ManagementConsole.Executive.RequestStatus.BeginRequest(IMessageClient messageClient, RequestInfo requestInfo)
at Microsoft.ManagementConsole.Executive.SnapInRequestOperation.ProcessRequest()
at Microsoft.ManagementConsole.Executive.Operation.OnThreadTransfer(SimpleOperationCallback callback)- On doing some further research, we found that the error was occurring because the WMI Namespace was not valid:
Inner Error = Invalid namespace at Microsoft.BizTalk.SnapIn.Framework.WmiProvider.get_ServerScope() .
- On doing some further research, we found that the error was occurring because the WMI Namespace was not valid:
- There was a failure executing the response(send) pipeline: "xxx" Source: "Unknown " Receive Port: "yyy.TwoWay" URI: "/path/BTSHTTPReceive.dll?Receive" Reason: Failed to get pipeline: Namesapce.Pipelines.CPipeline,Namespace.Pipelines, Version=1.0.0.0, Culture=neutral, PublicKeyToken=edf16f912420a3a8. Please verify that the pipeline strong name is correct and that the pipeline assembly is in the GAC. New!
- All of the errors were occurring under the Isolated Adapter, as this was a http receive port. This runs under the isolated host. What is the Isolated host? And how can I restart this? It says not applicable in BizTalk Admin. Well it’s any out of process host, for the HTTP receive, and most of these, its isolated host, is…. IIS.
Doing an IISReset, is just like restarting that isolated host. It flushed the old assemblies from memory, and caused it to reload all assemblies fresh from the GAC.
- All of the errors were occurring under the Isolated Adapter, as this was a http receive port. This runs under the isolated host. What is the Isolated host? And how can I restart this? It says not applicable in BizTalk Admin. Well it’s any out of process host, for the HTTP receive, and most of these, its isolated host, is…. IIS.
- "Unable to create binding configuration element for editing. Check the values of the bindyingType and BindingConfiguration properties. (Microsoft.BizTalk.Adapter.Wcf.Converters.CreateBindingException) Unable to get binding type for binding extension “sqlBinding”. Verify the binding extension is registered in the machine.config.”. New!
- The SQL Database adapter (also the Oracle Adapter or the Oracle E-Business Suite) is a WCF custom binding, which is registered under System.ServiceModel in the machine.config file.
- An output message of the component "Unknown " in receive pipeline "Microsoft.BizTalk.Edi.DefaultPipelines.EdiReceive, Microsoft.BizTalk.Edi.EdiPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" is suspended due to the following error:
Error: 1 (Miscellaneous error)
16: Invalid Control Standard Identifier
Error: 2 (Field level error)
SegmentID: ISA
Position in TS: 1
Data Element ID: ISA11
Position in Segment: 11
Data Value: {
7: Invalid code value.
The sequence number of the suspended message is 1.
An output message of the component "Unknown " in receive pipeline "Microsoft.BizTalk.Edi.DefaultPipelines.EdiReceive, Microsoft.BizTalk.Edi.EdiPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" is suspended due to the following error: Error: 1 (Miscellaneous error) 16: Invalid Control Standard Identifier
Error: 2 (Field level error) SegmentID: ISA Position in TS: 1 Data. New!
BizTalk SQL Agent Jobs Issues
- Backup BizTalk Server job failed: The last step to run was step 2 (BackupFull). The job was requested to start at step 1 (Set Compression Option)
- Unfortunately this error can happen for several reasons and we need to check what the best option for us is. However sometimes solutions are simpler than it seems. If you check the parameters of the BackupFull step you will see that the third parameter is the location of backup files and this location must exist in the file system.
- Backup BizTalk Server job failed: The job failed. The Job was invoked by Schedule 9 (MarkAndBackupLogSched). The last step to run was step 2 (BackupFull)
- All the parameter of the sp_BackupAllFull_Schedule must be placed between single quotation marks. You must ensure that all the parameters of the sp_BackupAllFull_Schedule is between single quotation marks.
- Backup BizTalk Server job failed: The job failed. The Job was invoked by User domain\user. The last step to run was step 3 (MarkAndBackupLog). The job was requested to start at step 1 (Set Compression Option)
- The MarkAndBackupLog step is responsible for marking the logs for backup, and then backing them up and all the mandatory parameters (MarkName and BackupPath) must be placed between single quotation marks. So you need to ensure that all the parameters of the sp_MarkAll is between single quotation marks.
- The "Backup BizTalk Server" job fails when backup files accumulate over time in the Microsoft BizTalk Server database server
- This issue occurs because the SQL Server Agent job that is named "Backup BizTalk Server" does not provide functionality for deleting backup files that have accumulated over time.
- BUG: The "Backup BizTalk Server" SQL job fails with an error because the adm_OtherBackupDatabases table is not created
- The Backup BizTalk Server SQL job fails if you elect not to install all the following components when you install BizTalk Server 2004: Engine\Human Workflow Services Runtime Component, Engine\Base EDI Adapter, Rules Engine, Administration Tools\Human Workflow Service Administration Tools, Information Worker Applications/Portal\Business Activity Services, Information Worker Applications/Portal\Human Workflow Web Services
- Could not relay results of procedure 'sp_BackupBizTalkFull' from remote server ‘Server Name’.
[OLE/DB provider returned message: Timeout expired]- I realized that backing up the databases from the other SQL instance was taking more than 10 mins to finish. And as we all might be aware of the fact that the other SQL instance would allow remote queries for 10 mins only. So even before my remote query can complete, other SQL instance was stopping this query and throwing the above error message. To avoid this situation, I changed the remote query timeout value on the other SQL instance and allowed it to execute remote queries without the time limit.
- Microsoft.BizTalk.Bam.Management.BamManagerException: Encountered error while executing command on SQL Server "servername". —> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object ‘bam_Metadata_GetProperty’, database ‘BAMPrimaryImport’, schema ‘dbo’ New!
- These problem occurs because the BizTalk Server Configuration Tool didn’t properly configure the right permissions in this stored procedure.
- Operations_OperateOnInstances_OnMaster_BizTalkMsgBoxDb fail with the following error:
The name 'ServerName,portNumber.BizTalkMsgBoxDb.dbo.ops_OperateOnInstanceOnMasterMsgBox ' is not a valid identifier. [SQLSTATE 42000] (Error 203). The step failed. New!- After doing some troubleshooting using SQL Profiler, we saw that following command was getting executed at the SQL Server Side: Exec 'ServerName.ABC.com,portNumber.BizTalkMsgBoxDb.dbo.ops_OperateOnInstanceOnMasterMsgBox 3 ID {ID }
On doing some further research, we came to know the issue was with using Fully Qualified Domain Name during the configuration of the Job..
- After doing some troubleshooting using SQL Profiler, we saw that following command was getting executed at the SQL Server Side: Exec 'ServerName.ABC.com,portNumber.BizTalkMsgBoxDb.dbo.ops_OperateOnInstanceOnMasterMsgBox 3 ID {ID }
Read suggested related TechNet Wiki topics:
Business Activity Monitoring (BAM) Issues
The following are the known errors/issues associated with Business Activity Monitoring (BAM):
The BAM Star Schema database has not been configured. Run bm.exe setup-databases to configure the database.
- One of the possible causes of the problem is that Analysis Services form BAM aggregations was not configured.
Using ‘BAMPrimaryImport’ BAM Primary Import database on server ‘…’… ERROR: Failed to open BAM Excel workbook file – ‘C:\Program Files\Microsoft BizTalk Server 2009\Tracking\MyBAMSample.xls’. Old format or invalid type library. (Exception from HRESULT: 0×80028018 (TYPE_E_INVDATAREAD))
- When you use a locale setting other than English (United States) while installing the English version of BizTalk Server, your deployment of the Bam.xls file generates an "fnGetString" or "Old format or invalid type library" error.
Scheduling BAM Packages: "Set global connection string variables. Object reference not set to an instance of an object.(0×00000000)".
- This error was due to the user under which the SQL Server Agent Service runs not having enough permissions on SQL Server.
BAM Portal: HTTP Error 503 - The Service is unavailable
- From time to time I get the 'HTTP Error 503 - The Service is unavailable' when I try to access my BAM portal. Usually I spend a few minutes before I remember how to get past this. It is the account configured to run bam that needs to have its password updated. Most of you should change your password on a regular basis, and its easy to forget to reconfigure BAM with the new password.
BAM Portal: The Server encountered a critical failure while trying to access the list of Views. The Business Management Web Service requires attention. Use the navigation bar on the left to access Business Activity Monitoring views. If the problem persists, contact your System Administrator.
Error 5009 Registration of BAM performance counters failed
- After a small amount of investigation it turn out to be a known issue where the performance counter registry has been damaged. To fix this problem open a command prompt as administrator and run: lodctr /r
BAM Portal: An unspecified error has occured. Use the navigation bar on the left to access Business Activity Monitoring views. If the problem persist, contact you System Administrator.
- This issue may occur if the user account which was granted permission to BAM objects are deleted from Active Directory or from Local Computers.
BAM Portal: Microsoft.BizTalk.Bam.Management.BamManagerException: Failed to list permissions for BAM view. —> System.Data.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.
- This issue may occur if the user account which was granted permission to BAM objects are deleted from Active Directory or from Local Computers.
BAM Portal: (BAMPortal.PortalApplication) Void LogAllErrors(System.Exception[]): System.Web.HttpException: Error executing child request for /BAM/Pages/Search.aspx.**
- This issue may occur if the user account which was granted permission to BAM objects are deleted from Active Directory or from Local Computers.
BM.exe: ERROR: Failed to list permissions for BAM view. Data is Null. This method or property cannot be called on Null values.
- This issue may occur if the user account which was granted permission to BAM objects are deleted from Active Directory or from Local Computers.
BM.exe: ERROR: Security management of the BAM view failed. Failed to grant OLAP permission to account domain\user. A connection cannot be made. Ensure that the server is running. No connection could be made because the target machine actively refused it ip:port.
- This error may occur when you try to add one account using BM command: "bm.exe add-account -AccountName:domain\user -View:MyView" - This issue may occur if the user account which was granted permission to BAM objects was deleted from Active Directory or from Local Computers.
BM.exe: ERROR: Security management of the BAM view failed. The specified account is the Database Owner. The Database Owner always has access to the view and cannot be added to or removed from the view.
- This error may occur when you try to add or remove one account using BM command: "bm.exe add-account -AccountName:domain\user -View:MyView" - As the error indicates, the user in question is database owner and therefore cannot be added to or removed from the view.
BAM Add-In Excel Issue : Unspecified Automation Error.
- This error can occur when Opening Excel using BAM Addin..
BAM Add-In Excel Issue : Object library invalid or contains references to object definitions that could not be found.
- To resolve the problem, delete cached versions of the control type libraries. To do this, search the hard disk for “.exd,” and then delete all occurrences. The .exd files are re-created automatically by using the new controls the next time that you use VBA.
Bm.exe is not a valid Win32 App.
- By looked at bm.exe and found the file size was 0, it seems got corrupted somehow . By replacing it with a new bm.exe solved the problem.
BAM Portal Activity Search: "This action cannot be performed because one or more database(s) appears corrupted"
- This error message means that there are instances with duplicate ID in the activity you were searching. If you look at the "Application" event log on the computer which runs the BAM Web Services, you will find one entry from "BAM Web Service" comparable to the following: EXCEPTION:System.Web.Services.Protocols.SoapException: There are instances with duplicate ID 'PO_COMPLETED_100' in activity 'PurchaseOrder'. The duplicates must be removed from the database to fix this problem.
BizTalk BAM Portal URL authorization failed for the request (Event code 4007).
- After a few minutes I remembered the basics… if you remember the BizTalk Configuration experience, you use the BizTalk Server configuration tool to specify whether BAM is enabled, and to specify the Web service accounts, the Windows groups that can view portal, and the Web site that will host the portal. To solve this problem you have to configure the users or groups that you want to have access to BAM Portal under the “BizTalk BAM Portal Users” in your Active Directory.
Troubleshooting BAM.
- ERROR: BAM deployment failed. A connection cannot be made. Ensure that the server is running. No connection could be made because the target machine actively refused it <IP address>.
- When you try to refresh the data in a live data workbook, Microsoft Office Excel might display the following error: XML for Analysis parser: The CurrentCatalog XML/A property was not specified.
- Error:"Object library invalid or contains references to object definitions that could not be found" with BAM Excel Add-In in Office 2010.
- BAM portal cannot connect
- BAM portal does not work if invalid users are granted permissions
- Cannot export or import a BAM definition to localhost: The system cannot find the path specified.
- This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.
- Failed to get data. If available, errors returned from the provider are listed below: * The following system error occurred: No connection could be made because the target machine actively refused it.
- Failed to get data. If available, errors returned from the provider are listed below: * Safety settings on this machine prohibit accessing a data source on another domain.
BAM Portal Display Problems
- If you are facing some BAM Portal display problems you may consider to enable Background Intelligent Transfer Service (BITS) IIS Server Extension.
Failed to get data. If available, errors returned from the provider are listed below
- Sometimes a website you���re visiting, in this case BAM Portal, doesn’t look like you expect it to. Images might not show up, menus might be out of place, and text boxes could be jumbled together. This can be caused by a compatibility problem between Internet Explorer and the site you’re on. When a site is incompatible with Internet Explorer, you’ll see the Compatibility View button in the Address bar.
The cube “...” was not processed. Please run the cube DTS to process the cube
- This error most likely when the machine account that runs the job doesn’t have permission to query the AD.
Deploying View... ERROR: The BAM deployment failed. Encountered error while executing command on SQL Server "MyMachineName". String or binary data would be truncated. The statement has been terminated.
Microsoft.BizTalk.Bam.Management.BamManagerException: Encountered error while executing command on SQL Server "SERVER_NAME". ---> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'bam_Metadata_GetConfigurationXml', database 'BAMPrimaryImport', schema 'dbo'.
- We found that only one role had execute rights: BAM_Management_WS and the BAM Portal App Pool was running under our BizTalk server account which was the only member of the role. We solved the problem by simply adding BizTalk Server Application Users group to the membership for the BAM_Management_WS role.
Execute batch error. Exception information: TDDS failed to batch execution of streams. SQLServer: ServerName, Database: BAMPrimaryImport. Parameter is not valid.
TDDS failed to execute event. Could not find stored procedure “dbo.bam_ActivityName_PrimaryImport'.- This stored procedure gets created when you deploy a BAM definition files for a BAM activity. There are a lot of artifacts (SPs,Tables) gets created along with this corresponding to the BAM definition we deploy. I went to the BAMPrimaryImport database and noticed that all the artifacts (Tables + SPs) related to this activity were not in place. This means that the BAM definition file for the activity was removed by me using the “BM remove-all -DefinitionFile:EAI_BAM_definition.xml”” command. But I did not remove the corresponding tracking profile from the tracking Profile Editor.
So although I did not have any BAM definition file deployed for an activity, the tracking profile was still tracking the data. Now as the artifacts related to BAM activity were missing from database, TDDS was not able to move data out of BizTalkMsgBoxDb.
- This stored procedure gets created when you deploy a BAM definition files for a BAM activity. There are a lot of artifacts (SPs,Tables) gets created along with this corresponding to the BAM definition we deploy. I went to the BAMPrimaryImport database and noticed that all the artifacts (Tables + SPs) related to this activity were not in place. This means that the BAM definition file for the activity was removed by me using the “BM remove-all -DefinitionFile:EAI_BAM_definition.xml”” command. But I did not remove the corresponding tracking profile from the tracking Profile Editor.
Event Source: BAM EventBus Service
Either another TDDS is processing the same data or there is an orphaned session in SQL server holding TDDS lock.Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. SQLServer: MyServer\Instance, Database: BizTalkDTADb.- So, the first thing to check here would be to look up all the SPIDs on SQL Server, and find if any of the BizTalk SPIDs are blocked (look in the ‘BlkBy’ column). You can run this on the ‘master’ database to get this information – sp_who2.
Exception object: 02d61034
Exception type: Microsoft.BizTalk.Bam.CfgExtHelper.BAMConfigurationException
Message: Error executing process: C:\Program Files (x86)\Microsoft BizTalk Server 2013\Tracking\bm.exe
InnerException: Microsoft.BizTalk.Bam.CfgExtHelper.BAMConfigurationException, Use !PrintException 02d60dc4 to see more.
Exception type: Microsoft.BizTalk.Bam.CfgExtHelper.BAMConfigurationException
Message: Microsoft (R) Business Activity Monitoring Utility Version 3.10.229.0
ERROR: Failed to set up BAM database(s).
The alert infrastructure was not created.
Cannot start service BAMAlerts on computer '.'.
The service did not respond to the start or control request in a timely fashion New!- When installing BAM Alerts on BizTalk 2013, we encountered an error; it was preventing us from moving ahead with our plans for BAM. The root problem was the BAM alerts service was being created, but failing to start in the allocated timeout, and thus it failed. The solution, as simple as it is now… was to implement a setting in the bamalerts service that would tell it to bypass the checking of the security.
This is a known issue, and there are some fixes out there for this, but it will also prevent other windows services from starting, not just BAMAlerts
- When installing BAM Alerts on BizTalk 2013, we encountered an error; it was preventing us from moving ahead with our plans for BAM. The root problem was the BAM alerts service was being created, but failing to start in the allocated timeout, and thus it failed. The solution, as simple as it is now… was to implement a setting in the bamalerts service that would tell it to bypass the checking of the security.
ERROR: Failed to set up BAM database(s). The specified account is already in the view. New!
- This error occur when installing BAM Alerts. Solution is simple enough: Remove the BAMAlerts Database and try again.
Error:
Faulting application name: BTSNTSvc64.exe, version: 3.9.469.0, time stamp: 0x4c548eb4
Faulting module name: clr.dll, version: 4.6.1055.0, time stamp: 0x563c12de
Exception code: 0xc00000fd
Fault offset: 0x000000000001a3a5
Faulting process id: 0x9cc
Faulting application start time: 0x01d1e7fd298a2c52
Faulting application path: C:\Program Files (x86)\Microsoft BizTalk Server 2010\BTSNTSvc64.exe
Faulting module path: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clr.dll
Report Id: 452fc95b-53f7-11e6-827d-d85de2912cce
Faulting package full name:
Faulting package-relative application ID
Analysisi of Scenario Which Results in TDDS Crash
List of Known Issues and Solutions with Setup and Configuration
BizTalk Server 2013 – List of Known Issues and Solutions with Setup and Configuration
The following are the known errors/issues associated to BizTalk Setup and Configuration:
- BizTalk Server 2013 BETA – Window 8 Configuration issues
- In Windows 8 for a better user experience it’s very important to use a Live ID, to keep everything in sync between your devices. For some reason BizTalk Server 2013 configuration is not happy (or may be product team haven’t tested this configuration in this BETA) with this setup.
- Error encountered: Missing file ‘MSVCP100.dll’ while installing BizTalk Server 2013 RTM
- Resolution: Download and install Microsoft Visual C++ 2010 Redistributable Package (both x64 as x86)
- Error encountered: Could not install BAM Tools while installing BizTalk Server 2013 RTM
- Resolution: install SQL Server 2005 Notification Services and set up database to use database-mail
- Error encountered while configuring BAM Portal in BizTalk Server 2013 RTM
**Error encountered: Could not install BAM Portal -> error with regards to “BAM Management Web Service User”
Error thrown: “Attempted to read or write protected memory. This is often an indication that other memory is corrupt.”
Actual exception: Log indicated ‘Cannot alter the role ‘NSSubscriberAdmin’, because it does not exist or you do not have permission.’ New!
**- Resolution: Manually Add NSSubscriberAdmin DatabaseRole to BAM Alert Application Database
- Missing itinerary designer after installing BizTalk 2013
- During the BizTalk 2013 beta the itinerary designer was distributed as a VSIX package. However, in the RTM version it is no longer there. I went into the registry and saw there were entries for the designer, implying it was installed, yet it was not in Visual Studio. Go to a Visual Studio command prompt, and run “devenv.exe /setup”. This “Forces Visual Studio to merge the resource metadata that describes menus, toolbars, and command groups, from all available VSPackages
- "The program can’t start because MSVCP100.dll is missing from your computer. Try reinstalling the program to fix the problem", following by "The following platform components failed to install and will need to be manually installed before setup can proceed: Enterprise Single Sign-On Server. Unspecified error."
- This error occurred while installing an BizTalk Server 2013 on Windows Server 2012 VM’. The error is saying it is missing the C++ Runtime components (probably why I did not see this error when I already had Visual Studios installed). After trial and error, it seems that it is only missing the 32-bit C++ Runtime. It seems that this does not get installed with the BizTalk CAB file
- "Internal Error 2761"
- If you are installing BizTalk 2013 and get this error
- Just check you remembered to right click and Run As Administrator on the BizTalk setup.exe: BizTalk 2013 Installation - Internal Error 2761
- Or the cause was that you didn't activated MS Office 2013: Another cause of Internal Error 2761 - BizTalk 2013
- If you are installing BizTalk 2013 and get this error
- BAM Portal configuration: "Attempted to read or write protected memory"
- For some reason db role were not created properly so you need to create the db role “NSSubscriberAdmin” manually on the BAMAlertsApplication database. After doing this the BAM Portal will configure correctly without error.
- "Microsoft SQL Server Data Transformation Services (DTS) 2012 with SP1 or higer for BAM Archiving is not installed on the local machine. Please install Microsoft SQL Server Integration Services. (Sql2012)"
- When installing a distributed BizTalk environment with BizTalk and SQL on seperate boxes he sure to install the SQL Server Client Components->Management Tools on you BizTalk Server.
- "Missing MSVCP100.dll"
- Download and install the Microsoft Visual C++ 2010 Redistributable Package.
- A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (.Net SqlClient Data Provider)
- While installing and configuring BizTalk Server 2013 in amulti-server configuration (separate BizTalk application and BizTalk SQL servers). Microsoft has released a hot fix for this issue: FIX: BAM tools cannot be configured in a multi-node BizTalk Server 2013 environment.
- Could not relay results of procedure 'sp_BackupBizTalkFull' from remote server ‘Server Name’.
[OLE/DB provider returned message: Timeout expired] New!- I realized that backing up the databases from the other SQL instance was taking more than 10 mins to finish. And as we all might be aware of the fact that the other SQL instance would allow remote queries for 10 mins only. So even before my remote query can complete, other SQL instance was stopping this query and throwing the above error message. To avoid this situation, I changed the remote query timeout value on the other SQL instance and allowed it to execute remote queries without the time limit.
- BizTalk ENTSSO Service Fails to start (Windows Server 2003):
**- RPC failure. Please check your network configuration. Error Code: 0x80070057, The parameter is incorrect.- String message: RPC raised an exception with a return code RPC_S_INVALIDA_ARG.
- The MS DTC Connection Manager is unable to register with RPC to use TCP/IP or UDP/IP. Please ensure that RPC is configured properly.
Error Specifics:D:\nt\com\complus\dtc\dtc\cm\src\iomgrsrv.cpp:2220, Pid: 1116
No Callstack, CmdLine: C:\WINDOWS\system32\msdtc.exe New!** - This looked to be a RPC related error. The error talked about allocating Ports for RPC communication. We opened up the registry and went to the hive which is responsible to specify this port allocation. HKEY_LOCAL_MACHINE\Software\Microsoft\Rpc\Internet\
- ERROR: The BAM deployment failed. The alerts were not deployed. There was a failure while executing nscontrol.exe.
Error:"Microsoft Notification Services Control Utility 9.0.242.0c Microsoft Corp. All rights reserved.
Notification Services failed to get the metadata for the specified instance. Instance Name: BAMAlerts
SqlServerError: Source: .Net SqlClient Data Provider
Message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
(Microsoft.BizTalk.Configuration.EDIAS2.Utility) New! - Source: ENTSSO
Failed to retrieve master secrets. Verify that the master secret server name is correct and that it is available.
Error Code: 0x80002918, No secrets were found in the registry of the master secret server. Use the configuration tools to generate or restore a master secret.
And: ERROR: 0xC0002A13 : This function can only be performed by a local administrator. New!- After doing some analysis we found out the issue was related to limited availability of the ports. In this scenario only port XXXX was opened between BizTalk Server and SQL Server (on which the SSO Server is present). For such communications it is important that port 135 and the secondary RPC ports needs to be opened. After opening the required port range the issue was resolved.
- Failed to validate BAM Portal Web Site (BAMPortal)
The BAM Portal website Default Web Site is not valid. (Microsoft.BizTalk.Bam.CfgExtHelper.PortalHelper)
Exception from HRESULT: 0×80005008 (System.DirectoryServices). New!- Since I was reinstalling the BAM Portal, the Microsoft BizTalk Server Configuration wizard did not completely uninstall the BAM Portal from IIS.
BizTalk 2010 – List of Known Issues and Solutions with Setup and Configuration
The following are the known errors/issues associated to BizTalk Setup and Configuration:
BizTalk 2010 – List of Known Issues and solutions with Setup and Configuration (Part 2)
BizTalk Server Application Service (BTSNTSvc.exe) fails to start automatically after a system restart
- After rebooting the operating system BizTalk Server 2010 services fails to start automatically, despite being configured to do so.
Microsoft SQL Server Data Transformation Services (DTS) 2008 with SP1 or higher for BAM Archiving is not installed on the local machine. Please install Microsoft SQL Server 2008 Integration Services. (Microsoft.BizTalk.BAM.CfgExtHelper.ToolsHelper)
- This error makes it sound like you need to install SQL Server Integration Services (SSIS) which is a little misleading.
The service instance will remain suspended until administratively resumed or terminated. If resumed the instance will continue from its last persisted state and may re-throw the same unexpected exception. Inner exception: The event log file is full
- The event viewer is not properly configured and it reached to the maximum limit of the log file. This causes that when we tried to write in EV he throws this type of exception.
“Could not open certificate store.” and “The system cannot find the file specified. (System)”
- For BizTalk Remote Administration, one need to have the Administration tools and Monitoring feature installed on a Non-BizTalk server as in the below screenshot. Once installed, you get the administration console tool to connect to any BizTalk group in the domain and can do the admin stuff.
Could not create SSOSQL. To fix the problem, reinstall SSO or try ‘regasm SSOSQL.dll’ from a Visual Studio command prompt.
- For some reason the Enterprise Single Sign-On Service stopped working in one of my BizTalk machines.
Windows could not start the Enterprise Single Sign-On Service service on Local Computer.
Error 0x80131700: 0x80131700.- This issue occurs after installing .NET Framework 4.0. The registration of the assembly used by ENTSSO to access SQL Server does not specify the correct version of the .NET Framework. When .NET Framework 4.0 is installed, the assembly will try to use the newer framework and then fail to load..
Could not contact the SSO server 'localhost'. Check that SSO is configured and that the SSO service is running on that server.
(RPC: 0x800706D9: There are no more endpoints available from the endpoint mapper.).- This issue occurs after installing .NET Framework 4.0. The registration of the assembly used by ENTSSO to access SQL Server does not specify the correct version of the .NET Framework. When .NET Framework 4.0 is installed, the assembly will try to use the newer framework and then fail to load..
Failed to connect to the SQL database 'SSODB' on SQL Server 'SQLServerName'
0x80131700 (Win32).- This issue occurs after installing .NET Framework 4.0. The registration of the assembly used by ENTSSO to access SQL Server does not specify the correct version of the .NET Framework. When .NET Framework 4.0 is installed, the assembly will try to use the newer framework and then fail to load..
An error occurred while processing the last operation. Error code 8004E00F – COM+ was unable to talk to the Microsoft Distributed Transaction Coordinator.
Start registering ASP.NET scriptmap (2.0.50727) at W3SVC/2/Root/BAM. Error when validating the IIS path (W3SVC/2/Root/BAM). Error code = 0×80040154
- The error indicates that IIS is in 64 bit mode, while this application is a 32 bit application and thus not compatible. (Microsoft.BizTalk.Bam.CfgExtHelper.Utility)
Windows could not start the Enterprise Single Sign-On Service service on Local Computer. Error 0×80131700: 0×80131700
- To issue started because it unregisterd SSOSQL.dll which is found on C:\Program Files\Common Files\Enterprise Single Sign-On folder. To register it again run regasm on the VS command prompt from your 32-Bit machine.
** ** Could not create SSOSQL. To fix the problem, reinstall SSO or try 'regasm SSOSQL.dll' from a Visual Studio command prompt. Error Code: 0x80131700
- This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem
- You might get this problem if you have made some mistakes while modifying the BTSNTSvc.exe.config or BTSNTSvc64.exe.config file.
- WCF Service: The document specification ‘...’ from assembly ‘...’ failed to load.”
- You might get this error in while using the WCF adapter in BizTalk server 2010 if specified the wrong framework for App Pool in IIS
- WCF Service: Error: “Root element is missing”
- For details see: Error: “Root element is missing”
- Error Code: 0x8004E004, There is no MTS object context
- This error occurs when trying to create an adapter handler/ performing some operation in BizTalk admin console
- “Could not open certificate store.” and “The system cannot find the file specified. (System)”
- This error occurs when connecting remotely via BizTalk Admin Console and navigating through the properties of any send port. On a newly installed computer, the Other People Certificate store is not initialized unless you access it once. During the Group configuration, you can initialize this other people store, and as a result we do not see this error on a computer on which group configuration has been done
- “You are attempting to install Windows SharePoint Adapter Web Service on a virtual server that has not been configured with Windows SharePoint Services. Refer to the documentation for instructions on extending a virtual Server (CWssAdaCfg)”
- “Could not load file or assembly ‘Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91′ or one of its dependencies. The system cannot find the file specified.(Microsoft.BizTalk.Bam.CfgExtHelper.Utility)”
- The Microsoft.SqlServer.Smo comes with the Microsoft SQL Server 2005 Management Objects Collection and as a prerequisite software I had installed it before installing BizTalk
- “SGEN : error : Cannot generate serialization assembly because it already exists. Use /force to force an overwrite of the existing assembly.”
- BAMAlerts – The activation state cache could not be updated.
- If you have log shipped or detached/attached the BAMAlerts databases, you will have issues starting the notification service on the BizTalk server for BAM alerts. The reason for this, when these databases are restored, the the ‘Cross-Database Ownership Chaining’ option on the BAMAlertsApplication and BAMAlertsNSMain databases is disabled and grayed out.
- BizTalk Server 2010 - Message Agent Counters do not get updated for Orchestration Host, shows value as 0 for all the counters New!
- There have been a few instances with BizTalk Server 2010, in which we have seen that if there is a host which is running only orchestration and no messaging is taking place, BizTalk:Message Agent performance counters do not appear in the performance monitor. If we check the BizTalk group settings and go to Hosts and select the Show performance counters for dropdown we see that by default Messaging option is selected.
- Either or both of the hosts (inproc: BizTalkServerApplication, isolated:BizTalkServerIsolatedHost) created during BizTalk Runtime configuration could not be found. To workaround, please re-create the hosts. New!
- This error can happen if the BizTalkServerApplication and BizTalkServerIsolatedHost are not configured during the startup but manually created from the admin console.
- Error: "BizTalkMgmtDb" on server " SQLSERVERNAME ".
The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. New!- When you take a process monitor trace at the time when this issue occurs, search for “Access Denied” in the result section for the below path of the machine.config file. You can search for the System.UnauthorizedAccessException exception as well. Once you find these error, giving everyone access to C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\Machine.Config should resolve the issue.
- The Microsoft Distributed Transaction Coordinator (MSDTC) may not be configured correctly. Ensure that the MSDTC service is running and DTC network access is allowed on the BizTalk, SQL and SSO Master servers. For more information, see "MSDTC Configuration settings required for BizTalk Server" in the BizTalk Server Help.
Internal error: "New transaction cannot enlist in the specified transaction coordinator. New!- For BizTalk to communicate properly with SQL via DTC, we need some MSDTC settings to be in place on both the servers. Please check out the below blog which talks about the settings which are required: http://blogs.msdn.com/b/biztalknotes/archive/2013/03/08/biztalk-group-configuration-issues.aspx.
- Configuration Framework]Feature: [Group] Failed to configure with error message [Exception of type 'System.EnterpriseServices.TransactionProxyException' was thrown.]. New!
- For BizTalk to communicate properly with SQL via DTC, we need some MSDTC settings to be in place on both the servers. Please check out the below blog which talks about the settings which are required: http://blogs.msdn.com/b/biztalknotes/archive/2013/03/08/biztalk-group-configuration-issues.aspx.
- Failed to setup database objects associated with BizTalk Host "BizTalkServerApplication" on MessageBox database server "RNOKENTUCKY\CIGINS2" / database name "BizTalkMsgBoxDb".
**BizTalk Server cannot access SQL server. This could be due to one of the following reasons:- Access permissions have been denied to the current user. Either log on as a user that has been granted permissions to SQL and try again, or grant the current user permission to access SQL Server.
- The SQL Server does not exist or an invalid database name has been specified. Check the name entered for the SQL Server and database to make sure they are correct as provided during SQL Server installation.
- The SQL Server exists, but is not currently running. Use the Windows Service Control Manager or SQL Enterprise Manager to start SQL Server, and try again.
- A SQL database file with the same name as the specified database already exists in the Microsoft SQL Server data folder.
Internal error from OLEDB provider: "Cannot open database "BizTalkMsgBoxDb" requested by the login. The login failed." New!**
- This can happen if BizTalk Group was not configured properly and the BizTalkMsgBoxDb is missing in the SQL database. Re-Configure BizTalk group and then give it a try. It should work.
List of Known Issues and Solutions with Setup and Configuration for All Versions
The following are the known errors/issues associated to BizTalk Setup and Configuration for all versions:
- BizTalk Group configuration issues: Exception of type 'System.EnterpriseServices.TransactionProxyException' was thrown.
- When you configure BizTalk Server 2006, BizTalk Server 2006 R2, BizTalk Server 2009, or BizTalk Server 2010, the group configuration fails and you receive this error message
- The master secret has not been backed up. If you lose the master secret all the information stored in the SSO system will be lost permanently and your systems may fail to work correctly. Please use the SSO admin tools to back up your master secret. New!
- The reason for this error is that the master secret has not yet been backed up. And you need to be very careful because if you lose the master secret all the information stored in the SSO system will be lost permanently and your systems may fail to work correctly.
- The SSO service failed to start. Error Code: 0x800710D9, Unable to read from or write to the database.
**The certificate received from the remote server was issued by an untrusted certificate authority. Because of this, none of the data contained in the certificate can be validated. The SSL connection request has failed. The attached data contains the server certificate. New!
**- The above error shows that SSO service is trying to communicate to the SQL server over SSL protocol but, the certificate got from the SQL server is not valid. This is obviously due to fact that I did not have SQL server configured for SSL communication. Then, why does SSO service is trying to communicate with the SQL server over SSL?
Because we have informed SSO service to do so. There is a registry key under the SSO hive which specifies whether to use SSL protocol to communicate with the SQL server.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ENTSSO\SQL\SSL
If this key is set to “Yes”, SSO would try to make SSL communication which was the case on my server. I changed the value to “No” and I was able to start the SSO service without any issues.
- The above error shows that SSO service is trying to communicate to the SQL server over SSL protocol but, the certificate got from the SQL server is not valid. This is obviously due to fact that I did not have SQL server configured for SSL communication. Then, why does SSO service is trying to communicate with the SQL server over SSL?
- Source: BizTalk Server
**Event ID: 6913
Task Category: BizTalk Server
Computer: ABC.Microsoft.com
Description: An attempt to connect to "BizTalkMgmtDb" SQL Server database on server "ABC" failed.
Error: "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.". New!
**- This is a known behavior and this might happen whenever you restart you Domain Controller(s). This happens because whenever you restart your domain controllers, application (BizTalk) cannot authenticate users until the Domain Controller(s) is not responding on the network.
List of Others Known Issues and Solutions
BizTalk 2010 – List of Others Known Issues and Solutions
The following are the other known errors/issues associated to BizTalk 2010:
- BizTalk 2010 – List of Known Issues and solutions (Part 1)
- Common Issues and Resolutions with the BizTalk Server Administration console
- BizTalk Orchestration Performance: Thoughts from BizTalk Support
- Common EDI errors
List of Others Known Issues and Solutions for All Versions
The following are the other known errors/issues for all BizTalk versions:
- Failed to enable constraints. One or more rows contain values violating non-null , unique or foreign-key constraints. (System.Data)
- Could not enlist orchestration <type details here>. Value does not fall within the expected range.
- Turns out there’s a bug in BizTalk 2006 that prevents orchestrations from enlisting if not all orchestrations in an application are configured to run on the same host.
- "Could not enlist send port '[Send Port Name]' Exception from HRESULT: 0xC00CE557(Microsoft.BizTalk.ExplorerOM) ".
- After some experimentation I found that it was definitely the filter and I think what was happening was that when I edited the file and saved it through Visual Studio it must be affecting the encoding of the file when it was saved. When I edited the file through Visual Studio I could not successfully import the bindings to setup the port. If I configured the template only through Notepad the import of bindings into BizTalk would setup the filter correctly
- Enlist operation failed: 0x8004d01c(XACT_E_CONNECTION_DOWN). SQL Server could not register with Microsoft Distributed Transaction Coordinator (MS DTC) as a resource manager for this transaction. The transaction may have been stopped by the client or the resource manager. A severe error occurred on the current command. The results, if any, should be discarded. (Microsoft SQL Server, Error: 8510).
- It turns out that when clustered services are brought online, they must be started in a specific order, with the DTC service being started before SQL Server. If they are not brought online in this order, SQL Server fails to register itself and DTC transactions cannot be initiated, even though both the DTC and SQL service’s are running and everything looks correct
- "An error has occurred while establishing a connection to the server"
- This happens if you receive a copy of someone elses project - since the servername is listed in the projectname.btproj.user file that is a part of the project - and you try to deploy it directly from Visual Studio.
- "The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters. (Microsoft.BizTalk.ResourceManagers)"
- As the error mentions, the fully qualified file name of the artefacts must be less than 260 characters, and the directory name must be less than 248 characters.
- "Add-PSSnapin : Cannot load Windows PowerShell snap-in BizTalkFactory.Powershell.Extensions because of the following err or: Could not load file or assembly 'file:///C:\Program Files (x86)\BizTalkFactory PowerShell Provider\BizTalkFactory.P owerShell.Extensions.dll' or one of its dependencies. This assembly is built by a runtime newer than the currently load ed runtime and cannot be loaded. At C:\Users\Administrator\Documents\WindowsPowerShell\profile.ps1:5 char:13 + Add-PSSnapin <<<< BizTalkFactory.Powershell.Extensions + CategoryInfo : InvalidArgument: (BizTalkFactory.Powershell.Extensions:String) [Add-PSSnapin], PSSnapInE xception + FullyQualifiedErrorId : AddPSSnapInRead,Microsoft.PowerShell.Commands.AddPSSnapinCommand"
- Error 1053: The service did not respond to the start or control request in a timely fashion
- We got this error when Rule Engine Update Service did not start up after a reboot. We had the same problem with HL7 Logging service.
- The problem was that our machines were up-to-date with windows update but latest Cumulative Pack was not applied. This was related to BizTalk 2009 environment.
- Lesson learnt is to always have latest windows update and latest Cumulative Pack applied.
- One of the server still did not have its Rule Engine Update Service start. The problem was that there is a time-out after 30 seconds. We tried to start again and it worked because it took less than 30 seconds to start on this occasion. The other option is to change the timeout property in the registry**.**
- Orchestration will not open in the Orchestration Designer
- This can be resolved by updating the project file
- Other option is to Reset the Visual Studio
- "Exception of type 'System.EnterpriseServices.TransactionProxyException' was thrown" error when you configure BizTalk Server
- This issue occurs either when the MSDTC service is configured incorrectly or because of an error in the MSDTC connection between BizTalk Server and SQL Server.
- "Msg 2601, Level 14, State 1, Procedure bts_ImportSQLAgentJobs, Line 56 Cannot insert duplicate key row in object 'dbo.bts_LogShippingJobs' with unique index 'CIX_LogShippingJobs'."
- Duplicate key row in object 'dbo.bts_LogShippingJobs' error while setting Log Shipping disaster recovery for BizTalk Server 2006 R2 environment.
- Logon failure: The user has not been granted the requested logon type at this computer
- Not all privileges referenced are assigned to the caller
- This happens when installation is performed with less privileges than required to do. It can be avoided by performing installation with maximum privileges or run as Administrator.
- Could not create SSOCSTX. To fix the problem, reinstall SSO or install SSOCSTX.dll into a COM+ library application.
**Additional Data: 93
Error Code: 0x8004E00F, COM+ was unable to talk to the Microsoft Distributed Transaction Coordinator New!
**- At this point for me it was clear I have issues with MSDTC.
- No BizTalk assembly got loaded to BizTalk Server 2010 process: Could not load file or assembly ‘xxxx' or one of its dependencies New!
- This was because the config entry <supportedRuntime version="v4.0" /> which directs BizTalk process to point to 4.0 assembly was missing in the btsntsvc.exe.config file. This key is present by default in config file, these default keys should not be removed..
BizTalk Server Accelerators
The following section is related to BizTalk Accelerators issues :
BizTalk Accelerator for HL7 (BTAHL7)
The following section is related to BizTalk Accelerator for HL7 issues :
BizTalk Accelerator for RosettaNet (BTARN)
The following section is related to BizTalk Accelerator for RosettaNet issues :
- Unable to cast object of type System.DBNull to System.String New!
- Error While Saving. Unable to access required Public Responder and Public Initiator assemblies or orchestrations. Make sure these assemblies and orchestrations are correctly applied New!
- As the error suggests we were not able to get the Public Responder and Public Initiator assemblies or orchestrations. Ideally with Rosettanet Installation 9 orchestrations should get created. In this case we had only 5. When I looked at the Resources folder, however, the assemblies were present.
- Receiving a RNIF exception: UNP.SCON.VALERR: A failure occurred while validating the service content while you are extending Microsoft BizTalk Accelerator for RosettaNet (BTARN) with a new Partner Interface Process (PIP) schema. New!
- By default BTARN App Pool Settings are configured to use .NET framework 2.0, doesn’t enable 32-bit applications and the application pool is in Classic mode.Important for you to know is that the accelerator requires both an in-process and out of process host, both of which must be marked as "Authentication Trusted" and "32-bit only".
- Receive pipeline rejected incoming message due to the following RNIF exception: UNP.SCON.VALERR : A failure occurred while validating the service content.
- It turns out that the RNDisassembler does in-fact attempt to validate the message contained within the Service Content against a deployed schema just like the standard XmlDisassembler. The message that our trading partner was sending did not validate and hence the RosettaNet Accelerator threw this error message; once we had corrected the schema and redeployed, the error went away.
- An instance of the host 'BizTalkServerIsolatedHost' was found on this computer, but is not running as the user account 'DomainName\BTARNService'. Use the BizTalk Administration Console to reconfigure the host to run as 'DomainName\BTARNService'.
- If the configuration succeeds on the first box, but then the following error displays on other boxes in the group during configuration
- Error ConfigHelper] Windows NT user or group SQLServer\SQLInstace\BizTalk Application Users' not found.
- If configuring BTARN with a named SQL instance the configuration will fail without error. A close review of the config log will show
- Error Configuration Framework]Feature: [Runtime] Failed to configure with error message [<Exception Message="Unexpected exception occurred while configuring [Runtime]." Source="" HelpID=""><Exception Message="Attempted to read or write protected memory. This is often an indication that other memory is corrupt." Source="Configuration" HelpID="" /></Exception>]
- When configuring Microsoft BizTalk Accelerator for RosettaNet the following error message displays. Try changing "localhost" to the name of the box (netbios name) in the configuration console.
BizTalk Accelerator for SWIFT (A4SWIFT)
The following section is related to BizTalk Accelerator for SWIFT issues :
Other Issues
The following section is related to other issues that can occur in a BizTalk Environment or ecosystem:
- Error(s): This operation is not supported for messaging queue in workgroup mode. New!
- When trying to increase the machine/computer quota for my clustered MSMQ resource this error can occur.
- Microsoft.ServiceBus.Messaging.MessagingCommunicationException was unhandled
HResult=-2146233088
Message=Error during communication with Service Bus. Check the connection information, then retry.
Source=Microsoft.ServiceBus
IsTransient=true
InnerException: System.ServiceModel.CommunicationObjectFaultedException HResult=-2146233087
Message=Internal Server Error: The server did not provide a meaningful reply; this might be caused by a premature session shutdown..TrackingId:18787480-6512-4c57-89ea-2618291dd1fb, Timestamp:9/24/2013 2:16:48 PM
Source=Microsoft.ServiceBus. New!- It seems that there is a configuration value in the “Microsoft.ServiceBus.Gateway.exe.config” file (located at “C:\Program Files\Service Bus\1.0”) which is restricting the larger messages to be received in the service bus queue.
- Error: Attempt to install Message Queuing Server failed with error code 0x80070643. Fatal error during installation
The following features were not installed:
Message Queuing Services
Message Queuing Server . New!- This issue may occur if the user permissions are inadequate for the installation. MSMQ service runs under the Network Service account. During installation if we are unable to start the service then the installation rolls back. The Network Service account permission is restricted and hence the service does not start up and thus rolls back the installation.
- An application cannot be created for the Message Queuing IIS extension /LM/W3Svc/Root/MSMQ. Message Queuing will not be able to receive HTTP messages.
Error Code: 0x080110414. New!- This behavior may occur because the password for the IWAM_computer account (IIS Anonymous Username) is mismatched between the Windows Active Directory and the IIS metabase. It may also occur if the IWAM_computer account is locked out or disabled.
Warnings
The following are the known Warnings associated to BizTalk:
- Cannot resolve the ‘schemaLocation’ attribute
- It turned out that the BizTalk compiler is quite strict in the way the imports are defined for schemas in other assemblies.
BizTalk 3rd Party Tools Issues
The following are the known Warnings associated to BizTalk 3rd Party Tools:
- "Unable to enlist in the transaction.
System.Runtime.InteropServices.COMException (0x8004D00A): Unable to enlist in the transaction.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options)
at System.Management.ManagementObject.InvokeMethod(String methodName, Object[] args)
at A.cf0555bb9c0f6a0aebd67da53b41e6535.cc49ef4e8476b31546c8cfd644bd22a66(String c3ce089d4844970dd178d4bf819010021)
at Kovai.BizTalk360.BusinessService.Main.BizTalkQueryBusinessService.ExecuteServiceInstanceOperation(ServiceInstances serviceInstances, ServiceInstanceOperation operation)
at Kovai.BizTalk360.WCFService.BizTalkQueryService.ExecuteServiceInstanceOperation(BizTalkQueryServiceRequest request, ServiceInstances serviceInstances, ServiceInstanceOperation operation)"- After some research, I found out this was a problem with the DTC service, which was not enabled on the BizTalk360 machine.
- Server Error in '/BizTalk360' Application: This collection already contains an address with scheme http. There can be at most one address per scheme in this collection. If your service is being hosted in IIS you can fix the problem by setting 'system.serviceModel/serviceHostingEnvironment/multipleSiteBindingsEnabled' to true or specifying 'system.serviceModel/serviceHostingEnvironment/baseAddressPrefixFilters'. New!
- The main reason for this exception is due to multiple bindings enabled for the the IIS website under which BizTalk360 is installed.
ESB Toolkit – List of Known Issues and Solutions
BizTalk Server 2013: ESB Toolkit 2.2 – List of Known Issues and Solutions
The following are the known errors/issues associated with the ESB Toolkit 2.2:
- warning MSB3245: Could not resolve this reference. Could not locate the assembly "ESB.BAM.Service.Implementation". Check to make sure the assembly exists on disk.
**warning MSB3245: Could not resolve this reference. Could not locate the assembly "Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL".
warning MSB3245: Could not resolve this reference. Could not locate the assembly "Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL".
Faults\Itineraries.aspx.cs(8,11): error CS0234: The type or namespace name 'BAM' does not exist in the namespace 'ESB' (are you missing an assembly reference?) [C:\Projects\Microsoft.Practices.ESB\Source\Samples\Management Portal\ESB.Portal\ESB.Portal.csproj]
Faults\MessageViewer.ascx.cs(41,11): error CS0234: The type or namespace name 'BAM' does not exist in the namespace 'ESB' (are you missing an assembly reference?) [C:\Projects\Microsoft.Practices.ESB\Source\Samples\Management Portal\ESB.Portal\ESB.Portal.csproj]
DAL\DALHelper.cs(21,13): error CS0012: The type 'Microsoft.Practices.ServiceLocation.IServiceLocator' is defined in an assembly that is not referenced. You must add a reference to assembly 'Microsoft.Practices.ServiceLocation, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'. [C:\Projects\Microsoft.Practices.ESB\Source\Samples\Management Portal\ESB.BAM.Service\ESB.BAM.Service\ESB.BAM.Service.Implementation\ESB.BAM.Service.Implementation.csproj]
** - C:\Program Files (x86)\Microsoft BizTalk ESB Toolkit\ESBSource\Source\Samples\Exception Handling
**\Install\Scripts>powershell .\ExceptionHandling_Install.ps1 1.\ExceptionHandling_Install.ps1:
File C:\Program Files (x86)\Microsoft BizTalk ESBToolkit\ESBSource\Source\Samples\ExceptionHandling\Install\Scripts\ExceptionHandling_Install.ps1 cannot be loaded because running scripts is disabled on this system.
**- The reason was the PowerShell didn’t have enough access to execute the cmdlets present in ExceptionHandling_Install.ps1.
- Exception has been thrown by the target of an invocation. Source: Microsoft.Practices.ESB.Resolver.ResolverMgr.
- You may get this error when you have configured an Itinerary Selector pipeline component in BizTalk 2013 to use a business rules policy to select the appropriate itinerary.
- Could not load file or assembly 'Microsoft.BizTalk.Interop.SSOClient, Version=7.0.2300.0, Culture=neutral, PublickKeyToken=31bf3856ad36e35' or one of its dependencies. The system cannot find the file specified.
- This error occurred whenever we browsed to a web service hosted by BizTalk, in this case http://localhost/ESB.ExceptionHandlingServices.WCF/ExceptionHandling.svc..
- Exception has been thrown by the target of an invocation.
**Source: Microsoft.Practices.ESB.Resolver.ResolverMgr
Method: System.Collections.Generic.Dictionary`2[System.String,System.String] Resolve(Microsoft.Practices.ESB.Resolver.ResolverInfo, Microsoft.BizTalk.Message.Interop.IBaseMessage, Microsoft.BizTalk.Component.Interop.IPipelineContext)
Error Source: mscorlib
Error TargetSite: System.Object InvokeMethod(System.Object, System.Object[], System.Signature, Boolean). New!
**- ESB Toolkit 2.2 uses Unity 2.0 which requires modifications to the esb.config file.
- Configuring ESB toolkit: System.NullReferenceException: Object reference not set to an instance of an object.
**at EsbConfigurationTool.Panels.WebServicesException.get_WebSiteId(). New!
**- The issue was, I had not installed the IIS 6 Management compatibility tools. ESB configuration tool uses the IIS 6 Management compatibility tools to add the web artifacts to IIS.
- Service cannot be started. Microsoft.Practices.ServiceLocation.ActivationException: Activation error occured while trying to get instance of type Database, key “” —> Microsoft.Practices.Unity.ResolutionFailedException: Resolution of the dependency failed, type = “Microsoft.Practices.EnterpriseLibrary.Data.Database”, name = “(none)”.
**Exception occurred while: while resolving.
Exception is: InvalidOperationException – The type Database cannot be constructed. You must configure the container to supply this value.. New!
**- There are two issues with this service to be fixed after the installation to make it work. Assuming the service has been installed in the default folder “C:\Program Files (x86)\Microsoft BizTalk ESB Toolkit\Exception Notification Service”.
ESB Toolkit 2.1: List of Known Issues and Solutions
The following are the known errors/issues associated with the ESB Toolkit 2.1:
- The send adapter for this send port is not supported on64-bit host instances. Please make sure that the send adapter is associated with a 32-bit only handler.
- Access denied: Source: Microsoft.Practices.ESB.BizTalkOperations.BizTalkQuery; Method: Void .ctor(); Error Source: System.Management; Error TargetSite: Void ThrowWithExtendedInfo(System.Management.ManagementStatus)
- Could not load type ‘System.ServiceModel.Activation.HttpModule’ from assembly ‘System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089′.
- Could not load file or assembly 'Microsoft.Practices.ESB.BizTalkOperations, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified
- Make sure you import/install Microsoft.Practices.ESB.CORE64.msi New!
- Create Fault Message enters "endless loop" and cause the CPU to max out and the orchestration to hang indefinitely
Other Languages
This article is also available in the following languages
See Also
Read suggested related topics:
- Azure BizTalk Services: List of Errors and Warnings, Causes and Solutions
- Regarding the ESB Toolkit: also check BizTalk Server ESB: Survival Guide
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.