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.

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

View PR not working in IP 2014 ?

IP 2014 has a problem with its view PR. View PR cannot work alone :)

Oracle support web has already given a workaround for this issue.

Here is the solution part. 

For this matter a defect was created: BUG 23016729 - SIEBEL OPEN UI VIEW PR DOES NOT WORK WITHOUT A SPECIFIC PM

Workaround:

The PR the PM it is called, according to the documentation and if the PM is called, a PM should exist for this PR.
Life Cycle of a Physical Renderer: https://docs.oracle.com/cd/E14004_01/books/config_open_ui/architecture13.html#wp1246021

Added a PM along with the PR and the view loaded properly, with no errors in the browser console log.

Steps
----------------------
1. Copied the Java Script file EIMViewPR.js in SCRIPTS/siebel/custom
2. Login into Siebel Application
3. Added the file through Manifest Administration Screen
4. Log out of Siebel Application
5. Login again in Siebel Application
6. Go to Site Maps > Query for EIM
7. Go to EIM Tables screen

8. Created a Java Script file EIMViewPM.js in SCRIPTS/siebel/custom
9. Login again into Siebel Application and added the file in the Manifest Screen
10. Go to Site Maps > Query for EIM > Go to EIM Tables screen

Expected results
----------------------
The application should work properly.

Actual results
----------------------
The application is loaded properly, no errors in the browser console log

For More information Check doc ID: 2122937.1

Log In Undefined issue in Siebel Open UI

In some of our environment, we noticed that Login button is showing as Login Undefined.

Solution to this problem.
From support web

1. On "CC Login Page (Login Only)', locate the "LoginButton".
2. Remove the Caption String Override.
3. Open UI script need to have nothing but HTML code in the caption. Otherwise, it will returns "Undefined" condition.

This did not worked for me due to some reason. The alternate way I used is by editing LoginSWT.

<script language="javascript" src="23030/scripts/3rdParty/jquery.js?_scb="></script>

<script>

$(document).ready(function(){

            $(".loginButton a").text("Login");

     });

</script>​

started working perfectly ;-)

Siebel UI Innovations

Here is some amazing OpenUI experiments. 

is it windows 8?? no its siebel 

1. 

2. 

3.

4. 

5. 

6.

7. 

Siebel Open UI - How to fix Form applet display issue in Chrome

Open UI form applets have some issue, when it rendering in Google Chrome.The controls are overlapped as shown below.

Solutions
Fix without JS
-------------
Open a CSS file your application referring paste the below css

td {
    border: 1px solid transparent;
}

clear the cache and try :-)

-------------------------------------------------------------------------------------
Fix with JS (as per oracle doc)
As per oracle technical document we can fix this issue with a piece of code

