Forum Stats

  • 3,769,815 Users
  • 2,253,026 Discussions
  • 7,875,214 Comments

Discussions

EPM 11.2.5 Servlet: "WorkflowEngine" failed to preload on startup in Web application: "interop".

I installed and configured EPM 11.2.5 successfully.


But the Foundation service can not start up correctly. I reconfigured the foundation but no luck.

I got following errors from the Foundation logs:

How can I know which table is missing in the foundation database?


####<19/08/2021 11:22:18,606 PM AEST> <Error> <HTTP> <audynappwd0089> <FoundationServices0> <[ACTIVE] ExecuteThread: '62' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <9fbe8395-c45e-4262-8fb8-8101c106648f-00000046> <1629379338606> <[severity-value: 8] [rid: 0:769:56:93:12] [partition-id: 0] [partition-name: DOMAIN] > <BEA-101216>

<Servlet: "WorkflowEngine" failed to preload on startup in Web application: "interop". javax.servlet.ServletException: DSF initialization error ORA-00942: table or view does not exist

at com.hyperion.cesdsf.server.framework.DsfServer.init(DsfServer.java:70)

at weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:356)

at weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:307)

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:344)

at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)

at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)

at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)

at weblogic.servlet.internal.StubSecurityHelper.initServletInstance(StubSecurityHelper.java:99)

at weblogic.servlet.internal.StubSecurityHelper.createServlet(StubSecurityHelper.java:87)

at weblogic.servlet.internal.StubLifecycleHelper.createOneInstance(StubLifecycleHelper.java:74)

at weblogic.servlet.internal.StubLifecycleHelper.<init>(StubLifecycleHelper.java:57)

at weblogic.servlet.internal.StubLifecycleHelper.<init>(StubLifecycleHelper.java:31)

at weblogic.servlet.internal.ServletStubImpl.initStubLifecycleHelper(ServletStubImpl.java:676)

at weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubImpl.java:615)

at weblogic.servlet.internal.WebAppServletContext.preloadServlet(WebAppServletContext.java:2072)

at weblogic.servlet.internal.WebAppServletContext.loadServletsOnStartup(WebAppServletContext.java:2049)

at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1938)

at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3191)

at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1864)

at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:919)

at weblogic.application.internal.ExtensibleModuleWrapper$StartStateChange.next(ExtensibleModuleWrapper.java:360)

at weblogic.application.internal.ExtensibleModuleWrapper$StartStateChange.next(ExtensibleModuleWrapper.java:356)

at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:45)

at weblogic.application.internal.ExtensibleModuleWrapper.start(ExtensibleModuleWrapper.java:138)

at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:124)

at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:233)

at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:228)

at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:45)

at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:78)

at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:52)

at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:752)

at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:45)

at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:262)

at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:66)

at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:165)

at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:90)

at weblogic.deploy.internal.targetserver.BasicDeployment.activate(BasicDeployment.java:274)

at weblogic.deploy.internal.targetserver.BasicDeployment.activateFromServerLifecycle(BasicDeployment.java:507)

at weblogic.management.deploy.internal.DeploymentAdapter$1.doActivate(DeploymentAdapter.java:53)

at weblogic.management.deploy.internal.DeploymentAdapter.activate(DeploymentAdapter.java:202)

at weblogic.management.deploy.internal.AppTransition$2.transitionAppInternal(AppTransition.java:53)

at weblogic.management.deploy.internal.AppTransition.transitionApp(AppTransition.java:138)

at weblogic.management.deploy.internal.ConfiguredDeployments$2.doItem(ConfiguredDeployments.java:741)

at weblogic.management.deploy.internal.parallel.BucketInvoker$2.run(BucketInvoker.java:95)

at weblogic.work.ContextWrap.run(ContextWrap.java:46)

at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:681)

at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)

at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)

at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)

at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)

at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)

####<19/08/2021 11:22:18,609 PM AEST> <Info> <Deployer> <audynappwd0089> <FoundationServices0> <[ACTIVE] ExecuteThread: '62' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <9fbe8395-c45e-4262-8fb8-8101c106648f-00000046> <1629379338609> <[severity-value: 64] [rid: 0:769:56:93:12] [partition-id: 0] [partition-name: DOMAIN] > <BEA-149059> <Module interop of application SHAREDSERVICES [Version=11.1.2.0] is transitioning from STATE_ADMIN to STATE_PREPARED on server FoundationServices0.> 

