Forum Replies Created
-
AuthorPosts
-
December 1, 2006 at 6:08 AM in reply to: Call Receive pipeline in orchestration to debatch a flat file #16655
I am doing the integrity check in the beginning of my orchestration and I would like to parse it as
Root
<Data>
</Data>
So if you could tell me how to use the pipeline in my orchestration it would be really great.
Thanks for your Help!!!!!!!!
December 1, 2006 at 6:02 AM in reply to: Need to make rows in a flat file into children in an XL file #16654I put the loop in and that fixed the problem.
Thanks
December 1, 2006 at 5:28 AM in reply to: Call Receive pipeline in orchestration to debatch a flat file #16653It seems you want to define the parsing schema as
<Rootnode>
<Header> (0,1)
<Data> (0,1)
<Trailer>(0,1)
So your batch is the whole file and each individual XML instance will either be a header, a data or a trailer record.
Then ignore the header and trailer in your application. This obviously does not preserve your integrity check, but it parses the instances like you want.
Hope that is useful
– weak architect
December 1, 2006 at 5:17 AM in reply to: BizTalk Maps: Does Custom xsl support the document function of XSLT #16652My uneducated guess would be that it doesn't have permission to see the external file path when it executes in Biztalk.
So although the function works, it effectively can;t do what you want because of security concerns. That would explain why it works in .net but not Biztalk.
-weak architect
December 1, 2006 at 4:11 AM in reply to: Call Receive pipeline in orchestration to debatch a flat file #16651I am pasting an Instance of my Schema
Header,Date,SystemID,Location
Data,Name,Amount,Customer,Location,Rating,Year,POSID
Trailer,DataRec
The above is my data file with the the data line Max occurance set to unbounded, As a matter of fact Every line starts with Header, Data or Trailer so we know what we are looking at.
The specs are
Header (1,1)
Data (0,Unbounded)
Trailer(1,1)
-Thanks
November 30, 2006 at 7:31 PM in reply to: BizTalk Maps: Does Custom xsl support the document function of XSLT #16648Hi Stephen,
Thanks for the reply. Here I am trying to avoid the Orchestration. I am using the custom xsl stylesheet(option to select the stylesheet in map properties), because when I use the BizTalk mapper my application gets hung and that is not serving my purpose. In the Biz Talk Mapper Tool scripting functoid I could call a dotnet component. But I am not able to use the Mapper and custom xsl together. Is there any way I can come to know if a particular xslt function is supported or not by the BizTalk Map.
Thanks
November 30, 2006 at 7:12 PM in reply to: Newbie: Flat file input sequence does not match Schema #16647Hello Greg,
Thanks for your offer. I actually found the solution in a reply that you made to post #3557 that you made to someone else!
Cheers
You need to implement your own COM Property Page;
You register the CLSID in the registry – see Configuration Property Pages on this page
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/BTS06CoreDocs/html/bc85b96e-7b7b-4131-88ec-87b419a61bc2.aspThere are very few details about creating this property page. I gave up and used the standard interface, which you can extend with dialogs
It looks like you missing the NAD loop in the input document you are trying to serialize.
Either add the data, which may not be an option for you , or remove the requirement for it in the schema. I am not sure how to do that in this hacked context, maybe you can figure it out.
November 30, 2006 at 11:03 AM in reply to: Call Receive pipeline in orchestration to debatch a flat file #16641Any chance of getting a whole file. With trailer records, it is not so much the Trailer record itself, as the preceding records which determine how you would debatch
November 30, 2006 at 10:55 AM in reply to: Having more schemas with the same root tag makes receive pipeline error #16640The error indicates that the message has made it thru the pipeline and has been published to the message box but cannot find a matching subscription. i.e. a send port or orchestration that will process the message. You need to check the subscriptions (use BTSSubscriptionViewer.exe) and match with the promoted properties.
What pipeline are you using?
If you have 2 schemas with the same MessageType (targetnamespace#rootnode) then you can specify the required schema in XML Disassembler pipeline component ( with BTS2004 you need to use a custom pipeline containing the Xml Disassembler)
Another option is to declare a single Envelope schema and debatch and forward the content of the envelope. You need to declare separate schemas for the content messages. I have not used SAP with Biztalk, so am not sure if this is possible
November 30, 2006 at 9:40 AM in reply to: SQL Adapter calling stored procedure that returns a number via a SELECT statement #16639Hey Bob,
I see your dilemma, as it's a common one when dealing with already-existing stored procs. First, this is a great BizTalk paper on the SQL Adapter (http://msdn2.microsoft.com/en-us/library/ms935658.aspx), so check that out.
To your point, I wouldn't say that using a component to call a proc is "bypassing standard BTS functionality." When using the SQL Adapter, one of the primary "value adds" is the generation of schemas. That's not really useful in your case. Given that you're just getting a value back from your call, you could still store that value in an orchestration variable, and use the BizTalk workflow to drive a next step based on it. The SQL Adapter is just one piece that you can choose to use, or ignore. There's still lots of other interfaces you can talk to besides SQL, and the workflow piece doesn't really care where the data comes from!
Does that help at all?
November 30, 2006 at 8:59 AM in reply to: SQL Adapter calling stored procedure that returns a number via a SELECT statement #16638Hi
no there is no xml auto … it does work though if the reponse is char rather than int – I would have expected that not to work either.
I am working with several hundred legacy stored procs on an MSSQL 2000 db, so I can't go changing them. It'd be a shame to have to bypass all of the standard BTS functionality … in fact it would be a major problem since we are supposed to be adopting BTS as our corporate standard workflow / interfacing tool !
Thx for the reply
Bob
Hi,
I want to convert an incoming xml file to an EDI file ie to CODECO D95 EDI format. As CODECO message format is not provided in Biztalk server 2006, i have created my own schema using the same rules and structure specified in http://www.stylusstudio.com/edifact/ and mapping with the incoming schema.
I m not getting the output. In the event viewer i am the below error. Pls can u tell me what this error means, i am not able to understand what is the error:
Error encountered: ERROR (36), docnr 10002 :
A required segment is not included in the document. Contact the sender.source format: [101 0 ,XML 1.0]
source document: [CODECOD 95BDEFAULT UN,Container gate-in/gate-out report m]
source segment: [data#3,def#1,name=EFACT_d95b_CODECO]
source element: [def#1,elm#0,comp#0,name=NADLoop1], (msgnr:1 segnr:3)(line:1 pos:40 filepos:320)Thanks
My email id is [email protected]
Gaurav Garg
A brief update. After allowing a database exception to suspend several records, I found that eventually I did see the exception logged correctly when handled within the Scope shape exception handler. Since I can detect an Error, now I can at least inform someone there was a generic DB error so that the message(s) can be reprocessed later. I just need to find a way to cleanly handle each specific situation based on the exception message contents or exception type.
BizTron.
-
AuthorPosts