Siebel Client-Side Logging for High-Interactivity Applications

 

Siebel Client side logging can help you to diagnose situations in which your browser freezes or aborts while using Siebel Application.

Below table illustrates settings to be done on Application Object Manager to enabling Client Side logging.

Parameter	Description	Possible Values	Default Value
ClientSideLogging	Enable/Disable Client Side logging	True/False	False
ClntTraceMode	Set this parameter to enable or disable logging.	1 - Enable 0 - Disable	0
ClntLogFileSize	Size of the log file in MB. Minimum log file size is 50 MB.	50 MB or more	50
ClntLogArchiveCount	Number of files to be archived.	2, 5, 10, and so on.	5
ClntLogDirectory	Directory where the log file is created.	D:\SiebelLogs	C:\SiebelLogs
ClntTraceUnicode	Set this parameter to turn on or off Unicode trace.	True—Unicode trace is on False—Unicode trace is off	False

Alternately if you want to enable Client logging for single High Interactivity client you can do so by setting below environment variables on local machine running Siebel Web Client(HI).

Environment Variable	Possible Values
SEBLCL_TRACEMODE	1—Enable 0—Disable
SEBLCL_LOGDIR	Directory where the log file is created
SEBLCL_LOGFILESIZE	Size of the log file in megabytes (MB) NOTE:  If a log file size exceeds the value in the SEBLCL_LOGFILESIZE environment variable, a new log file is created.
SEBLCL_LOGARCHIVECOUNT	Maximum number of files to be archived
SEBLCL_TRACEUNICODE	True—Unicode trace is on False—Unicode trace is off

Please close all Internet Explorer Sessions and open new IE session after setting above environment variables.

If settings are done both at Server and Client the behavior is defined by below table.

Value on Client (SEBLCL_TRACEMODE environment variable)	Value on Server (ClntTraceMode parameter)	Client Output
Not Set	0	No log file
Not Set	1	Log file for all users
0	0	No log file
0	1	No log file for the current user
1	1	Log file for the current user and all users
1	0	Log file for the current user only

Please refer “Examples of Log Files for Client-Side Logging” to read the log file created

http://docs.oracle.com/cd/E14004_01/books/SysDiag/SysDiagClientSideLogging12.html

Configuring Standard Error Files

Standard error files contain process messages that are directed to standard error and standard out

1. On the computer running the Siebel Server, set the following environment variable to the given value:

SIEBEL_STDERROUT = 1

2. Stop and restart the computer running the Siebel Server for the environment variable to take effect.

Allow Admin users to Insert/Update/Delete on certain table

Allow Admin users to Insert/Update/Delete on certain table

How to create a trigger in oracle which will restrict insertion and update queries on a table based on a condition

CREATE OR REPLACE TRIGGER SIEBEL.BLOCK_NON_ADMIN_ACCESS

BEFORE DELETE OR INSERT OR UPDATE

ON SIEBEL.CX_ERROR_LOG

REFERENCING NEW AS NEW OLD AS OLD

FOR EACH ROW

begin

    IF sys_context('USERENV','SESSION_USER') NOT IN ('SADMIN', 'EIMUSER') THEN

        RAISE_APPLICATION_ERROR(-20000, 'You are not allowed to update table CX_ERROR_LOG. Please contact Application Support.');

    END IF;

END;

Forgot password of old Siebel DBF file sse_data.dbf

If you have an old Siebel database and you have forgotten the user id and password you can execute below set of command on that dbf to get your user id created on the dbf. Please find the steps as below.

Steps:

1)      Copy the .dbf to Tools\LOCAL

2)      Launch dbisqlc.exe from tools\bin

UserName = DBA

Password = ENTRPRISENAME

Click On Database Tab -> Select Database File as the .dbf in the Tools\LOCAL

Click on OK

3)      Once connected run below mentioned command.

grant connect to SSE_ROLE

grant connect to USERNAME identified by PASSWORD

grant connect to SIEBEL identified by PASSWORD

grant group to SSE_ROLE

grant membership in group SSE_ROLE to USERNAME

Commit

