Symptoms

OA platform has been upgraded to 7.x version. Billing tasks started to fail with:

Execution Failed: Parallels Operations Automation error #error_code #-1, extype_id #-1, module_id #, javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection
org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection.

Cause

Incorrect permissions (database user or access level) specified in the Postgresql host-based access file /var/lib/pgsql/9.6/data/pg_hba.conf on the Billing database server.

Resolution

Obtain actual BA database credentials from the /usr/local/pem/wildfly-10.1.0.Final/standalone/configuration/standalone-full.xml file on OA Management Node (.../standalone-full-ha.xml in case of 7.3 platform version) and modify the .../pg_hba.conf file on the Billing database server.

For example, set the trust level:

# TYPE  DATABASE        USER            CIDR-ADDRESS            METHOD
...
  host    pba            all           192.168.10.0/24          trust

where 192.168.10.0/24 range includes OA Management Node IP address.

Postgresql service should be restarted to apply these modifications.

Internal content