My Oracle Support Banner

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

Last updated on MARCH 01, 2019

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

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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.