BSA: 8.9.01 Error while creating database connection.

Version 1
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BladeLogic Server Automation Suite


    COMPONENT:

    BladeLogic Server Automation


    APPLIES TO:

    BSA 8.9.01



    PROBLEM:

    After upgrading BSA to 8.9.01 Database connection errors appear frequently in appserver log.

    <appserver.log>
    [31 Jul 2017 01:32:42,398] [Scheduled-System-Tasks-Thread-5] [ERROR] [System:System:] [App Server Heartbeat] The TCP/IP connection to the host <target>, port 1433 has failed. Error: "Connection refused: 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 <target>, port 1433 has failed. Error: "Connection refused: 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)
    ...
    [31 Jul 2017 01:32:54,648] [Scheduled-System-Tasks-Thread-16] [ERROR] [System:System:] [Update-Launcher-Status-Task-AU2004SP0802] Error while creating database connection. Please check the following for possible reasons of connection failure :
    1. Authentication failure
    ...
    [31 Jul 2017 05:25:54,626] [Scheduled-System-Tasks-Thread-3] [ERROR] [System:System:] [Update-Launcher-Status-Task-AU2004SP0801] Error while creating database connection. Please check the following for possible reasons of connection failure :
    1. Authentication failure
    2. Database configuration like uri are incorrectly configured
    3. Network connectivity issues between this application server and the database
    com.bladelogic.om.infra.app.bladmin.BlAdminException: Error while creating database connection. Please check the following for possible reasons of connection failure :
    1. Authentication failure
    2. Database configuration like uri are incorrectly configured
    3. Network connectivity issues between this application server and the database
    ...
    Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
    ...
     


    CAUSE:

    The default value for BootStrapConnectionPoolMaxSize of 5 is too low.


    SOLUTION:

    Since 8.6 all application server configuration settings are stored in the BladeLogic database.  Normal application server operation and using the blasadmin utility to configure the application server will therefore access the database to retrieve and update these settings as needed.  In 8.9.01 a new database connection pool was added for this access.  The default value of 5 is too low.  The recommended value is 200.  The below blasadmin command should be run on all application servers and the application server service should be restarted to pickup the new value:
     

    blasadmin -a set Database BootStrapConnectionPoolMaxSize 200
      


      

     


    Article Number:

    000141438


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles