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

Thanks,
Shyam

Raising log levels for SWSE - Siebel Web Server Extension

NOTE: Starting in Siebel version 7.7.x, the Log parameter in the eapps.cfg file is no longer used by the SWSE. You only need to set the environment variables documented below to trace the SWSE connections. Bug <strong< a="">12-JP45TC>> has been logged to address the documentation defect to request the Log parameter be removed from the eapps.cfg file. This parameter has been removed from the Siebel Bookshelf starting with Siebel version 7.7.</strong<>


To troubleshoot further, the logging can be increased to include Siebel Internet Session API (SISNAPI) and Session Manager tracing. The following information details how to turn up logging for the SWSE on the Microsoft Windows and UNIX Operating Systems to include SISNAPI and Session Manager Information.

Be aware that by increasing the logging levels on the Web Server, this may cause performance degradation, the extent of which will depend on your specific implementation (mostly this is insignificant). Additionally, increasing the logging levels will require more available disk space in the SIEBEL_HOME\SWEApp\LOG directory as the log files will be bigger. It is always a good practice to test out these settings in your test environment first and then move these settings to production only if specifically requested by Siebel Technical Support. Once the behavior has been resolved, it is a good practice to unset the environment variables and reset the default logging for the SWSE in the production environment.


For Windows Environments

Perform the following steps to enable tracing for the SWSE:

1. Set the following System Environment Variables:

SIEBEL_LOG_EVENTS=4 (or higher)
SIEBEL_SESSMGR_TRACE=1
SIEBEL_SISNAPI_TRACE=1

To set up environment variables perform the following steps:

o Start > Settings > Control Panel > System.

o Click on the Advanced tab and then click on the Environment Variables button.

o Under the System variables view, click the New button and add the variable names and values mentioned above. Click the Ok button when finished.

2. In the eapps.cfg file located on the web server machine under the directory SIEBEL_HOME\SWEApp\BIN folder, make the following changes under the [swe] section:

Log = details (only for 7.5.3 or earlier)
SessionMonitor = TRUE

3. Restart the IIS Admin Service and its dependent services for the changes to take effect. NOTE: The inetinfo.exe process has to be restarted for the new environment variables to take effect.

NOTE: If SWSE is installed on a Windows 2003 Server, it is necessary to reboot the machine otherwise logging will not be enabled.

For a UNIX Environment except Linux

Perform the following steps to enable tracing for the SWSE:

1. Set the following environment variables:

SIEBEL_LOG_EVENTS=4 (or higher)
SIEBEL_SESSMGR_TRACE=1
SIEBEL_SISNAPI_TRACE=1

To set up environment variables for the user who starts the web server, perform the following steps (for Bourne and Korn Shell):

$ =value; export

For example:

$ SIEBEL_LOG_EVENTS=4; export SIEBEL_LOG_EVENTS

2. In the eapps.cfg file found on the web server machine under SIEBEL_ROOT/sweapps/bin folder make the following changes:

Under the [swe] section:

Log = details (only for 7.5.3 or earlier)
SessionMonitor = TRUE

3. Restart the web server process for the changes to take effect.

For Linux Environment
For increasing the logging for SWSE when using Oracle HTTP Server (OHS) add the environment variables to a file named envvars under ohs/bin directory.

envvars-std - default environment variables for apachectl
#

This file is generated from envvars-std.in
#
LD_LIBRARY_PATH=
export LD_LIBRARY_PATH

SIEBEL_SESSMGR_TRACE=1
SIEBEL_SISNAPI_TRACE=1
SIEBEL_LOG_EVENTS=5

export SIEBEL_SESSMGR_TRACE
export SIEBEL_SISNAPI_TRACE
export SIEBEL_LOG_EVENTS
To Reverse the Default Logging Levels on the Web Server

1. Remove all three environment variable settings.
2. In the eapps.cfg file set Log = errors (only for 7.5.3 or earlier).
3. Restart the web server processes.

NOTE: For information about unsetting the environment variables, see the appropriate operating system documentation.