Extra CRLF at end of Flat File

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

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.

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

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

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

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.

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

 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.

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.

  

ChildOrder property value must be Postfix.

Can i please have a copy of he trailer schema...