BizTalk Server General Forum

Asynchronous problem

Sat, 28 Nov 2009 21:56:25 Z

Hi, as an architect rather than a developer in BizTalk I have a problem which I wonder is someone could give some suggestions.

I need as Orchestration that sends XML messages to a web service. Simple enough. A some point later a get an ACK message to say they received it. This is dropped in a mailbox which I access through a web service call. This call will return all ACK's for all the messages I send in a none defined order.

Is it possible to do this with one Orchestration and a polling mechanism to read the ACKs. This is my thinking...

My orchestration sends the message and goes into a WaitingReceive Loop. It is waiting for the ACK that belongs to the messageID is sent. If after a defined timeout it does not arrive it either reports and error or retries.
I have a polling mechanism that calls the web service for the ACKS and drops them into the MessageBox. These will all have the same namespace but a different messageID
My Orchestration wakes up when the ACK with the correct MessageID arrives.

Does that sound feasible?

How do I create a mechanism so that the Orchestration RecievePort knows the Message has the right ID? All ACK will be in the same namespace so I need (I imagine) to correlate using the MessageID so the Orchestration only wakes up when the right ones arrives.

Am I right in thinking I create a CorrelationSet on the Receive in the Orchestration?

Could someone quicky explain (at a high level) how that works in BizTalk?

thanks

Error Report Failure Codes

Sun, 29 Nov 2009 16:47:53 Z

Hi everyone,

is there a resource that provides details of the values that can populate the FailureCode element in an error report?

For example

0xc0c01657 = Failure in recieve pipeline
0xc0c01658 = Failure in Send Pipeline
0xc0c0167a = Transmission Failure (e.g. endpoint down)

I cannot find a definitive list of these, which would be useful in creating an automated error handling solution.

Any help appreciated

Kind regards
TM

Does BTAHL7 2x assembler supports ORM 2.3.1 schema

Fri, 27 Nov 2009 07:42:42 Z

Hi,

I am passing a HL7 multipart message to send pipeline(BTAHL7 2X Assembler). HL7 message is made of MSH 25 and ORM 2.3.1 and a Zsegment.

I am getting following error:

Event Type: Error
Event Source: BizTalk Accelerator for HL7
Event Category: None
Event ID: 4133
Date:  11/27/2009
Time:  12:34:53 AM
User:  N/A

Description:
Error happened in body during serialization
Error # 1
Segment Id: PID_PatientIdentification
Sequence Number: 1
Error Number: 207
Error Description: Application internal error
Encoding System: HL7nnnn
Alternate Error Number: Z100
Alternate Error Description: From current serializer state, tag <PID_3_PatientIdentifierList> cannot be valid
Alternate Encoding System: HL7-BTA

---------------------------------

Event Type: Error
Event Source: BizTalk Server 2006
Event Category: BizTalk Server 2006
Event ID: 5720
Date:  11/27/2009
Time:  12:34:53 AM
User:  N/A
Description:
There was a failure executing the send pipeline: "xx", Source: "BTAHL7 2.X Assembler" Send Port: "Send " URI: "C:\Documents and Settings\%MessageID%.xml" Reason: Serialization errors:
Error # 1
Segment Id: PID_PatientIdentification
Sequence Number: 1
Error Number: 207
Error Description: Application internal error
Encoding System: HL7nnnn
Alternate Error Number: Z100
Alternate Error Description: From current serializer state, tag <PID_3_PatientIdentifierList> cannot be valid
Alternate Encoding System: HL7-BTA

It seems BTAHL7 assembler is looking for ORM 2.1 version, though the MSH.12_version is given 2.3.1. The party validation is also set to targetnamespace of ORM 2.3.1. Is anything else need to be considered?

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Futher XSLT question in a BizTalk Mapping, how to group the results by ID and find the earliest and latest date?

Thu, 26 Nov 2009 22:53:39 Z

Is there anyway, I could group the dates by ID then find the earliest and latest date?

For example:
<Employee>
<PayDetail PayID="1" WorkDate="9/28/2009">
<PayDetail PayID="1" WorkDate="9/27/2009">
<PayDetail PayID="1" WorkDate="9/26/2009">
<PayDetail PayID="1" WorkDate="9/29/2009">
<PayDetail PayID="1" WorkDate="9/30/2009">

