# Flat File "no Valid Records Found Error" **URL:** \ **Category:** Forum\ **Tags:** EDI\ **Created:** [May 20, 2008, 6:16pm UTC](https://techcommunity.softwareag.com/t/flat-file-no-valid-records-found-error/109586 "2008-05-20T18:16:03Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![greatnav](https://avatars.discourse-cdn.com/v4/letter/g/ee7513/32.png) [@greatnav](https://techcommunity.softwareag.com/u/greatnav)\ **Post date:** [May 20, 2008, 6:16pm UTC](https://techcommunity.softwareag.com/t/flat-file-no-valid-records-found-error/109586/1 "2008-05-20T18:16:03Z")
HI guys, I have created a schema which would parse a file with each record being of 1304 characters. In addition to fixed length, they are line delimited as well. Now, the characters/fields inside each record can be identified with only thier positions. i have created the schema in which i have selected fixed length as type of record. I have left all other options in the Flat file Defination window as empty.( i am using webMethods 7.x developer). Coming to flat File structure window, i have created each of those fields with extractor being the position.(1-3,3-6…etc). But when i try to run the schema or use the converttoValues, it eventually errors out saying “No valid records found”… I have tried to use Delimted instead of fixed lenght…but same problem… What could be the issue…kindly help. ---
**Author:** ![gupta\_r.17495](https://avatars.discourse-cdn.com/v4/letter/g/9fc348/32.png) [@gupta\_r.17495](https://techcommunity.softwareag.com/u/gupta_r.17495)\ **Post date:** [May 20, 2008, 9:20pm UTC](https://techcommunity.softwareag.com/t/flat-file-no-valid-records-found-error/109586/2 "2008-05-20T21:20:44Z")
The error indicates your FFSchema is not matching according to your ffData. You have to make sure your given FlatFileDefinition with delimiter option Record,Field or Composite and select Starts at Position 0 How is your ff data looks like?? and whats your currect Schema setup against it. HTH, RMG ---
**Author:** ![greatnav](https://avatars.discourse-cdn.com/v4/letter/g/ee7513/32.png) [@greatnav](https://techcommunity.softwareag.com/u/greatnav)\ **Post date:** [May 21, 2008, 11:37am UTC](https://techcommunity.softwareag.com/t/flat-file-no-valid-records-found-error/109586/3 "2008-05-21T11:37:19Z")
Basically, Its a text file with .txt extension. please see attached txt file for details. Its fields are basically position based and i have created schema according to it. But no matter what i am unable to get rid of this errror “No valid Records found”. [myname.txt](https://techcommunity.softwareag.com/uploads/short-url/oVMFo72Lv2TkOJfSlaHI9lcWQME.txt) (1.28 KB) ---
**Author:** ![gupta\_r.17495](https://avatars.discourse-cdn.com/v4/letter/g/9fc348/32.png) [@gupta\_r.17495](https://techcommunity.softwareag.com/u/gupta_r.17495)\ **Post date:** [May 21, 2008, 6:59pm UTC](https://techcommunity.softwareag.com/t/flat-file-no-valid-records-found-error/109586/4 "2008-05-21T18:59:56Z")
This doesnt have any delimiters…Basically then you got to choose Fixed length option and specify Start/End positions. What is your RecordDefinition set to?? Is it recordWithNoID and beneath you have to create FieldDefinitions(position based)… The error indicates the data file cannot be parsed with the schema you have in place… HTH, RMG ---
**Author:** ![greatnav](https://avatars.discourse-cdn.com/v4/letter/g/ee7513/32.png) [@greatnav](https://techcommunity.softwareag.com/u/greatnav)\ **Post date:** [May 21, 2008, 7:09pm UTC](https://techcommunity.softwareag.com/t/flat-file-no-valid-records-found-error/109586/5 "2008-05-21T19:09:30Z")
HI RMG, Thanks for your help, Basically i have created a schema in which i have defined a record name. Under the record, i have defined fields based on Positions. For example , field 1 starts from 0-3, field 2 from 3-4 etc. what is recordWithNoID? Any help is appreciated 🙂 Thanks. ---
**Author:** ![gupta\_r.17495](https://avatars.discourse-cdn.com/v4/letter/g/9fc348/32.png) [@gupta\_r.17495](https://techcommunity.softwareag.com/u/gupta_r.17495)\ **Post date:** [May 21, 2008, 7:11pm UTC](https://techcommunity.softwareag.com/t/flat-file-no-valid-records-found-error/109586/6 "2008-05-21T19:11:04Z")
You have to define the record name as “recordWithNoID” (maxRepeat=1 or ulimited) and beneath this create the FieldDefinitions and try it…When i looked at your data there is no record identifier exist,so recordWithNoID is the option to parse the file correctly. HTH, RMG ---
**Author:** ![greatnav](https://avatars.discourse-cdn.com/v4/letter/g/ee7513/32.png) [@greatnav](https://techcommunity.softwareag.com/u/greatnav)\ **Post date:** [May 21, 2008, 7:26pm UTC](https://techcommunity.softwareag.com/t/flat-file-no-valid-records-found-error/109586/7 "2008-05-21T19:26:10Z")
RMG, Thanks again, I did what you said , and it still gives the error… I have attached the schema in the package. If you could look at it and point out what is amiss , i would be reaalllly grateful 🙂 [dummyPackage.zip](https://techcommunity.softwareag.com/uploads/short-url/v14LO52qSL6kpY8SJmDGjkkPDIa.zip) (5.29 KB) ---
**Author:** ![gupta\_r.17495](https://avatars.discourse-cdn.com/v4/letter/g/9fc348/32.png) [@gupta\_r.17495](https://techcommunity.softwareag.com/u/gupta_r.17495)\ **Post date:** [May 21, 2008, 7:50pm UTC](https://techcommunity.softwareag.com/t/flat-file-no-valid-records-found-error/109586/8 "2008-05-21T19:50:27Z")
Sorry at this time…you got to play with the recordWithNoID option and make adjustments to your schema…I cannot load your package at this moment. I know it will be tricky to parse the files against schema…sometimes trying R&D is worth as a learning curve. HTH, RMg ---
**Author:** ![rockylee](https://avatars.discourse-cdn.com/v4/letter/r/ed655f/32.png) [@rockylee](https://techcommunity.softwareag.com/u/rockylee)\ **Post date:** [May 24, 2008, 3:42pm UTC](https://techcommunity.softwareag.com/t/flat-file-no-valid-records-found-error/109586/9 "2008-05-24T15:42:27Z")
When i use your schema in your dummyPackage.zip, also have the same issue“Found no valid records”. I try to fix it and find the way to fix it.🙂 There are two things you got to do: 1. create a flat file dictionary. 2.To set the default record, open the flat file schema and click on the tab of the schema so that you see the properties for the entire schema. You will see a property called ‘Default Record’. You will need to click the Set… button under the Value column and then choose the corresponding record in your dictionary. [dummyPackage.zip](https://techcommunity.softwareag.com/uploads/short-url/r6rEjJeRn4XpfyzYmD7t4ByRElj.zip) (11.3 KB) ---
**Author:** ![greatnav](https://avatars.discourse-cdn.com/v4/letter/g/ee7513/32.png) [@greatnav](https://techcommunity.softwareag.com/u/greatnav)\ **Post date:** [June 2, 2008, 1:20pm UTC](https://techcommunity.softwareag.com/t/flat-file-no-valid-records-found-error/109586/10 "2008-06-02T13:20:07Z")
RockyLee my man … You rock!!!😃 It works…and this is perfect solution for this problem. Thanks 🙂 ---
**Author:** ![Anupam\_Deb](https://avatars.discourse-cdn.com/v4/letter/a/ed8c4c/32.png) [@Anupam\_Deb](https://techcommunity.softwareag.com/u/Anupam_Deb)\ **Post date:** [April 9, 2012, 4:03pm UTC](https://techcommunity.softwareag.com/t/flat-file-no-valid-records-found-error/109586/11 "2012-04-09T16:03:28Z")
RockyLee…it really works…perfect man… :)🙂 Thanks Anupam ---
**Author:** ![gupta\_r.17495](https://avatars.discourse-cdn.com/v4/letter/g/9fc348/32.png) [@gupta\_r.17495](https://techcommunity.softwareag.com/u/gupta_r.17495)\ **Post date:** [April 9, 2012, 6:34pm UTC](https://techcommunity.softwareag.com/t/flat-file-no-valid-records-found-error/109586/12 "2012-04-09T18:34:11Z")
Enjoy your day man! ---
**Author:** ![Anupam\_Deb](https://avatars.discourse-cdn.com/v4/letter/a/ed8c4c/32.png) [@Anupam\_Deb](https://techcommunity.softwareag.com/u/Anupam_Deb)\ **Post date:** [April 17, 2012, 11:42pm UTC](https://techcommunity.softwareag.com/t/flat-file-no-valid-records-found-error/109586/13 "2012-04-17T23:42:03Z")
Hi Can anybody explain me why such a case works perfectly fine with a FF dictionary reference in the schema,but when we r creating a schema in a regular way without referring to the dictionary its throwing this error… Recently I created a tab delimited FF schema having only 3 fields…my PL asked me not to use dictionary for such a small schema ,but it didn’t work without the FF dict reference(was throwing this error)…So I again created a new FF schema with FF dict reference… ---
**Author:** ![gupta\_r.17495](https://avatars.discourse-cdn.com/v4/letter/g/9fc348/32.png) [@gupta\_r.17495](https://techcommunity.softwareag.com/u/gupta_r.17495)\ **Post date:** [April 17, 2012, 11:51pm UTC](https://techcommunity.softwareag.com/t/flat-file-no-valid-records-found-error/109586/14 "2012-04-17T23:51:10Z")
FFSchema should work independently with out Dictionary also… Not sure why you are getting the error. May be your schema not matching exactly per the file sample you are testing against? And obviously flatfile:convertToValues parsing (data issue or delimiters or other simple reasons) could cause that error.So you should debug and run sample file with it: HTH, RMG ---
**Author:** ![Anupam\_Deb](https://avatars.discourse-cdn.com/v4/letter/a/ed8c4c/32.png) [@Anupam\_Deb](https://techcommunity.softwareag.com/u/Anupam_Deb)\ **Post date:** [April 18, 2012, 12:10am UTC](https://techcommunity.softwareag.com/t/flat-file-no-valid-records-found-error/109586/15 "2012-04-18T00:10:14Z")
> [@rmg;83665](#): > > FFSchema should work independently with out Dictionary also… > > Not sure why you are getting the error. > > May be your schema not matching exactly per the file sample you are testing against? And obviously flatfile:convertToValues parsing (data issue or delimiters or other simple reasons) could cause that error.So you should debug and run sample file with it: > > HTH, > RMG ---
**Author:** ![Anupam\_Deb](https://avatars.discourse-cdn.com/v4/letter/a/ed8c4c/32.png) [@Anupam\_Deb](https://techcommunity.softwareag.com/u/Anupam_Deb)\ **Post date:** [April 18, 2012, 12:13am UTC](https://techcommunity.softwareag.com/t/flat-file-no-valid-records-found-error/109586/16 "2012-04-18T00:13:07Z")
Hi RMG, Thanks for the reply.I’ll try to debug it once again… Regards Anupam ---
**Author:** ![gupta\_r.17495](https://avatars.discourse-cdn.com/v4/letter/g/9fc348/32.png) [@gupta\_r.17495](https://techcommunity.softwareag.com/u/gupta_r.17495)\ **Post date:** [April 18, 2012, 7:03pm UTC](https://techcommunity.softwareag.com/t/flat-file-no-valid-records-found-error/109586/17 "2012-04-18T19:03:15Z")
good deal: ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [April 2, 2021, 3:05pm UTC](https://techcommunity.softwareag.com/t/flat-file-no-valid-records-found-error/109586/18 "2021-04-02T15:05:46Z")