BizTalk Server General Forum

Problem with a SalesOrder sent to Dynamics AX AIF

Wed, 02 Dec 2009 09:56:45 Z

Hi all.

I want to create a sales order in BizTalk and sent it to Dynamics AX using the BizTalk Adapter from Dynamics AX 2009. I can connect to the AOS of BizTalk and my message gets delivered to AX. But there is an error in the message I cannot get rid of.

The message is:
Invalid document schema. The element 'SalesLine' in namespace 'http://schemas.microsoft.con/dynamics/2008/01/documents/SalesOrder' has invalid child element 'InventDim' in namespace 'http://schemas.microsoft.con/dynamics/2008/01/documents/SalesOrder'. Expected list of possible elements: 'SalesStatus, SalesType, SalesUnit' in namespace 'http://schemas.microsoft.con/dynamics/2008/01/documents/SalesOrder'. (translated from german...)

I do not use the element 'InventDim' in my mapping, it should not be generetad. But as you can see in the XML-file it has been generated. How can I get rid of this element, what do I do wrong?

The message generated in BizTalk is a <Project>.SalesOrderService_create_Request message.

<? xml version="1.0" encoding="utf-8" ?>

- < Envelope xmlns =" http://schemas.microsoft.com/dynamics/2008/01/documents/Message " >

- < Header >

< MessageId > {6490678c-5560-4ede-83fa-c9b7c11e1d26} </ MessageId >

< SourceEndpoint > RemoteEP </ SourceEndpoint >

< DestinationEndpoint > LocalEP </ DestinationEndpoint >

< Action > http://schemas.microsoft.com/dynamics/2008/01/services/SalesOrderService/create </ Action >

< RequestMessageId > {6490678c-5560-4ede-83fa-c9b7c11e1d26} </ RequestMessageId >

</ Header >

- < Body >

- < MessageParts >

- < ns0:SalesOrder xmlns:ns0 =" http://schemas.microsoft.com/dynamics/2008/01/documents/SalesOrder " xmlns:xsi =" http://www.w3.org/2001/XMLSchema-instance " >

< ns0:DocPurpose > Original </ ns0:DocPurpose >

< ns0:SenderId > 1101 </ ns0:SenderId >

- < ns0:SalesTable class =" entity " >

< ns0:CurrencyCode />

< ns0:CustAccount > 1102 </ ns0:CustAccount >

< ns0:DeliveryDate > 2009-11-30 </ ns0:DeliveryDate >

< ns0:DeliveryName > Testlieferung </ ns0:DeliveryName >

< ns0:DeliveryState />

< ns0:DeliveryStreet />

< ns0:DeliveryZipCode />

< ns0:PurchOrderFormNum > 0001 </ ns0:PurchOrderFormNum >

< ns0:SalesUnitId > 0001 </ ns0:SalesUnitId >

- < ns0:SalesLine class =" entity " >

< ns0:ItemId > 0815 </ ns0:ItemId >

< ns0:LineNum > 1 </ ns0:LineNum >

< ns0:SalesQty > 123 </ ns0:SalesQty >

< ns0:InventDim class =" entity " />

< ns0:DocuRefLine class =" entity " />

< ns0:MarkupTransLine class =" entity " />

</ ns0:SalesLine >

< ns0:DocuRefHeader class =" entity " />

< ns0:MarkupTransHeader class =" entity " />

0068

</ ns0:SalesTable >

- < ns0:SalesTable class =" entity " >

< ns0:CurrencyCode />

< ns0:CustAccount > 1102 </ ns0:CustAccount >

< ns0:DeliveryDate > 2009-11-30 </ ns0:DeliveryDate >

< ns0:DeliveryName > Testlieferung </ ns0:DeliveryName >

< ns0:DeliveryState />

< ns0:DeliveryStreet />

< ns0:DeliveryZipCode />

< ns0:PurchOrderFormNum > 0001 </ ns0:PurchOrderFormNum >

< ns0:SalesUnitId > 0001 </ ns0:SalesUnitId >

- < ns0:SalesLine class =" entity " >

< ns0:ItemId > 0815 </ ns0:ItemId >

< ns0:LineNum > 1 </ ns0:LineNum >

< ns0:SalesQty > 123 </ ns0:SalesQty >

< ns0:InventDim class =" entity " />

< ns0:DocuRefLine class =" entity " />

< ns0:MarkupTransLine class =" entity " />

</ ns0:SalesLine >

< ns0:DocuRefHeader class =" entity " />

< ns0:MarkupTransHeader class =" entity " />

0068

</ ns0:SalesTable >

- < ns0:SalesTable class =" entity " >

< ns0:CurrencyCode />

< ns0:CustAccount > 1102 </ ns0:CustAccount >

< ns0:DeliveryDate > 2009-11-30 </ ns0:DeliveryDate >

< ns0:DeliveryName > Testlieferung </ ns0:DeliveryName >

< ns0:DeliveryState />

< ns0:DeliveryStreet />

< ns0:DeliveryZipCode />

< ns0:PurchOrderFormNum > 0001 </ ns0:PurchOrderFormNum >

< ns0:SalesUnitId > 0001 </ ns0:SalesUnitId >

- < ns0:SalesLine class =" entity " >

< ns0:ItemId > 0815 </ ns0:ItemId >

< ns0:LineNum > 1 </ ns0:LineNum >

< ns0:SalesQty > 123 </ ns0:SalesQty >

< ns0:InventDim class =" entity " />

< ns0:DocuRefLine class =" entity " />

< ns0:MarkupTransLine class =" entity " />

</ ns0:SalesLine >

< ns0:DocuRefHeader class =" entity " />

< ns0:MarkupTransHeader class =" entity " />

0068

</ ns0:SalesTable >

</ ns0:SalesOrder >

</ MessageParts >

</ Body >

</ Envelope >

BizTalk Server Virtualization

Wed, 02 Dec 2009 09:36:31 Z

Hi,

One of the features MS used to market BizTalk Server 2009 is Hyper-V support. I wonder (from technical perspective) why this is named as a new feature for BizTalk? What makes BizTalk 2009 different from BizTalk 2006 (r2) regarding Hyper-V support?

Also are there any performance numbers available for running BizTalk on Hyper-V compared to VMWare?

TIA

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

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

split schema into multiple xml types

Mon, 30 Nov 2009 15:27:14 Z

I have a schema with multiple xml types and i want to split it. I can split only if one single schema type inside the envelop but multiple xml type i cant. Is there any other way to do this?

Thanks, Raja

Message Property vs param @uidMsgID

Wed, 02 Dec 2009 01:18:07 Z

Hi,

Anyone knows what Message Property is related to the param @uidMsgID from store procedure bts_GetTrackedMessageParts?

Im trying to get the original file from Biztalk DB, I using some examples from differents forums and almost all of them refer to this SP, but I dont know what message property is the right.... I tried with BTS.MessageID value but doesnt work, well, not exists into outcome from SP...

Thanks in Advanced

XML with no namespace and the BizTalk Mapper

Wed, 02 Dec 2009 04:30:21 Z

I have an xml document that a partner sends to us with no namespaces. I use the ESB Add Namespace in a pipeline to add a namespace to the xml document and use a BizTalk map to convert that document from one xml format to another. The problem I am having is that the map does not produce any output.

xml document from partner:

<Acknowledgement>
	<AcknowledgementDetails>
		<TotalNumberOfRecords>100</TotalNumberOfRecords>
		<NumberOfRecordsProcessed>90</NumberOfRecordsProcessed>
		<NumberOfErrors>10</NumberOfErrors>
	</AcknowledgementDetails>
</Acknowledgement>

xml document after ESB Add Namespace component:

