I am getting 'ODI-1266: stale session' error on production environment. The production run is scheduled at night. I had to kill these stale session manually and the frequency of restarting such stale session again in the morning is more .
Is there any automated mechanism in ODI to kill such stale session and restart the execution of such packages again. Is there any way to avoid such ODI-1266 stale session error?