DB load throws an error message "Database is set to a non-supported collation"

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

When running ucybdbld program it throws an error message:

U00037180 Collation in Database: 'Latin1_General_100_CI_AI_SC_UTF8'.
U00038320 Database is set to a non-supported collation 'Latin1_General_100_CI_AI_SC_UTF8'.

Environment

Version 24.x

Component: Automic Workload Automation

Cause

Non-supported collation.

Resolution

Use the supported collation e.g. Latin1_General_100_CI_AS_SC_UTF8