ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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 confirmed to be a bug and will be fixed with a future service pack for Automation Engine V12.3 .