Siebel System Monitoring and Diagnostics Guide > Monitoring and Analyzing Data Using Siebel Diagnostic Tool >

Using Event Log Analysis to Monitor Session Errors and Events


This topic describes the Event Log Analysis feature for Siebel Diagnostic Tool and describes how to use Event Log Analysis to monitor, analyze, and diagnose session errors and events.

About Event Log Analysis

Event Log Analysis provides access to user session log and error detail data for specific user sessions at the enterprise, server group, server, and component levels. It also provides the ability to diagnose and identify the cause of a user session problem.

Event Log Analysis is the only Siebel Diagnostic Tool feature that retrieves data across all servers within a specified enterprise. For example, you can query for session details for a particular user or for all users. If you query User Name with the value, User A, then all tasks started by User A are retrieved. Whereas, if you do not specify any value for User Name, then all matching tasks within the enterprise are retrieved.

Typically, you query for user session details in the following ways:

  • Between a specified start and end time
  • Users under a server or server group
  • Users for a particular component

However, you can also query by specifying:

  • An operating system process ID
  • A task ID

About Date Range Queries

Date range queries allow you to limit the number of results retrieved for a particular search by specifying a Start Time and an End Time. For example, if you specify a start time of 11:00 in the morning and end time of 2:00 in the afternoon, then only log files with a start time between 11:00 A.M. and 2:00 P.M. are retrieved.

TIP:   By default, when you click the Now link next to the Start Time and End time date fields, the time displayed is the current time. You change these fields for your specific queries, keeping the server time zone in mind when you do so.

Table 33 shows the results given for different date range queries.

Table 33. Examples of Date Range Query Results
Start Time
End Time
Result

2006-11-10 11:00.00

2006-11-10 14:00.00

All tasks that have a start time between 11:00 A.M. and 2:00 P.M.

2006-11-10 11:00.00

NULL

All tasks with a start time after 11:00 A.M. until now

NULL

2006-11-10 14:00.00

All tasks with a start time before 2:00 P.M.

NULL

NULL

All tasks

2006-11-10 11:00.00

2006-11-10 11:00.00

Only tasks that have a start time of exactly 11:00 A.M.

For more information about other Siebel Diagnostic Tool Query Parameter fields, see About Siebel Diagnostic Tool Query Parameter Fields.

How to Use Event Log Analysis

When you submit a query using the Event Log Analysis screen, all matching sessions across the various Siebel Servers are retrieved. The data retrieved is stored in the S_SRM_TASK_HIST table in the Siebel database, and the results are displayed in the Session Query Results view where you can see the encountered errors for a task, or view the task log file.

If errors are encountered, the Errors and Download links on the form applet in the Session Query Results view become active. You can then click one of these links to view the following:

  • The Errors link displays detailed information about the errors that occurred for this session or event.
  • The Download link displays the log file that is associated with this session or event.

To use Event Log Analysis to monitor a session or task

  1. Launch Siebel Diagnostic Tool, if not already active.
  2. Click the Event Log Analysis screen tab.
  3. From the Enterprise drop-down list, select the enterprise that hosts the session or task that you want to analyze.
  4. From the Group drop-down list, select the group you want within the enterprise you specified in Step 3. Alternatively, you can specify All Groups.
  5. From the Server drop-down list, select the server you want within the enterprise you specified in Step 3. Alternatively, you can search across all servers in all groups.
  6. From the Component drop-down list, select a component. Alternatively, you can search all components by choosing All Components.
  7. Specify the values in the Start Time and End Time fields to constrain data retrieval for analysis. Alternatively, leave these fields blank to retrieve all available data for analysis.

    TIP:   Click the Now link to populate these fields with the current date and time, then edit accordingly.

  8. Enter a User Name, if applicable.
  9. (Optional) If you know what operating system process that you want to diagnose, enter it in the OS PID field, otherwise leave this field blank.
  10. (Optional) If you know the specific Task ID that you want to diagnose, enter it in the Task ID field, otherwise, leave this field blank.
  11. Click Submit.

    Siebel Diagnostic Tool retrieves the requested data that matches your query criteria and presents it in the Session Query Results view.

    NOTE:  If there are errors for the session, the Errors and Download words become active links in the Log Details column. Also, you can click the Refine Query button to retrieve the original query and modify it.

  12. If the Errors or Download links are active, take the following actions:
    1. Click the Errors link.

      The Session Errors view appears providing detailed information about the errors that occurred for this event.

    2. Click the Download link.

      The Log Details view appears showing the log file that is associated with this event.

Siebel System Monitoring and Diagnostics Guide Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.