EDQ: Error Connecting To MS SQL Server

(Doc ID 2233069.1)

Last updated on FEBRUARY 13, 2017

Applies to:

Oracle Enterprise Data Quality - Version 12.2.1.1.0 and later
Information in this document applies to any platform.

Symptoms

Error when connecting to a Microsoft SQL Server:

SEVERE: 01-Feb-2017 10:33:59: [EDQ-10315] Connection to configuration database (jdbc:oracle:thin:@vDCOracleDBPD01:1521:OrclEDQprod user edqconfig) failed - attempt 1 of 2: Cannot create PoolableConnectionFactory (ORA-28001: the password has expired)
SEVERE: 01-Feb-2017 10:34:09: [EDQ-10315] Connection to configuration database (jdbc:oracle:thin:@vDCOracleDBPD01:1521:OrclEDQprod user edqconfig) failed - attempt 2 of 2: Cannot create PoolableConnectionFactory (ORA-28001: the password has expired)
SEVERE: 01-Feb-2017 10:34:09: [EDQ-10316] Unable to connect to database (jdbc:oracle:thin:@vDCOracleDBPD01:1521:OrclEDQprod with user edqconfig): Cannot create PoolableConnectionFactory (ORA-28001: the password has expired)
SEVERE: 01-Feb-2017 10:34:09: [EDQ-01800] Error in database operation: Cannot create PoolableConnectionFactory (ORA-28001: the password has expired
)
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-28001: the password has expired
)
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.datanomic.director.databaseconfiguration.BlockingDataSourceProxy.getConnection(BlockingDataSourceProxy.java:86)
at com.datanomic.director.databaseconfiguration.DatabaseConfigurationSupport.checkSchemaVersion(DatabaseConfigurationSupport.java:66)
at com.datanomic.director.startup.WebApplicationContext.loadBeanDefinitions(WebApplicationContext.java:669)
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:113)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
Caused by: java.sql.SQLException: ORA-28001: the password has expired

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:391)
at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1126)
at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:507)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:440)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:1025)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:682)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:614)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.datanomic.director.databaseconfiguration.BlockingDataSourceProxy.getConnection(BlockingDataSourceProxy.java:86)
at com.datanomic.director.databaseconfiguration.DatabaseConfigurationSupport.checkSchemaVersion(DatabaseConfigurationSupport.java:66)
at com.datanomic.director.startup.WebApplicationContext.loadBeanDefinitions(WebApplicationContext.java:669)
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:113)
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 org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4715)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5177)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:152)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:724)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:700)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
SEVERE: 01-Feb-2017 10:34:09: [EDQ-10308] Database active version is not valid for application version

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms