Forum Stats

  • 3,855,104 Users
  • 2,264,458 Discussions
  • 7,905,897 Comments

Discussions

oedq 11.1.1.7.4 fresh installation : error : [EDQ-10308] Database active version is not valid for

1638469
1638469 Member Posts: 1
edited Jul 14, 2014 3:35AM in Data Quality

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

This discussion has been closed.