Using a trailer schema in a Flat File send pipeline

Home Page Forums BizTalk 2004 – BizTalk 2010 Using a trailer schema in a Flat File send pipeline

Viewing 1 reply thread
  • Author
    Posts
    • #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.

    • #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

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.