My Oracle Support Banner

Apply/ ddlsynch On S_CONTACT Table Fails - DDLIMP-ERR-1071: Unable to build ddl statement "modify col" (Cannot modify a function based Column 'X_EMAIL_ADDR_CI'). (Doc ID 1924170.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 8.1.1.11 [IP2013] and later
Information in this document applies to any platform.
Checked for Relevance on 09-Feb-2016

Symptoms

We have a problem with Apply / DDLSync in our environments.

apply on S_CONTACT table is failing with the following error in our environments.

we tried both full DDLsync and also apply on table from tools.

- - -
...
2014-09-04 18:09:17 Merging table S_CONTACT ...

2014-09-04 18:09:17 DDLIMP-ERR-1071: Unable to build ddl statement "modify col" (Cannot modify a function based Column 'X_EMAIL_ADDR_CI').

2014-09-04 18:09:17 writeExecDDL error (UTLDbDdlColModify).

2014-09-04 18:09:17 Error in MainFunction (UTLDbDdlDbMerge).

2014-09-04 18:09:17 Error in Main function...

2014-09-04 18:09:17 (logapi.cpp (184) err=1 sys=0) SBL-GEN-00001: (logapi.cpp: 184) error code = 1, system error = 0, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)
- - -

when we tried to drop X_EMAIL_ADDR_CI coloumn in our TEST environment apply worked successfully for that occurrence and fails again if we try to apply again.

Cause

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
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.