quote:

---

> Hi All,
>
> I've been getting the following Duplicate Key Exception error messages
> poluting my ECMSG log files... I don't really use the scheduler, at least
> not directly... any idea what they are? Isn't the scheduler used to
> periodically refresh the user registry? Is the scheduler something I can
> deactivate? Are they clogging my database connections?
>
> I know I can blow away old scheduled jobs using the following SQL:
>
> --- begin SQL ---
> delete from schconfig
> where SCCINTERVAL = 0 and
> SCCPATHINFO = 'RefreshLocalRegistry' and
> SCCJOBREFNUM not in (select SCSJOBNBR from schstatus where SCSSTATE
> = 'I');
>
> delete from schconfig
> where SCCINTERVAL = 0 and
> SCCPATHINFO = 'AddProductsToSearchSpace' and
> SCCJOBREFNUM not in (select SCSJOBNBR from schstatus where SCSSTATE
> = 'I');
>
> delete from schconfig
> where SCCINTERVAL = 0 and
> SCCPATHINFO = 'UpdateSearchSpaces' and
> SCCJOBREFNUM not in (select SCSJOBNBR from schstatus where SCSSTATE
> = 'I');
>
> delete from schbrdcst
> where schbrdcst.JOBSTATE = 'C';
>
> delete from schstatus
> where SCSSTATE = 'C';
>
> commit;
> --- end SQL ---
>
> Thanks.
>
> -Doug
>
> ==============
> TimeStamp: 2003-03-06 20:07:32.328
> Thread ID: <Scheduler Main>
> Class: com.ibm.commerce.scheduler.Scheduler
> Method: getReadyToRunLateJob
> Severity: 1
> Message Text: CMN0409E The following error occurred during processing:
> javax.ejb.DuplicateKeyException.
> Exception: javax.ejb.DuplicateKeyException
> at
> com.ibm.ejs.persistence.EJSJDBCPersister.create(EJSJDBCPersister.java(Compil
> ed Code))
> at
> com.ibm.ejs.container.ContainerManagedBeanO.postCreate(ContainerManagedBeanO
> .java(Compiled Code))
> at com.ibm.ejs.container.EJSHome.postCreate(EJSHome.java(Compiled Code))
> at
> com.ibm.commerce.base.objects.EJSSchedulerBroadcastHomeBean.create(EJSSchedu
> lerBroadcastHomeBean.java(Compiled Code))
> at
> com.ibm.commerce.base.objects.EJSRemoteSchedulerBroadcastHome.create(EJSRemo
> teSchedulerBroadcastHome.java(Compiled Code))
> at
> com.ibm.commerce.base.objects._SchedulerBroadcastHome_BaseStub.create(_Sched
> ulerBroadcastHome_BaseStub.java(Compiled Code))
> at
> com.ibm.commerce.base.objects._SchedulerBroadcastHome_Stub.create(_Scheduler
> BroadcastHome_Stub.java(Compiled Code))
> at
> com.ibm.commerce.base.objects.SchedulerBroadcastAccessBean.<init>(SchedulerB
> roadcastAccessBean.java(Compiled Code))
> at
> com.ibm.commerce.scheduler.Scheduler.getReadyToRunLateJob(Scheduler.java(Com
> piled Code))
> at
> com.ibm.commerce.scheduler.Scheduler.prepareLateJobs(Scheduler.java(Compiled
> Code))
> at com.ibm.commerce.scheduler.Scheduler.serverLoop(Scheduler.java)
> at com.ibm.commerce.scheduler.Scheduler.run(Scheduler.java)

---