APAR status
Closed as program error.
Error description
Customer created ALIAS for the Scheduler's tables, i.e.
CREATE ALIAS "PORTTEST"."SCHED_TASK" FOR "TZEP "."EPT200";
The Scheduler in WSAS 5.0.2 has the following code:
String[] types = new String[] { "TABLE", "VIEW" };
DatabaseMetaData dmd = con.getMetaData();
ResultSet rsTables = dmd.getTables(null, "%",
tableName, types);
Since the Scheduler's tables have type "ALIAS", the getTables
call gets empty resultset which triggers the following error:
1/25/05 9:16:31:017 EST] 5067a8f1 SchedulerAdmi E
org.cmlconnect.scheduledtask.ejb.SchedulerAdminBean
TRAS0014I: The
following exception was logged
com.ibm.websphere.scheduler.SchedulerNotAvailableException:
The Scheduler tables are not accessible.
at
com.ibm.ws.scheduler.SchedulerImpl.findByName(SchedulerImpl.ja
va:1307)
Local fix
Create tables for Scheduler's tables instead of ALIAS.
Problem summary
****************************************************************
* USERS AFFECTED: All WebSphere Application Server Users *
* of Scheduler who create table ALIASs. *
****************************************************************
* PROBLEM DESCRIPTION: 1/25/05 9:16:31:017 EST] 5067a8f1 *
* SchedulerAdmi E org.cmlconnect. *
* scheduledtask.ejb.SchedulerAdminBean *
* TRAS0014I: The following exception was *
* logged *
* com.ibm.websphere.scheduler. *
* SchedulerNotAvailableException: *
* The Scheduler tables are not *
* accessible. at *
* com.ibm.ws.scheduler.SchedulerImpl. *
* findByName *
* (SchedulerImpl.java:1307) *
****************************************************************
* RECOMMENDATION: *
****************************************************************
Customer created an ALIAS for the Scheduler's tables, i.e.
CREATE ALIAS "PORTTEST"."SCHED_TASK" FOR "TZEP
"."EPT200"; The Scheduler in Application Server 5.0.2 has the
following code:
String[] types = new String[] { "TABLE", "VIEW" };
DatabaseMetaData dmd = con.getMetaData();
ResultSet rsTables = dmd.getTables(null, "%",
tableName, types);
Since the Scheduler's tables have type "ALIAS", the
getTables call gets an empty resultset which triggers
the error.
Problem conclusion
ALIAS was added, so after applying the fixpack with this
APAR fix it should work. The work-around is to Create
tables for Scheduler's tables instead of using ALIAS.
The fix for this APAR is currently targeted for inclusion
in 5.02.11 and 5.1.1.5.
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 |
PK01665 |
Reported component name |
WAS BASE 5.0 |
Reported component ID |
5630A3600 |
Reported release |
00W |
Status |
CLOSED PER |
PE |
NoPE |
HIPER |
NoHIPER |
Special Attention |
NoSpecatt |
Submitted date |
2005-02-24 |
Closed date |
2005-04-11 |
Last modified date |
2005-04-11 |
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
Publications Referenced
|
Fix information |
Fixed component name |
WAS BASE 5.0 |
Fixed component ID |
5630A3600 |
Applicable component levels |
R003 PSY |
UP |
R00A PSY |
UP |
R00H PSY |
UP |
R00I PSY |
UP |
R00P PSY |
UP |
R00S PSY |
UP |
R00W PSY |
UP |
R103 PSY |
UP |
R10A PSY |
UP |
R10H PSY |
UP |
R10I PSY |
UP |
R10P PSY |
UP |
R10S PSY |
UP |
R10W PSY |
UP |
|