Using the Oracle Service Bus Console

     Previous  Next    Open TOC in new window    View as PDF - New Window  Get Adobe Reader - New Window
Content starts here

Reporting

Before you can use the Reporting module, you must first create a proxy service and then add a report action to the message flow of that proxy service. See Adding and Editing Actions in Message Flows and Adding Report Actions. See also Reporting in the Oracle Service Bus Operations Guide.

Viewing Reporting Messages

Use the Message Report Summary page to view reporting messages information shown in Table 25-2. The page displays up to 100 messages.

  1. To restrict the number of items in the list or locate specific messages:
    • Click the Open icon to display additional search filters. If you specify multiple search criteria, only results that match all the criteria will be returned.
    • To set the filter parameters, do one or more of the following steps shown in Table 25-1.

      • Table 25-1 Message Filter Parameters 
      To...
      Complete These Steps...
      Filter by time parameters
      Set a time period:
      1. Select the Messages From... To... radio button.
      2. In the Messages From field, enter a date and time in the format MM/DD/YY HH:MM:SS AM|PM. For example, you can enter 10/10/07 12:45:00 AM.
      3. In the Messages To field, enter a date and time in the format MM/DD/YY HH:MM:SS AM|PM.
      Alternatively, you can select parameters for the most recent messages:
      1. Select the For the Last radio button.
      2. In the For the Last field, enter the number of days, then specify hours and minutes.

      Note: By default, message reports for the last 30 minutes are displayed.
      Filter by service name
      In the Inbound Service Name field, enter the service name.
      Filter by error code
      In the Error Code field, enter an error code.
      Filter by report index
      In the Report Index field, enter the report indexes. These are the key value pairs you defined when you configured the report action for this proxy service. This is a string search.

    • You can use wildcard characters in service name, error code, and report index field searches.
      • Entering only asterisk (*) returns all messages. For example, if you enter * in the error code field, messages with and without error codes are displayed.
      • In the Error Code field only, strict search limitations apply. For example, to find messages with the error code BEA12345, you can enter *, BE*, or BEA12345.
  2. Click Search. The page displays the messages that fall within the filter parameters you set. The maximum number of messages that can be displayed when filtering messages is 1000.
  3. Click View All to remove the search filters and display all messages.
  4. To locate a message, you can also do the following:
    • Resort the list of messages. Click on an underlined column name. Ascending and descending arrows indicate the sort order. Click the column name to change the sort order.
    • Scroll through the pages. Use the page controls above or below the table. Go to a page by selecting the page number or by using the arrow buttons to go to the next, previous, first, or last page.

      • Table 25-2 Message (Reporting) Summary Details 
      Property
      Description
      Report Index
      A link to the View Message Details page. See Viewing Message Details.
      Report indexes are key value pairs that you use to extract key identifiers from a message context variable. Keys are a convenient way to filter messages. You use the report action to add key value pairs. See Adding and Editing Actions in Message Flows.
      DB TimeStamp
      The date and time that the message was added in the database.
      Inbound Service
      The inbound service associated with the message. The service is a link to the View a Proxy Service - Configuration Details page. See Editing Proxy Service Configurations.
      Error Code
      The error code associated with this message, if there is one.
      You specify error codes when you configure the raise error action. See Handling Errors in the Oracle Service Bus User Guide and Adding Proxy Service Error Handlers.

Related Topics

See also How to Enable Reporting in the Oracle Service Bus Operations Guide.

Viewing Message Details

Use this page to view details of a specific message.

  1. Locate the message. See Viewing Reporting Messages.
  2. Click the report index. The View Message Details page displays the General Configuration information shown in Table 25-3.

    3. Table 25-3 Message Configuration Parameters 
    Property
    Description
    Message ID
    The unique identification for this message.
    Database Timestamp
    The date and time that the message was registered in the database.
    Time at point of Logging
    The date and time that the message was logged.
    Server name
    The name of the server in which this message was generated.
    State
    State of the pipeline in which this message was generated:
    REQUEST—indicates that the reporting action is executed in a request pipeline.
    RESPONSE—indicates that the reporting action is executed in a response pipeline.
    ERROR—the action is running in the service-level error handler.
    Node Name
    The node name of the pipeline in which this message was generated.
    Pipeline Name
    The name of the pipeline in which this message was generated.
    Stage Name
    The name of the stage in which this message was generated.

    The page displays the Inbound Service information shown in Table 25-4.

    Table 25-4 Inbound Service Details 
    Property
    Description
    Name
    The inbound proxy service associated with this message. This is a link to the View a Proxy Service - Configuration Details page. See Editing Proxy Service Configurations.
    URI
    The URI associated with the proxy service.
    Operation
    The inbound operation associated with this message.

    The page displays the Outbound Service information shown in Table 25-5.

    Table 25-5 Outbound Service Details 
    Property
    Description
    Name
    The outbound business service associated with this message. This is a link to the View a Business Service - Configuration Details page. See Editing Business Service Configurations.
    URI
    The URI to the outbound business service end point.
    Operation
    Name of the operation invoked on the outbound service.

    The page displays the Report Index information shown in Table 25-6.

    Table 25-6 Report Index Details 
    Property
    Description
    Report Index Text
    Report indexes are key value pairs that you use to extract key identifiers from a message context variable. Keys are a convenient way to filter messages. You use the report action to add key value pairs. See Adding and Editing Actions in Message Flows.

    The page displays the Fault information shown in Table 25-7.

    Table 25-7 Fault information Details 
    Property
    Description
    Error Code
    The error code associated with the message, if there is one.
    You specify error codes when you configure the raise error action. See “ Handling Errors” in the Oracle Service Bus User Guide and Adding Proxy Service Error Handlers.
    Reason
    The reason for the error code.
    Detail
    The fault details associated with the error code. These details, if present, are typically a stack trace of where a particular fault occurred, and may be truncated due to a size limitation in the database. The limit is 2048 characters.

    The page displays the Report Body information shown in Table 25-8.

    Table 25-8 Report Body Details 
    Property
    Description
    Report Body Text
    This link opens another browser that displays the details of the report body. You use an expression in the report action to capture the report body text. See the procedure for the report action in Adding and Editing Actions in Message Flows.

  3. Click OK when you have finished viewing the details of a specific message.

Purging Messages

Use this page to purge selected messages from the reporting datastore.

Message purging occurs in the background so the Message Report Summary page is not locked up while the purge occurs. Therefore, you can do a purge that takes a while to finish; the length of time depends on how many messages need to be purged. However, if you filter reporting messages, the purging process is slowed down; the Message Report Summary page may display incorrect data as some of the data hasn’t been purged yet.

The Purge Messages feature may be useful during design and test phases of your project. However, in a production environment, Oracle recommends that the management of the data in your database (including purging) is handled by the Database Administrator using database management tools.

  1. Select Operations > Purge Messages.
  2. Do one of the following steps, shown in Table 25-9.

    3. Table 25-9 Message Purging Options 
    To...
    Complete These Steps...
    Purge all messages
    1. Select the Purge All Messages radio button.
    2. Click Purge.
    Purge messages within a specified time frame
    1. Select the Purge Messages From... To... radio button.
    2. In the Purge Messages From field, enter a month, day, year, and time in the format MM/DD/YY HH:MM:SS. For example, you can enter 10/10/07 12:45:00 AM.
    3. In the Purge Messages To field, enter a month, day, year, and time in the format MM/DD/YY HH:MM:SS.
    4. Click Purge.

Related Topics

To learn more about purging messages, see Reporting in the Oracle Service Bus Operations Guide.


  Back to Top       Previous  Next