<PayDetail PayID="1" WorkDate="10/3/2009">

<PayDetail PayID="2" WorkDate="10/4/2009">
<PayDetail PayID="2" WorkDate="10/5/2009">

<Employee>

I want the output to be:
<Result>
<ResultRow PayID="1" EarliestDate="9/26/2009" LatestDate="9/30/2009" />
<ResultRow PayID="1" EarliestDate="10/3/2009" LatestDate="10/3/2009" />
<ResultRow PayID="2" EarliestDate="10/4/2009" LatestDate="10/5/2009" />
</Result>

So the input message will not include any weekend dates. so if the records are crossing more than one week, only has weekdays, but seperates result into different ResultRow .

I have tried to use pure XSLT, but it doesn't work because in XSLT you can not update a variable's value everytime you find a earlier or later date. So it seems it has to be done in inline C#.

Anyone got any suggestion?

Thank you.

Biztalk 2009 Oracle Adapter two Package Procedures with same schema/package name/function name in two different databases

Thu, 26 Nov 2009 14:42:16 Z

Hi,

I have the same Schema.Package.Procedure on two different Oracle Database PDO.PO_CE_WS.PROCCESS_MESSAGE

Let's say one is Spain database and other Italy one.

When I generate an assembly for Italy and deploy everything goes well, when I deploy spain that uses the same procedure (but in his own database), even if they are in separate applications, as schema should be unique on Management Database I run into a problem that both schema namespace+rootnode generated from Oracle Adapter has the same matching type, so Italy assembly is load.

I tried to use Prefix and Generate Unique Schema names options on Oracle WCF Adapter generator with no luck....

Is there a configuration option or workaround I can apply to solve this, (final scenario handles up to six database with same use case)

Thank you so much

Custom disassembler pipeline component.

Wed, 25 Nov 2009 20:27:28 Z

Hi all,

I have written a custom disassembler pipeline component to split a batch of messages in a txt file. I managed to add the signed dll to the GAC and copied the dll to the <drive
>:\Program Files\BizTalk Server 2009\Pipeline Components\*.dll. Everything went well after creating a new Biztalk project with a custom pipeline in it using the custom build disassembler. The pipeline could be deployed to the server. After this I created a Receive port of the type FILE using the custom pipeline to receive the txt file. I also created a send port forwarding the splitted messages in xml. After starting the application and dropping in a file, the message is suspended indicating an error in the receive pipeline. When I look at the error message it tells me that the Application dll created in the deployment step of the BizTalk project isn't found in the GAC. When I query the GAC It is present with the right version and key. Anybody experienced a simular problem ?

I am using BizTalk Server 2009 on Windows 2008 Server by the way.

Resuming / Terminating an Service Instance Programatically

Fri, 27 Nov 2009 17:14:33 Z

There's a way to get the list of suspended service instances and programatically resume or terminate them?

My goal is to make a ASP.NET page where these service instances are displayed and the users can take some action on them (Resume / Terminate).

Thanks in advance.

Willians S. Schneider

Node/attribute font grayed out for Destination Schema nodes in Mapper...

Fri, 27 Nov 2009 17:22:51 Z

Hello Everyone - what does it mean when the BizTalk 2009 Mapper grays out the font used for the nodes/attributes in the Destination Schema pane? The node/attribute font in the Source Schema pane is normal black. I can connect links and functoids normally and the map validates and tests.

- Anthony

Retrieving content from multipart message in pipeline component

Fri, 27 Nov 2009 15:22:44 Z

I want to retrieve data one of my body parts in the multipart message.

I've got something like this:

Stream whatever = pInMsg.GetPart("msgHL7").GetOriginalDataStream();

Then I read in the stream and output it using a streamwriter.

The content I get is like this:

<?xml version="1.0"?>
<string>my msgHL7 content</string>

Is there a way to just get the "my msgHL7 content" part without the surrounding XML stuff?

logging schema check failure on a Web Service

Thu, 26 Nov 2009 16:40:13 Z

Hi Folks,
Sorry about the basic question. I'm sure this is answered somewhere else, I just can't find it!

