SQL CONN object's username field is limited in length on AWI but not on UI
book
Article ID: 84611
calendar_today
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
Error Message : "The maximum length is 20 characters"
The field validation in the Automic Web Interface (AWI) does not allow users to specify values for the username in SQL CONN login longer than 20 characters.
Cause
Cause type: Other Root Cause: Outdated field validation for SQL CONN login in AWI.
Environment
Release: 12.0, 12.1, 12.2 Component: AUTOMIC WEB INTERFACE
Resolution
Update to a fix version listed below or a newer version if available.
The issue was found and fixed with Automic.Web.Interface 12.0.4, 12.1.1 in UI (Released in Jan 2018). Fixes will also be applied to the upcoming minor 12.2.0 planned release on June 19th 2018. The Packages are available for download at the Automic-Support-Zone (https://support.automic.com).
Fix Status: In Progress
Fix Version(s): Automic Web Interface 12.2.0 – Available Automic Web Interface 12.1.1 – Available Automic Web Interface 12.0.4 – Available
Additional Information
Workaround : Create and edit connection objects for SQL in Java UI instead of the AWI.