2 Replies Latest reply on Apr 13, 2014 8:47 PM by megamalex1

    BI Apps 11.1.1.7.1 - Sessions still running

    megamalex1

      Hi,


      Looking at an ETL issue for BI Apps 11.1.1.7.1. where a Load Plan has been running over the weekend and still show's a status of running however there's no database activity or apparent errors. The sessions that are still running are those below (also some target table record counts) -


      (1)    SDE_ORA_GLBALANCEFACT

      select count(*) from C$_1311500_2_0

      21,258,432

       

      (2)    SDE_ORA_ACCRUALTRANSACTIONFACT

      select count(*) from C$_1447500_2_0

      765,639

       

      (3)    SDE_ORA_PAYROLLRUNBALANCEDETAILFACT

       

      select count(*) from C$_1444500_3_0

      0

       

      (4)    SDE_ORA_GLJOURNALSFACT

       

      select count(*) from C$_1321500_2_0

      23,642,869


      What could cause the sessions to remain in a state of running? are they somehow orphaned?


      I believe it may be possible to either delete/update a step in the operator for these sessions to manually change the status as it would be preferable to be able to correct and restart the Load Plan from where it's up to.


      Thanks


      R