IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
  • 1.  Delimited flat file schema problem

    Posted Mon February 06, 2006 01:17 PM

    I am new to webMethods, I am getting one problem while trying to prase the following file
    NEST2606.011,NEST
    1001,mum,10.00,20050626,07
    1002,mum,10.00,20050726,07
    2,20.00

    Where first line is the Header part, other 2 lines are transaction part which may occure multiple times and last line is footer part.
    I have created the the schema accordingly accordingly with transaction records max repeat is unlimited. header and footer is 1.

    In Flat File Definition → record parser, I have selected as Demiliter.
    Record: newline
    subfield: ,

    But while test run, it gives me the following error
    com.wm.ui.UiException: com.wm.ff.parse.ParseException: [FFP.0012.0004]
    Found no valid records
    Could anyone please help me out here, I tried to search similar problems but could not get the solution.
    Thanks in advance
    Vedant


    #webMethods
    #Integration-Server-and-ESB
    #edi


  • 2.  RE: Delimited flat file schema problem

    Posted Mon February 06, 2006 03:29 PM

    Did you choose nth field option?looks like your file is comma seperated file…
    So start the field1 as 0 and so on…
    What is ur RecordDefinition recordWithNoId?

    HTH,
    RMG


    #webMethods
    #edi
    #Integration-Server-and-ESB


  • 3.  RE: Delimited flat file schema problem

    Posted Tue February 07, 2006 05:43 AM

    Yes, I have mentioned nth field. and field 1 from 0.I am using webMethods 6.0.1. I am not sure what is recorddefinition.


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 4.  RE: Delimited flat file schema problem

    Posted Tue February 07, 2006 03:07 PM

    Basically you have to specify RecordDefinition (recordWithNoID)since your file dont have any starting record identifier to parse the file…so try this option and create field definitions (nth fields)under this record definition.

    HTH,
    RMG


    #webMethods
    #edi
    #Integration-Server-and-ESB