• HL7 Notes (6): Passthrough ACK pipeline component

    In the testing scenarios, we are dealing with multiple systems. One frustration for me is, I need to simulate those systems but (to my knowledge) only way to generate the ACK is to use the accelerator pipeline with parties.To use the standard accelerator pipeline component is not an easy thing, the schemas have to be […] Read more

  • Deploy Rules

    Lesson learned, Use command line from http://blogs.msdn.com/biztalkbre/archive/2007/02/16/sample-deploying-business-rules-programmatically.aspx to export vocabularies and rules to different files. Add this to Buildxxx.msi: ..\..\References\DeployRules /e /v:SharedInterfaceBroker.1.0 .\BRE_Vocabulary.xml..\..\References\DeployRules /e /p .\BRE_Policy.xml In deployment file turn IncludeVocabAndRules to true add entries to files extracted from step 1, <RuleVocabularies Include=”BRE_Vocabulary.xml”>   <LocationPath>.\</LocationPath> </RuleVocabularies> <RulePolicies Include=”BRE_Policy.xml”>   <LocationPath>.\</LocationPath> </RulePolicies> Read more

  • HL7 Notes (4)

    So scenario is from SAP to HL7, using the BATHL assembler in the send side to serialize the HL7 stream to flat file format then relay via MLLP adapter. Lesson leant, To help debugging, I took the BTAHL assembler pipeline component, reflected to be my custom pipeline component. This way, I have a debuggable component […] Read more

  • SharePoint Adapter: System.IO.FileNotFoundException

    This is for connecting SharePoint Foundation 2010 from BizTalk 2010, after deploying the adapter web service on the SharePoint server, adjust the TPM registry setting in the BizTalk server, my BizTalk server keep complaining although I confirmed many times the BizTalk host instance account is one of the group members. ‘The Windows SharePoint Services adapter […] Read more

  • WCF LOB Adapter

    Here are some tips for building the custom WCF LOB Adapter leant in the past days… § Design time § xxxURL.cs: This is where the custom connection string will go, i.e. for my scenario, the binding string is fax://faxserver/?enableTracing, the schema is fax, the fax server is host, enable tracing is custom query parameter which […] Read more

  • SQL script to undeploy rules/vocabularies

    Just to repost an entry to undeploy BRE rule a few years back in my another blog. USE [BizTalkRuleEngineDb]GO/****** Object:  StoredProcedure [dbo].[usp_un_rule]    Script Date: 04/27/2009 22:34:05 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO Create Procedure [dbo].[usp_un_rule](@rulesetName varchar(255),@verMajor int,@verMinor int)AsBeginDECLARE @RuleSetID intSELECT @RuleSetID = nRuleSetIDFROM RE_RulesetWHERE strName=@rulesetName AND nMajor=@verMajor AND nMinor=@verMinor UPDATE RE_RulesetSET nStatus = 0   WHERE nRuleSetID […] Read more