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

1638469 · Jul 12, 2014 11:12AM

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)