Extra CRLF at end of Flat File

Home Page Forums BizTalk 2004 – BizTalk 2010 Extra CRLF at end of Flat File

Viewing 2 reply threads
  • Author
    Posts
    • #16704

      Hello,

      I'm very new at BIZTalk.

      I have an electronic text file from a supplier. The records are delimited by CRLF and the child delimiter for the fields within the records are Prefix. The input file has an extra CRLF at the end of the file. When I delete this extra record and test via BIZTalk adminstration console it works fine. Next I've tried to add an extra child record with 1 child element to the end of the schema but BizTalk fails with the message:

      There was a failure executing the receive pipeline: "BizTestSchemas.BizTestPipeline, BizTestSchemas, Version=1.0.0.0, Culture=neutral, PublicKeyToken=607e7a326895630c" Source: "Flat file disassembler" Receive Port: "ReceivePort2" URI: "C:\BizTest\Filedrop\ReceiveInv\*.txt" Reason: The remaining stream has unrecognizable data.

       I think the properties for my extra record are incorrect.  What should the child delimiter and child type be for this extra CRLF be? There are no real child field and therefore I cannot set the child delimiter to Prefix.

       Any help will be much appreciated!

      Cheers

      Stable

    • #16714

      It’s been a while but I think there is a setting to ignore trailing delimiters.  I think it’s at the <Schema> level.  It’s a property.

       

      Never tried it before but it sound like it would work in your case.

      • #16722

        I think Stephen is maybe talking about Ignore CR and Ignore LF?  That is for handling parsing issues of the DOS pair CR/LF (hex 0D/0A), which is two chars instead of just one.

        If I understand correctly it sounds like there are two CR/LF at the end of your flat file? Try creating an outer record around your file that can absorb the extra CRLF.

        Otherwise explain the issue again if I have not understood it.  I just made some FF schemas recently, so I have the info fresh in my mind.

        – weak architect

        • #16732

          Hello,

          Thanks for your reply. I already had an outer record in the schema so added the trailer record on the end to absorb the extra CRLF but I still get the same “The remaining stream has unrecognizable data. ” error message. What should the child order and child delimiter type be for this trailer record? I suspect that could be the problem.

          Below is my schema:
































































































































































































































































































































































































































          Any help would be much appreciated.

          Cheers
          Stable

          • #16739

            I can’t think of anything else to try other than what’s suggested.

             

            Maybe on of the Records is in correctly makes Pre / Post / or Infixed?  Might want to double check that.  Otherwise, might have something else wrong. 

             

            If you want to email me the schema and sample file (email on Contact page) I should have some time to take a look at it.

            • #16782

              Hello,

              I have solved this problem.  Instead of adding another record in the schema I created a new trailer schema for this extra CRLF and set the trailer schema property in the Flat file dissassembler pipeline.

               Thanks to Greg and Stephen for reading this post.  As a newbie I really appreciate the help and am continually appreciative of the time others are so willing to give.

               Cheers

              Stable

              • #19878

                 Hi, can you share your trailer schema?  I am having the same issue and was able to solve it by creating the trailer schema.  However, for document that doesnt’ have the extra CrLf, it errors out with the following error:

                The trailer specification specified on the pipeline component properties does not contain an interchange trailer.

                • #20189

                  Hi, can you share your trailer schema to me too.

                  I’m having a similar problem and I want to test if your solution works for me.

                  Thanks.

                    

      • #16731

        Hi Stehen,
        Thanks for your reply. The suppress trailing delimiters property is available on the record below the schema level. I tried setting this but still got the same error.

        Cheers

    • #44180
      Paramjeet Sharma

        Hi, can you share your trailer schema to me too. this problem draging long. thanks in advance for help.

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