search cancel

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

book

Article ID: 212375

calendar_today

Updated On:

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)
reproduction on DepMan environment (Application Provisioning)

  • 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

 

Cause

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

Environment

Release : 12.3

Component : AUTOMATION ENGINE

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