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 (Doc ID 2120809.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.1.1.10 [23021] and later
Information in this document applies to any platform.

Symptoms

Preparing to upgrade Siebel with DB2 Z/OS from 8.1.1.10 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.

Cause

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