3,598 questions
2
votes
2
answers
139
views
SQL Server stored procedure passed a Biztalk XML message not returning field values when parsing the XML text
Our integration team want to send a XML parameter from their Biztalk server containing values to be written to a SQL Server table using a stored procedure, and have sent me an example for me to create ...
-1
votes
0
answers
31
views
How to properly decode ETW trace events emitted by BizTalk XLANG and other biztalk dlls
I’m trying to capture and decode internal BizTalk Server XLANG traces using ETW. I start an ETW session using tracelog:
{BiztalkFolder}\trace.cmd -start btstest
BizTalk code (decompiled) shows it uses ...
0
votes
0
answers
43
views
BizTalk 2020 - Could not find file 'Microsoft.BizTalk.TOM.resources'
I have a newly installed BizTalk Server 2020 with the latest CU pack also installed. This server also has Visual Studio 2019 installed. I've able to build BizTalk solutions on this machine ok. However,...
0
votes
0
answers
33
views
Is there a way to send an Excel file with BizTalk SharePoint adapter using ClientID and ClientSecret?
As say in the title, I need to send an excel file to a SharePoint with ClientID and ClientSecret credentials.
I put the clientId in the username text box of adapter, same with the clientSecret in ...
0
votes
0
answers
34
views
How to unit test a pipeline in BizTalk 2020? Option to create a New Test is unavailable in VS2019
I'm following the steps in this page to attempt unit testing of one of my custom pipelines. In that article, step 6 says "On the main menu, click Test, and then click New Test."
But in my ...
0
votes
0
answers
21
views
IIS return 404 when trying to access Applications.svc with BizTalk Rest API
I'm trying to use REST API of BizTalk 2020 to manage Receive locations from a web site.
When I try to access to ReceiveLocations.svc via URL : http://Localhost:8082/BizTalkManagementService/...
0
votes
1
answer
78
views
SQL > WCF-SQL send port in BizTalk
I'm trying to upgrade one of my send ports in BizTalk from using SQL to WCF-SQL, is there a way to do this without generating new schemas and instead applying the old SQL schemas to the new WCF-SQL ...
0
votes
0
answers
41
views
BizTalk 2020 - <any> element mapping issue
I've got a BizTalk 2020 map that has;
a source schema with 2 fields; RecID and an element
a target schema with a variety of generic elements
The map is performing simple point to point ...
0
votes
2
answers
56
views
Error when parsing message in Biztalk orchestration
I am passing following xml as input message in an orchestration.
and trying to extract value of "Number" field using the following xpath
identifier = xpath(XMsg, "/[local-name()='x' and ...
0
votes
0
answers
32
views
How to send the receive port name to a SQL procedure using WCF-Custom send port
I want to send the receive port name to a SQL procedure. I am using the message body shown here, but I get an event log error
The start element with name "BTS.ReceivePortID" and namespace &...
0
votes
0
answers
55
views
BizTalk Health Monitor V5 doesn't send e-mail on a schedule or when critical warning is detected
I'm trying to monitor my BizTalk Server 2020 with BHM V5.0.9118. I created a "Monitoring profile" and setted it like the following picture:
The Mail Settings window:
I have 2 send ports ...
0
votes
1
answer
65
views
BizTalk Health Monitor V5 crashes when creating custom rules
I'm trying to create a new custom rule in BHM V5.0.9118. I open the "Profile settings" window then go to "Rules" tab then check "List custom rule only" and then click &...
1
vote
0
answers
32
views
How to Handle Multiple Batch in Single File In EDI Using Biztalk?
I have Successfully Load EDI file using Biztalk but it handle Single Batch it time but now i need to Load Multiple Batch in Single Batch File here is my Orchestration so can any help into it to load ...
0
votes
1
answer
145
views
BizTalk 2020 WCF-Sql Polling Receive Location no Response
I have a BizTalk 2020 CU5 Server. It has an application with a receive location polling a Sql Server database running a simple select.
A copy of the database has been moved to another server, for ...
0
votes
1
answer
183
views
Tracking message events in BizTalk 2020 stopped working
We're running BizTalk 2020, and we've got an issue with tracking events.
One day around a week ago new events suddenly stopped tracking. If I process something, and it fails, I can see appropriate ...
1
vote
0
answers
149
views
How to add Content-Type header in custom send port
We are using Biztalk 2016 and configured WCF-Custom Sendport to send SOAP messages. We require to set following Content-Type:
Content-Type: application/soap+xml; action="actioname"; charset=...
-1
votes
1
answer
80
views
Get BizTalk host instance status from BizTalkMgmtDB
I am trying to query BizTalkMgmtDB database to get list of host instance with their status. Where can i find its current status i.e Running, Stopped and Not Applicable
SELECT
h.Name AS ...
-1
votes
1
answer
120
views
BizTalk Server 2020 - Why Configuration To Enable REST APIs Fails? [closed]
I'm trying to enable the REST APIs feature using the BizTalk Server Configuration Wizard as described here. However, it won't display any content in the REST APIs tab. I get the following error.
I ...
0
votes
0
answers
54
views
Biztalk 2020 File format is not valid. (System.Windows.Forms) during choosing filter to configure
I cannot configure filters for any Sendport on the specific BizTalk host. Choosing any Filter gets me the following error:
File format is not valid. (System.Windows.Forms)
On the second host in the ...
0
votes
1
answer
142
views
Bizarre Issue with decimals and leading zeros in BizTalk EDI Batching Validation
We're running into a very strange issue with our installation of BizTalk Server 2013R2. For only one party, we cannot process EDI messages that have elements with amounts that are decimal with values ...
0
votes
0
answers
33
views
Server did not recognize the value of HTTP Header SOAPAction exception
I'm sending the falling document using biztalk and get the following exception
Document:
<?xml version="1.0" encoding="utf-8"?>
<Envelope>
<Header>
&...
-1
votes
1
answer
82
views
Where i can set these propeties Encrypt=yes;TrustServerCertificate=True in WCF custom transport screen in receive location of BizTalk application
Where I can set these properties Encrypt=yes;TrustServerCertificate=True in WCF custom transport screen in receive location of BizTalk application.
I am using SQL database to polling data in one ...
-1
votes
1
answer
65
views
How to fix below error on BizTalk 2016 application? [closed]
How to fix below error on Biztalk 2016 application?
Microsoft.BizTalk.Adapter.Wcf.Converters.CreateBindingException: Unable to get binding type for binding extension "sqlBinding". Verify ...
0
votes
1
answer
101
views
How can I get BizTalk to allow a large array in querystring for consuming a REST service?
My problem is that I want to consume a REST service that have an array as input parameter, and I have a lot of items in the array (about 2 500 characters in total, which is allowed by HTTP protocol).
...
0
votes
1
answer
128
views
Restoring BizTalk Server
We have to configure BizTalk environment that will be replica of our current production environment, the one way to do this could be export the msi and binding files from production and import. Is ...
0
votes
1
answer
44
views
BizTalk 2006 Business Rule Composer, rule sets loading time optimization during Composer startup
Is there any way to decrease time of loading rule set versions in policy explorer? I have lots of versions of policies and loading it takes a lot of time. Maybe there is any possibility to limit the ...
0
votes
1
answer
101
views
How to solve WinSCP 5.19.2 vulnerability issue with BizTalk Server 2020 CU3
Currently we use BizTalk Server 2020 CU3 with WinSCP 5.19.2.
WinSCP 5.19.2 was found vulnerable by our security software Qualys and it recommends to update it to WinSCP 6.3.3.
Is WinSCP 6.3.3 ...
0
votes
1
answer
71
views
BizTalk changes after MSDTC logging file size change
We have a clustered environment of two BizTalk servers and two SQL servers. We are in process of changing the MSDTC log file size to a definite size of 50 MB so that it can handle maximum concurrent ...
0
votes
0
answers
174
views
BizTalk wcf-sql receive location polling issues
We have a wcf-sql receive location in BizTalk 2020 which executes a stored procedure and brings back the results. Everything was working fine initially but suddenly the receive location is polling ...
0
votes
0
answers
152
views
BizTalk 2020 SMTP adapter and attached file name
I understand that my problem is very old and looks trivial, but nevertheless...I'm pretty new in creating custom components, I've looked through similar questions here and stuck with one thing.
So, I ...
0
votes
1
answer
90
views
How do I retrieve the value of ReceivedFileName from the Context Property?
We are running more than 200 applications in our BizTalk environment. We frequently face suspended inbound messages due to issues like timeouts.
We need to reprocess all of them. For that, we need the ...
0
votes
1
answer
85
views
Using Macros BizTalk 2020 Office 365 adapter
Can we use macros in BizTalk 2020 send adapter for Office 365.
I tried %SourceFileName% and it wasn't working, Also trying to input the service account details in to the port but it was recognizing ...
0
votes
1
answer
123
views
How to export Parties and Agreements from BizTalk Server 2013 R2?
We are going with Standalone parallel installation of BizTalk server 2020 instead inplace upgrade.
I am looking for an option to copy Trading Partner party's and Agreements from old server to new ...
0
votes
1
answer
134
views
After making changes to Schema, I am getting Exception occurred when persisting state to the database error
My BizTalk application is calling some Azure functions and receiving a response, but due to recent changes, those Azure functions are returning responses in the camel case, so I made changes to some ...
0
votes
1
answer
221
views
Issue with BizTalk register WCF-WSHttp adapter while calling web service
I published a schema as a web service on BizTalk 2020 with the BizTalk WCF Service Publishing Wizard.
On DEV environment (all-in-one), everything is fine and I can access the wsdl when I browse my ...
-1
votes
1
answer
102
views
If I enable BAM on BizTalk 2020 does it provide EDI support for Inbound and Outbound Monitoring?
I've read thru several articles on what Business Activity Monitoring is about but none of them demonstrate real world example of how having BAM enabled is a benefit and what it can do? Hopelessly ...
0
votes
1
answer
98
views
The Microsoft.Adapters.Sql.BizTalk.WcfBtsSqlReceiver assembly (version 3.5.0.0) compatibility issue with 64-bit Office 365
After upgraded Office 365 64 bit from Office 2016 32 bit, I keep getting the following error when I use BizTalk server:
The Messaging Engine failed to creae the receive adapter "WCF-SQL". ...
0
votes
1
answer
46
views
Variable Used For Output parameter not detected as "used", even though it is used in the BizTalk Orchestration
I have a method like this:
CreateOrder(XmlDocument OrderData, out int OrderId);
This method is called from an Expression shape in an orchestration. However, during compilation, a warning like this ...
0
votes
1
answer
105
views
How to define application specific config file in Biztalk and consume it in specific application?
Could you please help to define a define application specific config file in Biztalk and consume it in specific application? (We are using Biztalk 2016)
In my scenario we have 3 applications. Two are ...
0
votes
1
answer
159
views
BizTalk 2020 - Receiving JSON decoded REST messages for different schemas
I've got 2 sets of schemas (send and receive); CheckUserExists and SaveBusinessObject.
Both schemas are used to send and receive payloads to and from JSON REST endpoints.
In the orchestration, these ...
0
votes
2
answers
375
views
BizTalk 2020 - Converting XML to Arrayed JSON payload
I'm trying to send the below payload (JSON) to a REST endpoint, but when I use conventional mapping in BizTalk to build the XML schema, and then use the JSON encoder in a custom pipeline to send it ...
1
vote
1
answer
60
views
Distinguished field promotion against a TypedPolling generated schema
I'm trying to promote a field using Distinguished promotion so that I can filter the value on the initializing Receive shape by a specific value.
The schema has been generated as a TypedPolling ...
1
vote
3
answers
560
views
BizTalk Server 2020 - Temp Files not getting cleaned within InProcess User Context
We are using BizTalk Server 2020 with SFTP Adapter (WinSCP Version 5.21.5).
Multiple Receive Locations and other Artefacts are running under this user.
Unfortunately our Admin contacted me that the ...
2
votes
0
answers
79
views
Updating Tracking on Sendport on Biztalk 2020 using REST API
We are using Biztalk 2020 and have enabled the REST API to use for our needs.
One of the things we want to do is to script and update the tracking settings on Recieveport, Sendport, Orchestration and ...
0
votes
2
answers
186
views
How can I xpath a value from an xml <Any> element?
In my Biztalk Orchestration designer (Expression editor) I need to extract the value from the element called <Any>. I created a string variable and did an xpath on the field but the variable ...
0
votes
1
answer
53
views
BizTalk 2020 - editing elements within a Mass Copy functoid
Is it possible to manipulate the copied elements within a Mass Copy functoid (or is there a design pattern that can be used instead)?
Currently, I call a REST endpoint to return user details. The user ...
0
votes
1
answer
135
views
There was a failure executing the receive pipeline. Reason: The pipeline component can not be found
There was a failure executing the receive pipeline. Reason: The pipeline component ... can not be found. If the component name is fully qualified, this error may occur because the pipeline component ...
1
vote
1
answer
130
views
Biztalk custom send pipeline only unzips one of the messages not all
I have a problem, I am trying to create an unzip pipeline in the pre-assemble stage of a Send Pipeline because i have to. This is my code:
[Guid("885186F0-8846-4AD1-BC3F-D0066844B871")]
[...
0
votes
1
answer
196
views
%SourceFileName% macro does not work with Blob Storage adapter bizTalk2020
I have a flow where receive location is blob storage and I use Azure Blob Storage adapter. Then I don't have any orchestrations, mapping and so on, just a send port as file share adapter.
In the file ...
-1
votes
1
answer
293
views
Biztalk flat file schema - how to use double quote as delimiter
I have a flat file as
"barn","40","10,120","bill"
which I have to separate, I tried using quotes as delimiter but there is another quote and comma which ...