<ns7:Acknowledgement xmlns:ns7="http://SomeNS/Acknowledgment">
	<AcknowledgementDetails>
		<TotalNumberOfRecords>100</TotalNumberOfRecords>
		<NumberOfRecordsProcessed>90</NumberOfRecordsProcessed>
		<NumberOfErrors>10</NumberOfErrors>
	</AcknowledgementDetails>
</ns7:Acknowledgement>

Map output:

<ns0:RecordInsert xmlns:ns0="http://SomeNS/RecordInsert">
	<ns0:TotalNumberOfRecords></ns0:TotalNumberOfRecords>
	<ns0:NumberOfRecordsProcessed></ns0:NumberOfRecordsProcessed>
	<ns0:NumberOfErrors></ns0:NumberOfErrors>
</ns0:RecordInsert>

As you can see the output has no values. Is there a way to ensure that all of the elements in the xml document are assigned the namespace prefix?

Biztalk vs other services

Wed, 02 Dec 2009 07:46:29 Z

hi to all..
Thanks in advance..
i am new to biztalk server..
i studied some thing about biztalk server.but i am not able to find out what the difference between biz talk server and other services like web services and in which situation we must used biz talk server ?

REDeployWiz.exe is not working

Tue, 01 Dec 2009 12:58:07 Z

Need to test my policy so installed only Business rule composer to one of my co-worker box.
I manually moved the policies and vocabularies. Now need to deploy them to his machine by REDeployWiz.exe.

I couldn't see the REDeployWiz.exe after installed/configured the Business rule composer in his box. Hence manually moved the exe to his box and tried to import the policy and vocabulary but no luck.

Is there anything do i need to install separately or any DB query to import the policies and Vocabularies?

Thanks, Raja

BizTalk BRE RuleBurst Studio Is it still available for use with BRE

Tue, 01 Dec 2009 18:23:12 Z

Is it still avaialbe for use with BRE after Oracle takeover of Haley, if so what is the contact for free evaluation copy.

SQL Send adapter call stored proc with xml datatype

Tue, 01 Dec 2009 17:15:00 Z

Hi

I'm using BizTalk 2009 I want to call a stored proc in SQL Server which accepts only one paramter of datatype XML
How can I achieve this ? The problem is SQL schema generated by Biztalk Creates attribute for input params and I can't copy the XML inside attribute which makes it invalid xml?

Thanks

Vishy

ASP.net and Orchestration

Tue, 01 Dec 2009 19:48:30 Z

Hi,
I have a biztalk solution to get PO request, process it and reply response message. Client want to send the PO request over HTTP. They want something like https://service.companyname.com/po/po.asp. I think, I have to write an asp page to get request, pass it to orchestration, get response from orchestration and reply to customer. How can I do this? How can I call the orchestration or receive port in asp.net?
I can not use BTSHTTPRecive.dll since URL cannot change to above format. I think if I publish the orchestration then it will create web service with extension .asmx but I need .asp format. So I cannot use this one neither. Is there way to call orchestration inside asp page?
Thank you in advance,

Virtual labs training materials

Tue, 01 Dec 2009 22:05:30 Z

Hi,
I am registered microsoft partner with ISV program Empower pack.
I am struggling to find out how I can get materials for course 2933A withiut success.
I have just found some interesting virtual labs which I can download the manuals but not the materials (VS solutions and other associated files). I am not connected 24/24 to internet that is why I need the materials in order to be able to follow the labs during the day
can you please point me how I can get those materials.

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

Decrypting a message response through WCF-Basichttp adapter

Mon, 30 Nov 2009 13:54:36 Z

On encryption, I can enter the security information by specifying the Client Certificate in the Security tab.

If the response I get from the web service call uses a different key to encrypt the data coming back, what is the best way for me to decrypt it?

Table Looping Null value

Sat, 21 Nov 2009 18:47:48 Z

I have a table looping functoid from two possible source fields to multiple destinations. It works perfect as long as the source has data. The problem I am having is when I have a null in the first source then the map throws an error. I then did a logical existence and then map the fields based on the source, but I keep gettting the same error. I have ran out of ideas to base the table looping to ignore the first record if it is null. Its almost as if it was a requirement for table looping. Is there a way to stop this from happening? Thank you in advance

Promotion error for xsd:date

Thu, 22 Oct 2009 10:34:45 Z

Hi I'm using BTS09, VS08. I've got strange problem. I've a schema with xsd:date element which is promoted and distinguished to a node in property schema element of type xsd:date. When I try to retrive value in orchestration it gives me wrong date. It gives me date of yesterday rather than today and also in datetime format rather than pure date. I checked the message itself which has correct date in correct format but its just the distinguished property giving me wrong value???

Is Microsoft paying people to answer these forums and are they therefore loosing their value ?(Please react)

Mon, 30 Nov 2009 14:26:09 Z

I have several questions posted on these MS forums.

