Forum Replies Created
-
AuthorPosts
-
Hi Chris:
Try using sequence group in your flat file schema structure and place row100, row105, row200 and row205 underneath that group, something like the following:
Root
row000 (mandatory;once per file. After this row there can be a lot of purchase-orders)
sequence-group1 (Min Occurs: 1 / Max Occurs: unbounded)
row100 (mandatory; once per order; containing orders-header data)
row105 (not mandatory; cann occure 0 to 5 times after row100; containing orders-header freetext information)
row200 (mandatory; unbounded per order; containing orders-line-data)
row205 (not mandatory; cann occure 0 to 5 times after row200; containing orders-line freetext information)
Daniel.
Hi DavidBZ,
You probably have an older version of the orchestration assembly (DLL) in your GAC. Try uninstalling that, and re-install the newer version of the DLL in GAC using gacutil command.
Daniel.
Hi Wolfgang,
You are most likely looking to do message debatching inside a custom pipeline. Here’s a blog you can consult more information (though it was written for BizTalk 2006 but I think it’s still relevant for version 2009):
http://geekswithblogs.net/benny/archive/2006/02/05/68249.aspx
Cheers,
Daniel.
Hello Daniel,
Thanks for the link.
I had try to expand my flatfile schema and since then – it doesnt work 🙁
Maybe I have a problem with putting the logic of the flatfile structure to the schema. Please take a look at this. The complete structure of the flatfile looks like this
row000 (mandatory;once per file. After this row there can be a lot of purchase-orders)
row100 (mandatory; once per order; containing orders-header data)
row105 (not mandatory; cann occure 0 to 5 times after row100; containing orders-header freetext information)
row200 (mandatory; unbounded per order; containing orders-line-data)
row205 (not mandatory; cann occure 0 to 5 times after row200;
containing orders-line freetext information)so the file can looks like this if there are 3 orders inside:
000 sender receiver
100 order1
105 The first textrow in order1
105 the secon textrow in order1
200 Line1 article1 qunatity1
205 The first textrow in Line1
200 Line2 article2 qunatity2
100 order2
200 Line1 article1 qunatity1
200 Line2 article2 qunatity2
100 order3
105 The first textrow in order3
200 Line1 article1 qunatity1
Have you any Idea ?
Chris
Oh no, I was in a mistake. The orchestration still doesn’t work… Now, i get the next error(I don’r know waht i’m doing wrong it cant’ be so difficult change a dynamic port….):
Uncaught exception (see the ‘inner exception’ below) has suspended an instance of service ‘Din.Orche1(16c48ad0-ac2d-c955-c705-2b3414c16e32)’.
The service instance will remain suspended until administratively resumed or terminated.
If resumed the instance will continue from its last persisted state and may re-throw the same unexpected exception.
InstanceId: a69fee76-f4a2-44e6-8976-dac925d99885
Shape name: Send_1
ShapeId: 202f3e11-0d37-4be8-afa2-822de30c988c
Exception thrown from: segment 1, progress 11
Inner exception: Failed while attempting to send message ‘Message_1’.
Exception type: SendFailedException
Source: Microsoft.XLANGs.BizTalk.Engine
Target Site: Void WriteMessageState(Microsoft.BizTalk.Interop.IBTPEPInfoLookup, System.Guid, Microsoft.XLANGs.BaseTypes.XLANGMessage, Microsoft.XLANGs.Core.Segment, System.String, System.String, System.Collections.IList, Boolean, System.Collections.IList)
The following is a stack trace that identifies the location where the exception occuredThanks!! It was that!
It’s solved 😉
Hi Daniel,
thanks a lot for your fast reply.
I’m not sure if this a solution I’m looking for. I’m looking for a solution to loop through ONE textfile with multiple datasets in it. I’m new to BTS 2009, but is there no way in a pipeline to say something like that:
Identifier (each row starts with it), value 1, value 2, value 3 …
And when the disassambler (?) read the textfile it knows by each same identifier it has to build a new xml file. I think something like this should works fine for me – if BTS provides a method like this, does it? (So I wouldn’t need an Orchestration so far)
Thanks
Wolfgang
Hi ,
Of course you can use the same direct bindings used in the orc2.
In fact, you have an orc1 which send msg to the MessageBox (due to the direct binding).
Then you have one or more subscipters who subscribe to the Msg (using Promoted Properties). In your case, you want that 2 orcs can receive the msg, so you have to build orc with receive shape and appropriate filter and msgType.
That’s all!!!
Regards,
Hello Colin,
I am having the same issue as you had. Can you please tell me what is the work around for below listed error. I have already updated the secret key with the new server name as example listed below. you reply will be greatly appreciated
<sso>
<globalInfo>
<secretServer>NewMSSServer</secretServer>
</globalInfo>
</sso>This version of the SSO server is not compatible with the SSO database. Please upgrade your master secret server.
SQL Server Name: xli-biztalk
SSO Database Name: SSODB
SSO Database Version: 0.0
Required Version: 3.0
Jay
Hi Wolfgang,
Have you looked into calling a Receive pipeline inside your orchestration to achieve your goal? Here’s a BizTalkGurus blog on this subject:
Daniel.
Hi Daniel
I tried that and much to my surprise it worked! I think that originally I had made the DocumentID a promoted property. It was not showing up in the intellisense (expression in an assignment shape) and then I ALSO did distinquished. So it was both. At that point the value was available for my email subject field but I also got the weird double messages.
This time it is ONLY distinquished and that is working correctly. I get one email and the subject line is correct.
I am learning not to do the “Quick Promotion” but rather open the promo dialog box and choose the type of promotion I want.
Thanks much-much!!!!
– Ziggy –
I think you are looking for the Cross Referencing functionality in Biztalk
There is a blog post @ http://geekswithblogs.net/bloesgen/archive/2007/12/06/117452.aspx which talks about it.
Hi Ziggy,
I assume that you promoted both fields as Promoted Properties. Have you tried promoting them as Distinguished Fields, since you seem to be just using them in the orchestration?
I’m not sure if you can use Distinguished Fields in your scenario, but give it a try and see if that works. Btw, Distinguished Fields are more light-weight then Promoted Properties.
Daniel.
Hi,
Based on the error messages that you are getting:
“Failed to publish (send) a message in the batch. This is usually because there is no one expecting to receive this message. The published message could not be routed because no subscribers were found.“
Check the send pipeline of your Dynamic Send port: what kind of pipeline are you using there? It should be XMLTransmit, since you are outputting an XML file.
Daniel.
July 8, 2010 at 7:13 AM in reply to: How to take leading zeros from a string in BizTalk mapper #25170Great Solution yaar, its working fine
-
AuthorPosts