PM31502: "SCHD0130W: FAILED TO VERIFY THE SCHEDULER TABLES BECAUSE OF AN ERROR" OCCURS WITH ORACLE OCI JDBC DRIVER AFTER PM13659

Fixes are available

APAR status

Closed as program error.

Error description

After installing Fix Pack 13 (V7.0.0.13) for WebSphere
Application Server V7.0 or Fix Pack 35 (V6.1.0.35) for
WebSphere Application Server V6.1, the following error may occur
when verifying the Scheduler database tables on an Oracle
database if the Oracle OCI (thick) JDBC driver is used:
.
SCHD0130W: Failed to verify the scheduler tables because of an
error:
com.ibm.ws.scheduler.exception.SchedulerDataStoreException:
com.ibm.websphere.scheduler.SchedulerNotAvailableException:
java.sql.SQLException: Invalid column index
 at
com.ibm.ws.scheduler.WASSchedulerCfgHelper.verifyTables(WASSched
ulerCfgHelper.java:707)
 at
com.ibm.ws.scheduler.WASSchedulerCfgHelper.processLocally(WASSch
edulerCfgHelper.java:1124)
 at
com.ibm.ws.scheduler.WASSchedulerCfgHelper.processAtDelegate(WAS
SchedulerCfgHelper.java:1329)
 at
com.ibm.ws.scheduler.WASSchedulerCfgHelper.process(WASSchedulerC
fgHelper.java:1087)
 at
com.ibm.ws.scheduler.WASSchedulerCfgHelper.verifyTables(WASSched
ulerCfgHelper.java:355)
 at
com.ibm.ws.scheduler.WASSchedulerCfgHelper.verifyTables(WASSched
ulerCfgHelper.java:343)
 at
com.ibm.ws.scheduler.WASSchedulerCfgHelperMbeanWrapper.verifyTab
les(WASSchedulerCfgHelperMbeanWrapper.java:107)
...
Caused by:
com.ibm.websphere.scheduler.SchedulerNotAvailableException:
java.sql.SQLException: Invalid column index
 at
com.ibm.ws.scheduler.TaskStoreImpl.create(TaskStoreImpl.java:494
)
 at
com.ibm.ws.scheduler.WASSchedulerCfgHelper.verifyTables(WASSched
ulerCfgHelper.java:651)
...
Caused by: java.sql.SQLException: Invalid column index
 at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError
.java:145)
 at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError
.java:190)
 at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError
.java:286)
 at
oracle.jdbc.driver.OraclePreparedStatement.setLongInternal(Oracl
ePreparedStatement.java:5105)
 at
oracle.jdbc.driver.OraclePreparedStatement.setLong(OraclePrepare
dStatement.java:5097)
 at
com.ibm.ws.scheduler.TaskStoreImpl.setLong(TaskStoreImpl.java:23
06)
 at
com.ibm.ws.scheduler.TaskStoreImpl.create(TaskStoreImpl.java:400
)
...
This is due to an error in the fix for APAR PM13659.

Local fix

Problem summary

****************************************************************
* USERS AFFECTED:  All users of IBM WebSphere Application      *
*                  Server                                      *
****************************************************************
* PROBLEM DESCRIPTION: VerifyTables operation for scheduler    *
*                      tables using the Oracle OCI driver      *
*                      can result in SQLException: Invalid     *
*                      column index                            *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
The Application Server Relational Resource Adapter (RRA) code
was using an incorrect internal TaskStore helper class when an
Oracle OCI JDBC Driver was configured. This helper class was
referring to an invalid column index of the Scheduler TASK
table and because of this the VerifyTables operation from the
administrative console for the scheduler tables results in
java.sql.SQLException: Invalid column index .

Problem conclusion

The RRA code has been corrected such that the right TaskStore
helper class is used for the OCI JDBC Driver.

The fix for this APAR is currently targeted for inclusion in
fix packs 7.0.0.19 & 6.1.0.39.  Please refer to the Recommended
Updates page for delivery information:
http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980

Temporary fix

Comments

APAR Information

APAR number
PM31502
Reported component name
WEBS APP SERV N
Reported component ID
5724H8800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-01-28
Closed date
2011-03-29
Last modified date
2011-07-26

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
WEBS APP SERV N
Fixed component ID
5724H8800

Applicable component levels

R61A PSY
UP
R61H PSY
UP
R61I PSY
UP
R61P PSY
UP
R61S PSY
UP
R61W PSY
UP
R61Z PSY
UP
R700 PSY
UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
27 October 2021

Tips

PM31502: "SCHD0130W: FAILED TO VERIFY THE SCHEDULER TABLES BECAUSE OF AN ERROR" OCCURS WITH ORACLE OCI JDBC DRIVER AFTER PM13659

Fixes are available

Subscribe

APAR status

Closed as program error.

Error description

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

APAR number

Reported component name

Reported component ID

Reported release

Status

PE

HIPER

Special Attention

Submitted date

Closed date

Last modified date

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

Fixed component ID

Applicable component levels

R61A PSY

R61H PSY

R61I PSY

R61P PSY

R61S PSY

R61W PSY

R61Z PSY

R700 PSY

Document Information

Share your feedback

Need support?