cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
woo
Barite | Level 11 woo
Barite | Level 11
Go to Solution

SASServer1_1 not starting

Posted 01-11-2019 11:25 AM (7636 views)

Hello, we are running sas 9.4 on Linux machine. there was no environment changes happened and we started receiving web application error. please help to troubleshoot. Thank you.

 

http:/hostname:7980 is fine so don't see any issue in web server or either jms broker or cache locator. when try -> http:/hostname:7980/any-sas-web-application is throws error saying web page cannot be found.

 

this is the server.log for server1_1 while starting up mid-tier server.

 09:34:43,904 WARN  (main) [com.springsource.tcserver.serviceability.rmi.JmxSocketListener] Detected LDAP configuration '/sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/jaas.config', but there is no ldap configuration entry specified.
 09:34:43,968 INFO  (main) [org.apache.catalina.startup.Catalina] Initialization processed in 1099 ms
 09:34:46,083 INFO  (main) [org.apache.catalina.core.StandardService] Starting service Catalina
 09:34:46,083 INFO  (main) [org.apache.catalina.core.StandardEngine] Starting Servlet Engine: Pivotal tc Runtime 3.0.0.RELEASE/7.0.55.A.RELEASE
 09:34:46,093 INFO  (localhost-startStop-1) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASThemeDesignerForFlex.xml
 09:34:46,093 INFO  (localhost-startStop-4) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASPermissionManager.xml
 09:34:46,093 INFO  (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASWIPSoapServices.xml
 09:34:46,093 INFO  (localhost-startStop-3) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASIdentityServices.xml
 09:34:56,606 INFO  (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASThemeDesignerForFlex]] No Spring WebApplicationInitializer types detected on classpath
 09:34:56,648 INFO  (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASThemeDesignerForFlex]] Config path: file:////sasconfig/Lev1/Web/Common/LogConfig/
 09:34:56,648 INFO  (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASThemeDesignerForFlex]] Context path: SASThemeDesignerForFlex
 09:34:56,649 INFO  (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASThemeDesignerForFlex]] Configuring Log4j from URL at path: /file:////sasconfig/Lev1/Web/Common/LogConfig/SASThemeDesignerForFlex-log4j.xml
 09:34:56,649 INFO  (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASThemeDesignerForFlex]] isXMLConfigFile: true
 09:34:56,659 INFO  (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASIdentityServices]] No Spring WebApplicationInitializer types detected on classpath
 09:34:56,675 INFO  (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASWIPSoapServices]] No Spring WebApplicationInitializer types detected on classpath
 09:34:56,678 INFO  (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASIdentityServices]] Config path: file:////sasconfig/Lev1/Web/Common/LogConfig/
 09:34:56,691 INFO  (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASIdentityServices]] Context path: SASIdentityServices
 09:34:56,692 INFO  (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASIdentityServices]] Configuring Log4j from URL at path: /file:////sasconfig/Lev1/Web/Common/LogConfig/SASIdentityServices-log4j.xml
 09:34:56,692 INFO  (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASIdentityServices]] isXMLConfigFile: true
 09:34:56,712 INFO  (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASThemeDesignerForFlex]] Initializing Spring root WebApplicationContext
 09:34:56,725 INFO  (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASIdentityServices]] Initializing Spring root WebApplicationContext
 09:34:56,730 INFO  (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASWIPSoapServices]] Config path: file:////sasconfig/Lev1/Web/Common/LogConfig/
 09:34:56,730 INFO  (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASWIPSoapServices]] Context path: SASWIPSoapServices
 09:34:56,730 INFO  (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASWIPSoapServices]] Configuring Log4j from URL at path: /file:////sasconfig/Lev1/Web/Common/LogConfig/SASWIPSoapServices-log4j.xml
 09:34:56,731 INFO  (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASWIPSoapServices]] isXMLConfigFile: true
 09:34:56,786 INFO  (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASWIPSoapServices]] Initializing Spring root WebApplicationContext
 09:34:56,995 INFO  (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASPermissionManager]] No Spring WebApplicationInitializer types detected on classpath
 09:34:57,053 INFO  (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASPermissionManager]] Config path: file:////sasconfig/Lev1/Web/Common/LogConfig/
 09:34:57,054 INFO  (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASPermissionManager]] Context path: SASPermissionManager
 09:34:57,054 INFO  (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASPermissionManager]] Configuring Log4j from URL at path: /file:////sasconfig/Lev1/Web/Common/LogConfig/SASPermissionManager-log4j.xml
 09:34:57,054 INFO  (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASPermissionManager]] isXMLConfigFile: true
 09:34:57,080 INFO  (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASPermissionManager]] Initializing Spring root WebApplicationContext
 09:35:01,863 ERROR (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASPermissionManager]] Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'cachedConfigurer' defined in ServletContext resource [/WEB-INF/spring-config/infrastructure-config.xml]: Cannot resolve reference to bean 'environmentProperties' while setting bean property 'properties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'environmentProperties': FactoryBean threw exception on object creation; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.atomikos.jdbc.AtomikosSQLException: Failed to grow the connection pool
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:334)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1419)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1160)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)
        at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:659)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:461)
        at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1862)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'environmentProperties': FactoryBean threw exception on object creation; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.atomikos.jdbc.AtomikosSQLException: Failed to grow the connection pool
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:173)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:126)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1465)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:304)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
        ... 27 more
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.atomikos.jdbc.AtomikosSQLException: Failed to grow the connection pool
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:575)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:668)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:676)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716)
        at com.sas.framework.services.config.dao.PropertySetDatabaseDAO.getProperties(PropertySetDatabaseDAO.java:180)
        at com.sas.framework.services.config.dao.PropertySetDatabaseDAO.getPropertyMap(PropertySetDatabaseDAO.java:223)
        at com.sas.framework.services.config.dao.PropertySetFactoryBean.getObject(PropertySetFactoryBean.java:56)
        at com.sas.framework.services.config.dao.PropertySetFactoryBean.getObject(PropertySetFactoryBean.java:21)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:166)
        ... 32 more
