Discussions
Categories
- 17.9K All Categories
- 3.3K Industry Applications
- 3.2K Intelligent Advisor
- 59 Insurance
- 534.2K On-Premises Infrastructure
- 137.6K Analytics Software
- 38.5K Application Development Software
- 5.3K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
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.>
Answers
-
Did you complete database prerequisites listed in installation document where certain database privileges have to be provided to database schemas before EPM configuration?
-
Yes, I granted the following privileges to the schema user. And I grant DBA to the user before I reconfigure the Foundation.
Grant privileges to database users:
– CREATE ANY SYNONYM
– CREATE CLUSTER
– CREATE INDEXTYPE
– CREATE PROCEDURE
– CREATE SEQUENCE
– CREATE SESSION
– CREATE TABLE
– CREATE TRIGGER
– CREATE TYPE
– CREATE VIEW
– DROP ANY SYNONYM
-
I found all these CES_ tables are missing CES_PROCESS_DEF and all the tables start with CES_
I can manually create CES_PROCESS_DEF.
Can I create these tables manually in the Foundation database?
-
I would not recommend to create the missing tables manually. Let's identify the issue why these were not created and then run EPM system configurator to configure Foundation database which should create the tables.