NOTE: USERNAME & PASSWORD Need to be in CAPITAL CASE

4)      Make environment specific changes in your Tools.cfg and create a local DSN to connect the .dbf file

DBCHCK utility to verify if physical schema is in sync with repository

DBCHCK verifies that the physical schema is in sync with repository

D:\sba81\siebsrvr\BIN\dbchck /u sadmin /p sadmin /s SBA81ENT_DSN /dict /all /r "Siebel Repository" /t SIEBEL /l D:\Automation\dbchck.log

The output on command prompt will be shown as below

dbchck: Logging into source "SBA81ENTMBA_DSN" as user "sadmin"...

dbchck: Connected to Oracle (table owner: SIEBEL, schema version: 45.19.0.176).

dbchck: Loading application dictionary (repository: Siebel Repository) ...

dbchck: Identified 3730 tables (0 columns) to check.

dbchck: S_ASSET checking completed: 2 checks failed.

dbchck: S_CONTACT checking completed: 3 checks failed.

dbchck: S_EVT_ACT checking completed: 7 checks failed.

dbchck: S_OPTY checking completed: 2 checks failed.

dbchck: S_ORDER checking completed: 3 checks failed.

dbchck: S_ORG_EXT checking completed: 1 check failed.

dbchck: S_PARTY_REL checking completed: 2 checks failed.

dbchck: Checking completed: 20 checks failed in 7 tables.

Output from Log File

2014-07-21 13:59:05        SQLstyle is 'Oracle'

2014-07-21 13:59:05        SARM is OFF -change param SARMLevel to enable

2014-07-21 13:59:05        SARM Client is OFF -change param SARMClientLevel to enable

2014-07-21 13:59:05        SARM is OFF -change param SARMLevel to enable

2014-07-21 13:59:05        SARM Client is OFF -change param SARMClientLevel to enable

2014-07-21 13:59:05        SARM is OFF -change param SARMLevel to enable

2014-07-21 13:59:05        SARM Client is OFF -change param SARMClientLevel to enable

2014-07-21 13:59:43        Failure: Dictionary for S_ASSET different from physical schema

2014-07-21 13:59:43        1    Physical column X_BRCL_NIMBLE_MASTER_ID not in the dictionary.

2014-07-21 13:59:43        2    Physical column X_BRCL_NIMBLE_PAO_ID not in the dictionary.

2014-07-21 14:00:28        Failure: Dictionary for S_CONTACT different from physical schema

2014-07-21 14:00:28        1    Physical column X_BRCL_NIMBLE_FCON_FAX not in the dictionary.

2014-07-21 14:00:28        2    Physical column X_BRCL_NIMBLE_SCON_EMAIL not in the dictionary.

2014-07-21 14:00:28        3    Physical column X_BRCL_NIMBLE_SCON_FAX not in the dictionary.

2014-07-21 14:01:22        Failure: Dictionary for S_EVT_ACT different from physical schema

2014-07-21 14:01:22        1    Dictionary different from physical schema for index S_EVT_ACT_F10:

2014-07-21 14:01:22                        dictionary: (TARGET_OU_ID APPT_START_DT ROW_ID)

2014-07-21 14:01:22                        physical:   (TARGET_OU_ID APPT_START_DT ROW_ID)

2014-07-21 14:01:22        2    Dictionary different from physical schema for index S_EVT_ACT_M10:

2014-07-21 14:01:22                        dictionary: (TARGET_OU_ID TEMPLATE_FLG APPT_START_DT)

2014-07-21 14:01:22                        physical:   (TARGET_OU_ID TEMPLATE_FLG APPT_START_DT)

2014-07-21 14:01:22        3    Dictionary different from physical schema for index S_EVT_ACT_M11:

2014-07-21 14:01:22                        dictionary: (EVT_STAT_CD EVT_PRIORITY_CD APPT_START_DT)

2014-07-21 14:01:22                        physical:   (EVT_STAT_CD EVT_PRIORITY_CD APPT_START_DT)

2014-07-21 14:01:22        4    Dictionary different from physical schema for index S_EVT_ACT_M2:

