All Questions
Tagged with biztalk biztalk-2013
423 questions
1
vote
0
answers
158
views
BizTalk - Is there a way to get the input file name (received file name) via SQL query in BizTalk
I have a requirement to get the suspended messages with the input file details.
I have managed to get the suspended messages using sql query. however, I am unable to get the input file details (...
- 11
1
vote
1
answer
52
views
BizTalk Debatch Input FlatFile with multiple header to multiple file
I have a requirement where i want to debatch the Below sample file into multiple file without using orchestration ,
Sample
H|3|ABC|1|5/10/2023
D|1|543
D|1|543
H|3|ABC|1|5/10/2023
D|1|543
D|1|543
The ...
- 133
0
votes
0
answers
611
views
How to set up BizTalk WCF-WebHttp Send Port for POST method
I am working with a REST API within BizTalk Server 2013 and I need to make a POST to send an SMS using WCF-WebHttp Send Port. Content-Type is application/json.
I have so far put in the Address (URI) ...
- 1
0
votes
1
answer
69
views
Inline xslt for max values per duplicate record
I need to map the following input message instance in my biztalk project so that for every group of customer records the program checks if there are any duplicate debtor info values. If there are ...
1
vote
1
answer
580
views
How can I connect to SFTP service based on Azure Storage Account Solution with BizTalk 2013
I have a requirement to connect to an SFTP service based on Azure Storage Account Solution, I setted my receive location as following :
But the receive location stay disabled. I was able to connect ...
- 121
0
votes
1
answer
3k
views
Using BizTalk 2013r2 to UPSERT via WCF-SQL stored procedure
I'm currently trying to write a canonical schema to multiple related tables within a SQL DB, but I'm experience DUPLICATE KEY ID conflicts when it's evaluating whether the record exists prior to ...
- 89
1
vote
1
answer
363
views
Unmatched wrap character for a wrapped field with comma in it
I have this CSV input:
Username,"Certification ID number","Certification Name","Date completed","Date due"
nlxxxxxx,NLaaa,"NL - Test certificaat",1/...
- 121
0
votes
1
answer
296
views
Transformation failed BizTalk
I have a map with a C# script in Script functoid to convert a date in dd/MM/yyyy format to yyyy-MM-dd format:
Here is the script I use in my functoid :
public string CheckDate(string inputDate)
{
if(...
- 121
0
votes
0
answers
161
views
How to transform text file to schema with biztalk or xslt, or logic apps also?
I have a text file like this:
20201117125512HH 001APPOINTMENT DATA 85372
APTHDR0350100000001 1 2CROS04202020-11-25012020-11-25 15:30:00.000000 PIC077120 ...
- 15
0
votes
1
answer
391
views
Passing parameters to BizTalk xslt map
Is it possible to pass some parameters to xslt map? Let's say I have the usual btm and xslt maps and going to use it with usual receive/send ports. And I want my xslt map to depend on some external ...
- 11
0
votes
2
answers
467
views
Set an xslt variable with an email
In a BizTalk mapper, I had to set a default e-mail in output field when a specific input field is null or empty.
So I set an XSLT variable with the email but when the condition is good no node is ...
- 121
0
votes
1
answer
213
views
Map Flatfile schema with repeating nodes input to one XML schema with repeating nodes output BizTalk
I'm trying to map a Flat file schema with multiple lines to an XML file with same multiple lines.
Input file example:
Username,"Certification ID","Certification Name","Date ...
- 121
1
vote
1
answer
110
views
Error while creating send handler for WCF Custom Adapter in BizTalk 2016
While trying to add the host instances to the WCF Custom Adapter as a send handler I am getting the below error messages.
I tried resetting my password and restarted and that didn't work. Also, I ...
0
votes
2
answers
299
views
BizTalk splitting stored procedure result
When I call a stored procedure from BizTalk the result is split across multiple nodes. The stored procedure returns XML which is mangled by being split.
Multiple sources state the correct ...
- 14.4k
0
votes
1
answer
70
views
BizTalk core format: redundant but all according to standard or "keep it simply stupid"?
I'm quite new in BizTalk mapping and my question now is:
Let's say that I need to receive UBL document, convert it to my Biztalk Core and send out same UBL. Of course I can perform 1:1 UBL->UBL ...
- 11
0
votes
1
answer
273
views
BizTalk mapping: how to extract single row from looping but, possibly, to extend it to few destination fields?
I have the following issue. In BizTalk core (XML) I have a tag which may be replicated few times. It's cardinality is n, let's say - in theory 0 ≤ n ≤ 99. Let's call it Note[n].
In outgoing file (it's ...
- 11
0
votes
1
answer
827
views
BizTalk mapping: how to extract single row from looping
I have the following issue. In BizTalk core (XML) I have a tag which may be replicated few times. It's cardinality is n, let's say - in theory 0 ≤ n ≤ 99. Let's call it Note[n].
In outgoing file (it's ...
- 11
0
votes
0
answers
123
views
Is there a way to set value template in BizTalk schema/mapping?
I have the following problem. In BizTalk mapper I'm converting BizTalk core (XML) into flat file. One of fields in this flat file must contain 13 chars in special format - if incoming value is less ...
- 11
1
vote
1
answer
1k
views
BizTalk WCF-Custom Behavior Extension not showing up
I have made the following behavior extension:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.ServiceModel....
- 11
0
votes
1
answer
356
views
BizTalk Flat File Schema with optional last child record
I am trying to create a delimited flat file schema that takes care of the following file format:
"ID","Surname","FirstName"{CR}{LF}
"FINAL","123",&...
- 1
0
votes
0
answers
129
views
BizTalk Rule Composer does not update rules after adding new vocabularies
I inherited a BizTalk application that is using Rule Composer to set up policies. I introduced new vocabularies and added new rules, however the new rules does not take effect after deploying the ...
- 1,019
1
vote
1
answer
287
views
BizTalk 2013 - BTS.MessageID and outMsg.MessageID do not match
I am using BizTalk Server 2013. I have a custom receive pipeline component in the disassemble stage. This component breaks the input xml message into separate messages based on "locations" ...
- 19
0
votes
1
answer
575
views
Getting error "There was a failure executing the send pipeline" for json-encoded pipeline
I am getting the following error while deploying it to my test server:
There was a failure executing the send pipeline: "NameOfMyApp.XmlToJSONSendPipeline, NameOfMyApp, Version=1.0.0.0, Culture=...
0
votes
1
answer
222
views
BizTalk application consuming api changing to TSL 1.0 to 1.2.What is the Required change in BizTalk side?
In my BizTalk application I am consuming one rest API which is TSL 1.0.
Now API team going t change the TSL 1.0 to TSL 1.2.
I am using BizTalk 2013 R2.
Any change need to do at BizTalk end to call TSL ...
- 41
0
votes
1
answer
499
views
Used Wshttpsbinding of WCF-custom Adapter in the send ports.Getting Multiple headers with name 'NotUnderstood'
Below are the configuration details:
Error Details:
A message sent to adapter "WCF-Custom" on send port "SendSIMONMessage" with URI "https://simon-qa.dhec.sc.gov/...
0
votes
1
answer
485
views
BizTalk - Build XSD for flat file with words delimiter at start and end of records
I am trying to build an XSD file based on the following text file (flat file). I am using the flat file schema wizard but can't achieve what I want.
:BEGIN
Key1 Value1
Key2 Value2
:END
:BEGIN
Key1 ...
- 1,300
0
votes
1
answer
124
views
General purpose database within BizTalk
In my BizTalk server, I would like to create custom orchestrations for fetching data from various sources such as REST APIs, SFTP folders, etc. I would like to store the parameters of the REST API ...
- 1,008
1
vote
1
answer
54
views
BizTalk 2016 BRE
I am trying to replace some characters in a JSON file in BRE, I want to use this in BRE pipeline.
Below is the JSON input
{
"Attributes": "{}",
"Credentials": &...
- 133
1
vote
1
answer
810
views
Encoding issue when passing URL Parameters with BizTalk WCF-WebHttp Send Port
I'm trying to call an RESTful API within BizTalk. I need to make a GET against the following endpoint:
https://mycompany.com/buyer/sandboxevol/
I have below mappings configured in my Send Port
<...
-1
votes
1
answer
55
views
Routing messages for two parties received on the same endpoint in BizTalk
I am receiving messages for two parties on the same endpoint. My receive port receives AS2 messages, not EDI, and I am trying to route this messages.
How can I route the messages I receive to a ...
- 11
0
votes
1
answer
351
views
Location of client-certificate on IIS hosted WCF service used with BizTalk 2013r2
I have problem with a windows client certificate, on a system I have inherited from a developer who left without documenting his work. Basically, when I try to connect to an IIS hosted webservice ...
- 169
0
votes
1
answer
214
views
How to get ACK/NACK in Biztalk orchestration
Can anyone help me in how to get the ACK/NACK to orchestration once the message is delivered through FILE send adapter. I am using Copy mode = Append in file adapter configuration.
Any specific ...
- 13
0
votes
0
answers
381
views
Unable to receive messages from SAP using WCF-SAP adapter in BizTalk Server 2013
We are not able to receive messages from SAP using WCF-SAP adapters on BizTalk Server 2013. The following is the error message
Error Description:
The adapter "WCF-SAP" raised an error message. ...
0
votes
1
answer
1k
views
BizTalk - Extract element value using xpath with multiple namespaces
I have an employee msg in BizTalk. In an orchestration, i am trying to get the value of the field(IBKT_SYSID_PK) but it is returning empty. Pls assist.
EMPLOYEE Message:
<ns1:Employee xmlns:ns2="...
- 5
0
votes
2
answers
513
views
Is there a way to exclude a file mask from a BizTalk receive location?
I have a receivelocation in a folder where we pull all files, .
We are now going to receive .xslt on the same folder, and wish to pull those files with another receivelocation. Is there a way to ...
- 9
0
votes
1
answer
257
views
BizTalk Mapping Fields to a Sequence
I am getting my hands on BizTalk and VS. My input schema looks something similar to this.
<root>
<order>
<orderid>
<orderdate>
...
...
and the output schema ...
- 342
0
votes
1
answer
134
views
BizTalk 2013R2: Why does my orchestration initialise after being terminated according to the Orchestration Debugger?
I am currently looking at diagnosing some reoccurring issues within a BizTalk environment and currently that is the issue of zombie messages. I am aware of the conditions that create these errors and ...
- 21
0
votes
1
answer
223
views
Dynamic subject on send port generated email
I've recently inherited a BizTalk 2013 setup and am struggling to get up to speed with it.
I have a send port which generates an email when it receives an XML file - currently it sends the file as an ...
- 169
0
votes
2
answers
242
views
BizTalk 2013 Admin Console not loading after installing CU 7 update
We have currently update from BizTalk 2010 to 2013 and after that we have installed CU 7 update for TLS1.2 requirement. But as we install this CU 7 update of BizTalk 2013, the console is not able to ...
- 11
0
votes
1
answer
2k
views
Could not load file or assembly
I want to archive a pdf version of a DESADV, therefore I create a Html page via Biztalk Custom XSLT Mapping from the original XML file and render it via Pechkin.Synchronized to a pdf (wrapper for ...
- 471
0
votes
1
answer
40
views
Collapse all policies nodes inside Microsoft Business Rule Composer
I have a lot of BRE policies, which make the BRE composer UI hard to deal with. So my question is how can I collapse all policies nodes inside Microsoft Business Rule Composer using a single click, ...
- 1
0
votes
1
answer
187
views
Receive different type of XML request in a orchestration
I have a Biztalk which had issues with handling large XML message requests. So I have planned to use a custom pipeline component which saves the message to a temporary directory if the request is ...
- 1,387
0
votes
2
answers
518
views
%MessageID% different from BTS.MessageID
I am trying to identify the messages I am saving in a folder using MessageID property. However the MessageID values are different from the values I get when I use BTS.MessageID. Why?
In my ...
- 7
0
votes
0
answers
87
views
Consume Salesforce wsdl in BizTalk application
We have a BizTalk application where we consume the salesforce wsdl to create a Quote everything is working the Login helper is also setup. Now we added new fields in to the Salesforce we need to ...
- 2,157
-1
votes
2
answers
467
views
Is there a Datetime format which not change the output date value?
I have a string in an XML which is a datetime with a timezone and I would like to change it to a DateTime format in C#.
The problem is that it go from the string format to datetime format, the value ...
- 121
2
votes
1
answer
11k
views
How to fix 'Errors were reported during stylesheet compilation' in XSLT?
I have this SaxonApiException when I run my XSLT code on https://xslttest.appspot.com/. It return this error :
net.sf.saxon.s9api.SaxonApiException: Errors were reported during stylesheet ...
- 121
0
votes
1
answer
129
views
how to replace value of field when field is empty?
On my left schema, sometimes for the StartTime we will have no value whatsoever. Some examples of valid values would be:
1200
1320
2100
0900
When the input is blank, simply <StartTime></...
- 60.4k
0
votes
3
answers
1k
views
Exception: "There was a failure executing the response(receive) pipeline"
In the BizTalk Console Administration I often see exceptions like the following:
There was a failure executing the response(receive) pipeline: "[pipelineName], [BizTalk projectName], Version=1.0....
- 7
0
votes
0
answers
66
views
How to disable AmbientTransaction when calling Stored Proc from a Helper Class?
I am trying to call a Stored Proc using a C# helper class in my BizTalk solution. I am able to call the stored proc when I use a Send port with WCF-Custom adapter and set AmbientTrancsaction to "false"...
- 116
0
votes
1
answer
101
views
how to extract last name?
Is there a functoid that specializes in splitting a string based on a delimitter?
Let's say I have a Fullname field that looks like so:
Gordon, Liza
Shiksa, Nancy
Shkura, Lola
Sukovich, Matthew
How ...
- 60.4k