SAS webservices not starting

MaxBeijer — Wed, 30 Jan 2019 16:03:36 GMT

Hi all,

Hope someone can help. I have problems starting the webservices. I already tried the next steps.

- checked license

- checked firewall/ports

- stop middle tier completely

- clean / archive logs from SASServerN_M, JMS and Cache Locator

- delete contents of /tmp and /work folders of SASServerN_M and contents of JMS (data folder) and the Cache Locator (except the config file)

- Restart services, if possible, manually and checking the logs with a tail tool, to see if problems starts somewhere else.

But still get the next errors in the server log when starting SASServer1_1.

2019-01-30 16:28:18,383 WARN (WrapperSimpleAppMain) [com.springsource.tcserver.serviceability.rmi.JmxSocketListener] Detected LDAP configuration 'D:/SAS94/Config/Lev1/Web/WebAppServer/SASServer1_1/conf/jaas.config', but there is no ldap configuration entry specified.
2019-01-30 16:28:18,430 INFO (WrapperSimpleAppMain) [org.apache.catalina.startup.Catalina] Initialization processed in 736 ms
2019-01-30 16:31:49,010 INFO (WrapperSimpleAppMain) [org.apache.catalina.core.StandardService] Starting service Catalina
2019-01-30 16:31:49,010 INFO (WrapperSimpleAppMain) [org.apache.catalina.core.StandardEngine] Starting Servlet Engine: VMware vFabric tc Runtime 2.8.0.RELEASE/7.0.30.A.RELEASE
2019-01-30 16:31:49,010 INFO (localhost-startStop-1) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASAdmin.xml
2019-01-30 16:31:49,010 INFO (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASAuthorizationServices.xml
2019-01-30 16:31:49,010 INFO (localhost-startStop-3) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASBIDashboard.xml
2019-01-30 16:31:49,026 INFO (localhost-startStop-4) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASBIDashboardEventGen.xml
2019-01-30 16:31:52,948 INFO (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAdmin]] No Spring WebApplicationInitializer types detected on classpath
2019-01-30 16:31:52,963 INFO (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAdmin]] Config path: file:///D:/SAS94/Config/Lev1/Web/Common/LogConfig/
2019-01-30 16:31:52,963 INFO (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAdmin]] Context path: SASAdmin
2019-01-30 16:31:52,963 INFO (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAdmin]] Configuring Log4j from URL at path: /file:///D:/SAS94/Config/Lev1/Web/Common/LogConfig/SASAdmin-log4j.xml
2019-01-30 16:31:52,963 INFO (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAdmin]] isXMLConfigFile: true
2019-01-30 16:31:52,979 INFO (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAdmin]] Initializing Spring root WebApplicationContext
2019-01-30 16:31:53,573 INFO (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboardEventGen]] No Spring WebApplicationInitializer types detected on classpath
2019-01-30 16:31:53,588 INFO (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboard]] No Spring WebApplicationInitializer types detected on classpath
2019-01-30 16:31:53,620 INFO (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboardEventGen]] Config path: file:///D:/SAS94/Config/Lev1/Web/Common/LogConfig/
2019-01-30 16:31:53,620 INFO (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboardEventGen]] Context path: SASBIDashboardEventGen
2019-01-30 16:31:53,620 INFO (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboardEventGen]] Configuring Log4j from URL at path: /file:///D:/SAS94/Config/Lev1/Web/Common/LogConfig/SASBIDashboardEventGen-log4j.xml
2019-01-30 16:31:53,620 INFO (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboardEventGen]] isXMLConfigFile: true
2019-01-30 16:31:53,620 INFO (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAuthorizationServices]] No Spring WebApplicationInitializer types detected on classpath
2019-01-30 16:31:53,635 INFO (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAuthorizationServices]] Config path: file:///D:/SAS94/Config/Lev1/Web/Common/LogConfig/
2019-01-30 16:31:53,635 INFO (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAuthorizationServices]] Context path: SASAuthorizationServices
2019-01-30 16:31:53,635 INFO (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAuthorizationServices]] Configuring Log4j from URL at path: /file:///D:/SAS94/Config/Lev1/Web/Common/LogConfig/SASAuthorizationServices-log4j.xml
2019-01-30 16:31:53,635 INFO (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAuthorizationServices]] isXMLConfigFile: true
2019-01-30 16:31:53,635 INFO (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboard]] Config path: file:///D:/SAS94/Config/Lev1/Web/Common/LogConfig/
2019-01-30 16:31:53,635 INFO (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboard]] Context path: SASBIDashboard
2019-01-30 16:31:53,635 INFO (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboard]] Configuring Log4j from URL at path: /file:///D:/SAS94/Config/Lev1/Web/Common/LogConfig/SASBIDashboard-log4j.xml
2019-01-30 16:31:53,635 INFO (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboard]] isXMLConfigFile: true
2019-01-30 16:31:53,651 INFO (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboardEventGen]] Initializing Spring root WebApplicationContext
2019-01-30 16:31:53,651 INFO (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAuthorizationServices]] Initializing Spring root WebApplicationContext
2019-01-30 16:31:53,698 INFO (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboard]] Initializing Spring root WebApplicationContext
2019-01-30 16:33:40,136 ERROR (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAuthorizationServices]] 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:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:644)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:446)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:384)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
at com.sas.svcs.webapp.servlet.springframework.DefaultContextLoaderListener.contextInitialized(DefaultContextLoaderListener.java:44)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4791)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5285)
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:618)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:650)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1582)
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:744)
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:149)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:109)
at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1441)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:305)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
... 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:573)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:714)
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:58)
at com.sas.framework.services.config.dao.PropertySetFactoryBean.getObject(PropertySetFactoryBean.java:23)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)
... 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:245)
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: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.connect(Driver.java:267)
at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.getConnection(AtomikosNonXAConnectionFactory.java:119)
at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.createPooledConnection(AtomikosNonXAConnectionFactory.java:127)
... 51 more
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at org.postgresql.core.PGStream.<init>(PGStream.java:60)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:101)
... 61 more
2019-01-30 16:33:40,246 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Error listenerStart
2019-01-30 16:33:40,246 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Context [/SASAuthorizationServices] startup failed due to previous errors
2019-01-30 16:33:40,246 INFO (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAuthorizationServices]] Closing Spring root WebApplicationContext
2019-01-30 16:33:41,324 INFO (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAuthorizationServices]] Cleaning up Log4j resources for context: null...
2019-01-30 16:33:41,324 INFO (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAuthorizationServices]] Shutting down all loggers and appenders...
2019-01-30 16:33:41,324 INFO (localhost-startStop-2) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAuthorizationServices]] Log4j cleaned up.
2019-01-30 16:33:41,324 INFO (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASBIPortlets.xml
2019-01-30 16:34:01,136 ERROR (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboard]] Exception sending context initialized event to listener instance of class com.sas.bi.dashboard.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.sas.svcs.springframework.config.DefaultProvidedPropertyPlaceholderConfigurer#0' 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:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:644)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:446)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:384)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4791)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5285)
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:618)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:650)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1582)
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:744)
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:149)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:109)
at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1441)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:305)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
... 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:573)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:714)
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:58)
at com.sas.framework.services.config.dao.PropertySetFactoryBean.getObject(PropertySetFactoryBean.java:23)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)
... 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:245)
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: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.connect(Driver.java:267)
at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.getConnection(AtomikosNonXAConnectionFactory.java:119)
at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.createPooledConnection(AtomikosNonXAConnectionFactory.java:127)
... 50 more
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at org.postgresql.core.PGStream.<init>(PGStream.java:60)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:101)
... 60 more
2019-01-30 16:34:01,246 ERROR (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboard]] Exception sending context initialized event to listener instance of class com.sas.svcs.webapp.servlet.FrameworkContextListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.sas.svcs.springframework.config.DefaultProvidedPropertyPlaceholderConfigurer#0' 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:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:644)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:446)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:384)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4791)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5285)
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:618)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:650)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1582)
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:744)
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:149)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:109)
at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1441)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:305)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
... 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:573)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:714)
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:58)
at com.sas.framework.services.config.dao.PropertySetFactoryBean.getObject(PropertySetFactoryBean.java:23)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)
... 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:245)
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: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.connect(Driver.java:267)
at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.getConnection(AtomikosNonXAConnectionFactory.java:119)
at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.createPooledConnection(AtomikosNonXAConnectionFactory.java:127)
... 50 more
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at org.postgresql.core.PGStream.<init>(PGStream.java:60)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:101)
... 60 more
2019-01-30 16:34:01,355 ERROR (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboard]] Exception sending context initialized event to listener instance of class com.sas.common.components.SpringComponentFacade
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.sas.svcs.springframework.config.DefaultProvidedPropertyPlaceholderConfigurer#0' 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:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:644)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:446)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:384)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4791)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5285)
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:618)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:650)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1582)
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:744)
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:149)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:109)
at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1441)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:305)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
... 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:573)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:714)
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:58)
at com.sas.framework.services.config.dao.PropertySetFactoryBean.getObject(PropertySetFactoryBean.java:23)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)
... 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:245)
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: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.connect(Driver.java:267)
at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.getConnection(AtomikosNonXAConnectionFactory.java:119)
at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.createPooledConnection(AtomikosNonXAConnectionFactory.java:127)
... 50 more
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at org.postgresql.core.PGStream.<init>(PGStream.java:60)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:101)
... 60 more
2019-01-30 16:34:01,464 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Error listenerStart
2019-01-30 16:34:01,464 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Context [/SASBIDashboard] startup failed due to previous errors
2019-01-30 16:34:01,480 ERROR (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboard]] Exception sending context destroyed event to listener instance of class com.sas.bi.dashboard.context.ContextLoaderListener
java.lang.NullPointerException
at com.sas.bi.dashboard.common.SpringApplicationContext.getBean(SpringApplicationContext.java:27)
at com.sas.bi.dashboard.context.ContextLoaderListener.contextDestroyed(ContextLoaderListener.java:26)
at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4831)
at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5478)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:232)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:160)
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:618)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:650)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1582)
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:744)
2019-01-30 16:34:01,480 INFO (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboard]] Cleaning up Log4j resources for context: SAS BI Dashboard 4.4...
2019-01-30 16:34:01,480 INFO (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboard]] Shutting down all loggers and appenders...
2019-01-30 16:34:01,480 INFO (localhost-startStop-3) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboard]] Log4j cleaned up.
2019-01-30 16:34:01,621 INFO (localhost-startStop-3) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASBIWS.xml
2019-01-30 16:34:22,152 ERROR (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAdmin]] 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/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:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:644)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:446)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:384)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
at com.sas.svcs.webapp.servlet.springframework.DefaultContextLoaderListener.contextInitialized(DefaultContextLoaderListener.java:44)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4791)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5285)
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:618)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:650)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1582)
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:744)
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:149)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:109)
at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1441)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:305)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
... 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:573)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:714)
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:58)
at com.sas.framework.services.config.dao.PropertySetFactoryBean.getObject(PropertySetFactoryBean.java:23)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)
... 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:245)
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: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.connect(Driver.java:267)
at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.getConnection(AtomikosNonXAConnectionFactory.java:119)
at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.createPooledConnection(AtomikosNonXAConnectionFactory.java:127)
... 51 more
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at org.postgresql.core.PGStream.<init>(PGStream.java:60)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:101)
... 61 more
2019-01-30 16:34:22,261 ERROR (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAdmin]] Exception sending context initialized event to listener instance of class com.sas.svcs.webapp.servlet.FrameworkContextListener
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:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:644)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:446)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:384)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
at com.sas.svcs.webapp.servlet.springframework.DefaultContextLoaderListener.contextInitialized(DefaultContextLoaderListener.java:44)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4791)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5285)
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:618)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:650)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1582)
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:744)
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:149)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:109)
at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1441)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:305)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
... 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:573)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:714)
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:58)
at com.sas.framework.services.config.dao.PropertySetFactoryBean.getObject(PropertySetFactoryBean.java:23)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)
... 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:245)
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: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.connect(Driver.java:267)
at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.getConnection(AtomikosNonXAConnectionFactory.java:119)
at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.createPooledConnection(AtomikosNonXAConnectionFactory.java:127)
... 51 more
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at org.postgresql.core.PGStream.<init>(PGStream.java:60)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:101)
... 61 more
2019-01-30 16:34:22,371 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Error listenerStart
2019-01-30 16:34:22,371 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Context [/SASAdmin] startup failed due to previous errors
2019-01-30 16:34:22,371 INFO (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAdmin]] Closing Spring root WebApplicationContext
2019-01-30 16:34:23,480 INFO (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAdmin]] Cleaning up Log4j resources for context: null...
2019-01-30 16:34:23,480 INFO (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAdmin]] Shutting down all loggers and appenders...
2019-01-30 16:34:23,480 INFO (localhost-startStop-1) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASAdmin]] Log4j cleaned up.
2019-01-30 16:34:23,480 INFO (localhost-startStop-1) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASContentServer.xml
2019-01-30 16:35:25,168 ERROR (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboardEventGen]] 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:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:644)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:446)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:384)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4791)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5285)
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:618)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:650)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1582)
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:744)
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:149)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:109)
at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1441)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:305)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
... 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:573)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:714)
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:58)
at com.sas.framework.services.config.dao.PropertySetFactoryBean.getObject(PropertySetFactoryBean.java:23)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)
... 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:245)
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: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.connect(Driver.java:267)
at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.getConnection(AtomikosNonXAConnectionFactory.java:119)
at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.createPooledConnection(AtomikosNonXAConnectionFactory.java:127)
... 50 more
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at org.postgresql.core.PGStream.<init>(PGStream.java:60)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:101)
... 60 more
2019-01-30 16:35:25,278 ERROR (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboardEventGen]] Exception sending context initialized event to listener instance of class com.sas.svcs.webapp.servlet.FrameworkContextListener
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:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:644)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:446)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:384)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4791)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5285)
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:618)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:650)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1582)
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:744)
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:149)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:109)
at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1441)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:305)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
... 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:573)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:714)
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:58)
at com.sas.framework.services.config.dao.PropertySetFactoryBean.getObject(PropertySetFactoryBean.java:23)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)
... 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:245)
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: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.connect(Driver.java:267)
at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.getConnection(AtomikosNonXAConnectionFactory.java:119)
at com.atomikos.jdbc.nonxa.AtomikosNonXAConnectionFactory.createPooledConnection(AtomikosNonXAConnectionFactory.java:127)
... 50 more
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at org.postgresql.core.PGStream.<init>(PGStream.java:60)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:101)
... 60 more
2019-01-30 16:35:25,387 ERROR (localhost-startStop-4) [org.apache.catalina.core.StandardContext] Error listenerStart
2019-01-30 16:35:25,387 ERROR (localhost-startStop-4) [org.apache.catalina.core.StandardContext] Context [/SASBIDashboardEventGen] startup failed due to previous errors
2019-01-30 16:35:25,403 INFO (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboardEventGen]] Closing Spring root WebApplicationContext
2019-01-30 16:35:25,512 INFO (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboardEventGen]] Cleaning up Log4j resources for context: SAS BI Dashboard Event Generator 4.4...
2019-01-30 16:35:25,512 INFO (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboardEventGen]] Shutting down all loggers and appenders...
2019-01-30 16:35:25,512 INFO (localhost-startStop-4) [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SASBIDashboardEventGen]] Log4j cleaned up.
2019-01-30 16:35:25,528 INFO (localhost-startStop-4) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASDeploymentBackup.xml
2019-01-30 16:35:46,278 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Error listenerStart
2019-01-30 16:35:46,278 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Context [/SASBIPortlets] startup failed due to previous errors
2019-01-30 16:35:46,434 INFO (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASFlexThemes.xml
2019-01-30 16:35:46,543 INFO (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASIdentityServices.xml
2019-01-30 16:36:07,278 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Error listenerStart
2019-01-30 16:36:07,278 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Context [/SASBIWS] startup failed due to previous errors
2019-01-30 16:36:07,356 INFO (localhost-startStop-3) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASJSR168RemotePortlet.xml
2019-01-30 16:37:52,388 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Error listenerStart
2019-01-30 16:37:52,388 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Context [/SASIdentityServices] startup failed due to previous errors
2019-01-30 16:37:53,482 INFO (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASLogon.xml
2019-01-30 16:38:13,498 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Error listenerStart
2019-01-30 16:38:13,498 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Context [/SASJSR168RemotePortlet] startup failed due to previous errors
2019-01-30 16:38:13,638 INFO (localhost-startStop-3) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASPackageViewer.xml
2019-01-30 16:38:34,170 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Error listenerStart
2019-01-30 16:38:34,170 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Context [/SASContentServer] startup failed due to previous errors
2019-01-30 16:38:34,264 INFO (localhost-startStop-1) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASPermissionManager.xml
2019-01-30 16:39:37,389 ERROR (localhost-startStop-4) [org.apache.catalina.core.StandardContext] Error listenerStart
2019-01-30 16:39:37,389 ERROR (localhost-startStop-4) [org.apache.catalina.core.StandardContext] Context [/SASDeploymentBackup] startup failed due to previous errors
2019-01-30 16:39:38,499 INFO (localhost-startStop-4) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASPortal.xml
2019-01-30 16:39:58,858 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Error listenerStart
2019-01-30 16:39:58,858 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Context [/SASLogon] startup failed due to previous errors
2019-01-30 16:39:59,889 INFO (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASPreferences.xml
2019-01-30 16:40:19,546 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Error listenerStart
2019-01-30 16:40:19,546 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Context [/SASPackageViewer] startup failed due to previous errors
2019-01-30 16:40:19,624 INFO (localhost-startStop-3) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASPrincipalServices.xml
2019-01-30 16:42:04,547 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Error listenerStart
2019-01-30 16:42:04,547 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Context [/SASPreferences] startup failed due to previous errors
2019-01-30 16:42:05,625 INFO (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASSharedApps.xml
2019-01-30 16:42:25,469 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Error listenerStart
2019-01-30 16:42:25,469 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Context [/SASPrincipalServices] startup failed due to previous errors
2019-01-30 16:42:26,547 INFO (localhost-startStop-3) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASStoredProcess.xml
2019-01-30 16:42:46,469 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Error listenerStart
2019-01-30 16:42:46,469 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Context [/SASPermissionManager] startup failed due to previous errors
2019-01-30 16:42:47,531 INFO (localhost-startStop-1) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASTemplateEditor.xml
2019-01-30 16:43:49,688 ERROR (localhost-startStop-4) [org.apache.catalina.core.StandardContext] Error listenerStart
2019-01-30 16:43:49,688 ERROR (localhost-startStop-4) [org.apache.catalina.core.StandardContext] Context [/SASPortal] startup failed due to previous errors
2019-01-30 16:43:49,829 INFO (localhost-startStop-4) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASThemeDesignerForFlex.xml
2019-01-30 16:44:10,688 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Error listenerStart
2019-01-30 16:44:10,688 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Context [/SASSharedApps] startup failed due to previous errors
2019-01-30 16:44:11,751 INFO (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASTheme_default.xml
2019-01-30 16:44:11,860 INFO (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\sasweb.xml
2019-01-30 16:44:11,954 INFO (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASWIPClientAccess.xml
2019-01-30 16:44:31,688 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Error listenerStart
2019-01-30 16:44:31,688 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Context [/SASStoredProcess] startup failed due to previous errors
2019-01-30 16:44:31,782 INFO (localhost-startStop-3) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASWIPServices.xml
2019-01-30 16:46:16,596 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Error listenerStart
2019-01-30 16:46:16,596 ERROR (localhost-startStop-2) [org.apache.catalina.core.StandardContext] Context [/SASWIPClientAccess] startup failed due to previous errors
2019-01-30 16:46:17,705 INFO (localhost-startStop-2) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASWIPSoapServices.xml
2019-01-30 16:46:37,596 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Error listenerStart
2019-01-30 16:46:37,596 ERROR (localhost-startStop-3) [org.apache.catalina.core.StandardContext] Context [/SASWIPServices] startup failed due to previous errors
2019-01-30 16:46:38,752 INFO (localhost-startStop-3) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASWorkflowServices.xml
2019-01-30 16:46:58,596 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Error listenerStart
2019-01-30 16:46:58,596 ERROR (localhost-startStop-1) [org.apache.catalina.core.StandardContext] Context [/SASTemplateEditor] startup failed due to previous errors
2019-01-30 16:46:59,658 INFO (localhost-startStop-1) [org.apache.catalina.startup.HostConfig] Deploying configuration descriptor D:\SAS94\Config\Lev1\Web\WebAppServer\SASServer1_1\conf\Catalina\localhost\SASWorkflowWebServices.xml

topic Re: SAS webservices not starting in Administration and Deployment

SAS webservices not starting

Re: SAS webservices not starting

Re: SAS webservices not starting