ETL Process failing --> SDE_ORA_GLJournals_Full
Hello all,
I log shows DB connection parameter error, not sure why, i have a couple of tasks completed successfully.
INFO : LM_36488 [Wed Aug 19 12:28:47 2009] : (5928|2644) Session task instance [SDE_ORA_GLJournals_Full] : [VAR_27028 Use override value ['N'] for mapping parameter:[mplt_BC_ORA_GLXactsJournalsExtract.$$FILTER_BY_LEDGER_TYPE].]
INFO : LM_36488 [Wed Aug 19 12:28:47 2009] : (5928|2644) Session task instance [SDE_ORA_GLJournals_Full] : [VAR_27028 Use override value [01/01/1970] for mapping parameter:[mplt_BC_ORA_GLXactsJournalsExtract.$$INITIAL_EXTRACT_DATE].]
INFO : LM_36488 [Wed Aug 19 12:28:47 2009] : (5928|2644) Session task instance [SDE_ORA_GLJournals_Full] : [VAR_27028 Use override value [] for mapping parameter:[mplt_BC_ORA_GLXactsJournalsExtract.$$LAST_EXTRACT_DATE].]
INFO : LM_36488 [Wed Aug 19 12:28:47 2009] : (5928|2644) Session task instance [SDE_ORA_GLJournals_Full] : [VAR_27028 Use override value [1] for mapping parameter:[mplt_BC_ORA_GLXactsJournalsExtract.$$LEDGER_ID_LIST].]
INFO : LM_36488 [Wed Aug 19 12:28:47 2009] : (5928|2644) Session task instance [SDE_ORA_GLJournals_Full] : [VAR_27028 Use override value ['NONE'] for mapping parameter:[mplt_BC_ORA_GLXactsJournalsExtract.$$LEDGER_TYPE_LIST].]
ERROR : LM_36488 [Wed Aug 19 12:28:47 2009] : (5928|2644) Session task instance [SDE_ORA_GLJournals_Full] : [CMN_1761 Timestamp Event: [Wed Aug 19 12:28:47 2009]]
>>>>>>>>>>>>>>>>>>>>>>>>
ERROR : LM_36488 [Wed Aug 19 12:28:47 2009] : (5928|2644) Session task instance [SDE_ORA_GLJournals_Full] : [TM_6193 An error occurred while expanding the connection parameter [Database connection name ORA_R12 for database connection variable $DBConnection_OLTP is not well defined.
].]
>>>>>>>>>>>>>>>>>>>>>>>>>>
ERROR : LM_36488 [Wed Aug 19 12:28:47 2009] : (5928|4028) Session task instance [SDE_ORA_GLJournals_Full] : [CMN_1761 Timestamp Event: [Wed Aug 19 12:28:47 2009]]
ERROR : LM_36488 [Wed Aug 19 12:28:47 2009] : (5928|4028) Session task instance [SDE_ORA_GLJournals_Full] : [TM_6270 Error: Variable parameter expansion error.]
ERROR : LM_36320 [Wed Aug 19 12:28:48 2009] : (5928|2384) Session task instance [SDE_ORA_GLJournals_Full]: Execution failed.
WARNING : LM_36331 : (5928|2384) Session task instance [SDE_ORA_GLJournals_Full] failed and its "fail parent if this task fails" setting is turned on. So, Workflow [SDE_ORA_GLJournals_Full] will be failed.
ERROR : LM_36320 [Wed Aug 19 12:28:48 2009] : (5928|2384) Workflow [SDE_ORA_GLJournals_Full]: Execution failed.
any ideas
regards
girish