####<19/08/2021 11:22:18,609 PM AEST> <Info> <Deployer> <audynappwd0089> <FoundationServices0> <[ACTIVE] ExecuteThread: '62' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <9fbe8395-c45e-4262-8fb8-8101c106648f-00000046> <1629379338609> <[severity-value: 64] [rid: 0:769:56:93:12] [partition-id: 0] [partition-name: DOMAIN] > <BEA-149059> <Module interop of application SHAREDSERVICES [Version=11.1.2.0] is transitioning from STATE_ADMIN to STATE_PREPARED on server FoundationServices0.> 

####<19/08/2021 11:22:18,631 PM AEST> <Info> <JDBC> <audynappwd0089> <FoundationServices0> <[ACTIVE] ExecuteThread: '62' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <9fbe8395-c45e-4262-8fb8-8101c106648f-00000046> <1629379338631> <[severity-value: 64] [rid: 0:769:56:93:12] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001513> <Destroying application-scoped data source java:comp/DefaultDataSource, created for Application SHAREDSERVICES#11.1.2.0, Module interop.> 

####<19/08/2021 11:22:18,636 PM AEST> <Info> <Deployer> <audynappwd0089> <FoundationServices0> <[ACTIVE] ExecuteThread: '62' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <9fbe8395-c45e-4262-8fb8-8101c106648f-00000046> <1629379338636> <[severity-value: 64] [rid: 0:769:56:93:12] [partition-id: 0] [partition-name: DOMAIN] > <BEA-149060> <Module interop of application SHAREDSERVICES [Version=11.1.2.0] successfully transitioned from STATE_ADMIN to STATE_PREPARED on server FoundationServices0.> 

####<19/08/2021 11:22:18,636 PM AEST> <Info> <Deployer> <audynappwd0089> <FoundationServices0> <[ACTIVE] ExecuteThread: '62' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <9fbe8395-c45e-4262-8fb8-8101c106648f-00000046> <1629379338636> <[severity-value: 64] [rid: 0:769:56:93:12] [partition-id: 0] [partition-name: DOMAIN] > <BEA-149060> <Module interop of application SHAREDSERVICES [Version=11.1.2.0] successfully transitioned from STATE_ADMIN to STATE_PREPARED on server FoundationServices0.> 

####<19/08/2021 11:22:18,665 PM AEST> <Info> <JDBC> <audynappwd0089> <FoundationServices0> <[ACTIVE] ExecuteThread: '62' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <9fbe8395-c45e-4262-8fb8-8101c106648f-00000046> <1629379338665> <[severity-value: 64] [rid: 0:769:56:93:12] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001513> <Destroying application-scoped data source java:comp/DefaultDataSource, created for Application SHAREDSERVICES#11.1.2.0, Module null.> 

####<19/08/2021 11:22:18,666 PM AEST> <Error> <Deployer> <audynappwd0089> <FoundationServices0> <[ACTIVE] ExecuteThread: '62' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <9fbe8395-c45e-4262-8fb8-8101c106648f-00000046> <1629379338666> <[severity-value: 8] [rid: 0:769:56:93:12] [partition-id: 0] [partition-name: DOMAIN] > <BEA-149231> <Unable to set the activation state to true for the application "SHAREDSERVICES [Version=11.1.2.0]".

weblogic.application.ModuleException: javax.servlet.ServletException: DSF initialization error ORA-00942: table or view does not exist


at weblogic.application.internal.ExtensibleModuleWrapper.start(ExtensibleModuleWrapper.java:140)

at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:124)

at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:233)

at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:228)

at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:45)

at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:78)

at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:52)

at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:752)

at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:45)

at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:262)

at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:66)

at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:165)

at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:90)

at weblogic.deploy.internal.targetserver.BasicDeployment.activate(BasicDeployment.java:274)

at weblogic.deploy.internal.targetserver.BasicDeployment.activateFromServerLifecycle(BasicDeployment.java:507)

at weblogic.management.deploy.internal.DeploymentAdapter$1.doActivate(DeploymentAdapter.java:53)