When I send SOAP messages to my web service with a valid XML message, I get a http 202 response from IIS. And the message goes into BizTalk. When the message has something causing an xml validation failure, I get a 200 ('OK') response. And no message in BizTalk. And no error message anywhere!

Is there some place I can see the error message looged? Like the detail of the schema validation fail. Ideally, I would also return the schema validation message with the http response.

thanks!
JS

Validate an xml file against DTD in BizTalk process

Thu, 26 Nov 2009 12:12:07 Z

Hello All,

I have a schenario, where, BizTalk receives a .zip file. The content of the .zip file will be one .xml file and one .dtd file. I need to validate the xml against the dtd file before starting the actual process.

(Note: each zip file will have its own xml and dtd file)

How to achieve this in BizTalk.

BizTalk Beginner

BizTalk default pipeline fails with error code 80070005

Wed, 25 Nov 2009 20:19:10 Z

We have a BizTalk solution where in some cases a message can contain a large 'blob' in the form of a byte array.. If the total message size is around 800-900k everthing works fine. However, once the message size get above about 1MB we get an error:

There was a failure executing the receive pipeline: "Microsoft.BizTalk.DefaultPipelines.PassThruReceive, Microsoft.BizTalk.DefaultPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Source: "Unknown " Receive Port: "<PortName>" URI: "<URI>" Reason: 0x80070005

The message is being submitted via the SOAP adapter. This only seems to happen in some environments. In our development enviroment, I can send messages of around 3MB through with no problems.

I Suspectit may be permission related but I can't work out what. Any help would be appreciated.

Thanks

Nigel Tunnicliffe

Global Naming

Thu, 26 Nov 2009 12:45:09 Z

Whenever i redeploy my Biz talk application it ask for new key , new port location . tell me some solution for this .
thanks .

Binding later

Fri, 27 Nov 2009 06:52:41 Z

when i deploy my biztalk application using binding now option . its works perfectly . but when i do bind later . it not works .
what i m doing . at later binding . i just create one send port and one receive port , define location thats it .

is it necessary to give filter at send port .

please rply .

BizTalk 2009 64-bit Installation

Thu, 26 Nov 2009 14:57:57 Z

Hi All,

Please help in finding the BizTalk 2009 installation on windows server 2008 on 64-bit.
Also 64-bit cab file.

Thanks in advance
Krishna

Error Handling into EDI Disassembler

Wed, 25 Nov 2009 16:07:27 Z

I have an issue where I need to catch the exception that happen into Receive Pipeline more specific in EDI Disasembler. and send the Error Description and the body of EDI File (flat file) to another orchestration.

I tried with one Send port that is suscribed to the Receive port and applied the filter BTS.AckReceivePortName == ReceivePort but this option only catch the Xml with NACK and there I get the Error Descrption. Then...

I tried other option Activating Enable Routing for Failed Messages in ReceivePort and into Send Port I filter by ErrorReport.ReceivePortName == ReceivePort but this option only catch the original copy from EDI File

then I tried to combine them both options but doesnt work....

anyone have any idea?

thanks in advanced

Congestion At Send Port

Thu, 26 Nov 2009 12:07:48 Z

Hi,
I am facing congestion at send port while sending message to CRM system.
Here is the detail,
I am receiving huge message from front end which contains 2000 reocords which i need to insert into CRM system.previously x-path debatching was used but it was taking long time. We changed it to port level debatching so 2000 messages are getting injected into message box after splitting at port level. This has improved the performance drastically. But we started facing another issue. We started gettign followign error.

The adapter failed to transmit message going to send port "SP_ZZZ" with URL "http://crmd01". It will be retransmitted after the retry interval specified for this Send Port. Details:"The operation has timed out".

We identified that there is some operation (validation) which is exceuted at CRM end for every record insertion. I feel we are in a situation where there are lot of messages ready to be pushed at CRM send port but they are gettign qued up. We have confirmed that the messages are getting into system inspite of the error (it must be because the retry interval is by default 3). The only issue that we see is how to get rid of these errors gracefully.

We though of reducing the sendhost throttling to reduce the rate override factor but it did not work out.

IMP:- Please note that we do not face these errors for a service which does not implement any validation at CRM end.

Any help on this will be highly appreciated.

Thanks With Regards, Shailesh Kawade

