WebSphere Application Server Network Deployment, Version 6.0.x     Operating Systems: AIX, HP-UX, Linux, Solaris, Windows

Troubleshooting schedulers

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

Reference topic    

Terms of Use | Feedback

Last updated: Dec 11, 2005 4:07:15 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, 2005. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)