Variables not sorted correctly in AWI compared to PREP_PROCESS_VAR

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The sorting in AWI does not respect the NLS_SORT defined at the DB Session Logon level, so the Vara sorting does not match the PREP_PROCESS_VAR sorting.
Example: In AWI, the variable #_# Name is displayed as first entry, whereas in the PREP_PROCESS_VAR the first entry is ##_NAME

Actual behavior: AWI performs a Javascript sorting that does not match what sorting has been defined at DB/User level.
Expected behavior: When displaying a Vara, the sorting should match the same as in PREP_PROCESS_VARA which is done taking the NLS_SORT variable defined in the connection string or at the Session Level of the DB user.

Environment

Release : 21.x

Cause

Defect

Resolution

Update to a fix version listed below or a newer version if available.

Fix version:
Component(s): Automatic.Web.Interface (AWI)
Will be fixed in Automation.Engine 21.0.9 - Planned release late December 2023

Additional Information

Bug ID: AE-33003

Public Description: A problem has been where variables were not sorted correctly in AWI