Consuming WCF Service in Biztalk App

Thu, 26 Nov 2009 12:43:01 Z

any body please tell me how to consume WCF service . send me important tutorial related this . i need it urgent plz help me . my id is mohit_gupta_akgec@hotmail.com

Clustered SSO database connection error on server startup

Wed, 25 Nov 2009 10:32:28 Z

Hi

We've implemented a Clustered SSO resource on our SQL cluster and created a separate BT 2009 server pointing at this. This appears to be working fine in general.

But on BT server restart, we get an ENTSSO connection error (The SSO service failed to start. Error code: 0x800710D9, unable to read from or write to the database)

However, if we now manually restart the service it connects without error. Or if we set the service to manual, and start the service after the server has come up, it starts fine. So it appears to be a service dependency issue - ie SSO is trying to start before it should. Has anyone experienced this before? We are running Win2003, so don't have an option in the services applet to delay service startup by a set interval .

I've googled this and changed some of the suggested settings - in DTC, I've set the security to require No Authentication. TCPIP is the first protocol in the SQL Client List.

Anyone have any insight on this?

Thanks

Ewan

If you have found this post helpful, please click the 'Vote as Helpful' link (the green triangle and number on the top-left).

If this post answers your question, click the 'Mark As Answered' link below. It helps others who experience the same issue in future to find the solution.

Is there a way to use an Excel file as a source document in BT 2009?

Mon, 23 Nov 2009 22:33:27 Z

I would like to use Excel data as source for BizTalk 2009... including creating the schema, etc. Can this be done? If so, is there any documentation or examples for it?

How to loop through the values in a message?

Sat, 21 Nov 2009 03:40:54 Z

I have a message, the structure is like:
<Root>
    <Employees>
       <Employee PayCategoryID="1">
         <PayDetails>15</PayDetails>
         <PayDetails>20</PayDetails>
         <PayDetails>30</PayDetails>
       </Employee>
       <Employee PayCategoryID="2">>
         <PayDetails>10</PayDetails>
         <PayDetails>20</PayDetails>
         <PayDetails>15</PayDetails>
       </Employee>
    </Employees>
    <PayCategorys>
        <PayCategory PayCategoryID="1" />
        <PayCategory PayCategoryID="2" />
    </PayCategory>
</Root>

If I want to search through the message and calculate the total Pay of each employee by adding all the PayDetails value for that employee together, what functoid I could use? Or using a customize XSLT file?

Thank you.

serialization in Orchestration

Thu, 26 Nov 2009 12:58:35 Z

How to enable serialization in Orchestration & why ? Please share with me .

Disable BAM Tracking

Thu, 26 Nov 2009 04:59:10 Z

How to disable BAM Tracking globally from BizTalk 2009 configuration or from sql server database

and then Enable back?

Thanks

Surendra Singh

ftp adapter password modification

Thu, 26 Nov 2009 16:53:04 Z

Hello Biztalk,

I am deploying biztalk applications and I was wondering about one subject.

I have some flows with FTP receive ports And/Or FTP send ports
I have set all the configurrations for these ports and have exported the bindings for later deployements.

But in the case the exploitation people decide to change the FTP logins and password, we will have to configure again the ports and export egain the bindings, so I was wondering if it was possible to make login and password configurable.

It seems that it is possible to do that in orchestration

msgOutput = msgInput;
msgOutput(FTP.UserName) = System.Configuration.ConfigurationManager.AppSettings["FTPUserName"];
msgOutput(FTP.Password) = System.Configuration.ConfigurationManager.AppSettings["FTPPassword"];

+ biztalk configuration file

<appSettings>
  <add key="FTPUserName" value = "UserName"/>
  <add key="FTPPassword" value = "Password"/>
</appSettings>

but only for send ports, with message context properties.

Can you guys tell me if there is a way to make login and password configurable for FTP receive ports ??

Thanks for your Help.

BizTalk + Master Data Services architecture

Thu, 26 Nov 2009 09:44:12 Z

Hi there,

can anyone please guide me to some BizTalk + Master Data Services architectures? Some pictures will be very helpful

thank a lot

Mike

connect to exchange server using BizTalk Server 2006

Mon, 14 Jan 2008 21:41:20 Z

