3 Replies Latest reply on Apr 13, 2013 8:22 AM by Veeresh Rayan

    SDE_ORA_GLCOGSFact_Full task has failed

    user9092293
      Hi all,

      While running the ETL, SDE_ORA_GLCOGSFact_Full task has failed. I checked everything but could not find any reason. I am new to this.

      Below is the log file for that error. Also I can see a reverse triangle symbol for that task in the workflow session.
      --------------------------------------------------------------

      INFO : LM_36435 [Wed Apr 10 21:37:03 2013] : (15836|1428375872) Starting execution of workflow [SDE_ORA_GLCOGSFact_Full] in folder [SDE_ORAR12_Adaptor] last saved by user [Administrator].
      INFO : LM_44206 [Wed Apr 10 21:37:03 2013] : (15836|1428375872) Workflow SDE_ORA_GLCOGSFact_Full started with run id [18641], run instance name [], run type [Concurrent Run Disabled].
      INFO : LM_44195 [Wed Apr 10 21:37:03 2013] : (15836|1428375872) Workflow [SDE_ORA_GLCOGSFact_Full] service level [SLPriority:5,SLDispatchWaitTime:1800].
      INFO : VAR_27085 [Wed Apr 10 21:37:03 2013] : (15836|1428375872) Parameter file [u01/app/Informatica/PowerCenter861/server/infa_shared/SrcFiles/ORA_R12.DataWarehouse.SDE_ORAR12_Adaptor.SDE_ORA_GLCOGSFact_Full.txt] is opened for [workflow [SDE_ORA_GLCOGSFact_Full]].
      INFO : LM_44253 : (15836|1428375872) Workflow started. Clients will be notified
      INFO : LM_36330 [Wed Apr 10 21:37:03 2013] : (15836|1428375872) Start task instance [Start]: Execution started.
      INFO : LM_36318 [Wed Apr 10 21:37:03 2013] : (15836|1428375872) Start task instance [Start]: Execution succeeded.
      INFO : LM_36505 : (15836|1428375872) Link [Start --> SDE_ORA_GLCOGSFact_Full]: empty expression string, evaluated to TRUE.
      INFO : LM_36388 [Wed Apr 10 21:37:03 2013] : (15836|1428375872) Session task instance [SDE_ORA_GLCOGSFact_Full] is waiting to be started.
      INFO : LM_36682 [Wed Apr 10 21:37:03 2013] : (15836|1428375872) Session task instance [SDE_ORA_GLCOGSFact_Full]: started a process with pid [18234] on node [node01_oraclebi64].
      INFO : LM_36330 [Wed Apr 10 21:37:03 2013] : (15836|1428375872) Session task instance [SDE_ORA_GLCOGSFact_Full]: Execution started.
      INFO : LM_36488 [Wed Apr 10 21:37:05 2013] : (15836|1417886016) Session task instance [SDE_ORA_GLCOGSFact_Full] : [TM_6793 Fetching initialization properties from the Integration Service. : (Wed Apr 10 21:37:04 2013)]
      INFO : LM_36488 [Wed Apr 10 21:37:05 2013] : (15836|1417886016) Session task instance [SDE_ORA_GLCOGSFact_Full] : [DISP_20305 The [Preparer] DTM with process id [18234] is running on node [node01_oraclebi64].
      : (Wed Apr 10 21:37:04 2013)]
      INFO : LM_36488 [Wed Apr 10 21:37:05 2013] : (15836|1417886016) Session task instance [SDE_ORA_GLCOGSFact_Full] : [PETL_24036 Beginning the prepare phase for the session.]
      INFO : LM_36488 [Wed Apr 10 21:37:05 2013] : (15836|1417886016) Session task instance [SDE_ORA_GLCOGSFact_Full] : [TM_6721 Started [Connect to Repository].]
      INFO : LM_36488 [Wed Apr 10 21:37:05 2013] : (15836|1417886016) Session task instance [SDE_ORA_GLCOGSFact_Full] : [TM_6722 Finished [Connect to Repository]. It took [0.599313] seconds.]
      INFO : LM_36488 [Wed Apr 10 21:37:05 2013] : (15836|1417886016) Session task instance [SDE_ORA_GLCOGSFact_Full] : [TM_6794 Connected to repository [Oracle_BI_DW_Base] in domain [Domain_oraclebi64] as user [Administrator] in security domain [Native].]
      INFO : LM_36488 [Wed Apr 10 21:37:05 2013] : (15836|1417886016) Session task instance [SDE_ORA_GLCOGSFact_Full] : [TM_6721 Started [Fetch Session from Repository].]
      ERROR : LM_36488 [Wed Apr 10 21:37:05 2013] : (15836|1417886016) Session task instance [SDE_ORA_GLCOGSFact_Full] : [CMN_1761 Timestamp Event: [Wed Apr 10 21:37:05 2013]]
      ERROR : LM_36488 [Wed Apr 10 21:37:05 2013] : (15836|1417886016) Session task instance [SDE_ORA_GLCOGSFact_Full] : [TM_6795 The Repository Service marked the session or session instance as impacted, and the Integration Service is not configured to run impacted sessions.]
      ERROR : LM_36320 [Wed Apr 10 21:37:05 2013] : (15836|1396906304) Session task instance [SDE_ORA_GLCOGSFact_Full]: Execution failed.
      WARNING : LM_36331 : (15836|1396906304) Session task instance [SDE_ORA_GLCOGSFact_Full] failed and its "fail parent if this task fails" setting is turned on. So, Workflow [SDE_ORA_GLCOGSFact_Full] will be failed.
      ERROR : LM_36320 [Wed Apr 10 21:37:05 2013] : (15836|1396906304) Workflow [SDE_ORA_GLCOGSFact_Full]: Execution failed.
      ---------------------------------------------------------------

      Kindly look into this.


      Thanks
      Sunil