Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Using a trailer schema in a Flat File send pipeline
- This topic has 1 reply, 1 voice, and was last updated 9 years, 2 months ago by
community-content.
-
AuthorPosts
-
-
December 19, 2007 at 7:06 AM #18654
Anyone help me understand how to use a trailer schema to add final summary row to a csv file when writing out a flat file?
If I use only a header and document schema it all works fine. If I add a final message to the pipeline that has a Trailer schema selected, it gives an error:
There was a failure executing pipeline “XYZ.Training.Lesson4.Pipelines.SendPaymentRecords”. Error details: “The document type “http://XYZ.Training.Lesson4.Schemas.PaymentRecordSummary#FooterRecord” does not match any of the given schemas. “.
Exception type: XLANGPipelineManagerException
Source: Microsoft.XLANGs.Pipeline
Target Site: Void ExecutePipeline(Microsoft.BizTalk.PipelineOM.SendPipeline, Microsoft.XLANGs.Pipeline.SendPipelineInputMessages, Microsoft.XLANGs.BaseTypes.XLANGMessage)
The following is a stack trace that identifies the location where the exception occured
at Microsoft.XLANGs.Pipeline.XLANGPipelineManager.ExecutePipeline(SendPipeline p, SendPipelineInputMessages inMessages, XLANGMessage outMsg)
at Microsoft.XLANGs.Pipeline.XLANGPipelineManager.ExecuteSendPipeline(Type sendPipelineType, SendPipelineInputMessages inMessages, XLANGMessage outXLANGMsg)
at G4S.Training.Lesson4.ProcessPayments.segment2(StopConditions stopOn)
at Microsoft.XLANGs.Core.SegmentScheduler.RunASegment(Segment s, StopConditions stopCond, Exception& exp)
Additional error information:
Exception type: XmlAsmException
Source: XML assembler
Target Site: Microsoft.BizTalk.Message.Interop.IBaseMessage Assemble(Microsoft.BizTalk.Component.Interop.IPipelineContext)
The following is a stack trace that identifies the location where the exception occured
at Microsoft.BizTalk.Component.XmlAsmComp.Assemble(IPipelineContext pc)
at Microsoft.BizTalk.Component.FFDocumentStream.AlignStream()
at Microsoft.BizTalk.Component.FFDocumentStream.ReadInternal(Byte[] buffer, Int32 offset, Int32 count)
at Microsoft.BizTalk.Streaming.EventingReadStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at Microsoft.XLANGs.Pipeline.XLANGPipelineManager.ConvertStreamToVirtualStream(Stream inputStream)
at Microsoft.XLANGs.Pipeline.XLANGPipelineManager.WrapMessageWithVirtualStream(IBaseMessage msg)
at Microsoft.XLANGs.Pipeline.XLANGPipelineManager.ExecutePipeline(SendPipeline p, SendPipelineInputMessages inMessages, XLANGMessage outMsg)
The code in the orchestration does the following:
// Add trailer (footer) summary details to pipeline
PipeLineInput.Add(PaymentSummary);
// Execute send pipeline to create a single flat file output
PaymentsOut = null;
Microsoft.XLANGs.Pipeline.XLANGPipelineManager.ExecuteSendPipeline(typeof(XYZ.Training.Lesson4.Pipelines.SendPaymentRecords), PipeLineInput, PaymentsOut);
This works fine for adding messages of type Document schema but does not work adding messages of type Trailer schema.
I can’t find any decent tutorials on using Trailer schemas to read and write flat files that contain a footer or summary record that must be constructed in an Orchestration?
Any help appreciated.
Thanks.
-
January 19, 2008 at 10:28 PM #18804
Nice
[URL=http://hertz-car-audio.boardwalkferrari.cn/cars-and-truk-part.html#] cars and truk part [/URL]
cars and truk part
http://hertz-car-audio.boardwalkferrari.cn/cars-and-truk-part.html cars and truk part
[URL=http://bmw-girl-hot.boardwalkferrari.cn/porsche-autojumble.html#] porsche autojumble [/URL]
porsche autojumble
http://bmw-girl-hot.boardwalkferrari.cn/porsche-autojumble.html porsche autojumble
[URL=http://marinos-fine-car.boardwalkferrari.cn/95-bmw-m3-angel-eyes.html#] 95 bmw m3 angel eyes [/URL]
95 bmw m3 angel eyes
http://marinos-fine-car.boardwalkferrari.cn/95-bmw-m3-angel-eyes.html 95 bmw m3 angel eyes
[URL=http://hertz-car-audio.boardwalkferrari.cn/auto-car-franchise-wash.html#] auto car franchise wash [/URL]
auto car franchise wash
http://hertz-car-audio.boardwalkferrari.cn/auto-car-franchise-wash.html auto car franchise wash
[URL=http://buick-century-lacrosse.boardwalkferrari.cn/tie-rod-94-toyota-camery.html#] tie rod 94 toyota camery [/URL]
tie rod 94 toyota camery
http://buick-century-lacrosse.boardwalkferrari.cn/tie-rod-94-toyota-camery.html tie rod 94 toyota camery
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.