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
Expand all | Collapse all

[ISS.0137.0010E] Scheduler: Resources unavailable: [sag-cjdbc42-0011][Oracle JDBC Driver]Row update

  • 1.  [ISS.0137.0010E] Scheduler: Resources unavailable: [sag-cjdbc42-0011][Oracle JDBC Driver]Row update

    Posted Tue October 22, 2013 05:55 AM

    Hi All,

    Please suggest this error keeps on appearing in logs.ISInternal Pool size also increased and restarted.

    java.sql.SQLException: [sag-cjdbc42-0011][Oracle JDBC Driver]Row update failed.
    at com.wm.dd.jdbc.oraclebase.ddb9.b(Unknown Source)
    at com.wm.dd.jdbc.oraclebase.ddb9.a(Unknown Source)
    at com.wm.dd.jdbc.oraclebase.ddb8.b(Unknown Source)
    at com.wm.dd.jdbc.oraclebase.ddb8.a(Unknown Source)
    at com.wm.dd.jdbc.oraclebase.ddb8.a(Unknown Source)
    at com.wm.dd.jdbc.oraclebase.ddcx.a(Unknown Source)
    at com.wm.dd.jdbc.oraclebase.ddcx.k(Unknown Source)
    at com.wm.dd.jdbc.oraclebase.dddm.updateRow(Unknown Source)
    at com.wm.app.b2b.server.scheduler.ScheduleDB.runNextTask(ScheduleDB.java:1349)
    at com.wm.app.b2b.server.scheduler.ScheduleManager.run(ScheduleManager.java:134)
    at com.wm.util.pool.PooledThread.run(PooledThread.java:131)
    at java.lang.Thread.run(Thread.java:619)


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


  • 2.  RE: [ISS.0137.0010E] Scheduler: Resources unavailable: [sag-cjdbc42-0011][Oracle JDBC Driver]Row update

    Posted Tue October 22, 2013 12:55 PM

    Hi Aparna,

    Check the service usage whether there are any services getting hanged continuously which may block the threads.

    Have you checked whether the DB connectivity is fine ? and test the JDBC pools. and also post the complete error.

    Best Regards,
    Venkat.


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


  • 3.  RE: [ISS.0137.0010E] Scheduler: Resources unavailable: [sag-cjdbc42-0011][Oracle JDBC Driver]Row update

    Posted Tue October 22, 2013 01:51 PM

    Please check with your DBA also and make sure all the tables/account configuration created fine or not:

    HTH,
    RMG


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