at weblogic.management.deploy.internal.DeploymentAdapter.activate(DeploymentAdapter.java:202)

at weblogic.management.deploy.internal.AppTransition$2.transitionAppInternal(AppTransition.java:53)

at weblogic.management.deploy.internal.AppTransition.transitionApp(AppTransition.java:138)

at weblogic.management.deploy.internal.ConfiguredDeployments$2.doItem(ConfiguredDeployments.java:741)

at weblogic.management.deploy.internal.parallel.BucketInvoker$2.run(BucketInvoker.java:95)

at weblogic.work.ContextWrap.run(ContextWrap.java:46)

at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:681)

at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)

at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)

at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)

at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)

at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)

Caused By: javax.servlet.ServletException: DSF initialization error ORA-00942: table or view does not exist


at com.hyperion.cesdsf.server.framework.DsfServer.init(DsfServer.java:70)

at weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:356)

at weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:307)

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:344)

at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)

at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)

at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)

at weblogic.servlet.internal.StubSecurityHelper.initServletInstance(StubSecurityHelper.java:99)

at weblogic.servlet.internal.StubSecurityHelper.createServlet(StubSecurityHelper.java:87)

at weblogic.servlet.internal.StubLifecycleHelper.createOneInstance(StubLifecycleHelper.java:74)

at weblogic.servlet.internal.StubLifecycleHelper.<init>(StubLifecycleHelper.java:57)

at weblogic.servlet.internal.StubLifecycleHelper.<init>(StubLifecycleHelper.java:31)

at weblogic.servlet.internal.ServletStubImpl.initStubLifecycleHelper(ServletStubImpl.java:676)

at weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubImpl.java:615)

at weblogic.servlet.internal.WebAppServletContext.preloadServlet(WebAppServletContext.java:2072)

at weblogic.servlet.internal.WebAppServletContext.loadServletsOnStartup(WebAppServletContext.java:2049)

at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1938)

at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3191)

at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1864)

at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:919)

at weblogic.application.internal.ExtensibleModuleWrapper$StartStateChange.next(ExtensibleModuleWrapper.java:360)

at weblogic.application.internal.ExtensibleModuleWrapper$StartStateChange.next(ExtensibleModuleWrapper.java:356)

at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:45)

at weblogic.application.internal.ExtensibleModuleWrapper.start(ExtensibleModuleWrapper.java:138)

at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:124)

at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:233)

at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:228)

at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:45)

at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:78)

at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:52)

at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:752)

at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:45)

at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:262)

at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:66)

at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:165)

at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:90)

at weblogic.deploy.internal.targetserver.BasicDeployment.activate(BasicDeployment.java:274)

at weblogic.deploy.internal.targetserver.BasicDeployment.activateFromServerLifecycle(BasicDeployment.java:507)

at weblogic.management.deploy.internal.DeploymentAdapter$1.doActivate(DeploymentAdapter.java:53)

at weblogic.management.deploy.internal.DeploymentAdapter.activate(DeploymentAdapter.java:202)

at weblogic.management.deploy.internal.AppTransition$2.transitionAppInternal(AppTransition.java:53)

at weblogic.management.deploy.internal.AppTransition.transitionApp(AppTransition.java:138)

at weblogic.management.deploy.internal.ConfiguredDeployments$2.doItem(ConfiguredDeployments.java:741)

at weblogic.management.deploy.internal.parallel.BucketInvoker$2.run(BucketInvoker.java:95)

at weblogic.work.ContextWrap.run(ContextWrap.java:46)

at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:681)

at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)

at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)

at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)

at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)

at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)

####<19/08/2021 11:22:18,667 PM AEST> <Info> <Deployer> <audynappwd0089> <FoundationServices0> <[ACTIVE] ExecuteThread: '62' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <9fbe8395-c45e-4262-8fb8-8101c106648f-00000046> <1629379338667> <[severity-value: 64] [rid: 0:769:56:93:12] [partition-id: 0] [partition-name: DOMAIN] > <BEA-149059> <Module interop of application SHAREDSERVICES [Version=11.1.2.0] is transitioning from STATE_PREPARED to STATE_NEW on server FoundationServices0.> 

Daniel Willis

Answers