Upgrep Failed With The Error ORA-00904. (Doc ID 2244880.1)

Last updated on MARCH 21, 2017

Applies to:

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

Symptoms

As part of Siebel upgrade process from 8.1.1.11 to IP 16, upgrep was started.

When it attempted to import "Prior Siebel Repository", repimexp utility failed with the error ORA-00904.
Here is a summary of imprep_ps.log file.

2017-02-23 15:00:09 D:\Siebel\8.1.1.11.0\ses\siebsrvr\bin\repimexp.exe /a I /g ENU /u sadmin /p ***** /c *****_DSN /D siebel /M y /R "Prior Siebel Repository" /F D:\Siebel\8.1.1.11.0\ses\dbsrvr\common\SIA\r2013.dat /l D:\Siebel\8.1.1.11.0\ses\siebsrvr\log\upgrep_dev_81111_20170223\output/imprep_ps.log /z 1000

...

2017-02-23 15:00:10 Found Signature of Repository:
2017-02-23 15:00:10 Signature: INTERNAL=, APP_VER=v8.2.2, DB_SCHEMA_VER=48, DB_MINOR_VER=33, DB_MAINT_VER=60, CUSTOMER_SCHEMA_VER=2
2017-02-23 15:00:10
2017-02-23 15:00:10 Importing file "D:\Siebel\8.1.1.11.0\ses\dbsrvr\common\SIA\r2013.dat".
2017-02-23 15:00:10 Importing table 0: S_ACCELERATOR ... imported 271 rows

...

2017-02-23 15:00:29 Importing table 12: S_APPLET_METH_MI ... imported 11045 rows
2017-02-23 15:00:30 SQL Statement:
select t.APPLET_DRG_DRP_FLG, t.APPLET_NAME, t.BUSOBJ_NAME, t.CONFLICT_ID, t.CREATED, t.CREATED_BY, t.DB_LAST_UPD, t.DB_LAST_UPD_SRC, t.INACTIVE_FLG, t.LAST_UPD, t.LAST_UPD_BY, t.MODIFICATION_NUM, t.REPOSITORY_ID, t.ROW_ID from siebel.S_APPLET_RX t
2017-02-23 15:00:30 [tp][ODBC Oracle driver][Oracle]ORA-00904: "T"."APPLET_NAME": invalid identifier

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