Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
oedq 11.1.1.7.4 fresh installation : error : [EDQ-10308] Database active version is not valid for

Hi
we are installing oedq 11.1.1.7.4 installation on weblogic 10.3.6 on aix 6.1 64 bit , oracle ver 11.2.0.3.0. after installation, EDQ deployment showing status 'failed' .. we are getting below errors in main0.log and oedq_server .log.
we created edqconfig, edqresults through RCU . after creation of schemas, we checked the permissions includes connect , resources in database for these schemas, it looks good, we tested the jdbc connection through service --> datasource in weblogic , checked the director.properties pointing to correct database. all looks ok. we tried installing in different environments, still same error. we followed the instructions as per bookshelf including chapter 3 & 5 . wondering what scenario this error could happen, is there a way to make this error explicit to find the root cause of this issue.. error say ' table or view does not exists' does not mention which one it is ? any inputs appreciated .
Error message from mail0.log
[EDQ-01800] Error in database operation: ORA-00942:
Error in database operation: ORA-00942: table or view does not exist
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
at com.datanomic.director.databaseconfiguration.DatabaseConfigurationSupport.checkSchemaVersion(DatabaseConfigurationSupport.java:75)
at com.datanomic.director.startup.WebApplicationContext.loadBeanDefinitions(WebApplicationContext.java:676)
at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:123)
at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:422)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)
at com.datanomic.director.startup.WebApplicationContext.refresh(WebApplicationContext.java:116)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
SEVERE: 11-Jul-2014 23:16:35: [EDQ-10308] Database active version is not valid for application version
error message from oedq_server.log
####<Jul 11, 2014 9:09:51 PM EDT> <Info> <Deployer> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0000KSc7Z1s7U8O6yjicMG1Jk8es000001> <1405127391833> <BEA-149060> <Module /edq of application edq successfully transitioned from STATE_PREPARED to STATE_ADMIN on server oedq_server1.>
####<Jul 11, 2014 9:09:53 PM EDT> <Info> <ServletContext-/edq> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <0000KSc7Z1s7U8O6yjicMG1Jk8es000001> <1405127393930> <BEA-000000> <Initializing Spring root WebApplicationContext>
####<Jul 11, 2014 9:09:55 PM EDT> <Info> <JDBC> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <0000KSc7Z1s7U8O6yjicMG1Jk8es000001> <1405127395956> <BEA-001516> <Data source connection pool "EDQConfigDS" connected to Database: "Oracle", Version: "Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options".>
####<Jul 11, 2014 9:09:55 PM EDT> <Info> <JDBC> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <0000KSc7Z1s7U8O6yjicMG1Jk8es000001> <1405127395958> <BEA-001517> <Data source connection pool "EDQConfigDS" using Driver: "Oracle JDBC driver", Version: "11.2.0.3.0".>
####<Jul 11, 2014 9:09:56 PM EDT> <Info> <Common> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <0000KSc7Z1s7U8O6yjicMG1Jk8es000001> <1405127396034> <BEA-000628> <Created "1" resources for pool "EDQConfigDS", out of which "1" are available and "0" are unavailable.>
####<Jul 11, 2014 9:09:56 PM EDT> <Info> <JDBC> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <0000KSc7Z1s7U8O6yjicMG1Jk8es000001> <1405127396424> <BEA-001516> <Data source connection pool "EDQResultsDS" connected to Database: "Oracle", Version: "Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options".>
####<Jul 11, 2014 9:09:56 PM EDT> <Info> <JDBC> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <0000KSc7Z1s7U8O6yjicMG1Jk8es000001> <1405127396425> <BEA-001517> <Data source connection pool "EDQResultsDS" using Driver: "Oracle JDBC driver", Version: "11.2.0.3.0".>
####<Jul 11, 2014 9:09:56 PM EDT> <Info> <Common> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <0000KSc7Z1s7U8O6yjicMG1Jk8es000001> <1405127396428> <BEA-000628> <Created "1" resources for pool "EDQResultsDS", out of which "1" are available and "0" are unavailable.>
####<Jul 11, 2014 9:09:57 PM EDT> <Warning> <HTTP> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0000KSc7Z1s7U8O6yjicMG1Jk8es000001> <1405127397498> <BEA-101162> <User defined listener org.springframework.web.context.ContextLoaderListener failed: java.lang.RuntimeException: Database active version is not valid for application version.
java.lang.RuntimeException: Database active version is not valid for application version
at com.datanomic.director.startup.WebApplicationContext.loadBeanDefinitions(WebApplicationContext.java:679)
at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:123)
at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:422)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)
at com.datanomic.director.startup.WebApplicationContext.refresh(WebApplicationContext.java:116)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)
at weblogic.servlet.internal.EventsManager$FireContextListenerAction.run(EventsManager.java:481)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.EventsManager.notifyContextCreatedEvent(EventsManager.java:181)
at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1868)
at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3154)
at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1518)
at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:484)
at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:247)
at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27)
at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:671)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:212)
at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:59)
at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:161)
at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79)
at weblogic.deploy.internal.targetserver.BasicDeployment.activate(BasicDeployment.java:184)
at weblogic.deploy.internal.targetserver.BasicDeployment.activateFromServerLifecycle(BasicDeployment.java:361)
at weblogic.management.deploy.internal.DeploymentAdapter$1.doActivate(DeploymentAdapter.java:51)
at weblogic.management.deploy.internal.DeploymentAdapter.activate(DeploymentAdapter.java:200)
at weblogic.management.deploy.internal.AppTransition$2.transitionApp(AppTransition.java:30)
at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:240)
at weblogic.management.deploy.internal.ConfiguredDeployments.activate(ConfiguredDeployments.java:169)
at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:123)
at weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:180)
at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:96)
at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
>
####<Jul 11, 2014 9:09:57 PM EDT> <Info> <Deployer> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0000KSc7Z1s7U8O6yjicMG1Jk8es000001> <1405127397506> <BEA-149059> <Module /edq of application edq is transitioning from STATE_ADMIN to STATE_PREPARED on server oedq_server1.>
####<Jul 11, 2014 9:09:57 PM EDT> <Info> <ServletContext-/edq> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <0000KSc7Z1s7U8O6yjicMG1Jk8es000001> <1405127397521> <BEA-000000> <Closing Spring root WebApplicationContext>
####<Jul 11, 2014 9:09:57 PM EDT> <Info> <Deployer> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0000KSc7Z1s7U8O6yjicMG1Jk8es000001> <1405127397559> <BEA-149060> <Module /edq of application edq successfully transitioned from STATE_ADMIN to STATE_PREPARED on server oedq_server1.>
####<Jul 11, 2014 9:09:57 PM EDT> <Info> <Deployer> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0000KSc7Z1s7U8O6yjicMG1Jk8es000001> <1405127397559> <BEA-149059> <Module empty.jar of application edq is transitioning from STATE_ADMIN to STATE_PREPARED on server oedq_server1.>
####<Jul 11, 2014 9:09:57 PM EDT> <Info> <Deployer> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0000KSc7Z1s7U8O6yjicMG1Jk8es000001> <1405127397560> <BEA-149060> <Module empty.jar of application edq successfully transitioned from STATE_ADMIN to STATE_PREPARED on server oedq_server1.>
####<Jul 11, 2014 9:09:57 PM EDT> <Error> <Deployer> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0000KSc7Z1s7U8O6yjicMG1Jk8es000001> <1405127397565> <BEA-149231> <Unable to set the activation state to true for the application 'edq'.
weblogic.application.ModuleException:
at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1520)
at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:484)
at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:247)
at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27)
at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:671)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:212)
at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:59)
at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:161)
at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79)
at weblogic.deploy.internal.targetserver.BasicDeployment.activate(BasicDeployment.java:184)
at weblogic.deploy.internal.targetserver.BasicDeployment.activateFromServerLifecycle(BasicDeployment.java:361)
at weblogic.management.deploy.internal.DeploymentAdapter$1.doActivate(DeploymentAdapter.java:51)
at weblogic.management.deploy.internal.DeploymentAdapter.activate(DeploymentAdapter.java:200)
at weblogic.management.deploy.internal.AppTransition$2.transitionApp(AppTransition.java:30)
at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:240)
at weblogic.management.deploy.internal.ConfiguredDeployments.activate(ConfiguredDeployments.java:169)
at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:123)
at weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:180)
at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:96)
at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused By: java.lang.RuntimeException: Database active version is not valid for application version
at com.datanomic.director.startup.WebApplicationContext.loadBeanDefinitions(WebApplicationContext.java:679)
at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:123)
at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:422)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)
at com.datanomic.director.startup.WebApplicationContext.refresh(WebApplicationContext.java:116)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)
at weblogic.servlet.internal.EventsManager$FireContextListenerAction.run(EventsManager.java:481)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.EventsManager.notifyContextCreatedEvent(EventsManager.java:181)
at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1868)
at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3154)
at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1518)
at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:484)
at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:247)
at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27)
at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:671)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:212)
at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:59)
at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:161)
at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79)
at weblogic.deploy.internal.targetserver.BasicDeployment.activate(BasicDeployment.java:184)
at weblogic.deploy.internal.targetserver.BasicDeployment.activateFromServerLifecycle(BasicDeployment.java:361)
at weblogic.management.deploy.internal.DeploymentAdapter$1.doActivate(DeploymentAdapter.java:51)
at weblogic.management.deploy.internal.DeploymentAdapter.activate(DeploymentAdapter.java:200)
at weblogic.management.deploy.internal.AppTransition$2.transitionApp(AppTransition.java:30)
at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:240)
at weblogic.management.deploy.internal.ConfiguredDeployments.activate(ConfiguredDeployments.java:169)
at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:123)
at weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:180)
at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:96)
at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
>
####<Jul 11, 2014 9:09:57 PM EDT> <Info> <Deployer> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0000KSc7Z1s7U8O6yjicMG1Jk8es000001> <1405127397568> <BEA-149059> <Module /edq of application edq is transitioning from STATE_PREPARED to STATE_NEW on server oedq_server1.>
####<Jul 11, 2014 9:09:57 PM EDT> <Info> <Deployer> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0000KSc7Z1s7U8O6yjicMG1Jk8es000001> <1405127397569> <BEA-149060> <Module /edq of application edq successfully transitioned from STATE_PREPARED to STATE_NEW on server oedq_server1.>
####<Jul 11, 2014 9:09:57 PM EDT> <Info> <Deployer> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0000KSc7Z1s7U8O6yjicMG1Jk8es000001> <1405127397570> <BEA-149059> <Module empty.jar of application edq is transitioning from STATE_PREPARED to STATE_NEW on server oedq_server1.>
####<Jul 11, 2014 9:09:57 PM EDT> <Info> <Deployer> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0000KSc7Z1s7U8O6yjicMG1Jk8es000001> <1405127397570> <BEA-149060> <Module empty.jar of application edq successfully transitioned from STATE_PREPARED to STATE_NEW on server oedq_server1.>
####<Jul 11, 2014 9:09:57 PM EDT> <Info> <Diagnostics> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1405127397583> <BEA-320000> <The Diagnostics subsystem is initializing on Server oedq_server1.>
####<Jul 11, 2014 9:09:57 PM EDT> <Info> <Store> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1405127397592> <BEA-280008> <Opening the persistent file store "WLS_DIAGNOSTICS" for recovery: directory=/oedqpch/app/oedq/oedq_domain/servers/oedq_server1/data/store/diagnostics requestedWritePolicy="Disabled" fileLockingEnabled=true driver="wlfileio3".>
####<Jul 11, 2014 9:09:57 PM EDT> <Info> <Store> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1405127397593> <BEA-280009> <The persistent file store "WLS_DIAGNOSTICS" (5c20a135-f28e-4dbb-ab52-c28e64248b1f) has been opened: blockSize=4,096 actualWritePolicy="Disabled(single-handle-non-direct)" explicitIOEnforced=false records=0.>
####<Jul 11, 2014 9:09:57 PM EDT> <Notice> <Log Management> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1405127397613> <BEA-170027> <The Server has established connection with the Domain level Diagnostic Service successfully.>
####<Jul 11, 2014 9:09:57 PM EDT> <Info> <Diagnostics> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1405127397679> <BEA-320077> <Initialized the Diagnostic Accessor Service.>
####<Jul 11, 2014 9:09:57 PM EDT> <Info> <Diagnostics> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <948e1d0586d1ccba:7142fe66:147281de09f:-8000-0000000000000003> <1405127397697> <BEA-320117> <The Harvester is being disabled because there are no Harvestable types configured specified.>
####<Jul 11, 2014 9:09:57 PM EDT> <Info> <Diagnostics> <mkmhxf01.pcc.int> <oedq_server1> <[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <948e1d0586d1ccba:7142fe66:147281de09f:-8000-0000000000000003> <1405127397699> <BEA-320119> <The Harvester is now in a inactive state.>
####<Jul 11, 2014 9:09:57 PM EDT> <Notice> <WebLogicServer> <mkmhxf01.pcc.int> <oedq_server1> <main> <<WLS Kernel>> <> <948e1d0586d1ccba:7142fe66:147281de09f:-8000-0000000000000004> <1405127397716> <BEA-000365> <Server state changed to ADMIN>
Answers
-
Hi
A similar error is documented in '' <Note# 1541263.1> Error processing results schema initialization script: Invalid expression in if: ORA-00942: table or view does not exist' Is Signalled In The 'main0.log' At Startup Of Oracle Enterprise Data Quality (EDQ) (Doc ID 1541263.1)'.
Symptoms:
========
'Error processing results schema initialization script: Invalid expression in if: ORA-00942: table or view does not exist' is signalled in the 'main0.log' (at startup of the application server)
You will not be able to view the Launchpad and you may see a '404' type error in the browser when attempting to do so.
Cause:
======
Database schema is partial, has changed or has become corrupt.
Generally at an application server restart:
1. where there is no results schema in place one should be successfully built
2. where there is a complete results schema in place the connection is successfully made
3. for a partial or corrupt schema neither 1 nor 2 can go ahead resulting in the error seen here
Solution:
=======
Clean absolutely everything – tables, sequences, etc – from the results database schema, (ensure the user 'results' has the CONNECT and RESOURCE permissions granted) and attempt an application server restart in order to allow a fresh schema to be rebuilt.
Hope it helps.
Thanks & Regards,
Shilpi