Ddlsync failing with error DDLIMP-ERR-1071: Unable to build ddl statement "rebuild test" ((Table Rebuild Failed) Column: 'NAME_CI' with Siebel DB2 Z/OS
Last updated on MARCH 02, 2017
Applies to:Siebel CRM - Version 220.127.116.11  and later
Information in this document applies to any platform.
Preparing to upgrade Siebel with DB2 Z/OS from 18.104.22.168 to Siebel 15.5.
The storage control file was extracted in order to run the ddlsync before starting the upgrade, to ensure that logical and physical schemas are synchronized.
The ddlsync fails as following:
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).
2016-02-03 20:28:55 writeExecDDL error (UTLDbDdlTblRebuildTest).
This happens while processing table T_DETAIL, but a similar issue also occurred in a previous execution while processing S_MASTER_POSTN.
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