Postgres DB: JWP loops after wrong password is used on AWI login

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

An issue was found where every time when a wrong password is used, the JWP loops with the following error message:

U00045014 Exception 'org.postgresql.util.PSQLException: "ERROR: invalid byte sequence for encoding "UTF8": 0x00

So far it seems this occurs only when LDAP over SSL is used in conjunction with a PostgreSQL database.

 

Steps to reproduce (incl. expected/documented vs. actual behavior)

• On an AE system with PostgreSQL as database, configure LDAPS coupling.
• setup a LDAP coupled user
• enter a wrong password during login
  ==> check JWP log for error

 

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Cause

The LDAP over SSL interface returns a string which contains a NULL character which cannot be stored in PostgreSQL.

Resolution

The issue has been fixed with the following versions auf Automic Automation:

Automation.Engine 12.3.5 HF4 - available

Automation.Engine 12.3.6 - available