Caused by: com.atomikos.jdbc.AtomikosSQLException: Failed to grow the connection pool
        at com.atomikos.jdbc.AtomikosSQLException.throwAtomikosSQLException(AtomikosSQLException.java:46)
        at com.atomikos.jdbc.AbstractDataSourceBean.throwAtomikosSQLException(AbstractDataSourceBean.java:90)
        at com.atomikos.jdbc.AbstractDataSourceBean.getConnection(AbstractDataSourceBean.java:328)
        at com.atomikos.jdbc.nonxa.AtomikosNonXADataSourceBean.getConnection(AtomikosNonXADataSourceBean.java:215)
        at com.atomikos.jdbc.AbstractDataSourceBean.getConnection(AbstractDataSourceBean.java:377)
        at com.sas.framework.services.config.dao.PropertySetDataSource.getConnection(PropertySetDataSource.java:241)
        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
        ... 42 more
Caused by: com.atomikos.datasource.pool.CreateConnectionException: Could not create JDBC connection
        at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.createPooledConnection(AtomikosNonXAConnectionFactory.java:130)
        at com.atomikos.datasource.pool.ConnectionPool.growPool(ConnectionPool.java:250)
        at com.atomikos.datasource.pool.ConnectionPool.borrowConnection(ConnectionPool.java:201)
        at com.atomikos.jdbc.AbstractDataSourceBean.getConnection(AbstractDataSourceBean.java:325)
        ... 47 more
Caused by: java.sql.SQLException: ORA-28001: the password has expired

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
        at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:600)
        at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:445)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
        at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:380)
        at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:760)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
        at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.getConnection(AtomikosNonXAConnectionFactory.java:119)
        at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.createPooledConnection(AtomikosNonXAConnectionFactory.java:127)
        ... 50 more
 09:35:01,866 ERROR (localhost-startStop-4) [org.apache.catalina.core.StandardContext] Error listenerStart
racle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:760)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
        at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.getConnection(AtomikosNonXAConnectionFactory.java:119)
        at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.createPooledConnection(AtomikosNonXAConnectionFactory.java:127)
        ... 50 more
 09:35:01,866 ERROR (localhost-startStop-4) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:01,868 ERROR (localhost-startStop-4) [org.apache.catalina.core.StandardContext] Context [/SASPermissionManager] startup failed due to previous errors
 09:35:01,881 INFO  (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASPermissionManager]] Closing Spring root WebApplicationContext
 09:35:02,144 ERROR (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASIdentityServices]] Exception sending context initialized event to listener instance of class com.sas.svcs.webapp.servlet.springframework.DefaultContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.sas.svcs.springframework.config.DefaultProvidedPropertyPlaceholderConfigurer#0': Cannot resolve reference to bean 'environmentProperties' while setting bean property 'properties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'environmentProperties': FactoryBean threw exception on object creation; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.atomikos.jdbc.AtomikosSQLException: Failed to grow the connection pool
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:334)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1419)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1160)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)
        at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:659)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:461)
        at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
        at com.sas.svcs.webapp.servlet.springframework.DefaultContextLoaderListener.contextInitialized(DefaultContextLoaderListener.java:44)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1862)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'environmentProperties': FactoryBean threw exception on object creation; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.atomikos.jdbc.AtomikosSQLException: Failed to grow the connection pool
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:173)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:126)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1465)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:304)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
        ... 28 more
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.atomikos.jdbc.AtomikosSQLException: Failed to grow the connection pool
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:575)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:668)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:676)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716)
        at com.sas.framework.services.config.dao.PropertySetDatabaseDAO.getProperties(PropertySetDatabaseDAO.java:180)
        at com.sas.framework.services.config.dao.PropertySetDatabaseDAO.getPropertyMap(PropertySetDatabaseDAO.java:223)
        at com.sas.framework.services.config.dao.PropertySetFactoryBean.getObject(PropertySetFactoryBean.java:56)
        at com.sas.framework.services.config.dao.PropertySetFactoryBean.getObject(PropertySetFactoryBean.java:21)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:166)
        ... 33 more
Caused by: com.atomikos.jdbc.AtomikosSQLException: Failed to grow the connection pool
        at com.atomikos.jdbc.AtomikosSQLException.throwAtomikosSQLException(AtomikosSQLException.java:46)
        at com.atomikos.jdbc.AbstractDataSourceBean.throwAtomikosSQLException(AbstractDataSourceBean.java:90)
        at com.atomikos.jdbc.AbstractDataSourceBean.getConnection(AbstractDataSourceBean.java:328)
        at com.atomikos.jdbc.nonxa.AtomikosNonXADataSourceBean.getConnection(AtomikosNonXADataSourceBean.java:215)
        at com.atomikos.jdbc.AbstractDataSourceBean.getConnection(AbstractDataSourceBean.java:377)
        at com.sas.framework.services.config.dao.PropertySetDataSource.getConnection(PropertySetDataSource.java:241)
        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
        ... 43 more
Caused by: com.atomikos.datasource.pool.CreateConnectionException: Could not create JDBC connection
        at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.createPooledConnection(AtomikosNonXAConnectionFactory.java:130)
        at com.atomikos.datasource.pool.ConnectionPool.growPool(ConnectionPool.java:250)
        at com.atomikos.datasource.pool.ConnectionPool.borrowConnection(ConnectionPool.java:201)
        at com.atomikos.jdbc.AbstractDataSourceBean.getConnection(AbstractDataSourceBean.java:325)
        ... 48 more
