Blogs

Help, I have a strange error occuring in a Orchestration. It seems there is a limit to the amount of objects\code\shapes I can add to the orchestration before it suddenly throws the error below. The orchestration isn't very big and even stranger is the error occurs on a send port with is before the...

If you have ever used the Table Looping functoid in a BizTalk map, then you’re aware of its ability to take multiple inputs (whether they’re links from a source schema or other functoid outputs), and configure them as a table looping grid, so that these values can be used to create multiple nodes in...

The Issue The ESB Toolkit 2.1 Exception Handling Framework provides the ability to easily report and and alert on both routed failed messages (where Failed Message Routing is enabled on a Receive or Send Port), as well as ESBFaults created from exceptions within an Orchestration.  However, if you...

Hi All, I am able to send a file to the UNIX (samba file share) using BizTalk FILE adapter but getting the below error when trying to read a file using FILE adapter. The host user account has the full permissions on the UNIX file share, surprisingly error shows the windows account. Error(error code)16397...

I have in several of my blog posts focused on statistics. And I’ve gotten a few mails regarding the sudden loss of this data. So what really is the problem. When I refer to statistics I’m aiming for information in the tracking database and the tables for in and out events, and instances....

Hi, Here's an error I am getting when validating a flatfile against its schema, "The DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar" This error is showing up for elements with datatype: "xs:date" and custom format: "MM...

Hi All, I have orchestration, where I am using parallel shape with 4 branches and Receive shape to receive all the message. The receive shape have Correlation set initialize to 'BTS.MessageType'. In each of the branch of parallel shape I am using scope shape where I have put all my business logic...

I have generated schemas using ConsumeAdapterService from oracle database. I just want to insert data into tables that contain user defined types. Hence, the usertype assembly also got generated.I also have specified the below properties. enableBizTalkCompatibilityMode = True useSchemaInNameSpace = False...

Hi, I have a custom disassembler that unzips files. and files for which an xml schema is defined, I call the base.Disassemble and base.GetNext methods to convert them from flat file to xml. It works fine in some situations, however for some test sample files where Base.GetNext method should be called...

The correct title might be: “Moving the BizTalk databases – The right way”. Because the way outlined in the BizTalk help, is not much help. Scared yet? Well not after reading thru my articles. Why move databases? This is a very natural question and the answer is very simple: Because you have to. At some...

Execute DTS Package on SQL 2008R2 how to execute a dts package on sql 2008 R2 from BizTalk 2010? All help is greatly appreciated. Thank you AJ

My dev machine works so slowly, so I decided to clean it. I found a guide to perform it. But don’t do it on production plateform, it won’t be supported Here are few steps to clean up BizTalk Message Box Database. 1. There is a Stored Proc bts_CleanupMsgbox in BizTalkMsgBoxDb Database. By...

Finally I had some free time available to be able to update and fix some minor bugs which existed in the latest version of this adapter and already had been reported by community members. I have to give a special thanks to maakku that reported a problem related to the Daily schedule properties… and the...

Normal 0 false false false EN-AU X-NONE X-NONE MicrosoftInternetExplorer4 When adding WCF sql ports to BizTalk, you can add a whole host of different types of operation with SQL and it’s incredibly powerful. The problem is with all these options, the wizard rarely makes a binding file for you, it will...