Troubleshooting schedulers

This topic 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.

IBM® Support has documents and tools that can save you time gathering information needed to resolve problems as described in Troubleshooting help from IBM. Before opening a problem report, see the Support page:



Related tasks
Using asynchronous beans
Reference topic    

Terms of Use | Feedback

Last updated: Aug 29, 2010 10:43:27 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=v602web&product=was-nd-mp&topic=rsch_trouble
File name: rsch_trouble.html