Extra CRLF at end of Flat File

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

  • This topic has 12 replies, 2 voices, and was last updated 4 years ago by community-content.
Viewing 2 reply threads
  • Author
    Posts
    • December 4, 2006 at 2:22 PM #16704
      community-content

        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

      • December 4, 2006 at 8:57 PM #16714
        community-content

          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.

          • December 5, 2006 at 5:03 AM #16722
            community-content

              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

              • December 5, 2006 at 12:31 PM #16732
                community-content

                  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

                  • December 5, 2006 at 8:18 PM #16739
                    community-content

                      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.

                      • December 7, 2006 at 2:08 PM #16782
                        community-content

                          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

                          • June 9, 2008 at 3:27 PM #19878
                            community-content

                               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.

                              • July 21, 2008 at 4:49 AM #20189
                                community-content

                                  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.

                                    

                      • December 5, 2006 at 12:21 PM #16731
                        community-content

                          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

                      • January 23, 2020 at 3:11 AM #44180
                        Paramjeet Sharma

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

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