Informatica Session Completing Successfully, but Still in Running Status
Hello All,
Env: OBIEE 10.1.3.4, Apps 7.9.5.1, Informatica 8.1.1 SP5, Windows Server 2003, SQL Server 2005, OOB DAC Siebel 8.0 Execution Plan
On seemingly random Informatica Sessions, a Session will complete successfully. However, the Session Monitor and Session Properties both continue to show the Session in 'Running' status. This basically hangs the Execution Plan, as the DAC is waiting for the Workflow to complete and it never does.
It seems as though the connection between the actual Session DTM and Session Monitor is somehow getting disconnected. These zombie Sessions can't be Aborted or Stopped in the Session Monitor. The only want to kill them is a restart of the Informatica services
We've tried many things to resolve, including reducing the number of concurrent Informatica tasks to 1, to no avail.
Has anyone else faced this issue? Any ideas to help resolve?
Thanks,
Steve C