What are Debugging Techniques in Siebel

Debugging Techniques in Siebel: 
While in Testing Siebel applications or else in development we find many errors in Siebel applications. Here we are going to discuss about how to find out source of that errors.
Siebel provides some debugging techniques
1. Placing the “Spool” File
2. Setup Environment variables
3. Siebel Debugger breakouts
4. Enabling Client side tracing script.
In this article, I am explaining how to setup the first two methods,
How to generate the Spool File:
Spool files are basically generating SQL Queries, to find out where is our SQL is failing we are using the spool file.
You can able to set the spool file for Client or Tools,
Step1: Right click on dedicated client shortcut or on the Tools shortcut --> Click on “Properties”
Step2: In the “Target” enter the following string /s “C:\<Path of your spool file>”
Ex: /s “C\Siebel\Logs\spool.txt”

Where “Logs” is the Folder Name, “spool.txt” is the spool file name in C drive.
Note: After placing the “spool” file path in dedicated client path, if you are not find any spool file generated then create an empty file with name “spool.txt” in the destination folder. It will create the spool file from the next time when you open the dedicated client.
How to create a spool file:
If you want to place the Spool file in your desktop then enter the following string at the end of the “Target” string i.e., /s “C:\spool.txt”. It will create the spool file directly on the desktop.
How to setup the Environmental Variables:
Siebel provides the environmental variables, which can help us to provide the logs for dedicated clients.
1. SIEBEL_LOG_EVENTS
2. SIEBEL_LOG_DIR
SIEBEL_LOG_EVENTS: 
This environment variables have the two types of values they are either Numeric or Text.
The Numeric value is the Log level which can be between 1- 4.
If you set the Numeric Value of 1, it will give you the low log levels.
If you set the Numeric value of 4, it will give you the High log levels.
If you set the Text value: ALL, It will give you a log level of 4.
SIEBEL_LOG_DIR: 
This Value of the variable represents where you want to save the logs.
Note: If you are not provided any value to this variable then logs will be created in the “Temp” directory.
Example Entries in Environment Variables:
SIEBEL_LOG_EVENTS: ALL
SIEBEL_LOG_DIR: C:\Siebel\EnvironmentalVariables\Logs
Steps to create the Environmental Variables: 
Step1: Right Click on “My Computer” Icon or “This PC” icon on Desktop.
Step2: Select “Properties”
Step3: One window will be opened, Select the “Advanced System Settings”
Step4: Click on “Environment Variables” button Under Advanced tab.

Step5:  Under “User Variable” section click on “New” button
Step6:  Provide the Variable Name and Variable Value
Variable Name: SIEBEL_LOG_EVENTS
Variable Value: ALL

Step7: Click on the “New” button on “User Variables” Section and provide the following values.
Variable Name: SIEBEL_LOG_DIR
Variable Value: C:\Siebel\Logs\EnvironmentVariables
Step8: Click on “Ok” button.
Note: After Creating the Environmental Variables i.e., SIEBEL_LOG_EVENTS & SIEBEL_LOG_DIR there are two files will be generated on the logs directory folder i.e., C:\Siebel\Logs\EnvironmentVariables
Siebel.log: This file will be generated for dedicated client.
Siebdev: This log file will be generated for Siebel tools.

Error Code: sbl-dev-00127

sbl-dev-00127:
Siebel will throw this error code when your debug setting are not properly set in you working environment after click on "Start" button in Debug menu option.
To avoid this error provide the Working directory details ex: "C:\Siebel\8.1.1.14.0\Client\BIN" and save the record.
In Siebel Tools Menu --> Debug --> Click on Start button or Press F5 button. Now your debugging will be successful.

How to Setup Debug settings in Siebel Tools

All Siebel developers should know about Debug settings while working with Siebel application customization in development environments.

In this article we are going to provide the steps, that will helpful to you to set debug settings in your Siebel local or sample environment.

To Setup the Debug settings: 

Login to Siebel Tools environment

In Tools Menu Options -->  Select “View” --> Select “Options”

window will be displayed like below

Now you need to fill the following information in “Debug” window.

