3 Replies Latest reply on Jan 22, 2019 12:35 AM by Cibi Mathew

    Not able to connect to Database : BBSA

    Cibi Mathew

      Hi friends,

       

      From BSA App Server getting connectivity Error :

       

      [21 Jan 2019 10:52:01,181] [Scheduled-System-Tasks-Thread-2] [ERROR] [System:System:] [Large Object Cleanup Task] Failed to cleanup large object cacheAn error occurred while attempting to access the database:

      Message : The TCP/IP connection to the host 192.168.14.26, port 1433 has failed. Error: "Connection timed out: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.". SQLState: null ErrorCode: 0

       

      [21 Jan 2019 10:52:10,202] [Scheduled-System-Tasks-Thread-19] [ERROR] [System:System:] [Update Job Run Counts] The TCP/IP connection to the host 192.168.14.26, port 1433 has failed. Error: "Connection timed out: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

      java.sql.SQLException: The TCP/IP connection to the host 192.168.14.26, port 1433 has failed. Error: "Connection timed out: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

      at com.bladelogic.om.infra.shared.db.pool.BlSqlServerDbConnectionFactory.createConnection(BlSqlServerDbConnectionFactory.java:68)

      at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)

       

      The existing database server got corrupted, and the BSA database has been moved to a new SQL database server.

       

      kindly confirm , if there are any files that i need to modify on the Application Server in order  to establish a connection with new database server.

       

      Details :

      BSA Application Server  : 8.9.01

      Database : SQL Server 2016

       

      Kindly Advise.

       

      Thanks...

      [21 Jan 2019 10:52:01,181] [Scheduled-System-Tasks-Thread-2] [ERROR] [System:System:] [Large Object Cleanup Task] Failed to cleanup large object cacheAn error occurred while attempting to access the database:

      Message : The TCP/IP connection to the host 10.4.226.43, port 1433 has failed. Error: "Connection timed out: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.". SQLState: null ErrorCode: 0

       

      [21 Jan 2019 10:52:10,202] [Scheduled-System-Tasks-Thread-19] [ERROR] [System:System:] [Update Job Run Counts] The TCP/IP connection to the host 10.4.226.43, port 1433 has failed. Error: "Connection timed out: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

      java.sql.SQLException: The TCP/IP connection to the host 10.4.226.43, port 1433 has failed. Error: "Connection timed out: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

      at com.bladelogic.om.infra.shared.db.pool.BlSqlServerDbConnectionFactory.createConnection(BlSqlServerDbConnectionFactory.java:68)

      at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)