My Oracle Support Banner

Siebel DDLIMP Fails with Error DDLIMP-WRN-1074: Truncated non-unique index "S_CONTACT_REGION_U1_X" (truncated at column 38: EMAIL_ADDR) (Doc ID 2791647.1)

Last updated on OCTOBER 12, 2021

Applies to:

Siebel CRM - Version 21.3 and later
Information in this document applies to any platform.


When attempting to migrate a repository using Siebel Application Migration (SMA), the ddlimp step (logical/physical definitions synchronization) fails as
following in the target environment:

DDLIMP-WRN-1074: Truncated non-unique index "S_CONTACT_REGION_U1_X" (truncated at column 38: EMAIL_ADDR).
[Microsoft][SQL Server Native Client 11.0][SQL Server]The index 'S_CONTACT_REGION_U1_X' on table 'S_CONTACT' has 38 columns in the key list. The maximum limit for index key column list is 32.


The source and target environments are accessing MS Sql Server databases.

The issue can be reproduced at will with the following steps:
1. Start SMA in source environment
2. Start a migration plan previously created to migrate the repository with schema changes
3. All export tasks work in source environment, but the logical/physical schemas synchronization fails in the target environment.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.