APMSQL Connections could not be acquired from the underlying database! after applying HF84

Products

• CA Application Performance Management (APM / Wily / Introscope)
• DX Application Performance Management

Issue/Introduction

APMSQL is not starting up properly and the apmsqlserver.out shows following messages

Completed Starting APM SQL 
  SQL Error occured while establishing connection with APMSQL Connections could not be acquired from the underlying database!
org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: <host>:54321. Reason: Connection refused (Connection refused)
 SQLException: Connections could not be acquired from the underlying database!

 

Environment

Release : 10.7.0

Component :

Cause

This was not related to the HF84 installation but a pre-existing configuration error.

The authorization defined in the apmsql-server-jetty-config.xml was configured to use a token rather than a user id BUT the password property was incorrectly defined - type was not set - even though password is not used.

         <Set name="driverClass">org.teiid.jdbc.TeiidDriver</Set>
         <Set name="jdbcUrl">jdbc:teiid:apm_base@mm://<host>:54321</Set>
         <Set name="user"><password></Set>
         <Set name="password" type=""></Set>

Resolution

Corrected the structure of the apmsql-server-jetty-config.xml file to define the type as String

         <Set name="driverClass">org.teiid.jdbc.TeiidDriver</Set>
         <Set name="jdbcUrl">jdbc:teiid:apm_base@mm://myhostname:54321</Set>
         <Set name="user"><password></Set>
         <Set name="password" type="String"></Set>