This section provides some debugging tips for resolving known scheduler problems.
Scheduler API and MBean management operations fail on Informix 7
Explanation | A SchedulerNotAvailable exception is created when running most Scheduler
API methods or WASScheduler MBean operations when the scheduler is configured
to use an Informix Version 7 database. The affected methods and operations
are: getTask, getTaskStatus, cancel, purge, suspend, and resume. The exception
created is:
com.ibm.websphere.scheduler.SchedulerNotAvailableException: java.sql.SQLException: Column (row_vers4ion) not found in any table in the query (or SLV is undefined). |
Possible causes | The SQL query that is used to load a task for Informix V7 databases has a typographical error: ROW_VERS4ION should be ROW_VERSION. |
Recommended response | Apply the next available service pack or use a more recent supported version of Informix. |
For current information available from IBM Support on known problems and their resolution, see the IBM customer support page.
IBM Support has documents that can save you time gathering information needed to resolve this problem. Before opening a PMR, see the IBM customer support page.
Related tasks
Using asynchronous beans