Posted by : Arjun Lagisetty Thursday, January 9, 2014

Overview:

We have all had this problem with long running jobs. When the network connection has a problem or an agent gets disconnected from master and work repository momentarily, we end up with stale sessions.
How do we deal with these annoying stale sessions. There are many solutions lets deal with them by category.

Tricky part about stale sessions is being able to identify them. You can identify stale sessions only when you check the target database for the sql sessions triggered by ODI sessions. Other way is check the log for connectivity drop. I will be addressing how to handle each one the problems below.

Emergency quick fix solution: I know you got this issue identified it as a stale session you are tearing your  hair out. What to do?

Most of the solutions are written for standalone agents. However, these can be fine tuned for the Java agents as well.

Solving the problem:

Agent restart: 

This is the most common solution recommended every where else. When you bring down the ODI agent and start it again, it cleans up the stale sessions. Wait for it, there is an easier option see below.

Clean stale sessions: 

You trigger cleaning the stale session from the operator itself. Pictures speak a thousand words. This is available as on 11.1.1.7. Please confirm this for your studio release. This should cleanup should be suffice.



Preventing the problem:

Odi Parameters:

OdiParams.bat has two little known parameters called retry parameters. What these two little guys do is to help agent to reconnect to the database when the connection is lost. When the connection is lost, below parameters are set up to let the agent retry to connect to the repositories three times max until successful connection every 7 seconds. Please fine tune this to the desired level depending on your network outage schedules.
REM #
REM # Connection retry parameters
REM #
set ODI_CONNECTION_RETRY_COUNT=3
set ODI_CONNECTION_RETRY_DELAY=7000



{ 2 comments ... read them below or Comment }

  1. How Packers and Movers India can assist you with your long-distance relocation services provide packing moving services at the make you best local shifting services exoprt amazing only.
    Packers and Movers Pune
    Packers and Movers Bangalore
    Packers and Movers Chennai
    Packers and Movers Hyderabad
    Packers and Movers Mumbai

    ReplyDelete
  2. How did you can avail the give your dream a shape with the help of make your move Adword India's No 1 services.

    http://www.adword.co.in/

    ReplyDelete

Popular Post

Labels

Blog Archive

Copyright © ODI Pundits - Oracle Data Integrator - Maintained by Arjun Lagisetty