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 number
PK62226
Reported component name
WRKPLC WEB CON
Reported component ID
5724I2900
Reported release
60F
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-03-05
Closed date
2008-03-24
Last modified date
2009-11-04
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
[{"Business Unit":{"code":null,"label":null},"Product":{"code":"SUPPORT","label":"IBM Worldwide Support"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0.1.2","Edition":"","Line of Business":{"code":null,"label":null}}]
Document Information
Modified date:
10 September 2020