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
Back to discussions
Expand all | Collapse all

Geting JDBC Connection Pool exception In analytic engine.

  • 1.  Geting JDBC Connection Pool exception In analytic engine.

    Posted Wed March 03, 2010 02:46 PM

    Hi All,

    i have sucessfully connected database pool and assigne anlatic engines in Define environment about one month back, today i am getting below errror, i have database connction pool and tested database connection it is sucessfully connected, please help me on this.

    (OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.UnknownKey] 2010-03-02 18:02:55.310 CET ERROR: Timed out attempting to get database connection for analysis.engine
    (OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.UnknownKey] 2010-03-02 18:02:55.310 CET ERROR: java.sql.SQLException: Connection unavailable
    at com.webMethods.sc.database.jdbcpools.alias.JDBCPortableAlias.getConnection(JDBCPortableAlias.java:70)
    at com.webMethods.bpo.database.SCGConnectionManager.getConnection(SCGConnectionManager.java:252)
    at com.webMethods.bpo.database.BaseStorage.getConnection(BaseStorage.java:33)
    at com.webMethods.optimize.timedims.TimeDimStorageJdbcImpl.locateId(TimeDimStorageJdbcImpl.java:150)
    at com.webMethods.optimize.timedims.TimeDimStorageJdbcImpl.locateId(TimeDimStorageJdbcImpl.java:125)
    at com.webMethods.optimize.event.engine.EventPersistenceBufferTransformer.getTimeFK(EventPersistenceBufferTransformer.java:169)
    at com.webMethods.optimize.event.engine.EventPersistenceBufferTransformer.populateForeignKeys(EventPersistenceBufferTransformer.java:206)
    at com.webMethods.optimize.event.engine.EventPersistenceBufferTransformer.addEvent(EventPersistenceBufferTransformer.java:98)
    at com.webMethods.optimize.core.AbstractEventProvider.addMappedEvent(AbstractEventProvider.java:119)
    at com.webMethods.optimize.event.engine.EventMapper.addStructAttribute(EventMapper.java:70)
    at com.webMethods.optimize.event.engine.EventMapper.addEvent(EventMapper.java:173)
    at com.webMethods.optimize.core.AbstractEventProvider.addDCAEvent(AbstractEventProvider.java:113)
    at com.webMethods.optimize.event.engine.EventStackAdapter.access$100(EventStackAdapter.java:34)
    at com.webMethods.optimize.event.engine.EventStackAdapter$AddEventTask.run(EventStackAdapter.java:109)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
    at java.util.concurrent.FutureTask.run(FutureTask.java:138)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    at java.lang.Thread.run(Thread.java:619)

    regards,
    anil kumar e


    #webMethods
    #webMethods-BPMS
    #BPM


  • 2.  RE: Geting JDBC Connection Pool exception In analytic engine.

    Posted Tue March 09, 2010 04:33 AM

    Hi,

    restart the ProcessAudit, ProcessEngine… in JDBC pools connection/Functional Alias Definitions.

    thanks,
    Vinod Kumar Ksheersagar


    #BPM
    #webMethods-BPMS
    #webMethods


  • 3.  RE: Geting JDBC Connection Pool exception In analytic engine.

    Posted Wed March 10, 2010 12:55 PM

    Hi Anil,

    have you resolved the issue?

    even i faced similar Error in nalytic Engine, and i resolved it.

    if u need any more help let me know.

    thanks,
    vinod kumar Ksheersagar


    #webMethods
    #BPM
    #webMethods-BPMS


Related Content