IBM Support

PM62558: SchedulerNotAvailableException when EJBTimer task table created on derby database is compressed

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • This APAR upgrades Derby SDK to 10.3.3.1.1306694 in WebSphere
    Application Server
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server vV7.0                                *
    ****************************************************************
    * PROBLEM DESCRIPTION: Upgrade IBM DERBY SDK in WebSphere      *
    *                      Application Server V7.0 to fix          *
    *                      DERBY-4275                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When the EJBTimer task table created on derby database is
    compressed using the SYSCS_UTIL.SYSCS_COMPRESS_ TABLE, the
    following exception can occur in the WebSphere logs.
    SCHD0104E: The Scheduler poll daemon
    WebSphere_EJB_Timer_Service (WebSphere_EJB_Timer_Service)
    failed to load tasks from the database due to an exception:
    com.ibm.websphere.scheduler.SchedulerNotAvailableException:
    java.sql.SQLException: Container 4,768 not found.
    ...
    ...
    Caused by: ERROR XSCH1: Container 4,768 not found.
    at
    org.apache.derby.iapi.error.StandardException.newException(Unk
    nown  Source)
    at
    org.apache.derby.impl.store.access.heap.Heap.openScan(Unknown
    Source)
    .....
    It has been identified that this problem is fixed in the Derby
    SDK by the bug DERBY-4275 : Query executions fail when
    compressing a table using SYSCS_UTIL.SYSCS_COMPRESS_TABLE.
    Hence this APAR upgrades the IBM DERBY SDK to 10.3.3.1.1306694
    which fixes the DERBY-4275 issue.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM62558

  • Reported component name

    WEBSPHERE APP S

  • Reported component ID

    5724J0800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-04-16

  • Closed date

    2012-07-23

  • Last modified date

    2012-07-23

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    WEBSPHERE APP S

  • Fixed component ID

    5724J0800

Applicable component levels

  • R700 PSY

       UP



Document information

More support for: WebSphere Application Server
General

Software version: 7.0

Reference #: PM62558

Modified date: 23 July 2012