Example of Xpath Count in BizTalk (and how to check empty/missing data)

One way to check for missing data is to do an xpath count. The two-step approach (put the xpath in a variable first). Some might find this code cleaner, but you use a variable. Note that you have to use the conversion statement to convert the string result of the xpath to a number, if […]

BizTalk Error: An xpath expression must be of the form …

If you get the error “An xpath expression must be of the form …” (in an expression shape of a BizTalk orchestration), here’s one possible solution. I was using a multi-part message, so instead of msgCreateSPServiceOrderAckResp, I had had to specify msgCreateSPServiceOrderAckResp.parameters. The compiler just shows the error “The expression that you have entered is […]

DOS Batch or Command File to clean-up (delete/purge/archive) old BizTalk log/debug files

In a previous article, we discussed how to use a Powershell job to delete files over a certain age. But what if if you want to do it using straight “pure” DOS .bat or .cmd file?  The following shows you how it’s done: REM Cleanup all files more than 7 days old e: cd E:\BizTalk\App\Backup […]

BizTalk Architect (Dallas) – Talks about past projects

This video gives an idea of some of the projects a BizTalk Architect are involved with. Neal Walters has worked in a number of industries, including: Oil and Gas, Mortgage, Banking, Manufacturing and Reverse Logistics, Government, Healthcare, Insurance, Aviation/Airline Fueling, Student Loans and Non-Profits. Neal started with mainframes back in 1981 with Amerada Hess Corporation […]

Losing Database Insert in a BizTalk WCF-CustomBehavior when it fails

I have a C# trace routine, that writes data to a SQL Trace table. It’s kind of like my own Log4Net, and allows a unified trace between BizTalk, WebServices, and other types of progams. I had the interesting task the last month of writing a WCF Custom Behavior to make JSON work in BizTalk 2010. […]

Webservice gives 404 with SSL but works without

I have a “Website” in IIS. It had a virtual directory with SSL working. I added a second virtual directory for another external client. I’m using SOAP-UI to test. It works fine with normal http, but gives an http status of 404 when I use https. Example URL: https://wstest.mydomain.com/App1/myService.svc https://wstest.mydomain.com/App2/myNewService.svc I’ve looked at the IIS […]

Swapping BizTalk Map References

Issue/Scenario: I have a new application that I’m building. I have for example three projects, App.Common, App.In, and App.Out. We have a somewhat debatable policy of keeping one app separate from the others and almost no application cross-references (still on BizTalk 2010 – but in 2013 this is supposed alleviated, partially or in whole). I […]

Install CURL for Windows and Run CURL on Windows

First download the C+ distributable from Microsoft: Download 64 Download the CURL MSI from here: Download CURL MSI Install will default to this directory, and here is the curl.exe: “c:\Program Files\cURL\bin\curl.exe”. You need to find the MSI. Many downloads of CURL will include the source code and it requires you to build it with C++ […]

How to set the web.config to get WebService errors returned to the client

The issue is you are testing, and it’s hard to see the exceptions you are encountering. You don’t want to go read the IIS logs, and they might not have the full .net error anyway. 1) Set customErrors mode attribute to “Off” 2) Set serviceDebug includeExceptionDetailInFaults attribute to “true” Example of a webconfig below with […]

Error: “Object reference not set…” on BizTalk Map Compile

I was getting this strange error yesterday: Error map_X_to_Y.btm: error btm1023: Exception Caught: Object reference not set to an instance of an object. Solution What I had done was copied a map from one project to another.  I had either not copied the schema, or I had copied the map to a different folder where […]