Caused by: java.sql.SQLException: ORA-28001: the password has expired

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
        at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:600)
        at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:445)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
        at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:380)
        at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:760)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
        at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.getConnection(AtomikosNonXAConnectionFactory.java:119)
        at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.createPooledConnection(AtomikosNonXAConnectionFactory.java:127)
        ... 51 more
 09:35:02,146 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:02,147 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Context [/SASIdentityServices] startup failed due to previous errors
 09:35:02,148 INFO  (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASIdentityServices]] Closing Spring root WebApplicationContext
bc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
        at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:380)
        at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:760)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
        at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.getConnection(AtomikosNonXAConnectionFactory.java:119)
        at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.createPooledConnection(AtomikosNonXAConnectionFactory.java:127)
        ... 51 more
 09:35:02,146 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:02,147 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Context [/SASIdentityServices] startup failed due to previous errors
 09:35:02,148 INFO  (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASIdentityServices]] Closing Spring root WebApplicationContext
 09:35:02,235 ERROR (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASThemeDesignerForFlex]] Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'cachedConfigurer' defined in ServletContext resource [/WEB-INF/spring-config/infrastructure-config.xml]: Cannot resolve reference to bean 'environmentProperties' while setting bean property 'properties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'environmentProperties': FactoryBean threw exception on object creation; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.atomikos.jdbc.AtomikosSQLException: Failed to grow the connection pool
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:334)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1419)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1160)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)
        at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:659)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:461)
        at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1862)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'environmentProperties': FactoryBean threw exception on object creation; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.atomikos.jdbc.AtomikosSQLException: Failed to grow the connection pool
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:173)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:126)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1465)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:304)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
        ... 27 more
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.atomikos.jdbc.AtomikosSQLException: Failed to grow the connection pool
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:575)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:668)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:676)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716)
        at com.sas.framework.services.config.dao.PropertySetDatabaseDAO.getProperties(PropertySetDatabaseDAO.java:180)
        at com.sas.framework.services.config.dao.PropertySetDatabaseDAO.getPropertyMap(PropertySetDatabaseDAO.java:223)
        at com.sas.framework.services.config.dao.PropertySetFactoryBean.getObject(PropertySetFactoryBean.java:56)
        at com.sas.framework.services.config.dao.PropertySetFactoryBean.getObject(PropertySetFactoryBean.java:21)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:166)
        ... 32 more
Caused by: com.atomikos.jdbc.AtomikosSQLException: Failed to grow the connection pool
        at com.atomikos.jdbc.AtomikosSQLException.throwAtomikosSQLException(AtomikosSQLException.java:46)
        at com.atomikos.jdbc.AbstractDataSourceBean.throwAtomikosSQLException(AbstractDataSourceBean.java:90)
        at com.atomikos.jdbc.AbstractDataSourceBean.getConnection(AbstractDataSourceBean.java:328)
        at com.atomikos.jdbc.nonxa.AtomikosNonXADataSourceBean.getConnection(AtomikosNonXADataSourceBean.java:215)
        at com.atomikos.jdbc.AbstractDataSourceBean.getConnection(AbstractDataSourceBean.java:377)
        at com.sas.framework.services.config.dao.PropertySetDataSource.getConnection(PropertySetDataSource.java:241)
        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
        ... 42 more
Caused by: com.atomikos.datasource.pool.CreateConnectionException: Could not create JDBC connection
        at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.createPooledConnection(AtomikosNonXAConnectionFactory.java:130)
        at com.atomikos.datasource.pool.ConnectionPool.growPool(ConnectionPool.java:250)
        at com.atomikos.datasource.pool.ConnectionPool.borrowConnection(ConnectionPool.java:201)
        at com.atomikos.jdbc.AbstractDataSourceBean.getConnection(AbstractDataSourceBean.java:325)
        ... 47 more
Caused by: java.sql.SQLException: ORA-28001: the password has expired

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
        at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:600)
        at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:445)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
        at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:380)
        at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:760)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
        at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.getConnection(AtomikosNonXAConnectionFactory.java:119)
        at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.createPooledConnection(AtomikosNonXAConnectionFactory.java:127)
        ... 50 more
 09:35:02,238 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:02,238 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Context [/SASThemeDesignerForFlex] startup failed due to previous errors
t oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:760)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
        at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.getConnection(AtomikosNonXAConnectionFactory.java:119)
        at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.createPooledConnection(AtomikosNonXAConnectionFactory.java:127)
        ... 50 more
 09:35:02,238 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:02,238 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Context [/SASThemeDesignerForFlex] startup failed due to previous errors
 09:35:02,258 INFO  (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASThemeDesignerForFlex]] Closing Spring root WebApplicationContext
 09:35:02,342 INFO  (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASThemeDesignerForFlex]] Cleaning up Log4j resources for context: null...
 09:35:02,342 INFO  (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASThemeDesignerForFlex]] Shutting down all loggers and appenders...
 09:35:02,343 INFO  (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASThemeDesignerForFlex]] Log4j cleaned up.
 09:35:02,361 INFO  (localhost-startStop-1) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASThemeDesignerForFlex.xml has finished in 16,267 ms
 09:35:02,362 INFO  (localhost-startStop-1) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASContentServer.xml
 09:35:02,621 ERROR (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASWIPSoapServices]] Exception sending context initialized event to listener instance of class com.sas.svcs.webapp.servlet.springframework.DefaultContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'cachedConfigurer' defined in ServletContext resource [/WEB-INF/spring-config/service-context.xml]: Cannot resolve reference to bean 'environmentProperties' while setting bean property 'properties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'environmentProperties': FactoryBean threw exception on object creation; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.atomikos.jdbc.AtomikosSQLException: Failed to grow the connection pool
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:334)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1419)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1160)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)
        at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:659)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:461)
        at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
        at com.sas.svcs.webapp.servlet.springframework.DefaultContextLoaderListener.contextInitialized(DefaultContextLoaderListener.java:44)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1862)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'environmentProperties': FactoryBean threw exception on object creation; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.atomikos.jdbc.AtomikosSQLException: Failed to grow the connection pool
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:173)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:126)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1465)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:304)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
        ... 28 more
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.atomikos.jdbc.AtomikosSQLException: Failed to grow the connection pool
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:575)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:668)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:676)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716)
        at com.sas.framework.services.config.dao.PropertySetDatabaseDAO.getProperties(PropertySetDatabaseDAO.java:180)
        at com.sas.framework.services.config.dao.PropertySetDatabaseDAO.getPropertyMap(PropertySetDatabaseDAO.java:223)
        at com.sas.framework.services.config.dao.PropertySetFactoryBean.getObject(PropertySetFactoryBean.java:56)
        at com.sas.framework.services.config.dao.PropertySetFactoryBean.getObject(PropertySetFactoryBean.java:21)
        at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:166)
        ... 33 more
