Warning The maximum key length for a clustered index is 900 bytes during UTF8 PCK execution

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

UTF8 Migration Tool and DB Load create a  clustered Index with a size that is not supported by MS SQL.

Hence, when launching the UTF8 migration pack, the following warning is encountered:

Warning! The maximum key length for a clustered index is 900 bytes. The index 'PK_CERT' has maximum length of 1024 bytes. For some combination of large values, the insert/update operation will fail.
The Index PK_CERT of UC_CERT is based on CERT_ID (varchar(1024) ) and is a clustered index.

Environment

Automation Engine 21.x or 24.x with MS SQL Server as database.

Cause

DE173973: wrong definition of the index PK_CERT as it was too big to be clustered

Resolution

Workaround:

The table definition of the source system contains this wrong definition of the index, so the following queries need to be run on the source database:

ALTER TABLE UC_CERT DROP CONSTRAINT PK_CERT;
ALTER TABLE UC_CERT ADD  CONSTRAINT PK_CERT PRIMARY KEY NONCLUSTERED (CERT_ID);

After this change the UTF8 migration pack will not print this warning anymore.

Solution:

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

Fix version:
Component(s): Automation Engine
Automation.Engine 24.4.2 - Planned release October 2025

Additional Information

The database schema was updated on version 24.4.2 with the correct non-clustered index for PK_CERT.