Process automation unable to connect to database.

Products

• CA Process Automation Base

Issue/Introduction

Hi,

DB connectivity is keep on fluctuating. Initially first-time installation of application at the DB details screen/page DB test connection was successful. but when we have tried to reinstall the application, we received an error.

As per DB team, this error is from application and while investigation there is not connection request found in DB team logs.

 

error: Test not successful, please check database setting. 

 

Environment

Release : 4.3

Cause

Network connectivity issue through load balance server settings. 

Resolution

#  Re run the CA Process Automation setup wizard. 
# Re define  Database server details with Server node name instead of Load balancer server details.