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 “CSiebelLogsspool.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:SiebelEnvironmentalVariablesLogs 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:SiebelLogsEnvironmentVariables 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:SiebelLogsEnvironmentVariables Siebel.log: This file will be generated for dedicated client. Siebdev: This log file will be generated for Siebel tools.
Generate your files so that the keystore file references both the private key and the public key, while the truststore file references the public key only. Specify the password that was previously. Jul 15, 2010 How to create Inbound Web Service in Siebel? In the last post, we talked about creating an Outbound Web Service in Siebel where we receives the WSDL file from other system and consume it into Siebel Tools to generate necessary artifacts.
I know its really a simple topic to discuss but recently i have such requirement and i got stuck. And this solution might not be as per standard but this works for me.
Case: On a screen, I am getting SQL error saying “An error has occurred executing a Sql statement. Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00105)“
Root Cause: I have generated spool and go that screen. Now, check in spool file and find that some new column (imported by seed data) not found error in sql query. I have checked in Tools and find that this column is available in Table. That means, its not applied in database. So, all i need to Apply/DDL this column to database.
Problem: I was getting permission error while Apply/DDL using DB User/Pass.
Solution: Use SIEBEL as username and user passw as password. see below screen:
Twist: You might get an error if you are setting default value for that column.
Twist solution: You have to generate DDL and use alter query by removing its default value. Later, we can update that column to that default value.
Thats all. Please feel free to have your comments below.