Siebel Administration Explored

-

 

SQL Query to List All Active RCR jobs in Siebel

As with any Siebel implementation, one of the day-to-day monitoring tasks for an Administrator are the Siebel components. And the RCR jobs running on the servers tend to be an integral part of the Workflow Process Manager and Workflow Process Batch Manager component requests. So, tracking them becomes useful in situations where there are component issues or some critical job failure.

This SQL can be a reference to list all the RCR jobs by their Execution Server name which is very helpful if you are not assigning any Server Name to the job upon submitting.

SELECT
    PAR_REQ_ID "Job Id",
    rpt_interval||' '||rpt_uom "Frequency",
    STATUS,
    ACTL_START_DT,
    EXEC_SRVR_NAME
FROM
    SIEBEL.S_SRM_REQUEST
WHERE
    REQ_TYPE_CD = 'RPT_INSTANCE'
    AND STATUS = 'ACTIVE'
    AND PAR_REQ_ID in
(
select
    par.row_id
from
    siebel.S_SRM_REQUEST par,
    siebel.S_SRM_ACT_PARAM aparam ,
    siebel.S_SRM_REQUEST child ,
    siebel.S_SRM_REQ_PARAM param
where
    par.row_id = child.par_req_id
    and par.req_type_cd = 'RPT_PARENT'
    and par.STATUS = 'ACTIVE'
    and child.status in ('QUEUED','ACTIVE')
    and par.row_id = param.req_id
    and child.req_type_cd = 'RPT_INSTANCE'
    and param.ACTPARAM_ID = aparam.row_id
    and aparam.NAME = 'Workflow Process Name'
group by par.row_id,param.value, par.rpt_interval||' '||par.rpt_uom
)
order by ACTL_START_DT desc;

As usual, you can feel free to play around and come up with complex outputs with this reference SQL.

---------------------------

SELECT U.LOGIN
FROM SIEBEL.S_USER U, SIEBEL.S_PER_RESP PER, SIEBEL.S_RESP R
WHERE U.ROW_ID = PER.PER_ID
AND R.ROW_ID = PER.RESP_ID
AND R.NAME LIKE 'Siebel Administrator';

----------------------------

How to Increase logging for a particular user in a Large Enterprise?

It is always a challenge when supporting large Siebel Enterprise applications when we have to troubleshoot a particular user issue. The very first question any DEV/Oracle person would ask is to provide them with the detailed logging from the user session for analysis.

I have posted an earlier article on the logging for specific user, but see that it does not work as expected in some scenarios. So listing this method which I follow personally when troubleshooting issues.

In this method, we are first looking for the server in which the user is connected to and increasing the logging on just that one server thereby limiting the overall impact of increasing the logging during business hours.

Steps:
1. Get the user login ID for which we need the logs
2. Login to Siebel server manager using the command:
srvrmgr /g <gatewayname> /e <enterprisename> /u <username> /p <password>
3. Get the active session of the user
srvrmgr> list session for login USER_NAME

SV_NAME  CC_ALIAS  CG_ALIAS  TK_TASKID  TK_PID  TK_DISP_RUNSTATE  TK_IDLE_STATE  TK_PING_TIME  TK_HUNG_STATE  DB_SESSION_ID  OM_LOGIN  OM_BUSSVC  OM_VIEW  OM_APPLET  OM_BUSCOMP
-------  --------  --------  ---------  ------  ----------------  -------------  ------------  -------------  -------------  --------  ---------  -------  ---------  ----------
SERVER1  SCCObjMgr_enu  CallCenter  35653120   18688   Running           FALSE                                       Shared Connection Id:   USER_NAME  Completed : Workflow Process Manager (RunProcess)  Completed: Business Servi

Note the task ID for the particular user session.
4. Increase the component logging by connecting to the server where user session is running
srvrmgr> set server SERVER1
srvrmgr:server1> change evtloglvl %=5 for comp SCCObjMgr_enu
5. Logon to SERVER1 and search by the task ID got from step 3 in the <siebelserver home>/log folder. This will be the user session log
6. Turn off the logging once done
srvrmgr:server1> change evtloglvl %=1 for comp SCCObjMgr_enu

