Last updated on DECEMBER 10, 2015
Applies to:Siebel System Software - Version 8.0  and later
Siebel CRM - Version 8.0  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).
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
Million Knowledge Articles and hundreds of Community platforms