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.
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.