webMethods

webMethods

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.  Variable Length Flatfile implementation issue

    Posted Sat November 18, 2023 11:47 PM

    RecordType,Name,Age,Address
    1,John,25,123 Main St
    2,Jane,30,456 Oak St,Apartment 5

    Here im taking sample input as this to parse a variable length getting below error

    [Could not run ‘flatFile.docs:variablelength’
    com.wm.app.b2b.server.ServiceException: java.io.IOException: [FFP.0014.0003] Variable Length file format invalid, file ended before record filled

    com.wm.app.b2b.server.ServiceException: java.io.IOException: [FFP.0014.0003] Variable Length file format invalid, file ended before record filled
    at pub.flatFileImpl.convertToValues(flatFileImpl.java:426)]

    Can anyone please help out with this.


    #webMethods
    #Integration-Server-and-ESB
    #Service-Designer


  • 2.  RE: Variable Length Flatfile implementation issue

    Posted Mon November 20, 2023 05:24 AM

    Hi Manikanta,

    can you add screenshots for your FlatFile-Dictionary, -Schema and -DocType please?

    Which version of wM are you using?
    Any Fixes applied your instance?

    Regards,
    Holger


    #webMethods
    #Integration-Server-and-ESB
    #Service-Designer


  • 3.  RE: Variable Length Flatfile implementation issue

    Posted Tue November 21, 2023 06:53 AM

    @Manikanta Please share the scheme definitions screenshots as well ?


    #Service-Designer
    #Integration-Server-and-ESB
    #webMethods


  • 4.  RE: Variable Length Flatfile implementation issue

    Posted Tue November 28, 2023 05:49 AM


  • 5.  RE: Variable Length Flatfile implementation issue

    Posted Tue November 28, 2023 05:49 AM


  • 6.  RE: Variable Length Flatfile implementation issue

    Posted Tue November 28, 2023 08:20 AM

    Hi,

    can you share the “Flat File Structure” tab as well, please?

    Regards,
    Holger


    #Service-Designer
    #Integration-Server-and-ESB
    #webMethods


  • 7.  RE: Variable Length Flatfile implementation issue

    Posted Tue November 28, 2023 02:08 PM

    Based upon the data shared, the type of parser you want is Delimiter not Variable length assuming your intent is to parse each row into records with fields (elements in an IS document).

    Assuming that is what you want, for the data you shared, the record delimiter is newline and the field delimiter is comma. You’ll also want to define the quoted release character and the release character – specifying these will allow the data values to have delimiter characters by escaping them. Read the documentation on this for details.


    #webMethods
    #Service-Designer
    #Integration-Server-and-ESB