WebSphere Application Server Network Deployment, Version 6.0.x   Operating Systems: AIX, HP-UX, Linux, Solaris, Windows
             [TIP: Focusing the table of contents and search results]

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: Mar 8, 2007 8:14:28 PM CST
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r0/index.jsp?topic=/com.ibm.websphere.nd.doc/info/ae/scheduler/ref/rsch_trouble.html

© Copyright IBM Corporation 2002, 2006. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)