Caused by: com.atomikos.jdbc.AtomikosSQLException: Failed to grow the connection pool
        at com.atomikos.jdbc.AtomikosSQLException.throwAtomikosSQLException(AtomikosSQLException.java:46)
        at com.atomikos.jdbc.AbstractDataSourceBean.throwAtomikosSQLException(AbstractDataSourceBean.java:90)
        at com.atomikos.jdbc.AbstractDataSourceBean.getConnection(AbstractDataSourceBean.java:328)
        at com.atomikos.jdbc.nonxa.AtomikosNonXADataSourceBean.getConnection(AtomikosNonXADataSourceBean.java:215)
        at com.atomikos.jdbc.AbstractDataSourceBean.getConnection(AbstractDataSourceBean.java:377)
        at com.sas.framework.services.config.dao.PropertySetDataSource.getConnection(PropertySetDataSource.java:241)
        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
        ... 43 more
Caused by: com.atomikos.datasource.pool.CreateConnectionException: Could not create JDBC connection
        at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.createPooledConnection(AtomikosNonXAConnectionFactory.java:130)
        at com.atomikos.datasource.pool.ConnectionPool.growPool(ConnectionPool.java:250)
        at com.atomikos.datasource.pool.ConnectionPool.borrowConnection(ConnectionPool.java:201)
        at com.atomikos.jdbc.AbstractDataSourceBean.getConnection(AbstractDataSourceBean.java:325)
        ... 48 more