if (typeof(SiebelAppFacade.ChromeSpaceFix) == "undefined") { Namespace('SiebelAppFacade.ChromeSpaceFix'); (function() { SiebelApp.EventManager.addListner("postload", ChromeTdSpaceFix, this); function ChromeTdSpaceFix() { try { $("#_svf0 table.GridBack").find("tr").children("td").each(function(index) { var regex = /(height)(\s*):(\s*)([^;]*)/, el = $(this), st = el.attr("style"), match = regex.exec(st); if (match && Number(match[4]) && el.is(":empty") && el.siblings().length != el.siblings(":empty").length) { st = st.replace("height", "x­height"); el.attr("style", st + "height:" + Number(match[4]) + "px;"); } }); } catch (error) { // Nothing to do. } } }()); }

Now you can add this file as Platform common (8.1.1.9 & 8.1.1.10) or Application -> common as (8.1.1.11)
you can see the above fix from here

Siebel OpenUI : Calender Issues

Siebel OpenUI : Calender Issues

Siebel OpenUI currently not supporting SI Classes and Applets referring to that type. That is why Salutation applets are shown with a "question mark". Open UI will not render these classes of applet.
Calender functionality is one of the main features of Siebel. Many Customers are using this feature to schedule their activities.In Siebel we have two kinds of Calenders. HI calender and SI type. Normally in home pages you can see SI calenders and that will not work in OpenUI. Even though OpenUI render this applets, that doesn't work properly.  Siebel Non OpenUI version needs SI applets in its home page. So we need to toggle these two applets in between OpenUI and Non OpenUI.

In order to do that, we can use Personalization.

In the home page view you can Include both Calenders. Now got to Administration- Personalization -> Applets.
Create two new records for two applets (HI & SI)

To display in HI: GetProfileAttr("IsOpenUI") < 1 OR GetProfileAttr("IsOpenUI") IS NULL
To display in OUI: GetProfileAttr("IsOpenUI") > 0


GetProfileAttr("IsOpenUI") will be 1 in OpenUI applications.

How to set your custom theme as Default theme

In Siebel Open UI, user can change theme from their user preferences.  If they did not choose any thing a default theme will get loaded. By default that is "Gray Tab".

Suppose you created a new theme called "Golden Tab" and you have to make it by default, Otherwise we have to force our clients to change their theme from their user preference and that is not recommended.
You can change this thing by using some tool level change.

In order to do that please follow the steps.


1. Using Siebel Tools, navigate to "User Preferences" BC.
2. Update the calculated value for field "Behavior/DefaultTheme" to "<custom theme>"
3. Update the Predefault value for field "Behavior/DefaultTheme" to "<custom theme>"
4. Compile the changes and re-test the behavior

You will need to remove the user pref file (spf) file to make the changes take effect.

GetService and theApplication() are Not Working In Browser Script In Siebel 8.1.1.11 (SIA)

GetService and theApplication() are Not Working In Browser Script In Siebel 8.1.1.11 (SIA)

SOLUTION

Engineering Team is currently working on fixing these issues. In the mean while you can use the below work around.

The work around requires changing a standard .js file from the Siebel Client framework.

Files to be modified: $siebsrvr_location$\webmaster\siebel_build\scripts\applicationshadow.js

Steps to apply the fix

 1. Replace the function theApplication() implementation in applicationshadow.js with the below change.

Existing implementation of the function theApplication()

function theApplication ()

{

   if ( App() == null )

       return null;

    

   if(SiebelAppFacade != undefined && SiebelAppFacade.InterfaceSI != undefined && SiebelAppFacade.InterfaceSI.App != undefined)

       return App().GetShadow();

   else

       return App().shadow;

 

}



Implementation with Fix

function theApplication ()

{

   if ( App() == null )

       return null;

    

   if (IsOpenUI())

       return App().GetShadow();

   else

       return App().shadow;

 

}

2. Replace the function SWEAlert () implementation in applicationshadow.js with the below change

Existing implementation of the function SWEAlert ()

function JSSApplicationShadow_SWEAlert (text)

{

   if (typeof (top._swescript) != "undefined")

   {

      top._swescript.SWEAlert (text);

   }

}

Implementation with Fix

function JSSApplicationShadow_SWEAlert (text)

{

   if (IsOpenUI())

   {

     window.SWEAlert (text);

   }

   else if (typeof (top._swescript) != "undefined")

   {

      top._swescript.SWEAlert (text);

   }

}

3. Replace the function JSSApplicationShadow () implementation in applicationshadow.js with the below change
Existing implementation of the function JSSApplicationShadow()

function JSSApplicationShadow (application)
{
   if (application != null)
   {
      this._application = application;
      application.shadow = this;
      this._application.SeblTrace(2,"JSSApplicationShadow Initialized");
   }
  
   if(!IsOpenUI())
   {
        this.swescriptFrame = top._swescript;

   }
}

Implementation with Fix

function JSSApplicationShadow (application)
{
   if (application != null)
   {
      this._application = application;
      application.shadow = this;
      this._application.SeblTrace(2,"JSSApplicationShadow Initialized");
   }
   if (IsOpenUI())
   {
      this.swescriptFrame = window;
   }
   else
   {
      this.swescriptFrame = top._swescript;
   }
}

4. Restart the web server after applying the fix

5. Clear the Browser cache and test.

for more info

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=247346837178836&id=1604411.1&displayIndex=3&_afrWindowMode=0&_adf.ctrl-state=89vqlzbd_61

8.1.1.11 Installation Fails when attempting to create a backup of the current Installation

8.1.1.11 Installation Fails when attempting to create a backup of the current Installation

Oracle provide a solution for this issue

In the installation location ...\Siebel_Enterprise_Server\Disk1\install there is a file named oneclick.properties

Open it into an editor and locate the line

BACKUP_FOLDER=

Please specify the location where the backup should be taken.

The backup will be made to

$BACKUP_FOLDER\$SIEBEL_ROOT

e.g In Siebel is installed in /sblqa, and the BACKUP_FOLDER=/temp/backup, then the backup will be made to /temp/backup/sblqa

The installer then needs to copy the contents of the existing installation to backup location specified above and then try to delete the contents of existing installation directory.

Modify the backup command line to do a copy instead of a move command:

e.g.

#UNIX_BACKUP_CMD will be used in case BACKUP_FOLDER parameter has a non empty value. Do not change %SOURCE_ORACLE_HOME_LOCATION% and %BACKUP_LOCATION% in command

UNIX_BACKUP_CMD=cp -r ORACLE_HOME_LOCATION BACKUP_LOCATION&&rm -rf ORACLE_HOME_LOCATION/*

Save the file and rerun the install.

Query Issue in Siebel Open UI 8.1.1.11

There is an issue with Siebel open UI 8.1.1.1 . When you query a record, OpenUI displays records. But you cannot drill-down or edit that record, even though you have all privileges.

steps to reproduce.
got to any list applet, Click on query, Press "Enter" try to drill-down. This drill-down works only if that record is current record.
or
Try to navigate by clicking next record, you cannot, you have to use next/previous button

Temporary Solution:
Instead of pressing enter click on "Go" Button.

Custom File Upload Applet Based On Class CSSSWEFRImpExp / CSSSWEFRImpExp Fails

We have an Import Button in an Applet, on clicking that button, a small popup applets comes and we can upload CSV which is to be imported in to parent applet. This functionality works well in HI mode. But this functionality fails in OpenUI.
Oracle support says this issues addressed in 8.1.1.11, but still I am getting error.

We can Implement this feature with some tricks.

lets create a button on applet and give method name as "FilePopup". And make sure that CanInvoke is true for this method.

function WebApplet_PreCanInvokeMethod (MethodName, &CanInvoke)
{
    if(MethodName == "FilePopup")
    {
            CanInvoke="TRUE";
            return (CancelOperation);
    }
    return (ContinueOperation);
} 

Now open Applet Browser script. 

function Applet_PreInvokeMethod (name, inputPropSet)
{
    switch(name)
    {
        case "FilePopup":
        var ShowModalOptions= "dialogHeight:150px;dialogLeft:100px;dialogWidth:350px;scrollbars:no";
        var intRet = theApplication().ShowModalDialog ("FileImport.htm", "", ShowModalOptions);
       
        var Bc = this.BusComp();
        var csvval=intRet.split("|");
       
        for(var j=0;j<csvval.length-1;j++){
            this.InvokeMethod("NewRecord");
            var csvvalue=csvval[j].split(",");
            Bc.SetFieldValue("First Name",csvvalue[0]);
            Bc.SetFieldValue("Last Name",csvvalue[1]);
            Bc.SetFieldValue("Age",csvvalue[2]);
            Bc.SetFieldValue("Sex",csvvalue[3]);
        }

        return ("CancelOperation");
        break;

        default:
        return ("ContinueOperation");
        break;
    }
    return ("ContinueOperation");
}

Next step is creating an HTML file. Copy the below code and save it as  "FileImport.htm"
in Webserver as well as siebel server. ( \Client\PUBLIC\ and \siebsrvr\WEBMASTER\ )

<html>
</head>
<script language="javascript" src="23030/scripts/3rdParty/jquery.js"></script>
<script>
$(document).ready(function(){

$("#filename").change(function(e) {
var ext = $("#filename").val().split(".").pop().toLowerCase();

if($.inArray(ext, ["csv"]) == -1) {
alert('Upload CSV');
return false;
}

if (e.target.files != undefined) {
var reader = new FileReader();
reader.onload = function(e) {
var csvval=e.target.result.split("\n");
var inputrad="";
for(var j=1;j<csvval.length-1;j++){
    var csvvalue=csvval[j].split(",");
    for(var i=0;i<csvvalue.length;i++)
    {
    var temp=csvvalue[i];
    if(inputrad==""){
         inputrad=temp+"";
    }else if(i!==0){
         inputrad=inputrad+","+temp+"";
    }else{
        inputrad=inputrad+""+temp;
    }
   
   
    }
    inputrad =inputrad+"|";
}

window.returnValue = inputrad;
return inputrad;
};
reader.readAsText(e.target.files.item(0));

}


});
$("#import").click(function(){
    self.close();
});
})
</script>
</head>
<body>
<input type="file" name="filename" id="filename">
    <div id="csvimporthint_1">
        <table border="1" id="csvimporthint">
        </table>
    </div>
<input type="button" id="import" value="import">

</body>
</html>

compile applet and run GenB script.
Click on Import button and test this functionality.

How to add custom JavaScript files in Siebel OpenUI 8.1.1.11

Siebel OpenUI 8.1.1.11 comes more more systematic way to manifest the custom JavaScript.
In the Administration level, we have options to add files as well as map those files with applets/views/Applications.

First we need to add our custom files in Manifest files

Now we can map those files with our Application /Applet

Siebel Open UI : Migrating a renderer from 8.1.1.10 to 8.1.1.11

Siebel Open UI : Migrating a renderer from 8.1.1.10 to 8.1.1.11

This tutorial is all about how to migrate code from 8.1.1.10 to 8.1.1.11


thanks to  Duncan Ford