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.