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.

Clib.System function fails in Solaris 11

Clib.System functions are commonly used to invoke system process or batch/shell files etc. This function is having some compatibility issues with Solaris 11 or above.

When you migrate Clib.system is returning some error codes like 32512 or 9.
This is because of Siebel is referring some 64 bit libraries instead of 32 bit.

To over come this issue kindly follow below steps:

1. Make a backup copy of $SIEBEL_ROOT/bin/siebmtshw.

2. Edit siebmtshw file

3. Change LD_PRELOAD to LD_PRELOAD_32

4. export LD_PRELOAD_32

5. Save the file

6. Take clean bounce of siebel services and a machine bounce as well.

By this way the library would be preloaded for 32-bit binaries

for more information please refer:
Doc ID 2193193.1
Doc ID 2149311.1