PK62226: EJBSCHEDULERBEAN.EXECUTE NOT LEVERAGING LOOKASIDE TABLE

APAR status

• Closed as program error.

Error description

• After Bulk load of content using the api 57,000 + entries added
  to the Scheduler Database causes the following exception
  CNTR0020E: EJB threw an unexpected (non-declared) exception
  during invocation of method "execute" on bean
  "BeanId(wcm#WCM_EJBs.jar#EJBScheduler, null)". Exception data:
  com.ibm.ejs.container.TimerServiceException:
  StatelessBeanO(BeanId(wcm#WCM_EJBs.jar#EJBScheduler, null),
  state = IN_METHOD)
   at com.ibm.ejs.container.BeanO.getTimers(BeanO.java:1579)
   at
  com.ibm.workplace.wcm.util.scheduler.ejb.EJBSchedulerBean.execut
  e(EJBSchedulerBean.java:627)
   at
  com.ibm.workplace.wcm.util.scheduler.ejb.EJSRemoteStatelessEJBSc
  heduler_27162c8e.execute(Unknown Source)
   at
  com.ibm.workplace.wcm.util.scheduler.ejb._EJBScheduler_Stub.exec
  ute(Unknown Source)
   at
  com.ibm.workplace.wcm.util.scheduler.service.SchedulerServiceImp
  l.execute(SchedulerServiceImpl.java:224)
   at com.aptrix.pluto.Pluto.startItemChangedTask(Pluto.java:594)
   at com.aptrix.pluto.Pluto.init(Pluto.java:274)
   at com.aptrix.pluto.PlutoModule.initPluto(PlutoModule.java:199)
   at com.aptrix.pluto.PlutoModule.init(PlutoModule.java:172)
   at
  com.presence.connect.business.module.ModuleStatus.initialise(Mod
  uleStatus.java:172)
   at
  com.presence.connect.business.module.ModuleManager.autoloadBL(Mo
  duleManager.java:586)
   at com.presence.connect.Connect.init(Connect.java:534)
   at com.presence.connect.Connect.safeInit(Connect.java:187)
   at com.presence.connect.Connect.getInstance(Connect.java:160)
   at
  com.presence.connect.ConnectServlet.init(ConnectServlet.java:8
  Caused by: com.ibm.ejs.container.TimerServiceException:
  BeanId(wcm#WCM_EJBs.jar#EJBScheduler, null)
   at
  com.ibm.ejs.container.TimerImpl.findTimersByBeanId(TimerImpl.jav
  a:492)
   at com.ibm.ejs.container.BeanO.getTimers(BeanO.java:1573)
   ... 34 more
  Caused by:
  com.ibm.websphere.scheduler.SchedulerNotAvailableException:
  com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -429,
  SQLSTATE: 54028, SQLERRMC: null
   at
  com.ibm.ws.scheduler.TaskStoreImpl.findByName(TaskStoreImpl.java
  (Compiled Code))
   at
  com.ibm.ws.scheduler.SchedulerImpl$7.run(SchedulerImpl.java:1909
  )
   at java.security.AccessController.doPrivileged1(Native Method)
   at
  java.security.AccessController.doPrivileged(AccessController.jav
  a(Compiled Code))
   at
  com.ibm.ws.scheduler.SchedulerImpl.find?yName(SchedulerImpl.java
  :1878)
   at
  com.ibm.ws.scheduler.SchedulerImpl.findByName(SchedulerImpl.java
  :1862)
   at
  com.ibm.ws.scheduler.SchedulerImpl.findTasksByName(SchedulerImpl
  .java:1825)
  Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error:
  SQLCODE: -429, SQLSTATE: 54028, SQLERRMC: null
   at com.ibm.db2.jcc.c.bh.b(bh.java(Compiled Code))
   at com.ibm.db2.jcc.c.bh.a(bh.java:3029)
   at com.ibm.db2.jcc.b.db.a(db.java(Inlined Compiled Code))
  
  Followed by this exception
  Pluto         E   Unable to schedule ItemChangedTask as part of
  Pluto initialization.
  
  com.ibm.workplace.wcm.util.scheduler.SchedulerException:
  java.rmi.ServerException: RemoteException occurred in server
  thread; nested exception is:
   java.rmi.RemoteException:  ; nested exception is:
   com.ibm.websphere.scheduler.SchedulerNotAvailableException:
  com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -429,
  SQLSTATE: 54028, SQLERRMC: null
   at
  com.ibm.workplace.wcm.util.scheduler.service.SchedulerServiceImp
  l.execute(SchedulerServiceImpl.java:228)
   at com.aptrix.pluto.Pluto.startItemChangedTask(Pluto.java:594)
   at com.aptrix.pluto.Pluto.init(Pluto.java:274)
   at com.aptrix.pluto.PlutoModule.initPluto(PlutoModule.java:199)
   at com.aptrix.pluto.PlutoModule.init(PlutoModule.java:172)
   at
  com.presence.connect.business.module.ModuleStatus.initialise(Mod
  uleStatus.java:172)
   at
  com.presence.connect.business.module.ModuleManager.autoloadBL(Mo
  duleManager.java:586)
   at com.presence.connect.Connect.init(Connect.java:534)
   at com.presence.connect.Connect.safeInit(Connect.java:187)
   at com.presence.connect.Connect.getInstance(Connect.java:160)
   at
  com.presence.connect.ConnectServlet.init(ConnectServlet.java:83)
  Caused by: java.rmi.ServerException: RemoteException occurred in
  server thread; nested exception is:
   java.rmi.RemoteException:  ; nested exception is:
   com.ibm.websphere.scheduler.SchedulerNotAvailableException:
  com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -429,
  SQLSTATE: 54028, SQLERRMC: null
   at
  com.ibm.CORBA.iiop.UtilDelegateImpl.mapSystemException(UtilDeleg
  ateImpl.java:165)
   at
  com.ibm.CORBA.iiop.UtilDelegateImpl.wrapException(UtilDelegateIm
  pl.java:700)
  Caused by: java.rmi.RemoteException:  ; nested exception is:
   com.ibm.websphere.scheduler.SchedulerNotAvailableException:
  com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -429,
  SQLSTATE: 54028, SQLERRMC: null
   at
  com.ibm.ws.scheduler.TaskStoreImpl.findByName(TaskStoreImpl.java
  (Compiled Code))
   at
  com.ibm.ws.scheduler.SchedulerImpl$7.run(SchedulerImpl.java:1909
  )
   at java.security.AccessController.doPrivileged1(Native Method)
  Caused by:
  com.ibm.websphere.scheduler.SchedulerNotAvailableException:
  com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -429,
  SQLSTATE: 54028, SQLERRMC: null
   ... 43 more
  Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error:
  SQLCODE: -429, SQLSTATE: 54028, SQLERRMC: null
   at com.ibm.db2.jcc.c.bh.b(bh.java(Compiled Code))
   at com.ibm.db2.jcc.c.bh.a(bh.java:3029)
   at com.ibm.db2.jcc.b.db.a(db.java(Inlined Compiled Code))
  

Local fix

Problem summary

• Summary: EJBSchedulerBean.execute() not leveraging WCM lookaside
  table for scheduled tasks
  

Problem conclusion

• Changed the execute to leverage the lookaside.
  
  An interim fix is available for this APAR from Fix Central at:
  
  6.0.1.3
  
  http://www.ibm.com/eserver/support/fixes/fixcentral/swgquickorde
  r?brandid=2&productid=Workplace%20Web%20Content%20Management&fix
  es=6.0.1.3-WCM-PK62226
  
  For release 6.0.1.2:
  
  http://www.ibm.com/eserver/support/fixes/fixcentral/swgquickorde
  r?brandid=2&productid=Workplace%20Web%20Content%20Management&fix
  es=6.0.1.2-WCM-PK62226
  
  
  You will need to cut/paste the entire URL into a browser to
  resolve the address.
  

Temporary fix

Comments

APAR Information

• 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

  WRKPLC WEB CON

• Fixed component ID

  5724I2900

Applicable component levels

• R60F PSY

     UP

• R60G PSY

     UP