Showing posts with label Siebel database upgrade. Show all posts
Showing posts with label Siebel database upgrade. Show all posts

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