Search Engine: Elastic

Article ID: 132095, created on Jan 19, 2018, last review on Jan 19, 2018

  • Applies to:
  • Business Automation

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.

caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 198398b282069eaf2d94a6af87dcb3ff

Email subscription for changes to this article
Save as PDF