Caused by: java.sql.SQLException: ORA-28001: the password has expired

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
        at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:600)
        at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:445)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
        at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:380)
        at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:760)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
        at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.getConnection(AtomikosNonXAConnectionFactory.java:119)
        at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.createPooledConnection(AtomikosNonXAConnectionFactory.java:127)
        ... 51 more
 09:35:02,624 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:02,625 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Context [/SASWIPSoapServices] startup failed due to previous errors
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
        at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:380)
        at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:760)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
        at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.getConnection(AtomikosNonXAConnectionFactory.java:119)
        at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.createPooledConnection(AtomikosNonXAConnectionFactory.java:127)
        ... 51 more
 09:35:02,624 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:02,625 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Context [/SASWIPSoapServices] startup failed due to previous errors
 09:35:02,883 INFO  (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASPermissionManager]] Cleaning up Log4j resources for context: null...
 09:35:02,883 INFO  (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASPermissionManager]] Shutting down all loggers and appenders...
 09:35:02,884 INFO  (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASPermissionManager]] Log4j cleaned up.
 09:35:02,890 INFO  (localhost-startStop-4) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASPermissionManager.xml has finished in 16,797 ms
 09:35:02,890 INFO  (localhost-startStop-4) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASTheme_default.xml
 09:35:03,153 INFO  (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASIdentityServices]] Cleaning up Log4j resources for context: null...
 09:35:03,153 INFO  (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASIdentityServices]] Shutting down all loggers and appenders...
 09:35:03,153 INFO  (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASIdentityServices]] Shutting down all loggers and appenders...
 09:35:03,154 INFO  (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASIdentityServices]] Log4j cleaned up.
 09:35:03,160 INFO  (localhost-startStop-3) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASIdentityServices.xml has finished in 17,067 ms
 09:35:03,160 INFO  (localhost-startStop-3) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASWIPClientAccess.xml
 09:35:03,627 INFO  (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASWIPSoapServices]] Closing Spring root WebApplicationContext
 09:35:03,635 INFO  (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASWIPSoapServices]] Cleaning up Log4j resources for context: null...
 09:35:03,636 INFO  (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASWIPSoapServices]] Shutting down all loggers and appenders...
 09:35:03,636 INFO  (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASWIPSoapServices]] Log4j cleaned up.
 09:35:03,644 INFO  (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASWIPSoapServices.xml has finished in 17,551 ms
 09:35:03,645 INFO  (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASPrincipalServices.xml
 09:35:03,819 INFO  (localhost-startStop-4) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASTheme_default.xml has finished in 929 ms
 09:35:03,822 INFO  (localhost-startStop-4) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASFlexThemes.xml
 09:35:04,964 INFO  (localhost-startStop-4) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASFlexThemes.xml has finished in 1,142 ms
 09:35:04,965 INFO  (localhost-startStop-4) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASBIWS.xml
 09:35:08,859 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:08,860 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Context [/SASContentServer] startup failed due to previous errors
 09:35:08,867 INFO  (localhost-startStop-1) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASContentServer.xml has finished in 6,505 ms
 09:35:08,867 INFO  (localhost-startStop-1) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASSharedApps.xml
 09:35:10,468 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:10,469 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Context [/SASPrincipalServices] startup failed due to previous errors
 09:35:11,161 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:11,162 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Context [/SASWIPClientAccess] startup failed due to previous errors
 09:35:11,469 ERROR (localhost-startStop-4) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:11,470 ERROR (localhost-startStop-4) [org.apache.catalina.core.StandardContext] Context [/SASBIWS] startup failed due to previous errors
 09:35:11,480 INFO  (localhost-startStop-4) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASBIWS.xml has finished in 6,515 ms
 09:35:11,480 INFO  (localhost-startStop-4) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASWorkflowServices.xml
 09:35:11,516 INFO  (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASPrincipalServices.xml has finished in 7,871 ms
 09:35:11,516 INFO  (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/sasweb.xml
 09:35:12,224 INFO  (localhost-startStop-3) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASWIPClientAccess.xml has finished in 9,064 ms
 09:35:12,224 INFO  (localhost-startStop-3) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASDeploymentBackup.xml
 09:35:12,428 INFO  (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/sasweb.xml has finished in 912 ms
 09:35:12,428 INFO  (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASPreferences.xml
 09:35:15,432 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:15,433 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Context [/SASSharedApps] startup failed due to previous errors
 09:35:16,452 INFO  (localhost-startStop-1) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASSharedApps.xml has finished in 7,585 ms
 09:35:16,453 INFO  (localhost-startStop-1) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASTheme_company.xml
 09:35:17,349 INFO  (localhost-startStop-1) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASTheme_company.xml has finished in 896 ms
 09:35:17,350 INFO  (localhost-startStop-1) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASAuthorizationServices.xml
 09:35:18,885 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:18,919 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Context [/SASPreferences] startup failed due to previous errors
 09:35:19,935 INFO  (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASPreferences.xml has finished in 7,507 ms
 09:35:19,935 INFO  (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASTemplateEditor.xml
 09:35:19,935 INFO  (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASTemplateEditor.xml
 09:35:20,029 ERROR (localhost-startStop-4) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:20,031 ERROR (localhost-startStop-4) [org.apache.catalina.core.StandardContext] Context [/SASWorkflowServices] startup failed due to previous errors
 09:35:21,051 INFO  (localhost-startStop-4) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASWorkflowServices.xml has finished in 9,570 ms
 09:35:21,051 INFO  (localhost-startStop-4) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASAdmin.xml
 09:35:21,231 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:21,231 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Context [/SASDeploymentBackup] startup failed due to previous errors
 09:35:22,148 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:22,149 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Context [/SASAuthorizationServices] startup failed due to previous errors
 09:35:22,242 INFO  (localhost-startStop-3) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASDeploymentBackup.xml has finished in 10,018 ms
 09:35:22,242 INFO  (localhost-startStop-3) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASWorkflowWebServices.xml
 09:35:23,166 INFO  (localhost-startStop-1) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASAuthorizationServices.xml has finished in 5,816 ms
 09:35:23,167 INFO  (localhost-startStop-1) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASLogon.xml
 09:35:24,748 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:24,749 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Context [/SASTemplateEditor] startup failed due to previous errors
 09:35:25,766 INFO  (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASTemplateEditor.xml has finished in 5,831 ms
 09:35:25,767 INFO  (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASWIPServices.xml
 09:35:26,540 ERROR (localhost-startStop-4) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:26,541 ERROR (localhost-startStop-4) [org.apache.catalina.core.StandardContext] Context [/SASAdmin] startup failed due to previous errors
 09:35:27,552 INFO  (localhost-startStop-4) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASAdmin.xml has finished in 6,501 ms
 09:35:27,552 INFO  (localhost-startStop-4) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASBackupManager.xml
 09:35:28,373 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:28,374 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Context [/SASWorkflowWebServices] startup failed due to previous errors
 09:35:29,395 INFO  (localhost-startStop-3) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASWorkflowWebServices.xml has finished in 7,153 ms
 09:35:29,397 INFO  (localhost-startStop-3) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASStoredProcess.xml
 09:35:29,397 INFO  (localhost-startStop-3) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASStoredProcess.xml
 09:35:29,406 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:29,407 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Context [/SASLogon] startup failed due to previous errors
 09:35:30,438 ERROR (localhost-startStop-1) [org.apache.catalina.loader.WebappClassLoader] The web application [/SASLogon] appears to have started a thread named [perf4j-async-stats-appender-sink-CoalescingStatistics] but has failed to stop it. This is very likely to create a memory leak.
 09:35:30,442 INFO  (localhost-startStop-1) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASLogon.xml has finished in 7,275 ms
 09:35:34,109 ERROR (localhost-startStop-4) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:34,110 ERROR (localhost-startStop-4) [org.apache.catalina.core.StandardContext] Context [/SASBackupManager] startup failed due to previous errors
 09:35:34,153 INFO  (localhost-startStop-4) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASBackupManager.xml has finished in 6,601 ms
 09:35:34,811 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:34,812 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Context [/SASStoredProcess] startup failed due to previous errors
 09:35:34,838 INFO  (localhost-startStop-3) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASStoredProcess.xml has finished in 5,440 ms
 09:35:38,875 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Error listenerStart
 09:35:38,876 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Context [/SASWIPServices] startup failed due to previous errors
 09:35:39,893 INFO  (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/conf/Catalina/localhost/SASWIPServices.xml has finished in 14,126 ms
 09:35:39,894 INFO  (localhost-startStop-1) [org.apache.catalina.startup.HostConfig] Deploying web application directory /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/webapps/ROOT
 09:35:40,477 INFO  (localhost-startStop-1) [org.apache.catalina.startup.HostConfig] Deployment of web application directory /sasconfig/Lev1/Web/WebAppServer/SASServer1_1/webapps/ROOT has finished in 582 ms
 09:35:40,494 INFO  (main) [org.apache.catalina.startup.Catalina] Server startup in 56525 ms
^C
-sh-4.1$

 

0 Likes
1 ACCEPTED SOLUTION

Accepted Solutions
Debi_SAS
Fluorite | Level 6 Debi_SAS
Fluorite | Level 6

Re: SASServer1_1 not starting

Posted 01-15-2019 01:42 PM (7445 views)  |   In reply to woo

Thanks Woo. 

 

For EG - If you are able to login to the linux server with your user ID and that ID is not mentioned in /etc/passwd file; then it must be an AD or LDAP ID / or any authentication provider ID . If it is AD/LDAP ID (PAM Authentication), then you need to enable PAM authentication to resolve this issue . 

 

Please find below link for the same. 

 

http://support.sas.com/kb/49/432.html  

View solution in original post

16 REPLIES 16
dpage
SAS Employee dpage
SAS Employee

Re: SASServer1_1 not starting

Posted 01-11-2019 11:33 AM (7632 views)  |   In reply to woo

"Caused by: java.sql.SQLException: ORA-28001: the password has expired"

 

Oracle isn't letting the JDBC connection through due to an expired password. If you can unexpire and keep the same password, do that. If you need to update it on the Oracle side to something new, follow the doc here to update SAS's references to it. https://go.documentation.sas.com/?docsetId=bisecag&docsetTarget=p0kb2gtnuyjnrnn1hduu5by88u4f.htm&doc...

 

 

0 Likes
woo
Barite | Level 11 woo
Barite | Level 11

Re: SASServer1_1 not starting

Posted 01-11-2019 11:43 AM (7625 views)  |   In reply to dpage

we have unexpired password in place. do we still need to update using sdm? we have sas metadata and other compute servers are up and seems fine. services came up fine for those tiers. issue is only mid-tier...

0 Likes
dpage
SAS Employee dpage
SAS Employee

Re: SASServer1_1 not starting

Posted 01-11-2019 01:12 PM (7607 views)  |   In reply to woo

I'm not sure what that means - but if the username/password combination for SharedServices is invalid, sasserver1 will fail to start with the errors you're seeing. There's nothing in the compute or metadata tier that would care about those credentials, so they'd work fine. Some solutions have database credentials that are used in multiple places, but typically the compute tier won't fail until you run a job / stored process / application action that triggers a database access - it's not usually a startup issue. 

0 Likes
woo
Barite | Level 11 woo
Barite | Level 11

Re: SASServer1_1 not starting

Posted 01-11-2019 02:34 PM (7599 views)  |   In reply to dpage

so if I use internal sas account, example: sas installer account, below libname statement runs fine. if password needs to update, would I able to still define libname statement?

 

however, at the moment, I, as a user, cannot use EG and connect to metadata server (same with other users). Profile error says userid or password is incorrect. only can connect using internal account and define libname statement.

 

libname myora oracle path="" schema="" user="" password="";

 

 

 

 

 

0 Likes
dpage
SAS Employee dpage
SAS Employee

Re: SASServer1_1 not starting

Posted 01-11-2019 04:10 PM (7585 views)  |   In reply to woo

It depends on how your Oracle authentication is setup - if you're using something like Kerberos auth it may be delegating that properly, but not the JDBC user/password login. You can see which userid it's attempting to use in SASServer1_1/conf/server.xml  - look for the jdbc line(s) - then attempt to use a libname statement to that same host/port/SID with that user/password.

 

I wouldn't expect that libname to do much of anything if you're not filling those fields out.

 

For your EG error, that seems unrelated but likely has something to do with the metadata server -> OS authentication layer - look for more details in the metadata server logs (is it supposed to be configured to validate external accounts in a system like LDAP?) 

0 Likes
woo
Barite | Level 11 woo
Barite | Level 11

Re: SASServer1_1 not starting

Posted 01-11-2019 05:50 PM (7576 views)  |   In reply to dpage

Thanks for your details. Also, I followed sas documentation and was able to update password on compute tier and mid-tier. all server tiers came up fine except server8 which is throwing below error.

 

I also modified "db.AdminTools.properties" /sasconfig/Lev1/Applications/SASModelRiskManagementAdministrativeTools/properties with proc pwencode process.

 

 

server.log for server8

 17:36:12,185 INFO  (main) [org.apache.catalina.core.StandardService] Starting service Catalina
 17:36:12,185 INFO  (main) [org.apache.catalina.core.StandardEngine] Starting Servlet Engine: Pivotal tc Runtime 3.0.0.RELEASE/7.0.55.A.RELEASE
 17:36:12,210 INFO  (localhost-startStop-1) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor ../sasconfig/Lev1/Web/WebAppServer/SASServer8_1/conf/Catalina/localhost/SASModelRisk.xml
 17:36:17,068 INFO  (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASModelRisk]] No Spring WebApplicationInitializer types detected on classpath
 17:36:17,096 INFO  (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASModelRisk]] Config path: file:///../sasconfig/Lev1/Web/Common/LogConfig/
 17:36:17,097 INFO  (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASModelRisk]] Context path: SASModelRiskManagementMidTier
 17:36:17,097 INFO  (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASModelRisk]] Configuring Log4j from URL at path: /file:///../sasconfig/Lev1/Web/Common/LogConfig/SASModelRiskManagementMidTier-log4j.xml
 17:36:17,097 INFO  (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASModelRisk]] isXMLConfigFile: true
 17:36:17,119 INFO  (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASModelRisk]] Initializing Spring root WebApplicationContext
 17:37:19,199 ERROR (localhost-startStop-1) [org.apache.tomcat.jdbc.pool.ConnectionPool] Unable to create initial connections of pool.
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
        at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
        at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
        at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:701)
        at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:635)
        at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:486)
        at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:144)
        at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
        at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
        at org.apache.tomcat.jdbc.pool.DataSourceFactory.createDataSource(DataSourceFactory.java:554)
        at org.apache.tomcat.jdbc.pool.DataSourceFactory.getObjectInstance(DataSourceFactory.java:242)
        at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:141)
        at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:321)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:842)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:167)
        at org.apache.naming.factory.ResourceLinkFactory.getObjectInstance(ResourceLinkFactory.java:92)
        at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:321)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:842)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:167)
        at org.apache.naming.SelectorContext.lookup(SelectorContext.java:156)
        at javax.naming.InitialContext.lookup(InitialContext.java:411)
        at com.sas.oprisk.framework.server.persistence.ContainerManagedConnectionProvider.<init>(ContainerManagedConnectionProvider.java:38)
        at com.sas.oprisk.monitor.web.MonitorContextListener.contextInitialized(MonitorContextListener.java:55)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1862)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

        at oracle.net.ns.NSProtocol.connect(NSProtocol.java:395)
        at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)
        ... 49 more
 17:37:19,203 WARN  (localhost-startStop-1) [org.apache.naming.NamingContext] Unexpected exception resolving reference
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
        at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
        at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
        at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:701)
        at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:635)
        at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:486)
        at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:144)
        at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
        at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
        at org.apache.tomcat.jdbc.pool.DataSourceFactory.createDataSource(DataSourceFactory.java:554)
        at org.apache.tomcat.jdbc.pool.DataSourceFactory.getObjectInstance(DataSourceFactory.java:242)
        at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:141)
        at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:321)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:842)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:167)
        at org.apache.naming.factory.ResourceLinkFactory.getObjectInstance(ResourceLinkFactory.java:92)
        at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:321)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:842)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:167)
        at org.apache.naming.SelectorContext.lookup(SelectorContext.java:156)
        at javax.naming.InitialContext.lookup(InitialContext.java:411)
        at com.sas.oprisk.framework.server.persistence.ContainerManagedConnectionProvider.<init>(ContainerManagedConnectionProvider.java:38)
        at com.sas.oprisk.monitor.web.MonitorContextListener.contextInitialized(MonitorContextListener.java:55)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1862)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

        at oracle.net.ns.NSProtocol.connect(NSProtocol.java:395)
        at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)
        ... 49 more
 17:37:19,205 ERROR (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASModelRisk]] Exception sending context initialized event to listener instance of class com.sas.oprisk.monitor.web.MonitorContextListener
