Posted by : Arjun Lagisetty Thursday, January 9, 2014


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 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 # Connection retry parameters

{ 4 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

  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.

  3. I agree so much. we should all be reinforcing positive feedback within the comment sections. So many good points to take into consideration.
    When people have good things to say about my web site Prasoon Kumar Arya it really makes positive impact.

  4. However, we're assured that the rest of|the the rest of} the choices are fairly interesting as properly – relying in your needs and 메리트카지노 preferences, of course. The different websites presented are also worth testing for various reasons, and so they all have professionals and cons to think about. However, regardless of which one you choose, we expect you may have a great time|a good time}. However, you'll be able to|you probably can} nonetheless use the cell model of the site when you don't wish to download the app. Since the websites use HTML5, the display will mechanically adapt to most cell units, and you may tilt it horizontally to modify to the full-screen mode. If you wish to cash in your winnings, you should use|you must use} Visa, Mastercard, wire transfers, and Bitcoin with out charges.


Popular Post


Blog Archive

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