How to crash test a Siebel server?

Yes you heard it right, this series is to find out what things developers can do to crash test the siebel server

Siebel unlike salesforce server has governor limits, it keeps on going until you ask it to stop. That's it's one of the key strength that I love, but not great when given it in hands of cowboys...

Siebel is generating offensive ROW_ID's in production

This is an original Siebel service request posted in Oracle support. It has been a laughing stock for many many years and now it has been archived on the Oracle support.

Customer found a row_id created in their production environment which got offensive words in the row_id such as, "1-190F**K". So, they would like to know whether Siebel have any internal validation to avoid offensive words in ROW_ID generation.

How to create cookies from server side?

Yes, you read it correctly, you can create cookies in the browser from the server side, and get your browser script to access them. This is enabled via Web Engine HTTP TXN business service.

Siebel Cookies

var oBS = TheApplication().GetService("Web Engine HTTP TXN");

var Inputs = TheApplication().NewPropertySet();
var Outputs = TheApplication().NewPropertySet();

var psCookie = TheApplication().NewPropertySet();
psCookie.SetType("Cookie");
psCookie.SetValue("Value of Cookie");
psCookie.SetProperty "Path", "/";
Inputs.AddChild(psCookie);

oBS.InvokeMethod("SetResponseCookies", Inputs, Outputs);

Keep in mind that this method can be called from any other event in Siebel except application start(Application_Start) event due to product limitation .

Not just that one can use this service to get IP address of the client which is used to access Siebel. I will highly recommend to go through all the methods of Web Engine HTTP TXN business service in your free time.

How caching work in Siebel?

In any online transaction processing system like CRM most of the processing time is taken in finding the right record in database. No matter what database optimization technique you implement, your db processing time would be the highest among the time spent in web server and application server.

Siebel Database

How to update bulk records in Siebel using eScript?

The best suggestion anyone can give to update records in bulk in Siebel is to use Siebel EIM. However sometimes developers don't have time to create EIM job, test it in lower environments and get it working in some days, and business can't wait for that long, And pesky admin team won't give developers the SQL access to production.

Then this is the last solution. Write a dirty little script and run it in business service simulator.