JR63841: PROCESS FEDERATION SERVER FAILS TO CONNECT TO A POSTGRESQL DATABASE REFERENCED BY JDBC_URL IN ICP4BA CR

APAR status

• Closed as program error.

Error description

• When specifying a PostgreSQL datasource for a Business
  Automation Workflow
  server on ICP4BA using the database.jdbc_url attribute of the
  ICP4BA Custom Resource, Process Federation Server fails to
  access the database and reports multiple errors similar to the
  following in its logs:
  
  [2021-06-15T02:24:25.370+0000] 00000026
  com.ibm.wbimonitor.partitioning.impl.agent.PartitioningAgent E
  CWMFS5027E: Agent for xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx:
  Attempting to re-initialize due to a severe error:
   com.ibm.wbimonitor.persistence.base.api.MonitorPersistenceExcep
  tion: java.sql.SQLException: Connection to localhost:50000
  refused. Check that the hostname and port are correct and that
  the postmaster is accepting TCP/IP connections. DSRA0010E: SQL
  State = 08001, Error Code = 0
    Caused By: java.sql.SQLException: Connection to
  localhost:50000 refused. Check that the hostname and port are
  correct and that the postmaster is accepting TCP/IP connections.
  DSRA0010E: SQL State = 08001, Error Code = 0
  
  PRODUCTS AFFECTED
  IBM Cloud Pak for Business Automation
  

Local fix

Problem summary

• No additional information is available.
  

Problem conclusion

• A fix is available or will be available that ensures that
  Process Federation Server properly connect to a PostgreSQL
  database for which connection information is solely provided
  using the database.jdbc_url attribute of the ICP4BE Custom
  Resource.
  

Temporary fix

• Not applicable.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  CLOUD PAK FOR A

• Fixed component ID

  5737I2300

Applicable component levels