org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: ORA-00942: table or view does not exist [See nested exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ]]

Oracle Community | Gaff | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Can't install BI Publisher Scheduler Schema

    Oracle Community | 6 years ago | Gaff
    org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: ORA-00942: table or view does not exist [See nested exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ]]

    Root Cause Analysis

    1. org.quartz.SchedulerConfigException

      Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: ORA-00942: table or view does not exist [See nested exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ]]

      at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize()
    2. quartz
      QuartzInitializerServlet.init
      1. org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:493)
      2. org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:68)
      3. org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010)
      4. org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152)
      5. org.quartz.ee.servlet.QuartzInitializerServlet.init(QuartzInitializerServlet.java:157)
      5 frames
    3. oracle.apps.xdo
      ExtendedQuartzInitializerServlet.init
      1. oracle.apps.xdo.servlet.scheduler.quartz.ExtendedQuartzInitializerServlet.init(ExtendedQuartzInitializerServlet.java:124)
      1 frame
    4. Atmosphere weblogic
      StubSecurityHelper$ServletInitAction.run
      1. weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:283)
      1 frame
    5. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    6. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
      1 frame
    7. Atmosphere weblogic
      WebAppModule.start
      1. weblogic.servlet.internal.StubSecurityHelper.createServlet(StubSecurityHelper.java:64)
      2. weblogic.servlet.internal.StubLifecycleHelper.createOneInstance(StubLifecycleHelper.java:58)
      3. weblogic.servlet.internal.StubLifecycleHelper.<init>(StubLifecycleHelper.java:48)
      4. weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubImpl.java:531)
      5. weblogic.servlet.internal.WebAppServletContext.preloadServlet(WebAppServletContext.java:1915)
      6. weblogic.servlet.internal.WebAppServletContext.loadServletsOnStartup(WebAppServletContext.java:1889)
      7. weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1807)
      8. weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3045)
      9. weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1397)
      10. weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
      10 frames
    8. weblogic.application.internal
      ModuleStateDriver$3.next
      1. weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
      1 frame
    9. weblogic.application.utils
      StateMachineDriver.nextState
      1. weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
      1 frame
    10. weblogic.application.internal
      ModuleStateDriver$3.next
      1. weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
      2. weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
      3. weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:247)
      4. weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
      4 frames
    11. weblogic.application.utils
      StateMachineDriver.nextState
      1. weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
      1 frame
    12. weblogic.application.internal
      BaseDeployment$2.next
      1. weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
      2. weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27)
      3. weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:1267)
      3 frames
    13. weblogic.application.utils
      StateMachineDriver.nextState
      1. weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
      1 frame
    14. weblogic.application.internal
      DeploymentStateChecker.activate
      1. weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:409)
      2. weblogic.application.internal.SingleModuleDeployment.activate(SingleModuleDeployment.java:39)
      3. weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:161)
      3 frames
    15. weblogic.deploy.internal
      DeploymentServiceDispatcher.commit
      1. weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79)
      2. weblogic.deploy.internal.targetserver.operations.AbstractOperation.activate(AbstractOperation.java:569)
      3. weblogic.deploy.internal.targetserver.operations.ActivateOperation.activateDeployment(ActivateOperation.java:150)
      4. weblogic.deploy.internal.targetserver.operations.ActivateOperation.doCommit(ActivateOperation.java:116)
      5. weblogic.deploy.internal.targetserver.operations.AbstractOperation.commit(AbstractOperation.java:323)
      6. weblogic.deploy.internal.targetserver.DeploymentManager.handleDeploymentCommit(DeploymentManager.java:844)
      7. weblogic.deploy.internal.targetserver.DeploymentManager.activateDeploymentList(DeploymentManager.java:1253)
      8. weblogic.deploy.internal.targetserver.DeploymentManager.handleCommit(DeploymentManager.java:440)
      9. weblogic.deploy.internal.targetserver.DeploymentServiceDispatcher.commit(DeploymentServiceDispatcher.java:163)
      9 frames
    16. weblogic.deploy.service
      DeploymentReceiverCallbackDeliverer$2.run
      1. weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.doCommitCallback(DeploymentReceiverCallbackDeliverer.java:181)
      2. weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.access$100(DeploymentReceiverCallbackDeliverer.java:12)
      3. weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer$2.run(DeploymentReceiverCallbackDeliverer.java:67)
      3 frames
    17. weblogic.work
      ExecuteThread.run
      1. weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:516)
      2. weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
      3. weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
      3 frames