CIAI Error DDLIMP-ERR-1071 while running DDLSYNC (Doc ID 793083.1)

Last updated on DECEMBER 10, 2015

Applies to:

Siebel System Software - Version 8.0 [20405] and later
Siebel CRM - Version 8.0 [20405] and later
Information in this document applies to any platform.
The behavior occurs on Siebel 8.0 or 8.1.1 CIAI enabled environments, SBA or SIA, with Siebel Database implemented in IBM DB2 for LUW or IBM DB2 for z/OS
***Checked for relevance on 04-Oct-2013***
***Checked for relevance on 10-Dec-2015***


During the execution of DDLSYNC process (which can take place as part of a Siebel Upgrade, Incremental Repository Merge, IRM or just Repository Migration/ Synchronization ),
the ddlimp utility that should generate the DDL/ DML meant to synchronize logical and physical Siebel schema stops with the following error if one of the tables has a CIAI enabled column:

DDLIMP-ERR-1071: Unable to build ddl statement "rebuild test" ((Table Rebuild Failed) Column: 'NAME_CI' in the input file is Function based and Column in the database is not Function based).

Or just:

DDLIMP-ERR-1071: Unable to build ddl statement "modify col" (Cannot modify a function based Column 'NAME_CI').




On Siebel CRM 15.x, the out of the box Siebel schema has at least two columns defined as such:




Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms