users with long names cannot login to WCC

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - System Agent (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent
• CA Workload Automation AE

Issue/Introduction

some users can login to wcc without issue but some cannot.

The following is seen in the wcc logs:

INFO   | jvm 1    | 2020/10/27 08:58:45 |   595685 | Internal Exception: java.sql.BatchUpdateException: ORA-12899: value too large for column "WCCSITDBO"."CFG_USER"."ID" (actual: 66, maximum: 64)
INFO   | jvm 1    | 2020/10/27 08:58:45 |   595685 | 
INFO   | jvm 1    | 2020/10/27 08:58:45 |   595685 | Error Code: 12899

 

Environment

Release : 11.4

Component : WORKLOAD CONTROL CENTER

Resolution

We have confirmed with our sustaining eng. team that the length supported for
username in the CFG_USER table and WCC code is currently 64 characters.
At this time the workaround for you would be to use a username with 64 or less characters.
Product mgmt will discuss internally if increasing the length of the allowable usernames
is something they will entertain as an enhancement request for some future release of WCC.