Q: Is there an example that allows me

>> to read a mailbox (for example mymailbox on exchange server) ;

>> after reading email or receiving every new email, sends to another mailbox/email on the same exchange server?

using BizTalk Server 2006.

Or do I need to write custom adapter for this?

Thank you.

BTARN Configuration on Win2k8 virtual machine issue

Thu, 26 Nov 2009 11:07:23 Z

Hello,

I'm trying to install and configure the BizTalk RosettaNet Accelerator 3.5 Standard Edition for BizTalk Server 2009 Developer Edition on a Windows Server 2008 x64 virtual pc.
When I configure the runtime feature, the configuration fails. In the Logfile at the end of file I see following log-messages:

[11:30:17 Error RNConfig] c:\depot\europa2009\private\europa_source\btarnconfig\dll\rnconfig.cpp(985): FAILED hr = 80004005

[11:30:17 Info RNConfig] Leaving function: CRNConfig::ConfigureFeature
[11:30:17 Warning Configuration Framework]Feature failed to configure: Runtime.
[11:30:18 Info Configuration Framework]Configuration Summaries:
[11:30:18 Error Configuration Framework]Feature: [Runtime] Failed to configure with error message [Configuration Wizard is unable to verify your network connection. A valid network connection is required.]
[11:30:18 Info Configuration Framework]	Feature: Runtime	Configuration Enabled: yes	Sub UI: no	Configured: no
[11:30:18 Info Configuration Framework]	Feature: WebApps	Configuration Enabled: yes	Sub UI: no	Configured: yes

Does anybody know this issue and how to solve it??

kind regards,
paulrem

Wcf message issue when coming from orchestration

Wed, 25 Nov 2009 17:52:25 Z

I have a wcf send port that calls an external wcf service. This wcf send port subscribe to all message of a specific messageType through a filter.

When I am using a file receive location and drop one of this message, I have no problem. The wcf send port pick up the message in the message box and sent it.

But when I create the same message type inside an orchestration and use a direct port (to send the message to messagebox), the wcf send port generate this error:

"The message could not be processed because the action 'myActionHere' is invalid or unrecognized".

I have stop the send port to compare the two files coming from the different path and the only thing I can see is that in the case of the message coming from the orchestration the message have a "part" and not a "Body".

Does someone know why a message coming from an orchestration is different and how can I workaround this issue.

Thanks for your help.

how to get the no of suspended and running instances of a biztalk application from external web application?

Thu, 26 Nov 2009 10:31:34 Z

hi,

I am developing a web application for biztalk server support. can any body give an idea how to get the no of instances both running and suspended instances from a web application?

Newbie help need for a simple DB2 poll to SQL insert

Tue, 24 Nov 2009 12:03:50 Z

Dear all,
i'm new to Biztalk 2009 and tryed to get a simple job up and running, i have to select some data out of a DB2 table in a cycle by seconds, and insert them into a SQL table on a SQL server. Inside this i need to convert the data.

