Siebel Open UI >  Blank Screen After Login Using Siebel Open UI After Upgrade To 8.1.1.11 or Later Versions

Blank Screen After Login Using Siebel Open UI After Upgrade To 8.1.1.11 or Later Versions

After upgrade to Siebel 8.1.1.11 from Siebel 8.1.1.10, Incremental Repository Merge(IRM) was performed.After a Full Compile of the upgrade repository the HI object manager works fine,
but when using the OpenUI enabled object manager browser console errors are noticed after the Login Page and the screen remains blank:

Message: Object expected
Line: 38
Char: 799
Code: 0
URI: http://siebel_url/echannelcgui_enu/23030/scripts/siebel/navctrlmngr.js?_scb=

The application worked fine using OpenUI object manager in Siebel 8.1.1.10.

CAUSE
The root cause was the missing records in the S_UI_* tables.

When compared with the sample db, it was found that in the S_UI_* table in the server DB had much less (almost no) records.

SOLUTION
The issue was fixed by repeating the failed step OUIManifestRep of upgrep and then applying the steps to modify the repository_id to hold the id of the new repository.

The following command was used to re-insert the records:

<Siebel_Root>\siebsrvr\bin\dataimp.exe /u SADMIN /p ****** /c SBA_81_DSN /d SIEBEL /f <Siebel_Root>\dbsrvr/common/OUIManifestRep.dat /h Log /w n /q 100 /e y /l <Siebel_Root>\siebsrvr\log\upgrep_dev_81110\output/OUIManifestRep-new.log /A 1

and these commands to fix the repository_id of the inserted records:

UPDATE S_UI_EXPR SET REPOSITORY_ID=(SELECT ROW_ID FROM S_REPOSITORY WHERE NAME='Siebel Repository') WHERE REPOSITORY_ID='0CR-V7O-1'
UPDATE S_UI_FILE SET REPOSITORY_ID=(SELECT ROW_ID FROM S_REPOSITORY WHERE NAME='Siebel Repository') WHERE REPOSITORY_ID='0CR-V7O-1'
UPDATE S_UI_OBJECT SET REPOSITORY_ID=(SELECT ROW_ID FROM S_REPOSITORY WHERE NAME='Siebel Repository') WHERE REPOSITORY_ID='0CR-V7O-1'
UPDATE S_UI_OBJ_EXPR SET REPOSITORY_ID=(SELECT ROW_ID FROM S_REPOSITORY WHERE NAME='Siebel Repository') WHERE REPOSITORY_ID='0CR-V7O-1'
UPDATE S_UI_OBJ_EXP_FL SET REPOSITORY_ID=(SELECT ROW_ID FROM S_REPOSITORY WHERE NAME='Siebel Repository') WHERE REPOSITORY_ID='0CR-V7O-1'

'0CR-V7O-1' is the seeded REPOSITORY_ID and needs to be updated to reflect the Repository id of the environment

After this step, blank screen issue in Siebel Open UI v8.1.1.11 was resolved.

Few situations the command may fail with error:

[DataDirect][ODBC Oracle driver][Oracle]ORA-00001: unique constraint (SIEBEL.S_UI_EXPR_P1) violated

In this case , truncate the tables above before following the steps. Open UI Customizations need to be recreated from User Interface.