com.sas.oprisk.framework.server.OpRiskConfigurationError: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

        at com.sas.oprisk.framework.server.persistence.ContainerManagedConnectionProvider.<init>(ContainerManagedConnectionProvider.java:47)
        at com.sas.oprisk.monitor.web.MonitorContextListener.contextInitialized(MonitorContextListener.java:55)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1862)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)
Caused by: javax.naming.NamingException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

        at org.apache.naming.NamingContext.lookup(NamingContext.java:859)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:167)
        at org.apache.naming.factory.ResourceLinkFactory.getObjectInstance(ResourceLinkFactory.java:92)
        at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:321)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:842)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:167)
        at org.apache.naming.SelectorContext.lookup(SelectorContext.java:156)
        at javax.naming.InitialContext.lookup(InitialContext.java:411)
        at com.sas.oprisk.framework.server.persistence.ContainerManagedConnectionProvider.<init>(ContainerManagedConnectionProvider.java:38)
        ... 14 more

Caused By:

javax.naming.NamingException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

        at org.apache.naming.NamingContext.lookup(NamingContext.java:859)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:167)
        at org.apache.naming.factory.ResourceLinkFactory.getObjectInstance(ResourceLinkFactory.java:92)
        at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:321)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:842)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:830)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:167)
        at org.apache.naming.SelectorContext.lookup(SelectorContext.java:156)
        at javax.naming.InitialContext.lookup(InitialContext.java:411)
        at com.sas.oprisk.framework.server.persistence.ContainerManagedConnectionProvider.<init>(ContainerManagedConnectionProvider.java:38)
        at com.sas.oprisk.monitor.web.MonitorContextListener.contextInitialized(MonitorContextListener.java:55)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1862)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)
 17:37:19,207 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Error listenerStart
 17:37:19,209 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Context [/SASModelRisk] startup failed due to previous errors
 17:37:19,294 WARN  (localhost-startStop-1) [com.sas.oprisk.monitor.web.MonitorContextListener] Cannot unlock secured user session context. Lock object was null.
 17:37:19,294 INFO  (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASModelRisk]] Closing Spring root WebApplicationContext
 17:37:19,830 INFO  (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASModelRisk]] Cleaning up Log4j resources for context: Model Risk Management Mid-Tier...
 17:37:19,830 INFO  (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASModelRisk]] Shutting down all loggers and appenders...
 17:37:19,832 INFO  (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASModelRisk]] Log4j cleaned up.
 17:37:19,841 ERROR (localhost-startStop-1) [org.apache.catalina.loader.WebappClassLoader] The web application [/SASModelRisk] appears to have started a thread named [disconnect thread for jabdl3908(27471)<v9>:47666/35271] but has failed to stop it. This is very likely to create a memory leak.
 17:37:19,841 ERROR (localhost-startStop-1) [org.apache.catalina.loader.WebappClassLoader] The web application [/SASModelRisk] appears to have started a thread named [SystemFailure WatchDog] but has failed to stop it. This is very likely to create a memory leak.
 17:37:19,842 ERROR (localhost-startStop-1) [org.apache.catalina.loader.WebappClassLoader] The web application [/SASModelRisk] appears to have started a thread named [SystemFailure Proctor] but has failed to stop it. This is very likely to create a memory leak.
 17:37:19,842 ERROR (localhost-startStop-1) [org.apache.catalina.loader.WebappClassLoader] The web application [/SASModelRisk] appears to have started a thread named [State Logger Consumer Thread] but has failed to stop it. This is very likely to create a memory leak.
 17:37:19,857 INFO  (localhost-startStop-1) [org.apache.catalina.startup.HostConfig] Deployment of configuration descriptor ../sasconfig/Lev1/Web/WebAppServer/SASServer8_1/conf/Catalina/localhost/SASModelRisk.xml has finished in 67,647 ms
 17:37:19,858 INFO  (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deploying web application directory ../sasconfig/Lev1/Web/WebAppServer/SASServer8_1/webapps/ROOT
 17:37:20,611 INFO  (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deployment of web application directory ../sasconfig/Lev1/Web/WebAppServer/SASServer8_1/webapps/ROOT has finished in 752 ms
 17:37:20,626 INFO  (main) [org.apache.catalina.startup.Catalina] Server startup in 69325 ms
^C

0 Likes
woo
Barite | Level 11 woo
Barite | Level 11

Re: SASServer1_1 not starting

Posted 01-14-2019 09:03 AM (7519 views)  |   In reply to woo

Also, I am able to define a libname statement successfully from EG (connect as installer id) and from base sas (./sas -nodms - from sas compute server) as installer id.

 

LIBNAME MYORA Oracle PATH="XXX" SCHEMA="XXX" USER=XXX PASSWORD="{SAS002}XXX";

 

 

+

 

for EG error, we are having only internal connection happening. user exist on metadata server but somehow profile is not being accepting...at same time, profile with sas installer id connecting fine...

 

0 Likes
dpage
SAS Employee dpage
SAS Employee

Re: SASServer1_1 not starting

Posted 01-14-2019 09:42 AM (7509 views)  |   In reply to woo

that error sounds like the Oracle server has changed since the SAS stack was deployed - so the URL we're using isn't valid. We're accessing a SID the server doesn't know about. This is JDBC so it doesn't consume the tnsnames.ora file local to the webappserver, but talks directly to the database server so it must know about the SID. That's different from what you're doing in EG and SAS where it will honor your local tnsnames.ora.

 

At this point engaging tech support will be the best path forward.

woo
Barite | Level 11 woo
Barite | Level 11

Re: SASServer1_1 not starting

Posted 01-14-2019 10:22 AM (7502 views)  |   In reply to dpage

Thank you so much. Really appreciate your input.

 

Just last check. for EG error, we have only internal authentication happening. however, we don't have users defined under /etc/passwd file, only internal users define there. when I, as user, try to connect metadata server with my eg profile, eg profile throwing "user id or password is not valid" error. does this means my id is not defined the way it should be at OS level?

 

New client connection (12345) rejected from server port 8561 for user xyz. Peer IP address and port are [::ffff:10.24.30.136]:54581 for APPNAME=SAS Enterprise Guide.

Client connection 12345 closed.

Access denied.

 

 

 

 

0 Likes
Kurt_Bremser
Super User Kurt_Bremser
Super User

Re: SASServer1_1 not starting

Posted 01-14-2019 10:36 AM (7497 views)  |   In reply to woo

Purely internal users will have the structure xyz@saspw (similar to sasadm@saspw), because the use the non-default authentication domain "saspw".

The default for DefaultAuth is authenticating against the OS, so for every user-id that does not have an authentication domain attached, SAS will go looking in the OS for the credentials. Also note that internal users are mostly useless in EG, as they can't start a workspace server.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX
woo
Barite | Level 11 woo
Barite | Level 11

Re: SASServer1_1 not starting

Posted 01-14-2019 10:55 AM (7490 views)  |   In reply to Kurt_Bremser

Thank you Kurt. in this case, I am sorry its my bad. actually my installer id is not internal id then as it is defined as "DefaultAuth" for Authentication Domain in smc  (like me). And since installer id is clearly defined under /etc/passwd (but not me) it is being authenticated fine.

 

So looks like, OS/Linux team will have to define my id same way or any other possible way where I can get authenticated as well.  

 

0 Likes
Debi_SAS
Fluorite | Level 6 Debi_SAS
Fluorite | Level 6

Re: SASServer1_1 not starting

Posted 01-15-2019 01:17 AM (7465 views)  |   In reply to woo

For your ID ; Are you able to login (direct SSH) to Linux server using your ID ?? If  yes, then can you login to Unix once and try to create a small file (touch abc) in your home path and check if you have permission there. If everything above goes well, then you should be able to connect through SAS EG without any issue.

 

Regarding your original error, I found "Caused by: java.sql.SQLException: ORA-28001: the password has expired" message from your log . Along with kurt's reply, you can also check if the password defined for the connection ID is correct and not expired.

 

Regards,
Debi

0 Likes
woo
Barite | Level 11 woo
Barite | Level 11

Re: SASServer1_1 not starting

Posted 01-15-2019 01:08 PM (7449 views)  |   In reply to Debi_SAS

for EG - I can login as me (as user) on Linux machines and can create directory or files. however, eg connection profile still showing error (userid or password invalid). however, can connect using sas installer id (which is defined at /etc/passwd) but users are not (they are not defined at /etc/passwd)

 

for oracle issue - we don't have expired password. however, there was error and it was pointing to updating password where we perform updating password (same password through) for compute server and mid-tier server - then everything else came up but not server81 - where we receive oracle error. however, I can connect using sqlplus + oracle libname statement define fine with sas installer id from EG.

0 Likes
Debi_SAS
Fluorite | Level 6 Debi_SAS
Fluorite | Level 6

Re: SASServer1_1 not starting

Posted 01-15-2019 01:42 PM (7446 views)  |   In reply to woo

Thanks Woo. 

 

For EG - If you are able to login to the linux server with your user ID and that ID is not mentioned in /etc/passwd file; then it must be an AD or LDAP ID / or any authentication provider ID . If it is AD/LDAP ID (PAM Authentication), then you need to enable PAM authentication to resolve this issue . 

 

Please find below link for the same. 

 

http://support.sas.com/kb/49/432.html  

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Watch Get Started with SAS Information Catalog in SAS Viya on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 16 replies
  • ‎01-11-2019 11:25 AM
  • 7637 views
  • 3 likes
  • 4 in conversation