Upgrep Failed With The Error ORA-00904.
(Doc ID 2244880.1)
Last updated on FEBRUARY 03, 2025
Applies to:
Siebel CRM - Version 16.0 [IP2016] and laterInformation 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 |