Executable: Provide the path of your Siebel executable file. i.e., Siebel.exe

CFG File: Provide the path of client CFG file in this section.

Browser: Provide the browser root folder path. Ex: IExplorer.exe

Working directory: Provide the Siebel web client-> BIN folder path

Arguments: There are two arguments you can provide here based on your needs

/h: If you want to enable the local debugging of server scripts.

/s: If you want to generate the spool file or enable spooling

In Login Information Section: 

User Name: Your local User name

Password:  Your Local Password

Data Source: Select the data source based on you environment ex: Local, Sample or any other if available.

Sample debug settings: 

Executable: C:\Siebel\8.1.1.14.0\Client\BIN\siebel.exe

CFG: C:\Siebel\8.1.1.14.0\Client\BIN\enu\scommtrue.cfg

Browser: C:\Program Files\Internet Explorer\iexplore.exe

Working Directory: C:\Siebel\8.1.1.14.0\Client\BIN

Arguments: /h or /s

User Name: sadmin (Give your login User Name)

Password: sadmin(Give your Login password)

Data Source: Local

After filling all details Debug window looks like below

Testing the Debug Settings: 

In Tools Menu Options --> Select “Debug” --> Select “Start”

Or 

Click on F5 button to invoke debugger directly.

Application opens after few seconds.

What are Horizontal and Vertical Applicatons in Siebel CRM

Siebel Applications are categorized as two types.
1. Horizontal Applications
2. Vertical Applications
1. Horizontal Applications: Different types of Customer, Partner or Employee and channel                                                                applications.
2. Vertical Applications:   Different types of Industries application.
                                         Vertical applications are also called as Industry applications.
Example:
Horizontal Applications:
* Siebel Sales
* Siebel Call Center
* Siebel Partner Portal
Vertical Applications:
* Siebel Finance
* Siebel Consumer Goods.

Organization Structure in Siebel

Organization Structure in Siebel is defined as following:
1. Define Currencies
2. Define Organization
3. Define Divisions
4. Define Position
5. Define Responsibility
6. Setup Employees
1. Define Currencies:
To define currencies we need to navigate to Site Map --> Admin Application --> Currencies --> Create a currency here.
2. Define Organization: 
To define Organization we need to navigate to Site Map --> Admin Group --> Organization --> Create an Organization here.
3. Define Division:
To define Division we need to navigate to Site Map --> Admin Group --> Divisions --> Create a Division here.
4. Define Position:
To define Position we need to navigate to Site Map --> Admin Group --> Position --> Create a position here.
5. Define Responsibility: 
To define position we need to navigate to Site Map --> Admin Application -->  Responsibilities --> define the responsibility here.
Position :
Position determines Access to Data in Siebel application.
Responsibility: Responsibility determines Access to View in Siebel application.
We group set of views as a responsibility and we will assign this responsibility to the employee.
6. Setup Employee: 
Creating an Employee in Siebel is a two way process, we need to create the Employee at the application level and also at the DB level. As Siebel does not maintain passwords at the application level we need to setup the USER ID at application level and again User ID and Password at DB level.
Create the Employee at Application Level: 
To Create an Employee at Application level we need to navigate to Site Map --> Admin User --> Employees --> Create an Employee
Create the Employee User ID & Password at the db Level: 
Navigate to Siebel Installation folder -- >  Web Client --> Bin --> search for "dbisqlc" and double click on the 'dbisqlc'  and provide the below details,
User ID: DBA
Password: SQL
After giving the user ID and password, --> Click on Database Tab Option, Keep the file on the database file option and browse of the db file i.e., your dbf file path.
Ex: siebel\webclient\Sample\UTF8\sse_samp.dbf
Navigate to SQL Window and execute the below command.
SP_ADDLOGIN<User Name>, <Password>
Ex: SP_ADDLOGIN TOM, XYZ
SP_ADDUSER<User Name>, <Password>, SSE_ROLE
Ex SP_ADDLOGIN TOM, XYZ, SSE_ROLE
Note: In Siebel Data model Employees and Responsibilities are M:M relationship and employees and positions are M:M relationship positions and responsibilities are not directly related.