Siebel Upgrade Failing with ORA-00942: table or view does not exist (Doc ID 1921516.1)

Last updated on MARCH 02, 2017

Applies to:

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

Goal

Siebel upgrade - Synch Physical And Logical Indexes Step (Upgphys) the following error is shown in the syncidx2.log file:

2014-08-21 12:18:40 Running SQL statements against the database...
2014-08-21 12:18:40    Merging   table                   CX_AD_HOUSE_MEM ...  
2014-08-21 12:18:40    Merging   table                   CX_AD_SRPRV_INF ...  
2014-08-21 12:18:40    Merging   table                   CX_ADD_MED_INFO ...  
2014-08-21 12:18:40    Merging   table                   CX_ADD_OTHR_INF ...  
2014-08-21 12:18:40 SQL Statement:
create unique index EIM_AC_RSRC_U1 on EIM_AC_RSRC
("IF_ROW_BATCH_NUM", "ROW_ID")
tablespace SIEBEL_X
2014-08-21 12:18:40 [tp][ODBC Oracle driver][Oracle]ORA-00942: table or view does not exist

 

Note: Siebel upgrade from 7.8 to 8.1 version

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