ODI – Session Logs


To view a specific session log file:

  1. Log into Fusion Applications Control.
  2. From the navigation pane, expand the farm, and then ODI.
  3. Click MASTER REPOSITORY.

    The Master Repository page displays.

  4. From the Agents section, from the Running column (Running column), click the number for the agent with the session to search the sessions, for example, FusionCrmOdiAgent

    The Search Sessions page displays.

  5. On the Search Sessions page, in the Sessions section, locate the session number corresponding to the job. Notice that while the session has a value in the Begin Date column, it does not have a value in the End Date column.
  6. Click the session number corresponding to the job.

    You are prompted to log in to the ODI Console.

  7. From the Repository list, choose Work Repository.
  8. Enter the credentials, and then click Sign In.
  9. On the Session page, in the Execution Statistics section, note the values for the Session ID and Session Name in the Definition section, and the time of session in the Execution Statistics section.
  10. Expand the Relationships and view the steps in the Session Steps tab.
  11. For a step that did not successfully complete, click the link in the Step Name column to perform a deeper analysis.
  12. On the Step page, expand the Relationships and view the tasks for the step in the Session Tasks tab.

    Description of odisessiontask.jpg follows

  13. For a step that did not successfully complete, click the link in the Step Name column to perform a deeper analysis.
  14. On the Session Task Detail page, review the Message field in the Execution Statistics section and the Target Command command in the Target Details section for errors.

    Description of odisessiondetail.jpg follows

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s