I use Dataadapter pack and can build a send/receive port for DB2 access and SQL access, but i got lost in how todo the logic and configuration this in Biztalk 2009 VS 2008 project. There are so many options :-(, is there anybody who can give me a step-by-step howto or a sample project which include polling from a table, modify data and insert them into a sql table by polling?

Many thanks,
Ingo

BizUnit SOAPHTTPRequestResponseStep Peculiarity

Thu, 26 Nov 2009 10:43:12 Z

Hi,

I am trying to put together a BizUnit test to call a number of BizTalk web services, and have found myself at a bit of a curious road block.

So far I have three web service calls defined for use with BizUnit, in NUnit these present themselves as:

BizUnitTests

Arrears

ArrearsAccountData

GetArrearsAccountData

ArrearsGeneralDetails

GetArrearsGeneralDetails

UpdateArrearsGeneralDetails

The ones in bold are the individual tests, each doing a simple call to a web method. The Getxxxx methods are both on the same web services, whereas the Update is on a seperate web service. They are all of the type:

<TestExecution>
      <TestStep assemblyPath="" typeName="BizUnit.SOAPHTTPRequestResponseStep">
           <WebServiceWSDLURL>http://d-cbsbiz02/EAEArrearsServices/Inquiries.asmx?WSDL</WebServiceWSDLURL>
           <ServiceName>Inquiries</ServiceName>
           <WebMethod>GetArrearsAccountData</WebMethod>
           <InputMessageTypeName>GetArrearsAccountDataRequest</InputMessageTypeName>
         <MessagePayload>C:\SourceSafe\Testing\CBS\BizTalk\BizUnitTests\Arrears\ArrearsAccountData\GetArrearsAccountDataRequest.xml</MessagePayload>

     <ValidationStep assemblyPath="" typeName="BizUnit.XmlValidationStep">
           <XmlSchemaNameSpace>http://XML.Schemas.Arrears.WebServices.GetArrearsAccountDataResponse</XmlSchemaNameSpace>
           <XPathList>
               <XPathValidation query="/*[local-name()='GetArrearsAccountDataResponse' and namespace-uri()='']/*[local-name()='Body' and namespace-uri()='']/*[local-name()='ArrearsAccountData' and namespace-uri()='']/*[local-name()='AccountNumber' and namespace-uri()='']">12121212</XPathValidation>
              <XPathValidation query="/*[local-name()='GetArrearsAccountDataResponse' and namespace-uri()='']/*[local-name()='Body' and namespace-uri()='']/*[local-name()='ArrearsAccountData' and namespace-uri()='']/*[local-name()='AccountName' and namespace-uri()='']">smith</XPathValidation>
    </XPathList>
   </ValidationStep>
  </TestStep>
</TestExecution>

<TestCleanup>
</TestCleanup>
</TestCase>

The problem I have is that when I run the full test, the Getxxx tests are successful, and the Updatexxx fails with:

System.TypeLoadException: Could not load type 'BizUnit.Proxy.UpdateArrearsGeneralDetailsRequest' from assembly 'TestFrameWorkProxy0, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null'

If I then reload the tests and run only the Updatexxx test this is then sucessful. Following this if I run any of the Getxxx tests they will fail with the error type as seen above.

Reloading the tests and running a Getxxx test first will succeed, but will then break the Updatexxx test!

It is as though the first test to run is causing something to get stuck, preventing any successful tests of the other web service.

If anyone has any ideas, please let me know.

Cheers

Stu.

BizTalk 2009 Multi-Computer Configuration Error

Wed, 25 Nov 2009 14:32:34 Z

I'm installing BizTalk Server 2009 in a multi-computer environment and receiving an 'Access Denied' error during configuration as shown in the log excerpt below:

[8:57:50 AM Info ConfigHelper] Validated service credentials for account: DOMAIN\btservice
[8:57:51 AM Info ConfigHelper] DOMAIN\BIZTALK-APP-GROUP is a valid domain group.
[8:57:51 AM Error ConfigHelper] f:\bt\890\private\source\common\prod\btscommon\configwizard\confighelper\confighelper.cpp(953): FAILED hr = 80070005

[8:57:51 AM Error ConfigHelper] Check for membership of DOMAIN\btservice in Group DOMAIN\BIZTALK-APP-GROUP failed. Reason: Access is denied.
[8:57:51 AM Error ConfigHelper] Access is denied.
[8:57:51 AM Error ConfigHelper] f:\bt\890\private\source\common\prod\btscommon\configwizard\confighelper\confighelper.cpp(1447): FAILED hr = 80070005

[8:57:51 AM Error BtsCfg] f:\bt\890\private\source\setup\prod\btssetup\btscfg\btscfg.cpp(3456): FAILED hr = 80070005

I'm performing a custom configuration in the BizTalk configuration tool. Configuration of Enterprise SSO and BizTalk Group proceeds without error. On the BizTalk Runtime configuration page the BizTalk Host Instance Account value is prepopulated with the domain account I entered at the beginning of configuration. When I enter the domain group name for the BizTalk Host Users Group the icon next to the BizTalk Host Instance Account entry turns from a person icon to a red-circled X icon. The associated error message is 'Access denied' as shown in the log above.

Here are some facts about the environment:

BTS 2009 is installed on a 64-bit Windows Server 2003 Enterprise R2 SP2 machine

Sql Server 2008 SP1 is installed on a 32-bit Windows Server 2003 Enterprise R2 SP2 machine

The account being used to configure BizTalk is a domain account, and is a local administrator on the BizTalk machine and on the Sql Server machine

All accounts and groups entered in the configuration are domain accounts and groups

BizTalk is being configured as a new BizTalk group

This is a brand-new installation of BizTalk, and our first in the multi-computer environment. There certainly seems to be a permissions issue, but what permissions might be lacking?

Thanks,
Mike

Extracting the Xml of a message?

Thu, 19 Nov 2009 17:21:27 Z

In my orchestration, there is an assignment shape, that assigns a message to another message using an XMLDocument object as in the snippet below:

objXml = new System.Xml.XmlDocument();



objXml = Msg_Input;



Msg_SQLRequest.parameters.StoredProc1.InputXmlText = objXml.OuterXml;

What this does is that, it produces an Xml with the desired NameSpace for the root (as specified in the Target Namespace property of the schema). However all the child nodes are written with the dreaded xmlns="" as an attribute.

I'm familiar with the process to avoid the blank or empty xmlns attributes where we add nodes explicitly - by specifying the Root node's namespace for all the child elements . But here the Namespace property is disabled for all the child nodes in the schema designer.

But in case like the above, is it possible to make the Child Nodes inherit the Target Namespace of the schema?

Adjusting the Schema properties *is* an option.

Is there is a better way to extract the Xml out of the Msg_Input ?

Thank you.

objXml is a Variable in Orchestration

BizTalk To Sharepoint

Mon, 23 Nov 2009 16:00:47 Z

Hello All,

I posted an issue few days back regarding Inserting a list item from BizTalk. (http://social.msdn.microsoft.com/Forums/en-US/biztalkgeneral/thread/a10a292f-3b0a-431b-8c4a-7546eeddf22e/)
I finally achieved this by calling the WS provided by Sharepoint (eg: http://[Host]/lists/_vti_bin/lists.asmx) using WCF-Custom adapter with basichttp binding. I mentioned the

It is working perfectly in my local environment. However, in the DEV box, i dont have access to sharepoint sites.
So, i tried utilizing "mysite" feature, where-in i create a list and tried accessing from BizTak using WCF-Custom adapter with the same configuration which i used in my local machine. But, this time i got the following error:

Details:"System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at http://[Host]:[port]/Lists/_vti_bin/lists.asmx that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. ---> System.Net.WebException: The remote server returned an error: (404) Not Found.

WCF-Custom Adapter Config: under Binding, i set the Security as TransportCredentialOnly, and Transport (clienttypecredential as "Windows").

Pls letme know what am doing wrong.

Regards

BizTalk Beginner

Error on the send pipeline

Mon, 28 Jul 2008 19:48:38 Z

I get this error on the send pipeline

There was a failure executing the send pipeline: "BTAHL72XPipelines.BTAHL72XSendPipeline, BTAHL72XPipelines, Version=1.3.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Source: "BTAHL7 2.X Assembler" Send Port: "SendOrm_TEST" URI: "C:\ORMOUT\%MessageID%.txt" Reason: Finding the document specification by message type "http://microsoft.com/HealthCare/HL7/2X#ORM_O01_22_GLO_DEF" failed. Verify the schema deployed properly.

How to get the earliest date and latest date in a loop of a message?

Wed, 25 Nov 2009 03:01:50 Z

I have a scenario which needs to find what the earliest and latest date inside a loop of records.
The date is stored in a attribute of the record:
<Employee>
<PayDetail PayID="1" WorkDate="9/26/2009">
<PayDetail PayID="2" WorkDate="9/27/2009">
<PayDetail PayID="3" WorkDate="9/28/2009">
<PayDetail PayID="4" WorkDate="9/29/2009">
<Employee>

Do I convert the value in WorkDate into DateTime first, then compare it? Or what's the best way to find out the earliest date(9/26/2009) and latest date ("9/29/2009") from this message?

Thank you.

BizTalk Diagnostic library by Greg

Wed, 21 Oct 2009 18:28:20 Z

Hi,

I am very much impressed with BizTalk diagnostic library & i downloaded it to my development server.But i would like to know has anybody used the Diagnostic library & if yes how do i change the namespace & create a MSI so that it caters to my company needs.

Thanks Greg for all your help.

chirag

How to export the Unbound ports using BTSTask.exe?

Wed, 18 Nov 2009 19:28:40 Z

Hi,

To export the unbound ports using BTSDeploy.exe in BizTalk 2006, we have an argument called "UNBOUNDPORTS"

How can i do this using BTSTask.exe in Biztalk 2009?

Thanks

Kumsi

Publish Web Service Wizard problem - extra xmlns=""

Wed, 25 Nov 2009 17:31:52 Z

Hi All,

I have a schema that I want to publish as a web service.

After I run through the wizard, I see that all my elements have an attribute of xmlns="" attached to it. How can I get rid of it?

My schema:

<?xml version="1.0" encoding="utf-16"?>
<xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003" targetNamespace="http:/test/ReceivingWS/" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="ReceiveHL7Message">
    <xs:complexType>
      <xs:sequence>
        <xs:element name="orgID" type="xs:string" />
        <xs:element name="password" type="xs:string" />
        <xs:element name="msgHL7" type="xs:string" />
      </xs:sequence>
    </xs:complexType>
</xs:element>
</xs:schema>

My web service looks like this:

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
    <WebMethod1 xmlns="http://tempuri.org/">
      <ReceiveHL7Message xmlns="http://test/ReceivingWS/">
        <orgID xmlns="">string</orgID>
        <password xmlns="">string</password>
        <msgHL7 xmlns="">string</msgHL7>
      </ReceiveHL7Message>
    </WebMethod1>
</soap:Body>
</soap:Envelope>

Schema Advice

Tue, 24 Nov 2009 20:38:23 Z

I'm a newbe to BizTalk and trying to build a schema for the following CSV flat file.

"AX","20090417033325","SORD","HEAD","215567","WHSE","FHT","FHT","6299641497","20090417033325","20090417033325","20090418120000","201ANHSC","8786189","aaa"
"AX","20090417033325","SORD","BILL","215567","WHSE","BILL","608 SW 8TH ST","","","SAM'S 6299","BENTONVILLE","AR","","US","72712","",""
"AX","20090417033325","SORD","SHIP","215567","WHSE","SHIP","23701 W SOUTHERN AVE","SAM'S 6299","BUCKEYE","AZ","MARICOPA","US","85326","",""
"AX","20090417033325","SORD","LINE","215567","WHSE","1","81000480",864.00,"CS"
"AX","20090417033325","SORD","LINE","215567","WHSE","2","82946330",245.00,"CS"
"AX","20090417033325","SORD","LINE","215567","WHSE","3","11299",23.00,"EA"
"AX","20090417033325","SORD","HEAD","215568","WHSE","FHT","FHT","6299641497","20090417033325","20090417033325","20090418120000","201ANHSC","8786189","aaa"
"AX","20090417033325","SORD","BILL","215568","WHSE","BILL","608 SW 8TH ST","","","SAM'S 6299","BENTONVILLE","AR","","US","72712","",""
"AX","20090417033325","SORD","SHIP","215568","WHSE","SHIP","23701 W SOUTHERN AVE","SAM'S 6299","BUCKEYE","AZ","MARICOPA","US","85326","",""
"AX","20090417033325","SORD","LINE","215568","WHSE","1","81000480",864.00,"CS"
"AX","20090417033325","SORD","LINE","215568","WHSE","2","82946330",245.00,"CS"
"AX","20090417033325","SORD","LINE","215568","WHSE","3","11299",23.00,"EA"

The forth field in each row identifies what kind of line it is. "HEAD", "BILL", "SHIP", or "LINE". Each "order" will have one "HEAD", "SHIP", and "BILL" and one or more "LINES". I've built a schema that works great if I only have one set of rows, even with multiple "LINE" rows but as soon as I have more than one of rows (line 7 above) it errors out with what I think is an error indicating that it is trying to validate the "HEAD" row to the "LINE" record.

Right now I've got a root node and four record type nodes in my schema, one for each of my four different type of lines. The first three record nodes all have MinOccurs and MaxOccurs set to 1 and 1. The last has no MinOccurs and a MaxOccurs set to "unbounded".

I tried using the Tag property but that only works when the tag is the first thing in the row.

Any suggestions would be most appriciated?