How to solve problem "DSRA0304E: XAException ERROR: prepared transactions are disabled" during Cloud Pak for Business Automation Business deployment while using PostgreSQL

Question

When you deploy a Workflow capability in Cloud Pak for Business Automation, and the database type you choose is PostgreSQL, you may experience that the Business Automation Workflow server pod can not be turned into 'Ready' status completely, and it throws XAException messages from the liberty server logs like below:

{"type":"liberty_message","host":"icp4adeploy-bawins1-baw-server-0.icp4adeploy-bawins1-baw-service-headless.cp4ba.svc.cluster.local","ibm_userDir":"\/opt\/ibm\/wlp\/usr\/","ibm_serverName":"defaultServer","message":"DSRA0304E: XAException occurred. XAException contents and details are: \nCaused by org.postgresql.util.PSQLException: ERROR: prepared transactions are disabled\n Hint: Set max_prepared_transactions to a nonzero value.\nThe error code is: 0\nThe SQL State is: 55000\n.","ibm_threadId":"000000a2","ibm_datetime":"2024-07-12T17:37:13.757+0000","ibm_messageId":"DSRA0304E","module":"com.ibm.ws.rsadapter.impl.WSRdbXaResourceImpl","loglevel":"ERROR","ibm_sequence":"1720805833757_0000000000304","ext_appName":"IBM_BPM_Teamworks","ext_thread":"Default Executor-thread-74"}

2024-07-12T17:37:13.758193137Z {"type":"liberty_message","host":"icp4adeploy-bawins1-baw-server-0.icp4adeploy-bawins1-baw-service-headless.cp4ba.svc.cluster.local","ibm_userDir":"\/opt\/ibm\/wlp\/usr\/","ibm_serverName":"defaultServer","message":"DSRA0302E: XAException occurred. Error code is: XAER_RMFAIL (-7). Exception is: Error preparing transaction. prepare xid={XidImpl: formatId(57415344), gtrid_length(36), bqual_length(54),\ndata(00000190a8053b410000000120147de4b58ffa7e7efe8d1bd633f764a99fa6ed73a78db900000190a8053b410000000120147de4b58ffa7e7efe8d1bd633f764a99fa6ed73a78db9000000010000000000000000000000000001)}","ibm_threadId":"000000a2","ibm_datetime":"2024-07-12T17:37:13.758+0000","ibm_messageId":"DSRA0302E","module":"com.ibm.ws.rsadapter.impl.WSRdbXaResourceImpl","loglevel":"ERROR","ibm_sequence":"1720805833758_0000000000305","ext_appName":"IBM_BPM_Teamworks","ext_thread":"Default Executor-thread-74"}

How to resolve the problem?