Page History
This section includes the following topics:• About
- About performing actions on a Siebel instance
...
- Setting up Siebel batch process sampling
...
- About sampling Siebel batch processes (SQL Server)
...
- Modifying the Siebel Repository File (SQL Server)
...
- About sampling Siebel batch processes (Oracle)
...
- Modifying the Siebel Repository File (Oracle)
About performing actions on a Siebel instance
The Interpoint for Siebel extension of Precise for SQL Server and Precise for Oracle can only receive notifications of user events if specific objects are included in the Siebel Repository File (SRF). Before you can use Interpoint for Siebel, you need to modify the SRF file. This document describes how to add the required objects to the file.
Setting up Siebel batch process sampling
For Siebel batch processes to be sampled by the Siebel AppTier Collectors, you need to create a tab-delimited text file that contains the mapping of each Siebel server to its host machine and network address. Each row in the file represents a physical machine. The first field in each row should represent the name of the Siebel server, the second field its corresponding host machine name, and the third its network address.
About sampling Siebel batch processes (SQL Server)
If you have installed Interpoint for a SQL Server database, perform the following procedures.
...
1. Log on to the SrvrMgr utility.
2. Execute the following command:
...
sieb2 APPSRV2 00096B26E67C
Modifying the Siebel Repository File (SQL Server)
Once the Siebel AppTier Collectors are installed, modify the Siebel Repository File (SRF), so that Interpoint for Siebel will be able to receive notifications of Siebel-related user events.
...
5. Lock the project by clicking the Locked column to the right.
Creating the CX_VTSSPID table (SQL Server)
...
8. From the Tools menu, select Compile Project.
Adding the Application_PreNavigate() function (SQL Server)
...
Application_PreNavigate = ContinueOperation
End Function
If the Scripting Language in use is eScript, use the following script:
...
1. Log on to your Siebel database using Query Analyzer. Make sure to log on with a privileged account.
2. Run the following script:
...
4. Make sure the EnableScripting option is set to TRUE.
About sampling Siebel batch processes (Oracle)
For Siebel batch processes to be sampled by the Interpoint for Siebel Collectors, create a tab-delimited text file that contains the mapping of each Siebel server to its host machine, as it appears in Oracle.
...
PRECISE\POOL-SIEBEL1
PRECISE\POOL-SIEBEL2
If there is no entry in V$SESSION with the physical machine name, use the results from the HOST_NAME column. After inserting the previous results into the siebel_machines.txt file, the contents is as follows:
...
AsDev2 PRECISE\POOL-SIEBEL2
Modifying the Siebel Repository File (Oracle)
Once the Siebel AppTier Collectors are installed, modify the Siebel Repository File (SRF), so that Interpoint for Siebel will be able to receive notifications of Siebel-related user events.
Part of the .srf file, is a collection of callback scripts, which are triggered by various events in a user's session. A user can view or change these scripts using the Siebel Tools.• For
- For each targeted Siebel application, modify the .srf file on the Siebel server. Define the application name by hard coding it in the Application_PreNavigate function.
...
- The modified SRFs need to be distributed to each of the Siebel servers
If you have installed Interpoint for an Oracle database, modifying the SRF consists of the following tasks:• Creating
- Creating the Precise Interpoint project (Oracle)
...
- Creating the CX_PSS_SBL table (Oracle)
...
- Creating the business component (Oracle)
...
- Creating the business object (Oracle)
...
- Adding the Application_PreNavigate() function (Oracle)
...
- Replacing the table with a global temporary table (Oracle)
...
- Completing the modification (Oracle)
...
- Debugging the script (Oracle)
...
Creating the Precise Interpoint project (Oracle)
1. Open Siebel Tools.
2. In the Siebel Tools, on the Types tab in the Object Explorer, select Project.
...
NOTE All objects created in subsequent steps will be grouped under this project.
Creating the CX_PSS_SBL table (Oracle)
NOTE This procedure applies to versions up to version 8.0 and version 8.0 and higher. For steps where there are differences between versions, the difference has been clearly specified.
...
Figure 1-1 General Dialog Box
4. In the Enter a name for the new Table field, type: CX_PSS_SBL.
...
9. For versions prior to version 8.0, iIn the Tables workspace, click Apply. For version 8.0 and higher, in the Tables workspace, click Apply/DDL. In the displayed dialog box, click Apply.
10. The Apply Schema dialog box is displayed.
Figure 1-2 Apply Schema dialog box
11. If needed, type a valid privileged user ID and privileged user password into the relevant text boxes.
...
21. Click Apply. The dialog box closes and the records are created.
22. In the Tables panel, click Activate to activate the table with the new columns.
Figure 1-3 Siebel Repository - Column List Dialog Box
Creating the business component (Oracle)
1. In Siebel Tools, from the File menu, choose New Object. The New Object Wizard opens.
...
Figure 1-4 New Business Component Dialog Box
4. In the Enter a name for the new Business Component field, type: PRECISE_SBL.
...
6. From the Select the Table this Business Component will operate on drop-down list, select CX_PSS_SBL.
7. Click Next. The Single Value Fields dialog box opens.
Figure 1-5 Single Value Fields Dialog Box
8. From the Select a column in the Base table drop-down list, select ACTION. A default field name automatically appears in the Enter a name for the Field text box.
...
12. Click Finish to create the Business Component.
Creating the business object (Oracle)
1. In Siebel Tools, on the Types tab in the Object Explorer, select Business Object. The Business Objects panel opens.
...
Figure 1-6 Siebel Repository - Business Object Component List Dialog Box
6. From the Edit menu, choose New Record. A new record is added to the table in the Business Object Components Panel.
...
8. From the Tools menu, choose Compile Project.
Adding the Application_PreNavigate() function (Oracle)
1. In Siebel Tools, from the View menu, select Options. On the Scripting tab, note the value of the Scripting Language list. If no language is selected, select the eScript option.
...
For versions prior to version 8.0:
For version 8.0 and higher:
2. In the Object Explorer, on the Types tab, expand Application.
...
5. In the Server Script Editor, select the Application_PreNavigate function. The function's default script appears in the text panel.
Figure 1-8 Siebel Repository - Application [Siebel Sales Enterprise] - Script Dialog Box
NOTE If this function already contains a custom script, do not continue. Contact Precise Technical Support for alternative instructions.
...
var client_info; //(64)
oActionBO =
TheApplication().GetBusObject("PRECISE_SBL");
pssBC = oActionBO.GetBusComp("PRECISE_SBL");
action = DestViewName.substring(0,32);
...
DestBusObjName.substring(0,31) + "," +
appName.substring(0,17);
pssBC.NewRecord(1);
pssBC.SetFieldValue("Action", action);
pssBC.SetFieldValue("Client Info", client_info);
pssBC.WriteRecord();
pssBC = null;
oActionBO = null;
...
Const appName = "Siebel Field Service"
On Error Resume Next
Set oActionBO = TheApplication.GetBusObject("PRECISE_SBL")
Set pssBC = oActionBO.GetBusComp("PRECISE_SBL")
action = Left(DestViewName,32)
client_info="S," + Left(LoginName,14) + "," + Left(DestBusObjName,31) + "," + Left(appName,17)
pssBC.NewRecord 1
pssBC.SetFieldValue "Action", action
...
Set oActionBO = Nothing
Set pssBC = Nothing
Application_PreNavigate = ContinueOperation
...
8. Compile the project.
Replacing the table with a global temporary table (Oracle)
1. Log in to your Siebel database, using SQLPLUS. Make sure to log in with a privileged account.
...
DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:new.client_info); DBMS_APPLICATION_INFO.SET_ACTION (:new.action);
END;
/
Completing the modification (Oracle)
1. Save all changes.
2. Compile the Siebel project. This will create a new Siebel.srf file.
...
c. Verify that the EnableScripting option in the application CFG file is set to TRUE.
d. Start the Server.
Debugging the script (Oracle)
1. Before attempting to debug, select Options from the View menu.
...
5. Make sure the EnableScripting option is set to TRUE.
Precise. Performance intelligence from click to storage. Learn more > >
...