8.2.2.4 Upgrep Throwing SQL Not Found Errors (Doc ID 1945157.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

On : 8.2.2.4.11 [IP2013] version, Upgrade

When attempting to run the upgrade from V8.0.0.3 to V8.2.2.4,
the following error occurs.

ERROR
-----------------------


Trace    TracingInfo    3    000000025466292f:0    2014-11-14 10:23:19    CFG Entry (Repeat For Language=ld.so.1: sqlgenval: fatal: relocation error: file /sia82/dev/siebsrvr/bin/sqlgenval: symbol Mw___uuid_DependancyNode: referenced symbol not foundKilled)
Trace    TracingInfo    3    000000025466292f:0    2014-11-14 10:23:19    CFG Entry (Language=ENU)

-----

UpgradeLog UpgradeInfo 3 000000025466292f:0 2014-11-14 10:37:49 Data source Name:(SBA_82_DEV_DSN)
UpgradeLog UpgradeInfo 3 000000025466292f:0 2014-11-14 10:37:49 Status Message (Executing SQL statements in file /sia82/dev/dbsrvr/oracle/upgrade/v8_0/drop_db_func_proc.sql ...)
Trace Trace 3 000000025466292f:0 2014-11-14 10:37:49 Unable to open file 'drop_db_func_proc.sql'.
UpgradeLog UpgradeError 1 000000025466292f:0 2014-11-14 10:37:49 Error in function UTLStartSqlStmtAPI
UpgradeLog UpgradeError 1 000000025466292f:0 2014-11-14 10:37:49 Error executing statement () in file (drop_db_func_proc.sql).
UpgradeLog UpgradeInfo 3 000000025466292f:0 2014-11-14 10:37:49 Close database connection.
UpgradeLog UpgradeError 1 000000025466292f:0 2014-11-14 10:37:49 Execute SQL file action failed.
UpgradeLog UpgradeError 1 000000025466292f:0 2014-11-14 10:37:49 Error executing action (Drop database level functions and procedures).
UpgradeLog UpgradeInfo 3 000000025466292f:0 2014-11-14 10:37:49 Status Message (Errors encountered)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup upgrade environment
2. Run UpgRep
3. The above errors are displayed after completing the DB configuration wizard and then by invoking upgrade process.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, upgrade is halted.

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