Page History

This section includes the following topics:

• 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)

Anchor
AboutperformingactionsonaSiebelinstance AboutperformingactionsonaSiebelinstance

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.

Anchor
SettingupSiebelbatchprocesssampling SettingupSiebelbatchprocesssampling

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.

Anchor
AboutsamplingSiebelbatchprocessesSQLServer AboutsamplingSiebelbatchprocessesSQLServer

About sampling Siebel batch processes (SQL Server)

If you have installed Interpoint for a SQL Server database, perform the following procedures.

...

sieb2 APPSRV2 00096B26E67C

Anchor
ModifyingtheSiebelRepositoryFileSQLServer ModifyingtheSiebelRepositoryFileSQLServer

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.

...

4.    Make sure the EnableScripting option is set to TRUE.

Anchor
AboutsamplingSiebelbatchprocessesOracle AboutsamplingSiebelbatchprocessesOracle

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.

...

AsDev2 PRECISE\POOL-SIEBEL2

Anchor
ModifyingtheSiebelRepositoryFileOracle ModifyingtheSiebelRepositoryFileOracle

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.

...

If you have installed Interpoint for an Oracle database, modifying the SRF consists of the following tasks:

• 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)

Anchor
CreatingthePreciseInterpointprojectOracle CreatingthePreciseInterpointprojectOracle

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.

Anchor
CreatingtheCXPSSSBLtableOracle CreatingtheCXPSSSBLtableOracle

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-3    Siebel Repository - Column List Dialog Box

Anchor
CreatingthebusinesscomponentOracle CreatingthebusinesscomponentOracle

Creating the business component (Oracle)

1.    In Siebel Tools, from the File menu, choose New Object. The New Object Wizard opens.

...

12.    Click Finish to create the Business Component.

Anchor
CreatingthebusinessobjectOracle CreatingthebusinessobjectOracle

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.

...

8.    From the Tools menu, choose Compile Project.

Anchor
AddingtheApplicationPreNavigatefunctionOracle AddingtheApplicationPreNavigatefunctionOracle

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.

...

8.    Compile the project.

Anchor
ReplacingthetablewithaglobaltemporarytableOracle ReplacingthetablewithaglobaltemporarytableOracle

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;

/

Anchor
CompletingthemodificationOracle CompletingthemodificationOracle

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.

Anchor
DebuggingthescriptOracle DebuggingthescriptOracle

Debugging the script (Oracle)

1.    Before attempting to debug, select Options from the View menu.

...