This method will also increase the details in other user sessions that are connected to that Object Manager on the server, but if needed for short term analysis this can be an effective method. Any other alternative and efficient inputs from the community are greatly appreciated.



-----------------------------

List Component
srvrmgr> list comp sccobjmgr_enu

List Component for specific server
srvrmgr> list comp sccobjmgr_enu for server SERVER1

List Active sessions for a component
srvrmgr> list active sessions for comp sccobjmgr_enu

List Active sessions for a user
srvrmgr> list active sessions for login tom_siebel

List all sessions for a component
srvrmgr> list sessions for comp sccobjmgr_enu

List all sessions for a user
srvrmgr> list sessions for login tom_siebel

To connect to a specific server within the Enterprise
srvrmgr> set server SERVER2

To disconnect from a server session and go back to Enterprise
srvrmgr:SERVER2> unset server

Starting a Siebel component
srvrmgr> start comp wfprocmgr

Stopping a Siebel component
srvrmgr> stop comp wfprocmgr

Starting a component for a specific server
srvrmgr> start comp wfprocmgr for server SERVER1

Stopping a component for a specific server
srvrmgr> stop comp wfprocmgr for server SERVER2

Kill a stuck/non-responsive component
srvrmgr> kill comp wfprocbatchmgr

How to change startup mode for a component
srvrmgr> manual start comp SCCObjMgr_enu
srvrmgr> auto start comp SCCObjMgr_enu
srvrmgr> manual start comp wfprocmgr for server SERVER1
srvrmgr> auto start comp wfprocbatchmgr for server SERVER2

Listing component parameters
srvrmgr> list param for comp wfprocmgr
To list a specific parameter
srvrmgr> list param <parameterAliasName> for comp wfprocmgr
To list a hidden/advanced parameter
srvrmgr> list advanced param ConnForwardAlgorithm for comp SCBroker

-----------------------

Alter sessions commands for Siebel SQL

In order to have the Siebel SQL statements that we obtain from the logs run with the same execution time with SQL clients like SQL Developer/Toad, these alter statements need to be run in the DB client window where you plan to execute the SQL from Siebel logs:

alter session set optimizer_mode = first_rows_10
alter session set “_optimizer_sortmerge_join_enabled” = false
alter session set “_optimizer_join_sel_sanity_check” = true

 

How to increase logging for a specific user?

In many situations we would need the Siebel log details for troubleshooting issues within the application, in scenarios where we need the logs for one particular user for a component this command might be helpful.

Connect to Server manager command line from any of the Siebel servers.

1. Command to connect to Server Manager
Navigate to siebsrvr\bin directory and use this command:
srvrmgr /g <gateway server name> /e <enterprise name> /s <server name> /u sadmin /p <password>

2. srvrmgr> list param UserList for comp FINSObjMgr_enu show PA_ALIAS, PA_VALUE
 PA_ALIAS   PA_VALUE
--------          --------
UserList
UserList

Now change it by using
 srvrmgr>change param UserList=<UserName> for comp FINSObjMgr_enu

Posted by Shyam at 6/10/2015 01:07:00 PM No comments: 

Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Labels: increasing logs in siebel, Siebel logging, Siebel server manager, srvrmgr

Thursday, January 15, 2015

How to Drop and Generate Triggers in Siebel

If there are changes to a Workflow policy, you might be asked to either 'Generate' the triggers or 'Recreate' them for the changes to take effect. This task can be accomplished in two ways, one through the Siebel Application and the other via Server Manager command line.

The main parameter to consider to Generate or Drop the triggers is 'Remove' which can be set to TRUE or FALSE depending upon the purpose.

Server Manager Commands:

1. Drop Triggers
run task for comp GenTrig with EXEC=True,Remove=True,PrivUser=SIEBEL,PrivUserPass=<siebelpassword>

