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 […]
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 […]
I recently showed a VBScript to Archive/Move xml files to a subfolder. This is often needed when you have been archive or storing 1000s of XML files, and the the directory/folder is very slow to open due to the large number of files. Now, we will do it in Powershell. Create the subfolders ahead of […]
Business Problem/Scenario I had a .bat file with 50 lines or more, and many of them had disk paths. We were migrating this to production, so I did “replace all” commands to change all the paths to production SAN/Server names. But then, I knew some of the paths existed, and some didn’t. So I wanted […]
Two handy references for BizTalk XSLT: Substring in XSLT Value-Of XPATH The first example is fairly easy, I just needed to get the date/time without the timezone modifier, in other words to convert this: 2016-01-29T00:00:00-08:00 to this: 2016-01-29T00:00:00. The reason was that our web service was only coded to handle the date without the timezone. […]
Sample Code Error MyMap.btm: error btm1023: Exception Caught: The ‘=’ character, hexadecimal value 0x3D, cannot be included in a name. Line 4, position 23. Solution This was a simple typo. I typed in “value-of-select=” instead of “value-of select=” (I erroneously included an extra dash between the “of” and the “select”). The parser saw the entire […]
How do you test a multi-part map, i.e. a map with multiple input messages? To test a normal map, you just take an sample XML file, click the map (in Visual Studio Solution Explorer), set the property of the filename into the value of the property “TestMap Input”, then right-click on the map and select […]
<br> USE BizTalkDTADb<br> –select top 10 * from dbo.dta_DebugTrace<br> select COUNT(*) from dbo.dta_DebugTrace as TotalRowCount <br> SELECT YEAR(dtBeginTimeStamp) AS Yr,<br> Month(dtBeginTimeStamp) AS Mo,<br> COUNT(*) AS [RowCount]<br> FROM dbo.dta_DebugTrace nolock<br> GROUP BY<br> YEAR(dtBeginTimeStamp),<br> DatePart(mm,dtBeginTimeStamp)<br> Order BY<br> YEAR(dtBeginTimeStamp),<br> Month(dtBeginTimeStamp)<br> The results show you by year/month how many rows. In most cases, you will find you need to […]
I brought a Rosetta .xsd schema into a new BizTalk Project, gave it a compile and got 1524 occurences of the following error: The Build Errors —— Rebuild All started: Project: BTS2C7Outbound, Configuration: Debug Any CPU —— e:\MyDir\BTS2C7Outbound\Schemas\2C7\Domain\Logistics\CodeList\RN_ResponseCode_01_00.xsd.cs(13,17): error CS0234: The type or namespace name 'NonSerializedAttribute' does not exist in the namespace 'BTS2C7Outbound.Schemas._2C7.System' (are you […]
I had a case today where I was mapping two fields N01 and N02 to two side by side fields in the output schema. N01 was working, and N02 wasn’t. Both were under an condition that a certain variable MESSAGE_TYPE was equal to a certain value. Yet one worked, the other didn’t? How did I […]