Monday, December 29, 2014

Siebel Database upgrade from 8.1.1.0 to 8.1.1.11 Fails - upgrep

Environment:
OS - Windows 2012
Siebel - 8.1.1.11 SIA
Upgrading from - 8.1.1.0 SEA
Database - Oracle 11.2.0.3

Issue:
While running the 'upgrep' process in the Database configuration for the upgrade from 8.1.1.0 SEA to 8.1.1.11 SIA, the process fails at step 27 with the following error:

[Item 27]
Status = Error
Item Name = File Execute Entry 26
SecondaryLanUpgrade = 3611514Unable to get schema version.Please verify that you have specified the correct Table Owner (siebel) and you have select access to the S_APP_VER table.

Upon checking the database permissions, everything looked okay and the user SIEBEL did have all the needed privileges on the table.

Solution:
The workaround is to replace the number in the master_upgrep_dev_81110 file by the installed languages :

Repeat For Language = 3611519
replace with
Repeat For Language = DEU,ENU for example.

If  the unique language installed is ENU:
Repeat For Language = ENU

Re-execute the upgrade wizard from siebsrvr/bin/master_*.ucf file.

This is a known product bug documented in 'Bug 18614385 - DATABASE CONFIGURATION WIZARD FAILS BECAUSE OF INCORRECT LANGUAGE 0ENU'

Oracle support document reference - 1668300.1

No comments:

Post a Comment