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
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