2. Generate Triggers
run task for comp GenTrig with EXEC=True,Remove=False,PrivUser=SIEBEL,PrivUserPass=<siebelpassword>



Siebel Application:

Login to the Siebel application and navigate to the 'Administration - Server Management' and then 'Jobs'.
Create a new job 'Generate Triggers' and add the parameters as shown:



Change the parameter value of 'Remove' to 'True' if you want to drop the triggers. The ideal sequence for re-creating the triggers is to drop them first and then create. So you would have to run the job with the 'Remove' parameter set to 'True' first and then run the job again with the parameter set to 'False'.

You can also include additional logging parameters like 'ErrorFlags', 'SQLFlags','TraceFlags' etc for capturing additional information in the logs.

Oracle bookshelf link related to this topic:

http://docs.oracle.com/cd/E14004_01/books/BPFWorkflow/administering_policies4.html

 

Comments

Post a Comment

Popular posts from this blog

Siebel crm Best Bloggers/Blog sites

-
 Siebel Best Bloggers/Blog sites https://markenjam.blogspot.com/ https://medium.com/@markenjam https://siebelopenui.blogspot.com/ https://thesiebel.blogspot.com/ https://siebelenhance.blogspot.com/ https://crmcog.com/ https://geeksajan.blogspot.com/ https://thesiebelscholar.blogspot.com/ http://siebel.ittoolbox.com/blogs/ https://siebelhacker.blogspot.com/ https://siebelcrmmaterials.blogspot.com/ https://siebelexamples.wordpress.com/ https://siebelwizards.blogspot.com/ https://thealternatespace.blogspot.com/ https://siebelexpress.blogspot.com/ https://siebelexplored.blogspot.com/ https://siebel-ansari.blogspot.com/ http://www.error-codes.info/ https://crmknowledgebase.blogspot.com/ https://siebel360.blogspot.com/ https://siebel-learnings.blogspot.com/ https://www.impossiblesiebel.com/ https://weeklysiebel.blogspot.com/ https://exploringsiebel.blogspot.com/ https://siebelresources.blogspot.com/ https://siebelsupport.blogspot.com/ https://siebeltechhelp.blogspot.com/ https://yetanoth...
Read more

Siebel REST API Interview Questions

-
Image
Question 1 : What are REST APIs?  Answer: REST stands for Representational state transfer. It is a protocol for data transfer using HTTP methods. Usually REST API uses JSON format to communicate as it is simpler and lightweight than XML uestion 2: Whats the architecture changes required in Siebel to implement REST API?  Answer:  Oracle has introduced java web containers and Proxy Object Manager to manage them at run time. Architecture looks like below: Question 3: What is the use of Siebel REST Proxy Object Manager? Answer: Siebel REST Proxy Object Manager is a new component which was introduced in Siebel IP17 to manage Java Web Containers on the Siebel Server. Requests from the web server is served by java web container by sending the request to EAI Object Manager. Siebel REST Proxy Object Manager is responsible for turning the Java Web Container On or Off. Question 4:  What are the URL Patterns for data and business services? Answer: Business services can be direct...
Read more

Siebel CRM product config and pricing interview questions

-
 1. What are the most commanly used UI Properties? 2. How Products will be migrated one environment to another environment 3. How price list will be moved from one environment to another enivironment 4. What is product workspace 5. If any thing wrong in existing Sturcutre how you identiy 6. what are Imporatant product Feature like Auto Explode 7. On which cases we will write scripts 8. What Product Catche will do 9. can we edit product XML and Import or no. 10.what are the common parameters required to be productsync in BRM AIA And CRM 11.Difference Between Check Eligibily and Inclusive Eligibily 12.What is use of Produt Catalogue how you link it 13.how we can Restrict Products with Responsibility 15.How to overide the price for BRM Products 16.What are important Constraints(Require/Exclude/ procedural) 17.How we Restrict eConfigurator based on Segment or condition 18.How the cardinality will workspace 19.Difference between Class and Dynamic class 20.How we can identify root produc...
Read more