2014-07-21 14:01:22                        dictionary: (CREATED_BY TODO_PLAN_START_DT OWNER_PER_ID)

2014-07-21 14:01:22                        physical:   (CREATED_BY TODO_PLAN_START_DT OWNER_PER_ID)

2014-07-21 14:01:22        5    Dictionary different from physical schema for index S_EVT_ACT_M3:

2014-07-21 14:01:22                        dictionary: (TODO_DUE_DT)

2014-07-21 14:01:22                        physical:   (TODO_DUE_DT)

2014-07-21 14:01:22        6    Dictionary different from physical schema for index S_EVT_ACT_M6:

2014-07-21 14:01:22                        dictionary: (OWNER_PER_ID APPT_START_DT)

2014-07-21 14:01:22                        physical:   (OWNER_PER_ID APPT_START_DT)

2014-07-21 14:01:22        7    Dictionary different from physical schema for index S_EVT_ACT_M8:

2014-07-21 14:01:22                        dictionary: (TODO_PLAN_START_DT)

2014-07-21 14:01:22                        physical:   (TODO_PLAN_START_DT)

2014-07-21 14:02:39        Failure: Dictionary for S_OPTY different from physical schema

2014-07-21 14:02:39        1    Dictionary different from physical schema for index S_OPTY_M1:

2014-07-21 14:02:39                        dictionary: (SUM_EFFECTIVE_DT)

2014-07-21 14:02:39                        physical:   (SUM_EFFECTIVE_DT)

2014-07-21 14:02:39        2    Dictionary different from physical schema for index S_OPTY_M55:

2014-07-21 14:02:39                        dictionary: (SECURE_FLG CONSUMER_OPTY_FLG SUM_EFFECTIVE_DT)

2014-07-21 14:02:39                        physical:   (SECURE_FLG CONSUMER_OPTY_FLG SUM_EFFECTIVE_DT)

2014-07-21 14:02:50        Failure: Dictionary for S_ORDER different from physical schema

2014-07-21 14:02:50        1    Dictionary different from physical schema for index S_ORDER_M3:

2014-07-21 14:02:50                        dictionary: (ORDER_DT)

2014-07-21 14:02:50                        physical:   (ORDER_DT)

2014-07-21 14:02:50        2    Dictionary different from physical schema for index S_ORDER_M4:

2014-07-21 14:02:50                        dictionary: (ORDER_CAT_CD ORDER_DT)

2014-07-21 14:02:50                        physical:   (ORDER_CAT_CD ORDER_DT)

2014-07-21 14:02:50        3    Dictionary different from physical schema for index S_ORDER_M7:

2014-07-21 14:02:50                        dictionary: (CRDT_STATUS_CD ORDER_DT)

2014-07-21 14:02:50                        physical:   (CRDT_STATUS_CD ORDER_DT)

2014-07-21 14:02:57        Failure: Dictionary for S_ORG_EXT different from physical schema

2014-07-21 14:02:57        1    Dictionary different from physical schema for index S_ORG_EXT_F1:

2014-07-21 14:02:57                        dictionary: (LAST_UPD)

2014-07-21 14:02:57                        physical:   (LAST_UPD)

2014-07-21 14:03:08        Failure: Dictionary for S_PARTY_REL different from physical schema

2014-07-21 14:03:08        1    Dictionary different from physical schema for index S_PARTY_REL_U1:

2014-07-21 14:03:08                        dictionary: (PARTY_ID REL_TYPE_CD REL_PARTY_ID START_DT ONFLICT_ID) unique

2014-07-21 14:03:08                        physical:   (PARTY_ID REL_TYPE_CD REL_PARTY_ID START_DT ONFLICT_ID) unique

2014-07-21 14:03:08        2    Dictionary different from physical schema for index S_PARTY_REL_U2:

2014-07-21 14:03:08                        dictionary: (REL_PARTY_ID REL_TYPE_CD PARTY_ID START_DT ONFLICT_ID) unique

2014-07-21 14:03:08                        physical:   (REL_PARTY_ID REL_TYPE_CD PARTY_ID START_DT CONFLICT_ID) unique