LDAP User cannot login | Invalid value in Boolean field
search cancel

LDAP User cannot login | Invalid value in Boolean field

book

Article ID: 249177

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic One Automation

Issue/Introduction

An issue was found where a user would not be able to login via LDAP after the upgrade to V21.  This has also been seen on 12.3

 

A forced trace would be created and the following error message could be found in the WP logs:

 

U00003518 UCUDB: Invalid value in Boolean field 'USR_Active'

 

 

Environment

Release : 21.0.2

Component : AUTOMATION ENGINE

Cause

Software Bug

Resolution

The bug was found and will be fixed with V21.0.5 which is scheduled for early 2023.

Additional Information

As a workaround you can use LDAP Authentication via the JWP: https://docs.automic.com/documentation/WEBHELP/English/all/components/DOCU/21.0.4/Automic%20Automation%20Guides/Content/AWA/Admin/admin_LDAPConnectionSetup.htm

This is done by adding or updating the VERSION keyword to 2 in the UC_LDAP_* variable.  

For example:

The default for VERSION is 1 which uses a C Module to authenticate against LDAP.  Setting it to 2 will use the JWP which uses Java to authenticate instead. 

This should be a low-risk setting to change and does not require a restart of any components, but we will always recommend testing it in a non-production environment first before updating production.