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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  Database Storage problem

    Posted 04/16/07 07:47 PM

    Hi ,

    Anyone havng Idea about the followin exception .

    Database Storage problem. Exception: [wm-cjdbc32-0014][Oracle JDBC Driver]No more data available to read


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 2.  RE: Database Storage problem

    Posted 04/17/07 10:47 AM

    a similar error, returned by WmDB+Oracle JDBC driver, is “no more data to read from socket” and it’s usually returned when your session is killed or the database went down. Have you checked if something happened on database side?

    Sandro


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 3.  RE: Database Storage problem

    Posted 04/17/07 03:03 PM

    This can happen if the connection to the database is somehow lost (ie. database or network went down) and you’re left with a bad connection in the pool. Check the pool settings for that JDBC Adapter connection. If Minimum Pool Size is set to something other than zero, then consider setting it to zero. This causes the IS to get rid of stale connections.

    • Percio

    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 4.  RE: Database Storage problem

    Posted 04/17/07 09:58 PM

    Hi Percio / Sandro ,

    Actually I am dealing with any Database here ., We have process which takes the Flatfile (More than 32 mb) webMethod will spilts that into small files (each 2000 kb ) than loop on filenames to map the EDI Format … this will generate the .xxx file ., then .xxx file will be validate against HIPPA .

    I am able to gererate the .xxx file and validation is went fine for small files…
    even Once I process same file havimg 32mb and validated against HIPPA.

    But same file failed and getting NO MORE DATA TO READ error.

    let me know do you have any idea?

    Thanks ,
    Raj


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 5.  RE: Database Storage problem

    Posted 04/17/07 10:11 PM


  • 6.  RE: Database Storage problem

    Posted 04/17/07 10:46 PM

    It might have problem with Internnel tables ? do you have idea about cjdbd32 builds ?

    Raj


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB