Siebel Upgrade In Production Test Environment Failed - ORA-22858 (Doc ID 1574479.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.

Goal

During Production upgrade, you are encountering the following error during table creation.

2013-07-30 20:52:11 Merging table S_AUDIT_ITEM ... 2013-07-30 20:52:11 Modifying column FIELD_NAME ... 0.078s 2013-07-30 20:52:11 SQL Statement:
alter table S_AUDIT_ITEM modify
"NEW_VAL" clob 2013-07-30 20:52:11 [tp][ODBC Oracle driver][Oracle]ORA-22858: invalid alteration of datatype

2013-07-30 20:52:11 2013-07-30 20:52:11 S1000: [tp][ODBC Oracle driver][Oracle]ORA-22858: invalid alteration of datatype 2013-07-30 20:52:11 2013-07-30 20:52:11 alter table S_AUDIT_ITEM modify 2013-07-30 20:52:11 "NEW_VAL" clob 2013-07-30 20:52:11 2013-07-30 20:52:11 ; 2013-07-30 20:52:11 writeExecDDL error (UTLOdbcExecDirectDDL pDDLSql). 2013-07-30 20:52:11 writeExecDDL error (UTLDbDdlColModify). 2013-07-30 20:52:11 Error in MainFunction (UTLDbDdlDbMerge). 2013-07-30 20:52:11 Error in Main function... 2013-07-30 20:52:11 (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)


Basically the schema.ddl file has S_AUDIT_ITEM tables defined for columns NEW_VAL & OLD_VAL as follows:
Column 30 = NEW_VAL WLONGVARCHAR
Column 31 = OLD_VAL WLONGVARCHAR

But the Dev & Production Test DB’s have them defined as varchar2(4000)

You would like to know if you can manually update the schema.ddl file for table S_AUDIT_ITEM as follows & run the upgrade.

Column 30 = NEW_VAL WVARCHAR(4000)
Column 31 = OLD_VAL WVARCHAR(4000)
 

Solution

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