Siebel - blank page after login

Issue

Since applying update 20.9, when attempting to log into Siebel application with Browser Scripts in a reverse proxy server environment, the page is blank. A Brower refresh was required to get to the Home Screen. 

Solution

The bug is fixed in Siebel 21.4. To work around the issue for versions before Siebel 21.4, there are two options: 

1. Disable the browser scripts 

OR 

2. Turn on HTTP Keepalives on the Proxy web server  

Error “Codepage {0} is not supported.(SBL-JCA-00328)”

Codepage {0} message on tomcat catalina.out log file is due to encoding issue.

Siebel Error message usually appears like below

<ErrMsg>Codepage {0} is not supported.(SBL-JCA-00328)</ErrMsg> 

Solution: 

Step 1: export JAVA_OPTS to environment variable. (see below)

export JAVA_OPTS="-Dfile.encoding=UTF-8" 

Step 2: Restart Server (Application container)

Design Repository Migration has been deprecated as of Siebel 19.3

Design Repository Migration won't be available from Siebel 19.3 update.
For more details:
Refer: 2531821.1

Oracle Product Management / Oracle Engineering removed the Design Repository migration from Siebel 19.3 onwards as there will only be one Design Repository. Bug 29178365 - REMOVE THE DESIGN REPOSITORY MIGRATION SERVICE FROM MIGRATION UI

Enabling breadcrumb navigation on Siebel Simplified UI / Synergy Theme

Synergy Theme has been doen't have breadcrumb navigation (It is hidden),
Eventhough customers loved this theme,they demands breadcrumb.
Here is the qucik code snippets to enable those.

Js (Add below code to postload)
---------------------

var elm = $("#s_tb").eq(0)
$("#s_tb").eq(0).remove();
$("#_swescrnbar").after(elm);

CSS
------
#siebui-threadbar .siebui-crumb {
    color: #ffffff;
    font-weight: 300;
}

#siebui-threadbar>li a {
    color: #ffffff;
    text-decoration: underline;
}

Issues Siebel 2018 Upgrade

After upgrade, we encountered some issues with attachment / Document Server.

-> Any attachment upload is successful
-> able to download any attachment, which is uploaded before upgrade
-> unable to download any attachment, which is uploaded after upgrade

OM  Logs

SBL-SVC-00155: No file has been attached to this record. Please attach a file.
SBL-UIF-00230: The file %1 could not be found on any specified file system.

FSMSrvr Log

IDS : FLAGS [1] : REQID [1-B1AW-7B] : SRBSESSID [e1450298200002MI_PRD_SS03] : SRMCONNID [15] 
SRC : SRC_ID [] : SRC_KEY [] 
DEST : ROUTE_ID [FSMSrvr] : ROUTE_KEY [] : ROUTE_SRVR [] : LANG_CODE [ENU] : CODE_PAGE [1200] : LANG_IND [0] : CLIENTPROC_ID [18517] 

FSMLog FSMInfo 3 0000024f5ba853c2:0 2018-09-24 09:47:58 FSMSrvr getting thrctx



on further investigation, we found that new documents on siebel file system is having some naming issue.

usually Siebel attachment will be saved like tablename_rowid_revision.SAF
but after upgrade we noticed that all new files missing revision value.


So new files are like S_DOC_CORR_1-23EUN9_.SAF

On further ticket, oracle confirmed that there is a Bug 26452153 : FILE_REV_NUM IS 0 DURING FILE UPLOAD 

it is found that, In the bug there was corruption in NEXT_FILE_SUFFIX column in table S_SSA_ID. 

on production, NEXT_FILE_SUFFIX is having a value "ActivationList" and all lower environment is a 5 char value. (ex: 4DFGT)

we replaced it with a sql update and all functionality started working. 

Server 500 Error on Siebel Servers (IP17, Siebel 2018)

Siebel Servers or basically Apache/Tomacat server have issues with "." or Space on your cookie values.

So if you are getting any 500 error, when you check the browser console, please make sure that you are not sending any custom cookies.

The below documentation is applicable for old versions of Siebel and have spaces in their sample cookie. You need to remove those Space and  leading "dot" to resolve this issue.
 
https://docs.oracle.com/cd/B40099_02/books/PortalFrame/PortalFrameTxNBS3.html

tmpCookie.SetType ('My_Test_Cookie');

tmpCookie.SetValue ('Cookie Value for My_Test_Cookie');

tmpCookie.SetProperty ('Domain', '.siebel.com');  => to siebel.com

Siebel CRM on Oracle Cloud

An interesting video describing Siebel SRM and its very basic set ups.