XSLT : Cummulative Sum
I need to do a sum within biztalk map or custom xslt. The sum of different field from different records should be calculated only for providers listed within the 'TotalAmount' Element. I would appreciate any help. Thanks! Here is the sample Input XML and…
Biztalk 2016 and SQL Server Version
We have installed Biztalk 2016 with SQL Server 2014 SP3. Is it supported to migrate to SQL Server 2019?
![](https://techprofile.blob.core.windows.net/images/C4NZdJhmG0Sbq-xji3b4Zw.png?8D8969)
added webreference of service not working some times
Dear team , I have added webreference of some x service in my integration, deployed and tested in UAT, its working fine. Then i have deployed same integration in Live, its working some times and some times getting 404 not found, and 502 bad gateway…
How to receive messages from Azure Blob in BizTalk 2016
Hi Team, I am trying to pull the messages from Azure Blob in BizTalk 2016 to get this trying to use the WCF-webhttp adapter but it is asking .svc based URL. So could you please share inputs on this to receive the messages from Azure Blob
Send Email with Multiple attachments using BizTalk SMTP
Hello, I need to send multiple attachments (1... n) using BizTalk SMTP adapter. I have created a Multipart message with one body and dynamically adding parts to the multipart message using .Net Helper assembly. I added one construct shape before the…
![](https://techprofile.blob.core.windows.net/images/C4NZdJhmG0Sbq-xji3b4Zw.png?8D8969)
BizTalk-debatching Schema and deploying
I'm pretty new to Biztalk. Got a new requirement to split error messages individually instead of them coming in as a big chunk so that each message triggers individual emails. So here are the steps I followed- Changed existing schema to…
Json conversion in XSLT 1.0
Within XSLT in Biztalk, I have a requirement to convert to json for a specific data only within my xml. Am NOT looking at converting my entire xml to Json, just data from a specific node. Below is a an example of that specific node. INPUT FILE …
![](https://techprofile.blob.core.windows.net/images/C4NZdJhmG0Sbq-xji3b4Zw.png?8D8969)
Activating new SFTP ports -stops working sftp\ftp\SAP ports
Hallo I use biztalk 2016 professional, I have two application in the system using file,sftp,ftp,SMTP and SAP adapter. Recently I added two new receive sftp ports in one application (I had already 10-15 of them). After i started these ports all the…
not able to generate the record using storeprocedure
HI , I am using store procedure to insert and update my table in SQL , but once i generate the schema using store procedure i am not able to see the record but fields are under root node .due to this not able to insert multiple records in SQL ,…
Currently Biztalk 2013 working with POP3 adapter on exchange server, migrating to outlook 365 causes problems
Does BT 13 POP3 wrk with Outlook 365 or an upgrade is needed.
![](https://techprofile.blob.core.windows.net/images/fafdfe01b6174acb87a3a342fc227b24.png)
BizTalk 2013R2 to SharePoint Online - 'The adapter "Windows SharePoint Services" raised an error message. Details "Sequence contains no elements".'
Configured a BizTalk 2013R2 Receive Location to SharePoint Online. The port is using a host running off an AD account associated with Office 365. I'm entering the same credentials into the Location configs SharePoint Online Username and Password…
Lookups in xslt mapper
Hi All, We are developing integrations in logic apps. We have the requirement to convert from XML to Flatfile. We need to do lookups in the azure blob table based on the fields in XML request at runtime. Currently, we are using VS 2015 update2…
![](https://techprofile.blob.core.windows.net/images/j_hATN6lWUGQqy8lwG64fA.png?8D869F)
BizTalk 2016 and MSXML dependency
Hi, Is there a dependency between BizTalk 2016 and MSXML? Noticed that BizTalk Rosettanet installer installs MSXML4 SP2. But Windows 2016 comes with MSXML6 so can we remove MSXML4 coz of security vulnerability identified by MSFT? What do we need to…
![](https://techprofile.blob.core.windows.net/images/vw_4yP5_AwAAAAAAAAAAAA.png?8DA6AF)
Biztalk 2020 edi configuration
I am getting following error when try to configure EDI on Biztalk 2020 any suggession
multiple heasder to single header biztalk
hi, i am receiving multiple lines of flat files which have header value in all lines like below Flat file Structure: abc,123,xyz,body1,body2,body3,body4 abc,123,xyz,boday11,body12,body13,body14 but i want to convert like below abc,123,xyz …
![](https://techprofile.blob.core.windows.net/images/vw_4yP5_AwAAAAAAAAAAAA.png?8DA6AF)
Transform failure in orchestration
Using Biztalk 2016 CU7 (one biztalk server only) Time to time get this kind of error in event viewer and suspended instance for same. It seems that it happen only when having many instance of same orchestration running on same time. It looks that it is…
how to sendjson data to sql stored procedure using biztalk/how to call json send pipeline in orchestration
i hav a requirement, i need to call awebserive which has 3 methods, 1)encript 2)datapush 3)decrypt first i need to call encrypt method , the input to this method is json string: { "RequestString":{ "Policy_No":"…
Error Report for EDI files
Created orchestration to handle Error Report and send notifications. The failed EDI message need to be sent in the email as well but , the message in the orchestration is in XML format. Is there any way to convert the XML to EDI format .
Powershell Script to browse webapplication
Hi Team, I have webapplication those are microsoft biztalk services hosted in IIS , When i restarted the server then my webapplications are not working once first time I browse then it is working. Could you please suggest powershell script to…