DevTest 10.5 unstable after weekend patching

Products

• CLOUDTEST
• CA Application Test
• CA Cloud Test Mobile
• MOBILECLOUD
• Service Virtualization

Issue/Introduction

We are observing connection issue with devtest server intermittently from portal and virtual services. I also observed that admin users lost access to view and manage VSE on portal.

 

OS : linux service pack 

V : 3.10.0

Changes : Patching event happend 

 

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (IO Error: The Network Adapter could not establish the connection)

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (IO Error: The Network Adapter could not establish the connection)
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.afterPropertiesSet(LazyConnectionDataSourceProxy.java:162)
at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy.(LazyConnectionDataSourceProxy.java:106)

Cause

Database IP  address changed  or  Firewall rules were enabled after patching. 

Environment

Release : 10.5

Component : CA Service Virtualization

Resolution

We tried to ping Database server from the ED/Registry machine.. and we got connection time out error.


Please work with your network team and see if the IP address changed or if the firewall rules are enabled on the Database server..