ONE Installer defaults to incorrect Oracle codeset WE8MSWIN1252 in v24.4.4

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

During a new installation of Automic Automation Engine version 24.4.4 using the ONE Installer, the suggested ODBC connection string for Oracle incorrectly defaults to WE8MSWIN1252.

Example of the incorrect proposed string: [ODBCVAR=NNJNIORO,DSN=AUTOMIC;UID=AUTOMIC;PWD=AUTOMIC;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8MSWIN1252,NLS_LENGTH_SEMANTICS=CHAR]

Environment

• Product: Automic Automation Engine
• Version: 24.4.4, 26.x.x.
• Database: Oracle
• Installer: ONE Installer

Cause

This issue is a confirmed defect (DE185116). For Automic Automation Engine version 24.x, the character set AL32UTF8 is mandatory How to configure NLS_NCHAR_CHARACTERSET and NLS_CHARACTER_SET in Automation Engine V 24.x. The installer incorrectly proposes the legacy WE8MSWIN1252 value, which can lead to data inconsistencies.

Resolution

A fix is scheduled for the following versions:

• Automic Automation.Engine 24.4.5 - TBA
• Automic Automation.Engine 26.1.0 - TBA

Workaround

During the installation process, manually update the ODBC connection properties to use the correct codeset and length semantics:

1. Select Advanced [2] when prompted for database connection properties.
2. In the ODBC connection string, change CODESET=WE8MSWIN1252 to CODESET=AL32UTF8.
3. Ensure NLS_LENGTH_SEMANTICS=CHAR is present in the string to avoid column length inconsistencies 

Corrected connection string example: [ODBCVAR=NNJNIORO,DSN=AUTOMIC;UID=AUTOMIC;PWD=AUTOMIC;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=AL32UTF8,NLS_LENGTH_SEMANTICS=CHAR]

Additional Information

Article title: How to register to Broadcom Software Product updates and Critical Alerts

https://knowledge.broadcom.com/external/article?articleId=133819