October 2010 Entries

BizTalk - using a custom schema with your WCF stored procedure

Let’s say you added a table to the database created in the previous post, with a foreign key relationship to the original table, like this: The idea here is that you can have multiple rows in NestedData for each single row in TestData. If you create a stored procedure (call it Get_NestedData) with the following select statement: select TestData.TestDataId, StringColumn, IntColumn, Notes from TestData left outer join NestedData on TestData.TestDataId = NestedData.TestDataId where TestDataId = @TestDataId ......

BizTalk - simple WCF tutorial for using a stored procedure

This is a basic tutorial for using a stored procedure via a WCF-SQL adapter in BizTalk. It's similar to the examples given in the SDK, but eliminates all the extra garbage of creating custom C# assemblies, enabling the SQL FILESTREAM, etc. You'll need to make sure both the LOB SDK and the Adapter Pack are installed before beginning. First, create a test database call WCFSQLTest, then create a table and a stored proc, using the following scripts: CREATE TABLE [dbo].[TestData]( [TestDataId] [int] IDENTITY(1,1) ......

BizTalk error - "No valid adapters are installed on this machine"

After upgrading to a new 64-bit OS on our BizTalk server, I was unable to get the WCF-SQL adapter working - kept getting the "No valid adapters are installed on this machine" error message. The Admin Console had SOME of the WCF adapters visible, just not WCF-SQL. I found out that this was due to the fact that I had simply installed the 64-bit version of the Adapter Pack - both Visual Studio and the BizTalk Admin Console run as 32-bit processes, so you'll need to install that version as well. So, ......

Working with 5010 schemas in BizTalk (part 1)

If you're working with healthcare EDI transactions in BizTalk, then you need to be thinking about the upcoming 5010 transaction set implementation. In a nutshell, the 5010 transaction set introduces anywhere from dozens to hundreds of changes (depending on the individual transaction) and paves the way for the upcoming ICD-10 implementation. The timeline for transition is as follows: Jan 2009 Begin Level 1 activities (gap analysis, design, and development) Jan 2010 Begin internal testing for HIPAA ......

BizTalk - Failed while creating a service

I recently was testing some new functionality in a BizTalk solution by adding it to a second orchestration (before I went screwing around with my main one...) and received an error in the event log when dropping a file to the receive location: "xlang/s engine event log entry: Failed while creating a <Orchestration Name> service." (the full stack trace is shown at the end of this post) So, I tried to simplify things - I deleted that orchestration and started a new one, with just send and receive ......