AE fails to connect to PostgreSQL DB.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

When attempting to connect to a new database on postgres, the connection failed with the following error-

20220420/104458.156 - U00038091 Change application directory to 'D:\Automic\db\'.

20220420/104458.156 - U00038091 Change application directory to 'D:\Automic\db\'.

20220420/104458.172 - U00038091 Change application directory to '.\'.

20220420/104458.203 - U00003545 UCUDB: Opening database ...

20220420/104458.203 - U00029112 UCUDB - Length of the DB-History area: 100

20220420/104458.953 - U00003590 UCUDB - DB error: 'FATAL:  LDAP authentication failed for user "srvc_uc4_uc4rndev"

', '', '', ''

20220420/104458.953 - U00000001 NO DATA (end of file, invalid key, no message...)

20220420/104458.953 - U00000001 NO DATA (end of file, invalid key, no message...)

Application return code = 1

Environment

Release : 12.3.2

Component :

Resolution

The password for the database user contained a special character that the driver drops when passing the password to PostgreSQL DB.

Please change the password and excluded some special characters such as | @ and /.

Additional Information

There are known issues about special characters.

https://www.postgresql.org/message-id/trinity-6901c03f-0697-4493-bd86-779816915279-1368712107174%403capp-gmx-bs58