But sometimes I see some very bad answers from people who don't know what they are talking about.
Worst is that they propose their own (bad) answer as a solution....
( have a look here to see what i mean : http://social.msdn.microsoft.com/Forums/en-US/biztalkr2adapters/thread/907906ce-68f1-4f4e-8ece-ec6036fac737)

It looks like somebody is paying those people per Solution

Do you have the same experience ? Please let me know in this thread ?

If you cannot trust the answer of a discussion toe be a real answer ( the answer was awarded by the one asking the question) what is the value of marking them as an answer ??

Well0549

Disaster Recovery for high message thoughput and tight SLA's

Tue, 01 Dec 2009 17:20:29 Z

Hi all,

Just wondered if anyone has any thoughts or better still has used any third party products such as Neverfail or DoubleTake to provide a Disaster Recovery Solution for an application which is implemented using Biztalk 2006 R2. It has to support high message throughput and can not lose any messages also the DR switch at peak periods must be able to be turned around within approx. 20 minutes.
I think this type of turn around would be difficult using log shipping and we can not implement SAN replication due to restrictions imposed by our data centre which houses our applications.

Any insight would be much appreciated,

Regards,

Dave

RemoteCertificateNameMismatch. Could not establish trust relationship for the SSL/TLS secure channel.

Tue, 01 Dec 2009 11:53:32 Z

Hi,

I am trying to connect to the partner test web site which is using IP address instead of name for e.g https://256.274.167.246/ghservlet/XMLQuote, it is secured with SSL certificate which is actually the live site certificate and gives the error "RemoteCertificateNameMismatch" when used on browser, however you can ignore it. When this URL is used in Biztalk, I get the error message "Could not establish trust relationship for the SSL/TLS secure channel.". I know the certificate is not issued to 256.274.167.246, its in another name.

Is there a way to get this URL working in Biztalk or I need to ask the partner to issue a correct certificate?

Array in Biztalk 2006

Tue, 14 Aug 2007 09:51:41 Z

Hi All,

I am new in Biztalk thats why i am facing lot of problems,i have to use array in one of my application but i am not getting what will be the type of that variable.Can anyone please send me some sample code related to it.

Thanks in Adance........

Multiple IF/ELSE decesions to me made in an Orchestration to be exposed

Mon, 30 Nov 2009 15:33:30 Z

Hi,

I have got one parent orchestration which is suppose to perform some steps in a particular order and in case some errors occurs during step 2, I don't want to continue to to Step 3, construct the error message and send the same as a response, because this orchestration is supposed to be exposed as a WCF service, so It would receive a message from an external application and it would perform some steps in a particular order and incase and error comes in any step it is not suppose to continue with the next following steps and return back the constructed error message back as a response.

How should I design this orchestration to be ?

BizTalk 2009 64-bit config Sql server using non default port

Tue, 01 Dec 2009 09:18:17 Z

Hi All,

I need to configure to BizTalk Server 2009 where Sql Server running on non default port.
When I giving IP/Server name it's not connecting,but when I enter servername,portname it's working.
but during Group configuration, biztalk is trying to split the name and it's failing.

Any help,

Thanks in advance,
Krishna

Message struck with Orchestration

Tue, 01 Dec 2009 05:42:54 Z

An solution has many orchestrations and a message got struck , how can I find on which Orchestraion the problem has occured. Please advice .

Dehydration

Tue, 01 Dec 2009 04:22:55 Z

is it possible to dehydrate the orchestration on the basis of message content.

SELECT Statement without store procedure in SQLServer

Mon, 30 Nov 2009 17:33:17 Z

Hi all!
I need to query a table but i have no chance to use sps. I need to use a parameter - name - to get all the records that contain that name. How can I do this.

Best Regards

Luis Diego Rojas. http://icomparable.blogspot.com

MCP, MCTS Biztalk Server

Can we make a custom pipeline as a default pipeline?

Tue, 01 Dec 2009 12:08:43 Z

Hi,

Is it possible to make a custom pipeline appear in the BizTalk Administration console by default?

For example - a scenario where a flat file delimited by LF needs to be converted to CR LF. I develop a custom pipeline for this. But even if this is a simple file drop, I will still have to create a solution and deploy it. Now if there is another requirement to do the same, but for a different file, I will have to create a solution again and deploy, etc.

Is there a way to create this custom pipeline (which will convert LF to CR LF in this scenario) and get it in the drop down(like the passThruReceive for example)? Any application that is created later in the Administration console should be able to see this new custom pipeline.

Thanks!

Need to process set of files of which one could be empty file

Mon, 30 Nov 2009 15:21:47 Z

LS,

I have the following situation: I receive a set of two files over FTP. Both files are related and should be processes by the same orchestration through parallel convoy. Correlation is done through filename.
The problem I have is that if one of the files is empty I get an error in my custom receivepipeline stating that "no disassemble stage components can recognize the data".
Is there a way to get around this? I need both files for the parallel convoy to proceed.

Regards René

Inetinfo.exe is always taking at least 25% of processor

Tue, 01 Dec 2009 11:33:35 Z

Hi,

We have a Windows 2003 Server running Biztalk 2003 which has a problem with inetinfo.exe taking up the processor. We have also got this running SMTP mail, so we are not able to turn this off. We have tried stopping the service, but it just restarts.

Has anyone else had this issue, and been able to resolve it?

Thanks

Adding Node and also Attribute value @ runtime using BRE .Net Classes

Tue, 27 Oct 2009 06:18:18 Z

Is it possible to add together new record node and also attribute and its value at runtime using BRE .Net Classes?
using BRE .Net Classes, i could add new node with value and also attribute value separately.

Thanks, Raja

BRE loop

Tue, 24 Nov 2009 13:05:08 Z

I'm having the xml file which is having almost 200+ fields. Using BRE i need to validate each field if anything invalid data of field then need to generate error code [ <ErrorCode Value="CP18" /> ] under the same xml file of each record.

<ns0:NGHPData xmlns:ns0="http://XXX.XXX.XXX.Schema.XXX">
<NGHPRecord>
<RecordNo>1</RecordNo>
<ClientID>XXX</ClientID>
<FileTransferLogID />
<FieldValue_1 />
     -------
     -------
<FieldValue_200 />
<ErrorData ClientID="XXX" FileTransferLogID="YYY" RecordNo="1">
<ErrorCode Value="CP18" />
<ErrorCode Value="CB05" />
</ErrorData>
</NGHPRecord>

<NGHPRecord>
<RecordNo>2</RecordNo>
<ClientID>XXX</ClientID>
<FileTransferLogID />
<FieldValue_1 />
     -------
     -------
<FieldValue_200 />
<ErrorData ClientID="XXX" FileTransferLogID="YYY" RecordNo="2">
<ErrorCode Value="CP18" />
<ErrorCode Value="CB05" />
</ErrorData>
</NGHPRecord>

<NGHPRecord>
<RecordNo>428</RecordNo>
<ClientID>XXX</ClientID>
<FileTransferLogID />
<FieldValue_1 />
     -------
     -------
<FieldValue_200 />
<ErrorData ClientID="XXX" FileTransferLogID="YYY" RecordNo="428">
<ErrorCode Value="CP18" />
<ErrorCode Value="CB05" />
</ErrorData>
</NGHPRecord>
</ns0:NGHPData>

Inside Business rule composer, when i test the policy with 7 MB of xml instance data then getting Memory exception. so created .net application and started to test the client XML data.

The client each xml file is having maximum <RecordNo>428</RecordNo>.

Inside Business rule composer i took 1st and 428 records of 1 xml file and started to test so got the output.
But when i test the 2nd whole XML of 7MB using .net application which generated ADDITIONAL error code at 428th record.

what is the reason the 2nd xml file is populating the additional error codes which are not in 1st xml file.

Thanks, Raja

VS 2008 taking long time adding a fairly large schema to project...

Wed, 25 Nov 2009 16:23:05 Z

Hello Everyone - I'm using BizTalk 2009 with Visual Studio 2008 and am attempting to add a fairly large third-party standard schema (HL7 version 3 subset) to my project. The schema is stored in two separate folders, which I've stored in another folder within my project directory. I did the usual thing to add the schema:

"Show all" files in project folder
Add schema upper-level folder to project

There are six XSD files in one of the sub-folders and 608 XSD files in the other folder. VS 2008 has been chugging now for almost an hour adding the schema to the project. Is this normal for fairly large schemas and is it a sign of further bad things to come? Is the processing time indicative of it traversing various links, etc? Any best practices suggestions that might help me out? Thanks in advance!

- Anthony

Debuging an Orchestration

Tue, 01 Dec 2009 07:37:12 Z

Can any one explain me on how to debug an Orchestrion ? Please.

BizTalk 2009 64-bit configuration error

Mon, 30 Nov 2009 12:21:57 Z

Hi All,

When I try to configure the BizTalk 2009 on windows 2008 r2, It's Not able to connect to SQL Server which is on different Machine.
When I try to ping,it's getting response, but from configuration screen, it's throwing Error.

following is the error.

The database server you specified cannot be reached. Make sure you have specified the correct server name and that the server is currently running.A networt related or instance-specific error occured while establishing a connection to SQL Server. The Server was not found or was not accessible.Verify that the instance name is correct and that SQL Server is configured to allow remote connection.(provider: SQL Network Interfaces,error: 26 - Error Locating Server/Instance Specified)

Thanks in advance
Krishna

BizTalk Mapping

Mon, 30 Nov 2009 21:40:17 Z

I have a Scenario in Map Where In Input I have datetime element ...I need to map Input DateTime Element to Output datetime in such a way that.
Map Input to Outout Only if Input has value. Which Functoid Should I use to check whether Input has value in it or not.

Biztalk Grouping Problems

Mon, 30 Nov 2009 21:51:00 Z

Hello,

I'm trying to map a flat file to an xml, but I need to group some of the flat file into the same node. Everything I've read says I should use the Muenchian grouping technique, but no matter which way I try it I can't seem to get it right. If somebody could shove me in the right direction it would be greatly appreciated.

Here is my source schema:
867GP
   867GP_Detail
        Utility
        UtilActNo.
        Marketer
        Mktr Act No.
        Customer
        Trans. Date
        MeterNo.
        Purpose
        Svc. Type
        Meters
        Util Rate
        Util Load Profile
        Act. Opened
        Meter Reading Start Date
        Reading Type
        Reading Total
        UOM
        Season
        Read Period
        Base Award Fee
        Billing Cycle

Here is my destination schema:
EDIFile
ny814
     Esco
        Code
        Name
        CodeQualifier
     LDC
        Code
        Name
        CodeQualifier
     Gas Profile
         TransactionDate
         TransactionControlNumber
         TrackingID
         Account
              LDCAccountID
              Commodity
              EscoAccount
              PreviousLdcAccount
              CustomerName
              TaxDistrict
         GasProfilePeriod
              ProfilePeriodStartDate
              DateCustomerInitiatedService
              UtilityRateClass
              UtilityRateSubClass
              BaseQuantity
                    Quantity
                    UOM
                    ReportPeriod
                         ReportMonth
                         AnnualPeriodStartDate
                         AnnualPeriodEndDate
                         SwingCharges
                         NormalUse
                              Quanity
                              UOM

Etc....., If you need more I can provide it.

So basically the really simple version of what I need is for each unique Util Act No. I only want one Gas Profile node. The file that is coming over has somewhere around 20 lines with the same Util Act No. and that all needs to be reduced into one XML node. No matter where I try and do my for-each loop I don't seem to be able to achieve what I need. Don't mind all of the other logic going on in here, it is a work in progress with a lot of strange requirements.


Here is my map:

<?xml version="1.0" encoding="UTF-16"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:var="http://schemas.microsoft.com/BizTalk/2003/var" exclude-result-prefixes="msxsl var s0 userCSharp userVB" version="1.0" xmlns:s0="http://ECInfoSystemsMap.EC867GP" xmlns:userCSharp="http://schemas.microsoft.com/BizTalk/2003/userCSharp" xmlns:userVB="http://schemas.microsoft.com/BizTalk/2003/userVB">
<xsl:output omit-xml-declaration="yes" method="xml" version="1.0" />
<xsl:key name="groups" match="GasProfile" use="Util_x0020_Act_x0020_No."/>
<xsl:template match="/">
    <xsl:apply-templates select="/s0:_x0038_67GP" />
</xsl:template>
<xsl:template match="/s0:_x0038_67GP">
    <EdiFile>
      <ny814>
        <Esco>
          <xsl:variable name="var:v1" select="userCSharp:InitCumulativeConcat(0)" />
          <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
            <xsl:variable name="var:v2" select="userVB:ESCOCode(string(Utility/text()))" />
            <xsl:variable name="var:v3" select="userCSharp:StringConcat(string($var:v2) , ",")" />
            <xsl:variable name="var:v4" select="userCSharp:AddToCumulativeConcat(0,string($var:v3),"1000")" />
          </xsl:for-each>
          <xsl:variable name="var:v5" select="userCSharp:GetCumulativeConcat(0)" />
          <xsl:variable name="var:v6" select="userVB:GrabESCOCode(string($var:v5))" />
          <xsl:variable name="var:v7" select="userCSharp:LogicalIsString(string($var:v6))" />
          <xsl:if test="string($var:v7)='true'">
            <xsl:variable name="var:v8" select="userCSharp:InitCumulativeConcat(0)" />
            <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
              <xsl:variable name="var:v9" select="string(Utility/text())" />
              <xsl:variable name="var:v10" select="userVB:ESCOCode($var:v9)" />
              <xsl:variable name="var:v11" select="userCSharp:StringConcat(string($var:v10) , ",")" />
              <xsl:variable name="var:v12" select="userCSharp:AddToCumulativeConcat(0,string($var:v11),"1000")" />
            </xsl:for-each>
            <xsl:variable name="var:v13" select="userCSharp:GetCumulativeConcat(0)" />
            <xsl:variable name="var:v14" select="userVB:GrabESCOCode(string($var:v13))" />
            <xsl:attribute name="Code">
              <xsl:value-of select="$var:v14" />
            </xsl:attribute>
          </xsl:if>
          <xsl:variable name="var:v15" select="userCSharp:InitCumulativeConcat(1)" />
          <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
            <xsl:variable name="var:v16" select="string(Utility/text())" />
            <xsl:variable name="var:v17" select="userVB:ESCOName($var:v16)" />
            <xsl:variable name="var:v18" select="userCSharp:StringConcat(string($var:v17) , ",")" />
            <xsl:variable name="var:v19" select="userCSharp:AddToCumulativeConcat(1,string($var:v18),"1000")" />
          </xsl:for-each>
          <xsl:variable name="var:v20" select="userCSharp:GetCumulativeConcat(1)" />
          <xsl:variable name="var:v21" select="userVB:GrabESCOName(string($var:v20))" />
          <xsl:variable name="var:v22" select="userCSharp:LogicalIsString(string($var:v21))" />
          <xsl:if test="string($var:v22)='true'">
            <xsl:variable name="var:v23" select="userCSharp:InitCumulativeConcat(1)" />
            <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
              <xsl:variable name="var:v24" select="string(Utility/text())" />
              <xsl:variable name="var:v25" select="userVB:ESCOName($var:v24)" />
              <xsl:variable name="var:v26" select="userCSharp:StringConcat(string($var:v25) , ",")" />
              <xsl:variable name="var:v27" select="userCSharp:AddToCumulativeConcat(1,string($var:v26),"1000")" />
            </xsl:for-each>
            <xsl:variable name="var:v28" select="userCSharp:GetCumulativeConcat(1)" />
            <xsl:variable name="var:v29" select="userVB:GrabESCOName(string($var:v28))" />
            <xsl:attribute name="Name">
              <xsl:value-of select="$var:v29" />
            </xsl:attribute>
          </xsl:if>
          <xsl:variable name="var:v30" select="userCSharp:InitCumulativeConcat(2)" />
          <xsl:variable name="var:v31" select="userVB:ESCOCQ()" />
          <xsl:variable name="var:v32" select="userCSharp:StringConcat(string($var:v31) , ",")" />
          <xsl:variable name="var:v33" select="userCSharp:AddToCumulativeConcat(2,string($var:v32),"1000")" />
          <xsl:variable name="var:v34" select="userCSharp:GetCumulativeConcat(2)" />
          <xsl:variable name="var:v35" select="userVB:GrabESCOCQ(string($var:v34))" />
          <xsl:variable name="var:v36" select="userCSharp:LogicalIsString(string($var:v35))" />
          <xsl:if test="string($var:v36)='true'">
            <xsl:variable name="var:v37" select="userCSharp:InitCumulativeConcat(2)" />
            <xsl:variable name="var:v38" select="userVB:ESCOCQ()" />
            <xsl:variable name="var:v39" select="userCSharp:StringConcat(string($var:v38) , ",")" />
            <xsl:variable name="var:v40" select="userCSharp:AddToCumulativeConcat(2,string($var:v39),"1000")" />
            <xsl:variable name="var:v41" select="userCSharp:GetCumulativeConcat(2)" />
            <xsl:variable name="var:v42" select="userVB:GrabESCOCQ(string($var:v41))" />
            <xsl:attribute name="CodeQualifier">
              <xsl:value-of select="$var:v42" />
            </xsl:attribute>
          </xsl:if>
        </Esco>
        <Ldc>
          <xsl:variable name="var:v43" select="userCSharp:InitCumulativeConcat(3)" />
          <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
            <xsl:variable name="var:v44" select="userVB:LDCCode(string(Marketer/text()))" />
            <xsl:variable name="var:v45" select="userCSharp:StringConcat(string($var:v44) , ",")" />
            <xsl:variable name="var:v46" select="userCSharp:AddToCumulativeConcat(3,string($var:v45),"1000")" />
          </xsl:for-each>
          <xsl:variable name="var:v47" select="userCSharp:GetCumulativeConcat(3)" />
          <xsl:variable name="var:v48" select="userVB:GrabLDCCode(string($var:v47))" />
          <xsl:variable name="var:v49" select="userCSharp:LogicalIsString(string($var:v48))" />
          <xsl:if test="string($var:v49)='true'">
            <xsl:variable name="var:v50" select="userCSharp:InitCumulativeConcat(3)" />
            <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
              <xsl:variable name="var:v51" select="string(Marketer/text())" />
              <xsl:variable name="var:v52" select="userVB:LDCCode($var:v51)" />
              <xsl:variable name="var:v53" select="userCSharp:StringConcat(string($var:v52) , ",")" />
              <xsl:variable name="var:v54" select="userCSharp:AddToCumulativeConcat(3,string($var:v53),"1000")" />
            </xsl:for-each>
            <xsl:variable name="var:v55" select="userCSharp:GetCumulativeConcat(3)" />
            <xsl:variable name="var:v56" select="userVB:GrabLDCCode(string($var:v55))" />
            <xsl:attribute name="Code">
              <xsl:value-of select="$var:v56" />
            </xsl:attribute>
          </xsl:if>
          <xsl:variable name="var:v57" select="userCSharp:InitCumulativeConcat(4)" />
          <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
            <xsl:variable name="var:v58" select="string(Marketer/text())" />
            <xsl:variable name="var:v59" select="userVB:LDCName($var:v58)" />
            <xsl:variable name="var:v60" select="userCSharp:StringConcat(string($var:v59) , ",")" />
            <xsl:variable name="var:v61" select="userCSharp:AddToCumulativeConcat(4,string($var:v60),"1000")" />
          </xsl:for-each>
          <xsl:variable name="var:v62" select="userCSharp:GetCumulativeConcat(4)" />
          <xsl:variable name="var:v63" select="userVB:GrabLDCName(string($var:v62))" />
          <xsl:variable name="var:v64" select="userCSharp:LogicalIsString(string($var:v63))" />
          <xsl:if test="string($var:v64)='true'">
            <xsl:variable name="var:v65" select="userCSharp:InitCumulativeConcat(4)" />
            <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
              <xsl:variable name="var:v66" select="string(Marketer/text())" />
              <xsl:variable name="var:v67" select="userVB:LDCName($var:v66)" />
              <xsl:variable name="var:v68" select="userCSharp:StringConcat(string($var:v67) , ",")" />
              <xsl:variable name="var:v69" select="userCSharp:AddToCumulativeConcat(4,string($var:v68),"1000")" />
            </xsl:for-each>
            <xsl:variable name="var:v70" select="userCSharp:GetCumulativeConcat(4)" />
            <xsl:variable name="var:v71" select="userVB:GrabLDCName(string($var:v70))" />
            <xsl:attribute name="Name">
              <xsl:value-of select="$var:v71" />
            </xsl:attribute>
          </xsl:if>
          <xsl:variable name="var:v72" select="userCSharp:InitCumulativeConcat(5)" />
          <xsl:variable name="var:v73" select="userVB:LDCCQ()" />
          <xsl:variable name="var:v74" select="userCSharp:StringConcat(string($var:v73) , ",")" />
          <xsl:variable name="var:v75" select="userCSharp:AddToCumulativeConcat(5,string($var:v74),"1000")" />
          <xsl:variable name="var:v76" select="userCSharp:GetCumulativeConcat(5)" />
          <xsl:variable name="var:v77" select="userVB:GrabLDCCQ(string($var:v76))" />
          <xsl:variable name="var:v78" select="userCSharp:LogicalIsString(string($var:v77))" />
          <xsl:if test="string($var:v78)='true'">
            <xsl:variable name="var:v79" select="userCSharp:InitCumulativeConcat(5)" />
            <xsl:variable name="var:v80" select="userVB:LDCCQ()" />
            <xsl:variable name="var:v81" select="userCSharp:StringConcat(string($var:v80) , ",")" />
            <xsl:variable name="var:v82" select="userCSharp:AddToCumulativeConcat(5,string($var:v81),"1000")" />
            <xsl:variable name="var:v83" select="userCSharp:GetCumulativeConcat(5)" />
            <xsl:variable name="var:v84" select="userVB:GrabLDCCQ(string($var:v83))" />
            <xsl:attribute name="CodeQualifier">
              <xsl:value-of select="$var:v84" />
            </xsl:attribute>
          </xsl:if>
        </Ldc>
        <xsl:for-each select="_x0038_67GP_Detail">
          <xsl:variable name="var:v85" select="userCSharp:LogicalIsString(string(Trans._x0020_Date/text()))" />
          <xsl:variable name="var:v88" select="userCSharp:LogicalIsString(string(Mktr_x0020_Act_x0020_No./text()))" />
          <xsl:variable name="var:v94" select="userCSharp:LogicalIsString(string(Util_x0020_Act_x0020_No./text()))" />
          <xsl:variable name="var:v96" select="userCSharp:LogicalIsString(string(Customer/text()))" />
          <xsl:variable name="var:v98" select="userCSharp:LogicalIsString(string(Meter_x0020_Reading_x0020_Start_x0020_Date/text()))" />
          <xsl:variable name="var:v100" select="string(Meter_x0020_Reading_x0020_Start_x0020_Date/text())" />
          <xsl:variable name="var:v101" select="userCSharp:LogicalIsString($var:v100)" />
          <xsl:variable name="var:v103" select="userCSharp:LogicalIsString(string(Act._x0020_Opened/text()))" />
          <xsl:variable name="var:v105" select="string(Act._x0020_Opened/text())" />
          <xsl:variable name="var:v106" select="userCSharp:LogicalIsString($var:v105)" />
          <xsl:variable name="var:v108" select="userCSharp:LogicalIsString(string(Util_x0020_Rate/text()))" />
          <xsl:variable name="var:v110" select="string(Util_x0020_Rate/text())" />
          <xsl:variable name="var:v111" select="userCSharp:LogicalIsString($var:v110)" />
          <xsl:variable name="var:v137" select="string(Reading_x0020_Type/text())" />
          <GasProfile>
            <xsl:if test="string($var:v85)='true'">
              <xsl:variable name="var:v86" select="Trans._x0020_Date/text()" />
              <xsl:attribute name="TransactionDate">
                <xsl:value-of select="$var:v86" />
              </xsl:attribute>
            </xsl:if>
            <xsl:variable name="var:v87" select="userVB:TransactionNumber()" />
            <xsl:attribute name="TransactionControlNumber">
              <xsl:value-of select="$var:v87" />
            </xsl:attribute>
            <Account>
              <xsl:if test="string($var:v88)='true'">
                <xsl:variable name="var:v89" select="Mktr_x0020_Act_x0020_No./text()" />
                <xsl:attribute name="LdcAccount">
                  <xsl:value-of select="$var:v89" />
                </xsl:attribute>
              </xsl:if>
              <xsl:variable name="var:v90" select="userVB:ServiceType(string(Svc._x0020_Type/text()))" />
              <xsl:variable name="var:v91" select="userCSharp:LogicalIsString(string($var:v90))" />
              <xsl:if test="string($var:v91)='true'">
                <xsl:variable name="var:v92" select="string(Svc._x0020_Type/text())" />
                <xsl:variable name="var:v93" select="userVB:ServiceType($var:v92)" />
                <xsl:attribute name="Commodity">
                  <xsl:value-of select="$var:v93" />
                </xsl:attribute>
              </xsl:if>
              <xsl:if test="string($var:v94)='true'">
                <xsl:variable name="var:v95" select="Util_x0020_Act_x0020_No./text()" />
                <xsl:attribute name="EscoAccount">
                  <xsl:value-of select="$var:v95" />
                </xsl:attribute>
              </xsl:if>
              <xsl:if test="string($var:v96)='true'">
                <xsl:variable name="var:v97" select="Customer/text()" />
                <xsl:attribute name="CustomerName">
                  <xsl:value-of select="$var:v97" />
                </xsl:attribute>
              </xsl:if>
            </Account>
            <GasProfilePeriod>
              <xsl:if test="string($var:v98)='true'">
                <xsl:variable name="var:v99" select="Meter_x0020_Reading_x0020_Start_x0020_Date/text()" />
                <xsl:attribute name="ProfilePeriodStartDate">
                  <xsl:value-of select="$var:v99" />
                </xsl:attribute>
              </xsl:if>
              <xsl:if test="string($var:v101)='true'">
                <xsl:variable name="var:v102" select="Meter_x0020_Reading_x0020_Start_x0020_Date/text()" />
                <xsl:attribute name="ProfilePeriodStartDate">
                  <xsl:value-of select="$var:v102" />
                </xsl:attribute>
              </xsl:if>
              <xsl:if test="string($var:v103)='true'">
                <xsl:variable name="var:v104" select="Act._x0020_Opened/text()" />
                <xsl:attribute name="DateCustomerInitiatedService">
                  <xsl:value-of select="$var:v104" />
                </xsl:attribute>
              </xsl:if>
              <xsl:if test="string($var:v106)='true'">
                <xsl:variable name="var:v107" select="Act._x0020_Opened/text()" />
                <xsl:attribute name="DateCustomerInitiatedService">
                  <xsl:value-of select="$var:v107" />
                </xsl:attribute>
              </xsl:if>
              <xsl:if test="string($var:v108)='true'">
                <xsl:variable name="var:v109" select="Util_x0020_Rate/text()" />
                <xsl:attribute name="UtilityRateClass">
                  <xsl:value-of select="$var:v109" />
                </xsl:attribute>
              </xsl:if>
              <xsl:if test="string($var:v111)='true'">
                <xsl:variable name="var:v112" select="Util_x0020_Rate/text()" />
                <xsl:attribute name="UtilityRateClass">
                  <xsl:value-of select="$var:v112" />
                </xsl:attribute>
              </xsl:if>
              <xsl:variable name="var:v113" select="userVB:IsBaseQuantityVisible(string(Reading_x0020_Type/text()))" />
              <xsl:variable name="var:v114" select="userCSharp:LogicalIsString(string($var:v113))" />
              <xsl:if test="$var:v114">
                <BaseQuantity>
                  <xsl:variable name="var:v115" select="userCSharp:InitCumulativeConcat(6)" />
                  <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
                    <xsl:variable name="var:v116" select="string(Reading_x0020_Type/text())" />
                    <xsl:variable name="var:v117" select="userCSharp:StringConcat($var:v116 , ",")" />
                    <xsl:variable name="var:v118" select="userCSharp:AddToCumulativeConcat(6,string($var:v117),"1000")" />
                  </xsl:for-each>
                  <xsl:variable name="var:v119" select="userCSharp:GetCumulativeConcat(6)" />
                  <xsl:variable name="var:v120" select="userCSharp:InitCumulativeConcat(8)" />
                  <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
                    <xsl:variable name="var:v121" select="userCSharp:StringConcat("," , string(UOM/text()))" />
                    <xsl:variable name="var:v122" select="userCSharp:AddToCumulativeConcat(8,string($var:v121),"1000")" />
                  </xsl:for-each>
                  <xsl:variable name="var:v123" select="userCSharp:GetCumulativeConcat(8)" />
                  <xsl:variable name="var:v124" select="userVB:RetrieveUOMBaseQuantity(string($var:v119) , string($var:v123))" />
                  <xsl:variable name="var:v125" select="userCSharp:LogicalIsString(string($var:v124))" />
                  <xsl:if test="string($var:v125)='true'">
                    <xsl:variable name="var:v126" select="userCSharp:InitCumulativeConcat(6)" />
                    <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
                      <xsl:variable name="var:v127" select="string(Reading_x0020_Type/text())" />
                      <xsl:variable name="var:v128" select="userCSharp:StringConcat($var:v127 , ",")" />
                      <xsl:variable name="var:v129" select="userCSharp:AddToCumulativeConcat(6,string($var:v128),"1000")" />
                    </xsl:for-each>
                    <xsl:variable name="var:v130" select="userCSharp:GetCumulativeConcat(6)" />
                    <xsl:variable name="var:v131" select="userCSharp:InitCumulativeConcat(8)" />
                    <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
                      <xsl:variable name="var:v132" select="string(UOM/text())" />
                      <xsl:variable name="var:v133" select="userCSharp:StringConcat("," , $var:v132)" />
                      <xsl:variable name="var:v134" select="userCSharp:AddToCumulativeConcat(8,string($var:v133),"1000")" />
                    </xsl:for-each>
                    <xsl:variable name="var:v135" select="userCSharp:GetCumulativeConcat(8)" />
                    <xsl:variable name="var:v136" select="userVB:RetrieveUOMBaseQuantity(string($var:v130) , string($var:v135))" />
                    <xsl:attribute name="UnitsOfMeasure">
                      <xsl:value-of select="$var:v136" />
                    </xsl:attribute>
                  </xsl:if>
                </BaseQuantity>
              </xsl:if>
              <xsl:variable name="var:v138" select="userVB:IsSlopeQuantityIsVisible($var:v137)" />
              <xsl:variable name="var:v139" select="userCSharp:LogicalIsString(string($var:v138))" />
              <xsl:if test="$var:v139">
                <SlopeQuantity>
                  <xsl:variable name="var:v140" select="userCSharp:InitCumulativeConcat(6)" />
                  <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
                    <xsl:variable name="var:v141" select="string(Reading_x0020_Type/text())" />
                    <xsl:variable name="var:v142" select="userCSharp:StringConcat($var:v141 , ",")" />
                    <xsl:variable name="var:v143" select="userCSharp:AddToCumulativeConcat(6,string($var:v142),"1000")" />
                  </xsl:for-each>
                  <xsl:variable name="var:v144" select="userCSharp:GetCumulativeConcat(6)" />
                  <xsl:variable name="var:v145" select="userCSharp:InitCumulativeConcat(8)" />
                  <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
                    <xsl:variable name="var:v146" select="string(UOM/text())" />
                    <xsl:variable name="var:v147" select="userCSharp:StringConcat("," , $var:v146)" />
                    <xsl:variable name="var:v148" select="userCSharp:AddToCumulativeConcat(8,string($var:v147),"1000")" />
                  </xsl:for-each>
                  <xsl:variable name="var:v149" select="userCSharp:GetCumulativeConcat(8)" />
                  <xsl:variable name="var:v150" select="userVB:RetrieveUOMSizingFactor(string($var:v144) , string($var:v149))" />
                  <xsl:variable name="var:v151" select="userCSharp:LogicalIsString(string($var:v150))" />
                  <xsl:if test="string($var:v151)='true'">
                    <xsl:variable name="var:v152" select="userCSharp:InitCumulativeConcat(6)" />
                    <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
                      <xsl:variable name="var:v153" select="string(Reading_x0020_Type/text())" />
                      <xsl:variable name="var:v154" select="userCSharp:StringConcat($var:v153 , ",")" />
                      <xsl:variable name="var:v155" select="userCSharp:AddToCumulativeConcat(6,string($var:v154),"1000")" />
                    </xsl:for-each>
                    <xsl:variable name="var:v156" select="userCSharp:GetCumulativeConcat(6)" />
                    <xsl:variable name="var:v157" select="userCSharp:InitCumulativeConcat(8)" />
                    <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
                      <xsl:variable name="var:v158" select="string(UOM/text())" />
                      <xsl:variable name="var:v159" select="userCSharp:StringConcat("," , $var:v158)" />
                      <xsl:variable name="var:v160" select="userCSharp:AddToCumulativeConcat(8,string($var:v159),"1000")" />
                    </xsl:for-each>
                    <xsl:variable name="var:v161" select="userCSharp:GetCumulativeConcat(8)" />
                    <xsl:variable name="var:v162" select="userVB:RetrieveUOMSizingFactor(string($var:v156) , string($var:v161))" />
                    <xsl:attribute name="UnitsOfMeasure">
                      <xsl:value-of select="$var:v162" />
                    </xsl:attribute>
                  </xsl:if>
                </SlopeQuantity>
              </xsl:if>
              <xsl:variable name="var:v163" select="userVB:IsLoadFactorIsVisible($var:v137)" />
              <xsl:variable name="var:v164" select="userCSharp:LogicalIsString(string($var:v163))" />
              <xsl:if test="$var:v164">
                <LoadFactor>
                  <xsl:variable name="var:v165" select="userCSharp:InitCumulativeConcat(6)" />
                  <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
                    <xsl:variable name="var:v166" select="string(Reading_x0020_Type/text())" />
                    <xsl:variable name="var:v167" select="userCSharp:StringConcat($var:v166 , ",")" />
                    <xsl:variable name="var:v168" select="userCSharp:AddToCumulativeConcat(6,string($var:v167),"1000")" />
                  </xsl:for-each>
                  <xsl:variable name="var:v169" select="userCSharp:GetCumulativeConcat(6)" />
                  <xsl:variable name="var:v170" select="userCSharp:InitCumulativeConcat(8)" />
                  <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
                    <xsl:variable name="var:v171" select="string(UOM/text())" />
                    <xsl:variable name="var:v172" select="userCSharp:StringConcat("," , $var:v171)" />
                    <xsl:variable name="var:v173" select="userCSharp:AddToCumulativeConcat(8,string($var:v172),"1000")" />
                  </xsl:for-each>
                  <xsl:variable name="var:v174" select="userCSharp:GetCumulativeConcat(8)" />
                  <xsl:variable name="var:v175" select="userVB:RetrieveUOMLoadFactor(string($var:v169) , string($var:v174))" />
                  <xsl:variable name="var:v176" select="userCSharp:LogicalIsString(string($var:v175))" />
                  <xsl:if test="string($var:v176)='true'">
                    <xsl:variable name="var:v177" select="userCSharp:InitCumulativeConcat(6)" />
                    <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
                      <xsl:variable name="var:v178" select="string(Reading_x0020_Type/text())" />
                      <xsl:variable name="var:v179" select="userCSharp:StringConcat($var:v178 , ",")" />
                      <xsl:variable name="var:v180" select="userCSharp:AddToCumulativeConcat(6,string($var:v179),"1000")" />
                    </xsl:for-each>
                    <xsl:variable name="var:v181" select="userCSharp:GetCumulativeConcat(6)" />
                    <xsl:variable name="var:v182" select="userCSharp:InitCumulativeConcat(8)" />
                    <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
                      <xsl:variable name="var:v183" select="string(UOM/text())" />
                      <xsl:variable name="var:v184" select="userCSharp:StringConcat("," , $var:v183)" />
                      <xsl:variable name="var:v185" select="userCSharp:AddToCumulativeConcat(8,string($var:v184),"1000")" />
                    </xsl:for-each>
                    <xsl:variable name="var:v186" select="userCSharp:GetCumulativeConcat(8)" />
                    <xsl:variable name="var:v187" select="userVB:RetrieveUOMLoadFactor(string($var:v181) , string($var:v186))" />
                    <xsl:attribute name="UnitsOfMeasure">
                      <xsl:value-of select="$var:v187" />
                    </xsl:attribute>
                  </xsl:if>
                </LoadFactor>
              </xsl:if>
              <xsl:variable name="var:v188" select="userVB:IsUFGRateIsVisible($var:v137)" />
              <xsl:variable name="var:v189" select="userCSharp:LogicalIsString(string($var:v188))" />
              <xsl:if test="$var:v189">
                <UFGRate>
                  <xsl:variable name="var:v190" select="userCSharp:InitCumulativeConcat(6)" />
                  <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
                    <xsl:variable name="var:v191" select="string(Reading_x0020_Type/text())" />
                    <xsl:variable name="var:v192" select="userCSharp:StringConcat($var:v191 , ",")" />
                    <xsl:variable name="var:v193" select="userCSharp:AddToCumulativeConcat(6,string($var:v192),"1000")" />
                  </xsl:for-each>
                  <xsl:variable name="var:v194" select="userCSharp:GetCumulativeConcat(6)" />
                  <xsl:variable name="var:v195" select="userCSharp:InitCumulativeConcat(8)" />
                  <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
                    <xsl:variable name="var:v196" select="string(UOM/text())" />
                    <xsl:variable name="var:v197" select="userCSharp:StringConcat("," , $var:v196)" />
                    <xsl:variable name="var:v198" select="userCSharp:AddToCumulativeConcat(8,string($var:v197),"1000")" />
                  </xsl:for-each>
                  <xsl:variable name="var:v199" select="userCSharp:GetCumulativeConcat(8)" />
                  <xsl:variable name="var:v200" select="userVB:RetrieveUOMUFGy(string($var:v194) , string($var:v199))" />
                  <xsl:variable name="var:v201" select="userCSharp:LogicalIsString(string($var:v200))" />
                  <xsl:if test="string($var:v201)='true'">
                    <xsl:variable name="var:v202" select="userCSharp:InitCumulativeConcat(6)" />
                    <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
                      <xsl:variable name="var:v203" select="string(Reading_x0020_Type/text())" />
                      <xsl:variable name="var:v204" select="userCSharp:StringConcat($var:v203 , ",")" />
                      <xsl:variable name="var:v205" select="userCSharp:AddToCumulativeConcat(6,string($var:v204),"1000")" />
                    </xsl:for-each>
                    <xsl:variable name="var:v206" select="userCSharp:GetCumulativeConcat(6)" />
                    <xsl:variable name="var:v207" select="userCSharp:InitCumulativeConcat(8)" />
                    <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
                      <xsl:variable name="var:v208" select="string(UOM/text())" />
                      <xsl:variable name="var:v209" select="userCSharp:StringConcat("," , $var:v208)" />
                      <xsl:variable name="var:v210" select="userCSharp:AddToCumulativeConcat(8,string($var:v209),"1000")" />
                    </xsl:for-each>
                    <xsl:variable name="var:v211" select="userCSharp:GetCumulativeConcat(8)" />
                    <xsl:variable name="var:v212" select="userVB:RetrieveUOMUFGy(string($var:v206) , string($var:v211))" />
                    <xsl:attribute name="UnitsOfMeasure">
                      <xsl:value-of select="$var:v212" />
                    </xsl:attribute>
                  </xsl:if>
                </UFGRate>
              </xsl:if>
              <xsl:variable name="var:v213" select="userVB:IsMaxDelIsVisible($var:v137)" />
              <xsl:variable name="var:v214" select="userCSharp:LogicalIsString(string($var:v213))" />
              <xsl:if test="$var:v214">
                <MaximumDeliveryQuantity>
                  <xsl:variable name="var:v215" select="userCSharp:InitCumulativeConcat(6)" />
                  <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
                    <xsl:variable name="var:v216" select="string(Reading_x0020_Type/text())" />
                    <xsl:variable name="var:v217" select="userCSharp:StringConcat($var:v216 , ",")" />
                    <xsl:variable name="var:v218" select="userCSharp:AddToCumulativeConcat(6,string($var:v217),"1000")" />
                  </xsl:for-each>
                  <xsl:variable name="var:v219" select="userCSharp:GetCumulativeConcat(6)" />
                  <xsl:variable name="var:v220" select="userCSharp:InitCumulativeConcat(8)" />
                  <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
                    <xsl:variable name="var:v221" select="string(UOM/text())" />
                    <xsl:variable name="var:v222" select="userCSharp:StringConcat("," , $var:v221)" />
                    <xsl:variable name="var:v223" select="userCSharp:AddToCumulativeConcat(8,string($var:v222),"1000")" />
                  </xsl:for-each>
                  <xsl:variable name="var:v224" select="userCSharp:GetCumulativeConcat(8)" />
                  <xsl:variable name="var:v225" select="userVB:RetrieveRateTotalMaxDelUOM(string($var:v219) , string($var:v224))" />
                  <xsl:variable name="var:v226" select="userCSharp:LogicalIsString(string($var:v225))" />
                  <xsl:if test="string($var:v226)='true'">
                    <xsl:variable name="var:v227" select="userCSharp:InitCumulativeConcat(6)" />
                    <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
                      <xsl:variable name="var:v228" select="string(Reading_x0020_Type/text())" />
                      <xsl:variable name="var:v229" select="userCSharp:StringConcat($var:v228 , ",")" />
                      <xsl:variable name="var:v230" select="userCSharp:AddToCumulativeConcat(6,string($var:v229),"1000")" />
                    </xsl:for-each>
                    <xsl:variable name="var:v231" select="userCSharp:GetCumulativeConcat(6)" />
                    <xsl:variable name="var:v232" select="userCSharp:InitCumulativeConcat(8)" />
                    <xsl:for-each select="/s0:_x0038_67GP/_x0038_67GP_Detail">
                      <xsl:variable name="var:v233" select="string(UOM/text())" />
                      <xsl:variable name="var:v234" select="userCSharp:StringConcat("," , $var:v233)" />
                      <xsl:variable name="var:v235" select="userCSharp:AddToCumulativeConcat(8,string($var:v234),"1000")" />
                    </xsl:for-each>
                    <xsl:variable name="var:v236" select="userCSharp:GetCumulativeConcat(8)" />
                    <xsl:variable name="var:v237" select="userVB:RetrieveRateTotalMaxDelUOM(string($var:v231) , string($var:v236))" />
                    <xsl:attribute name="UnitsOfMeasure">
                      <xsl:value-of select="$var:v237" />
                    </xsl:attribute>
                  </xsl:if>
                </MaximumDeliveryQuantity>
              </xsl:if>
            </GasProfilePeriod>
            <GasProfilePeriod>
              <xsl:if test="string($var:v101)='true'">
                <xsl:variable name="var:v238" select="Meter_x0020_Reading_x0020_Start_x0020_Date/text()" />
                <xsl:attribute name="ProfilePeriodStartDate">
                  <xsl:value-of select="$var:v238" />
                </xsl:attribute>
              </xsl:if>
              <xsl:if test="string($var:v101)='true'">
                <xsl:variable name="var:v239" select="Meter_x0020_Reading_x0020_Start_x0020_Date/text()" />
                <xsl:attribute name="ProfilePeriodStartDate">
                  <xsl:value-of select="$var:v239" />
                </xsl:attribute>
              </xsl:if>
              <xsl:if test="string($var:v106)='true'">
                <xsl:variable name="var:v240" select="Act._x0020_Opened/text()" />
                <xsl:attribute name="DateCustomerInitiatedService">
                  <xsl:value-of select="$var:v240" />
                </xsl:attribute>
              </xsl:if>
              <xsl:if test="string($var:v106)='true'">
                <xsl:variable name="var:v241" select="Act._x0020_Opened/text()" />
                <xsl:attribute name="DateCustomerInitiatedService">
                  <xsl:value-of select="$var:v241" />
                </xsl:attribute>
              </xsl:if>
              <xsl:if test="string($var:v111)='true'">
                <xsl:variable name="var:v242" select="Util_x0020_Rate/text()" />
                <xsl:attribute name="UtilityRateClass">
                  <xsl:value-of select="$var:v242" />
                </xsl:attribute>
              </xsl:if>
              <xsl:if test="string($var:v111)='true'">
                <xsl:variable name="var:v243" select="Util_x0020_Rate/text()" />
                <xsl:attribute name="UtilityRateClass">
                  <xsl:value-of select="$var:v243" />
                </xsl:attribute>
              </xsl:if>
              <BaseQuantity />
              <SlopeQuantity />
              <LoadFactor />
              <UFGRate />
              <MaximumDeliveryQuantity />
            </GasProfilePeriod>
          </GasProfile>
        </xsl:for-each>
      </ny814>
    </EdiFile>
</xsl:template>

BizTalk UserGroup in Dallas

Mon, 30 Nov 2009 20:50:47 Z

Hi. Sorry if this is the wrong place for this post. I've searched the web and only found 1 group that has very little activity. I'm new to BizTalk and would like to meet local users. Thanks!

-Will

Construct shape with two maps issue

Mon, 30 Nov 2009 16:43:46 Z

Hi, This is my setup:

I have an orchestration with a contruct message shape. In it I have two transform shapes. Both transform shape have the same output message but different input and each map affect different fields of my output message. What I want to acheive is that my same message be transform twice (with first map then with second map) inside the same construct shape.

The result is that only the second map is applied. Do I need to use two construct shape to acheive that scenario?

Thank for the help.

Referenced dll not executing

Wed, 11 Nov 2009 22:03:11 Z

BizTalk 2006R2 is platform

I have a small class library DLL, built in .NET 2.0, that I have been using successfully in my BizTalk orchestrations to wite to the event log. The assembly is signed, in the GAC, etc... A variable is instantiated in the orch against the class, to write out debug messages to the event log.

However I created a new BizTalk project, created my orch, referenced the DLL, but the orch crashes when it hits the instantiation line. No errors get thrown, nothing is suspended, but processing stops when it hits the expression shape that has the assignment:
Logger l = new MyNamespace.Logger();

I know this because the next shape outputs a CSV file to a folder share, and this works when that looger line is commented out.

What could be causing this? This has never happened before, I'm baffled. Compiles fine - of course!

Any help would be appreciated. Thanks - Hedge

Update - any DLL that I reference seems to be not working! Again, things compile, but on runtime when the class is instantiated the orch fails.

Expanding a body in Pipeline

Mon, 30 Nov 2009 17:46:58 Z

Could someone point me in the right direction to achieve this?

I have a schema defined as something like

- <xs:element name="PickupDocumentResponse">

- <xs:complexType>

- <xs:sequence>

<xs:element minOccurs="0" maxOccurs="1" name="PickupDocumentResult" type="tns:PostOfficeParcel" />

</xs:sequence>

</xs:complexType>

</xs:element>

- <xs:complexType name="PostOfficeParcel">

- <xs:sequence>

<xs:element minOccurs="0" maxOccurs="1" name="GUID" type="xs:string" />

<xs:element minOccurs="0" maxOccurs="1" name="Body" type="xs:string" />

<xs:element minOccurs="0" maxOccurs="1" name="ContextGuid" type="xs:string" />

<xs:element minOccurs="0" maxOccurs="1" name="ConfigurationGuid" type="xs:string" />

</xs:sequence>

</xs:complexType>

where the <body> would be some XML encoded as a string like this

<Body><Order xmlns:pro="http://www.xxx.com/xml/xml-ns" xmlns="urn:schemas-basda-org:2000:purchaseOrder:xdr:3.01"><OrderHead><Schema><Version>3.09&l.......

I thought that it would be best if I transposed this into my own ORDER schema (which includes the header) in the Pipeline using a mapping. Is that possible? Do any of the functoids allow you to assign a "string" of encoded XML into a "parent" node in another schema?

If not do I have to do it in code in a disassemble component? What might that code look like?

It seems like a common thing to want to do that BizTalk would have a gadget to do it.

Further down the line I want to extract different bodies into different schemas so maybe the component is the only way anyway?

thanks

Cliff