Search here for wide range of results..
Loading
Home » Archive

Articles in the Siebel Administration Category

EAI, Siebel Administration, Web Services »

[4 Apr 2010 | 3 Comments | ]

Whenever we make use of HTTP Transport or Web Services based on HTTP transport, we need to secure that web service using the
digital certificates. Because, the information is exchanged over internet which is no more secure now.
Now question is, what is a digital certificate? Then answer is simple, just launch your http://mail.google.com in a browser.
Automatically, you will see the url will be redirected to “https” from “http”. Also, you will see a “Lock” on the browser url
on right side. Because google has configured a digital certificate on this site. So, …

Configuration, Siebel Administration, Siebel SQLs & Database, Uncategorized »

[15 Jun 2009 | 4 Comments | ]

This issues was faced by a developer, who asked for the solution, so here is something can be done at database level -

[a]
Create an Oracle profile and limit the number of sessions per database user, for example:
sql> CREATE PROFILE <profilename> limit SESSIONS_PER_USER 1;
sql> ALTER USER <username> <profilename>;
sql> ALTER SYSTEM SET RESOURCE_LIMIT=TRUE;
Using this approach, please be aware that dead connections will not always be detected by the database immediately, so users might occasionally not be able to login even a single time until a database administrator has killed their session. Also, …

Outbound Communication Manager, Siebel SQLs & Database »

[22 Apr 2009 | No Comment | ]

During Siebel development, we have many development environments like DEV, QA, BUILD, and PRODUCTION. And we may get mails or end-users may get mails from Siebel, but we don’t know which the originating environment is. Hence, it takes time to debug and find the source of emails.
Solution:
The emails are sent by the server component – Outbound Communication Manager. Outbound Communication Manager Business service inserts records with parameters in two tables – S_SRM_ACTION and S_SRM_DATA. The action name is stored in S_SRM_ACTION. S_SRM_DATA stores the various parts of the mail like …