Analytics Software

Hello all I am trying to get Oracle BI Applications running on eBS 11.5.10.

But dac fails to complete. When I look in the sesslog I see the following output:

TM_6708 Warning: undocumented configuration parameter used [SiebelUnicodeDB,APPS@VIS OLAP@VIS]

TM_6703 Session [SDE_ORA_GLJournals_Full] is run by 32-bit Informatica Server [Oracle_BI_DW_Server].
MASTER> CMN_1688 Allocated [32000000] bytes from process memory for [DTM Buffer Pool].
MASTER> PETL_24000 Parallel Pipeline Engine initializing.
MASTER> PETL_24001 Parallel Pipeline Engine running.
MASTER> PETL_24003 Initializing session run.
MAPPING> TM_6014 Initializing session [SDE_ORA_GLJournals_Full] at [Mon Apr 14 21:23:13 2008]

MAPPING> TM_6683 Repository Name: [Oracle_BI_DW_Base]
MAPPING> TM_6684 Server Name: [Oracle_BI_DW_Server]
MAPPING> TM_6686 Folder: [SDE_ORA11510_Adaptor]
MAPPING> TM_6685 Workflow: [SDE_ORA_GLJournals_Full]
MAPPING> TM_6101 Mapping name: SDE_ORA_GLJournals [version 1]
MAPPING> CMN_1569 Server Mode: [UNICODE]
MAPPING> CMN_1570 Server Codepage: [MS Windows Latin 1 (ANSI), superset of Latin1]
MAPPING> TM_6151 Session Sort Order: [Binary]
MAPPING> TM_6185 WARNING! Data codepage validation is disabled in this session.
MAPPING> TM_6156 Using LOW precision decimal arithmetic
MAPPING> TM_6180 Deadlock retry logic will not be implemented.
MAPPING> TM_6307 DTM Error Log Disabled.
MAPPING> TE_7022 TShmWriter: Initialized
MAPPING> TM_6007 DTM initialized successfully for session [SDE_ORA_GLJournals_Full]
MASTER> PETL_24004 Starting pre-session tasks.
MASTER> PETL_24027 Pre-session task completed successfully.
MASTER> PETL_24006 Starting data movement.
MAPPING> TM_6351 WARNING: Insufficient number of data blocks for adequate performance. Increase DTM buffer size of the session. The recommended value is 42760801.
MAPPING> TM_6660 Total Buffer Pool size is 32000000 bytes and Block size is 1280000 bytes.
READER_1_1_1> DBG_21438 Reader: Source is [VIS], user [APPS]
READER_1_1_1> BLKR_16051 Source database connection [ORA_11_5_10] codepage: [UTF-8 encoding of Unicode]
READER_1_1_1> BLKR_16003 Initialization completed successfully.
WRITER_1_*_1> WRT_8146 Writer: Target is database [VIS], user [OLAP], bulk mode [ON]
WRITER_1_*_1> WRT_8106 Warning! Bulk Mode session - recovery is not guaranteed.
WRITER_1_*_1> WRT_8221 Target database connection [DataWarehouse] codepage: [UTF-8 encoding of Unicode]
WRITER_1_*_1> WRT_8124 Target Table W_ORA_GL_JOURNALS_F_TMP :SQL INSERT statement:
INSERT INTO W_ORA_GL_JOURNALS_F_TMP(SET_OF_BOOKS_ID,CODE_COMB_ID,GL_ACCT_ID,PERIOD_NAME,EFFECTIVE_DATE,ACCT_PERIOD_END_DT,STATUS,ENTERED_DR,ENTERED_CR,ACCOUNTED_DR,ACCOUNTED_CR,JE_CATEGORY,JE_SOURCE,CREATED_BY,LAST_UPDATED_BY,CREATION_DATE,LAST_UPDATE_DATE,POSTED_DATE,CURRENCY_CODE,GL_JE_BATCHES_NAME,GL_JE_LINES_NUM,GL_JE_HEADERS_NAME,REFERENCE_1,REFERENCE_2,REFERENCE_3,REFERENCE_4,REFERENCE_5,REFERENCE_6,REFERENCE_7,REFERENCE_8,REFERENCE_9,REFERENCE_10,GL_SL_LINK_ID,INTEGRATION_ID,DATASOURCE_NUM_ID) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
WRITER_1_*_1> WRT_8146 Writer: Target is database [VIS], user [OLAP], bulk mode [ON]
WRITER_1_*_1> WRT_8106 Warning! Bulk Mode session - recovery is not guaranteed.
WRITER_1_*_1> WRT_8124 Target Table W_ORA_GLRF_DERV_F_TMP :SQL INSERT statement:
INSERT INTO W_ORA_GLRF_DERV_F_TMP(GL_JE_HDR_ID,GL_JE_LINE_NUM,LAST_UPDATE_DATE,LAST_UPDATED_BY,SET_OF_BOOKS_ID,CODE_COMB_ID,GL_ACCOUNT_ID,PERIOD_NAME,EFFECTIVE_DATE,STATUS,CREATION_DATE,CREATED_BY,JE_CATEGORY,JE_SOURCE,GL_JE_HEADER_NAME,CURRENCY_CODE,POSTED_DATE,GL_JE_BATCHES_NAME,IMPORT_REF_SOURCE,IMPORT_REF_ID,IMPORT_REF_IA_ID,INTEGRATION_ID,DATASOURCE_NUM_ID) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
WRITER_1_*_1> WRT_8270 Target connection group #1 consists of target(s) [W_ORA_GL_JOURNALS_F_TMP, W_ORA_GLRF_DERV_F_TMP]
WRITER_1_*_1> WRT_8003 Writer initialization complete.
READER_1_1_1> BLKR_16007 Reader run started.
WRITER_1_*_1> WRT_8005 Writer run started.
WRITER_1_*_1> WRT_8158

*****START LOAD SESSION*****

Load Start Time: Mon Apr 14 21:23:28 2008

Target tables:

W_ORA_GL_JOURNALS_F_TMP
W_ORA_GLRF_DERV_F_TMP


READER_1_1_1> RR_4029 SQ Instance [mplt_BC_ORA_GLXactsJournalsExtract.SQ_GL_JE_LINES] User specified SQL Query [SELECT
GL_JE_LINES.JE_HEADER_ID,
GL_JE_LINES.JE_LINE_NUM,
GL_JE_LINES.LAST_UPDATE_DATE,
GL_JE_LINES.LAST_UPDATED_BY,
GL_JE_LINES.SET_OF_BOOKS_ID,
GL_JE_LINES.CODE_COMBINATION_ID,
GL_JE_LINES.PERIOD_NAME,
GL_JE_LINES.EFFECTIVE_DATE,
GL_JE_LINES.STATUS,
GL_JE_LINES.CREATION_DATE,
GL_JE_LINES.CREATED_BY,
GL_JE_LINES.ENTERED_DR,
GL_JE_LINES.ENTERED_CR,
GL_JE_LINES.ACCOUNTED_DR,
GL_JE_LINES.ACCOUNTED_CR,
GL_JE_LINES.REFERENCE_1,
GL_JE_LINES.REFERENCE_2,
GL_JE_LINES.REFERENCE_3,
GL_JE_LINES.REFERENCE_4,
GL_JE_LINES.REFERENCE_5,
GL_JE_LINES.REFERENCE_6,
GL_JE_LINES.REFERENCE_7,
GL_JE_LINES.REFERENCE_8,
GL_JE_LINES.REFERENCE_9,
GL_JE_LINES.REFERENCE_10,
GL_JE_LINES.GL_SL_LINK_ID,
GL_JE_HEADERS.JE_CATEGORY,
GL_JE_HEADERS.JE_SOURCE,
GL_JE_HEADERS.NAME,
GL_JE_HEADERS.CURRENCY_CODE,
GL_JE_HEADERS.POSTED_DATE,
GL_JE_BATCHES.NAME,
GL_PERIOD_STATUSES.START_DATE,
GL_PERIOD_STATUSES.END_DATE
FROM
GL_JE_BATCHES,
GL_JE_LINES,
GL_JE_HEADERS,
GL_PERIOD_STATUSES
WHERE
GL_JE_LINES.CREATION_DATE > TO_DATE('01/01/1970 00:00:00', 'MM/DD/YYYY HH24:MI:SS') AND
GL_JE_LINES.JE_HEADER_ID = GL_JE_HEADERS.JE_HEADER_ID AND
GL_JE_HEADERS.ACTUAL_FLAG = 'A' AND
(GL_JE_LINES.STATUS = 'P' OR GL_JE_LINES.STATUS = 'U') AND
GL_JE_HEADERS.JE_BATCH_ID = GL_JE_BATCHES.JE_BATCH_ID(+) AND
GL_JE_LINES.PERIOD_NAME = GL_PERIOD_STATUSES.PERIOD_NAME AND
GL_JE_LINES.SET_OF_BOOKS_ID = GL_PERIOD_STATUSES.SET_OF_BOOKS_ID AND
GL_PERIOD_STATUSES.APPLICATION_ID = 101]
WRITER_1_*_1> WRT_8167 Start loading table [W_ORA_GL_JOURNALS_F_TMP] at: Mon Apr 14 21:25:37 2008
WRITER_1_*_1> Mon Apr 14 21:25:37 2008
WRITER_1_*_1> WRT_8229 Database errors occurred:
ORA-00942: table or view does not exist

Database driver error...
Function Name : Prepare DPL
SQL Stmt : INSERT INTO W_ORA_GL_JOURNALS_F_TMP(SET_OF_BOOKS_ID,CODE_COMB_ID,GL_ACCT_ID,PERIOD_NAME,EFFECTIVE_DATE,ACCT_PERIOD_END_DT,STATUS,ENTERED_DR,ENTERED_CR,ACCOUNTED_DR,ACCOUNTED_CR,JE_CATEGORY,JE_SOURCE,CREATED_BY,LAST_UPDATED_BY,CREATION_DATE,LAST_UPDATE_DATE,POSTED_DATE,CURRENCY_CODE,GL_JE_BATCHES_NAME,GL_JE_LINES_NUM,GL_JE_HEADERS_NAME,REFERENCE_1,REFERENCE_2,REFERENCE_3,REFERENCE_4,REFERENCE_5,REFERENCE_6,REFERENCE_7,REFERENCE_8,REFERENCE_9,REFERENCE_10,GL_SL_LINK_ID,INTEGRATION_ID,DATASOURCE_NUM_ID) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO W_ORA_GL_JOURNALS_F_TMP(SET_OF_BOOKS_ID,CODE_COMB_ID,GL_ACCT_ID,PERIOD_NAME,EFFECTIVE_DATE,ACCT_PERIOD_END_DT,STATUS,ENTERED_DR,ENTERED_CR,ACCOUNTED_DR,ACCOUNTED_CR,JE_CATEGORY,JE_SOURCE,CREATED_BY,LAST_UPDATED_BY,CREATION_DATE,LAST_UPDATE_DATE,POSTED_DATE,CURRENCY_CODE,GL_JE_BATCHES_NAME,GL_JE_LINES_NUM,GL_JE_HEADERS_NAME,REFERENCE_1,REFERENCE_2,REFERENCE_3,REFERENCE_4,REFERENCE_5,REFERENCE_6,REFERENCE_7,REFERENCE_8,REFERENCE_9,REFERENCE_10,GL_SL_LINK_ID,INTEGRATION_ID,DATASOURCE_NUM_ID) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
WRITER_1_*_1> Mon Apr 14 21:25:37 2008
WRITER_1_*_1> WRT_8076 Writer run terminated. [Commit Error]
WRITER_1_*_1> WRT_8333 Rolling back all the targets due to fatal session error.
WRITER_1_*_1> WRT_8325 Final rollback executed for the target [W_ORA_GL_JOURNALS_F_TMP, W_ORA_GLRF_DERV_F_TMP] at end of load
WRITER_1_*_1> Mon Apr 14 21:25:37 2008
WRITER_1_*_1> WRT_8081 Writer run terminated. [Error in loading data to target table [W_ORA_GL_JOURNALS_F_TMP]]
WRITER_1_*_1> WRT_8168 End loading table [W_ORA_GL_JOURNALS_F_TMP] at: Mon Apr 14 21:25:37 2008
WRITER_1_*_1> WRT_8168 End loading table [W_ORA_GLRF_DERV_F_TMP] at: Mon Apr 14 21:25:37 2008
WRITER_1_*_1> WRT_8035 Load complete time: Mon Apr 14 21:25:37 2008

LOAD SUMMARY
============

WRT_8036 Target: W_ORA_GL_JOURNALS_F_TMP (Instance Name: [W_ORA_GL_JOURNALS_F_TMP])
WRT_8044 No data loaded for this target


WRT_8036 Target: W_ORA_GLRF_DERV_F_TMP (Instance Name: [W_ORA_GLRF_DERV_F_TMP])
WRT_8044 No data loaded for this target



WRITER_1__1> WRT_8043 ****END LOAD SESSION*****
TRANSF_1_1_1> Mon Apr 14 21:25:37 2008
TRANSF_1_1_1> TM_6085 The transformation [W_ORA_GL_JOURNALS_F_TMP] encountered fatal error. Terminating session.
TRANSF_1_1_1> Mon Apr 14 21:25:37 2008
TRANSF_1_1_1> TM_6085 The transformation [EXP_GL_JOURNALS_KEY_ID] encountered fatal error. Terminating session.
TRANSF_1_1_1> Mon Apr 14 21:25:37 2008
TRANSF_1_1_1> TM_6085 The transformation [EXP_GL_JOURNALS_KEY_ID] encountered fatal error. Terminating session.
TRANSF_1_1_1> Mon Apr 14 21:25:37 2008
TRANSF_1_1_1> TM_6085 The transformation [mplt_BC_ORA_GLXactsJournalsExtract.SQ_GL_JE_LINES] encountered fatal error. Terminating session.
TRANSF_1_1_1> Mon Apr 14 21:25:37 2008
TRANSF_1_1_1> TM_6085 The transformation [mplt_BC_ORA_GLXactsJournalsExtract.SQ_GL_JE_LINES] encountered fatal error. Terminating session.
TRANSF_1_1_1> Mon Apr 14 21:25:37 2008
TRANSF_1_1_1> TM_6085 The transformation [mplt_BC_ORA_GLXactsJournalsExtract.SQ_GL_JE_LINES] encountered fatal error. Terminating session.
TRANSF_1_1_1> DBG_21511 TE: Fatal Transformation Error.
MASTER> PETL_24020

***** RUN INFO FOR TGT LOAD ORDER GROUP [1], CONCURRENT SET [1] *****
MASTER> PETL_24018 Thread [READER_1_1_1] created for the read stage of partition point [mplt_BC_ORA_GLXactsJournalsExtract.SQ_GL_JE_LINES] has completed: Total Run Time = [129.234375] secs, Total Idle Time = [0.140625] secs, Busy Percentage = [99.891186].
MASTER> PETL_24024 Thread [TRANSF_1_1_1] created for the transformation stage of partition point [mplt_BC_ORA_GLXactsJournalsExtract.SQ_GL_JE_LINES] has completed. The total run time was insufficient for any meaningful statistics.
MASTER> PETL_24022 Thread [WRITER_1_*_1] created for the write stage of partition point(s) [W_ORA_GL_JOURNALS_F_TMP, W_ORA_GLRF_DERV_F_TMP] has completed: Total Run Time = [69.203125] secs, Total Idle Time = [68.937500] secs, Busy Percentage = [0.383834].
MASTER> PETL_24021 ***** END RUN INFO *****

MASTER> PETL_24005 Starting post-session tasks.
MASTER> PETL_24029 Post-session task completed successfully.
MAPPING> TM_6020 Session [SDE_ORA_GLJournals_Full] completed at [Mon Apr 14 21:25:38 2008]
MAPPING> TM_6018 Session [SDE_ORA_GLJournals_Full] run completed with [0] row transformation errors.
MAPPING> TM_6022

SESSION LOAD SUMMARY
================================================

MAPPING> TM_6252 Source Load Summary.
MAPPING> CMN_1740 Table: [SQ_GL_JE_LINES] (Instance Name: [mplt_BC_ORA_GLXactsJournalsExtract.SQ_GL_JE_LINES])
Output Rows [4104], Affected Rows [4104], Applied Rows [4104], Rejected Rows [0]
MAPPING> TM_6253 Target Load Summary.
MAPPING> CMN_1740 Table: [W_ORA_GL_JOURNALS_F_TMP] (Instance Name: [W_ORA_GL_JOURNALS_F_TMP])
Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]
MAPPING> CMN_1740 Table: [W_ORA_GLRF_DERV_F_TMP] (Instance Name: [W_ORA_GLRF_DERV_F_TMP])
Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]
MAPPING> TM_6023
===================================================

MASTER> PETL_24002 Parallel Pipeline Engine finished.
MASTER> PETL_24013 Session run completed with failure.











When I look in the workflowlog I see:
INFO : LM_36435 : (1280|2220) Starting execution of workflow [SDE_ORA_GLJournals_Full] in folder [SDE_ORA11510_Adaptor] last saved by user [Administrator].
INFO : LM_36330 [Mon Apr 14 21:22:44 2008] : (1280|2220) Start task instance [Start]: Execution started.
INFO : LM_36318 [Mon Apr 14 21:22:44 2008] : (1280|2220) Start task instance [Start]: Execution succeeded.
INFO : LM_36505 : (1280|2220) Link [Start --> SDE_ORA_GLJournals_Full]: empty expression string, evaluated to TRUE.
INFO : LM_36330 [Mon Apr 14 21:22:44 2008] : (1280|2220) Session task instance [SDE_ORA_GLJournals_Full]: Execution started.
INFO : LM_36522 : (1280|2220) Session task instance [SDE_ORA_GLJournals_Full]: Started DTM process [pid = 396] for this session instance.
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: LM_36033 [Connected to repository [Oracle_BI_DW_Base] running on server:port [rst-act3ct2]:[5001] user [Administrator]].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27021 [Parameter file [o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220] opened for session [SDE_ORA_GLJournals_Full].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$ANALYSIS_END = 01/01/2011 07:59:34] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$ANALYSIS_END_WID = 20110101] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$ANALYSIS_START = 01/01/1980 08:00:20] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$ANALYSIS_START_WID = 19800101] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$CURRENT_DATE = 04/14/2008] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$DEFAULT_LOC_RATE_TYPE = Corporate] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$ETL_PROC_WID = 1] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$GLOBAL1_CURR_CODE = USD] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$GLOBAL1_RATE_TYPE = Corporate] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$GLOBAL2_CURR_CODE = USD] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$GLOBAL2_RATE_TYPE = Corporate] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$GLOBAL3_CURR_CODE = USD] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$GLOBAL3_RATE_TYPE = Corporate] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$Hint_Tera_Post_Cast = ] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$Hint_Tera_Pre_Cast = ] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$INITIAL_EXTRACT_DATE = 01/01/1970] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$LANGUAGE_CODE = E] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$LAST_EXTRACT_DATE = ] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$LAST_EXTRACT_DATE_IN_SQL_FORMAT = ] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$LOAD_DT = TO_DATE('2008-04-03 14:41:19', 'YYYY-MM-DD HH24:MI:SS')] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$MASTER_CODE_NOT_FOUND = ] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$SOURCE_CODE_NOT_SUPPLIED = ] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$TENANT_ID = DEFAULT] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27014 [Warning! Found an unused name and value pair [$$WH_DATASOURCE_NUM_ID = 999] in parameter file[o:\Informatica\Server\Temp\SDE_ORA_GLJournals_Full_a02220].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27028 [Use override value [DataWarehouse] for session parameter:[$DBConnection_OLAP].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27028 [Use override value [ORA_11_5_10] for session parameter:[$DBConnection_OLTP].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27028 [Use override value [4] for mapping parameter:[$$DATASOURCE_NUM_ID].].
INFO : TM_6292 : (396|312) 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 : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: VAR_27028 [Use override value [] for mapping parameter:[mplt_BC_ORA_GLXactsJournalsExtract.$$LAST_EXTRACT_DATE].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: TM_6228 [Writing session output to log file [o:\Informatica\Server\SessLogs\SDE_ORA11510_Adaptor.SDE_ORA_GLJournals_Full.log].].
INFO : TM_6292 : (396|312) Session task instance [SDE_ORA_GLJournals_Full]: TM_6708 [Warning: undocumented configuration parameter used [SiebelUnicodeDB,APPS@VIS OLAP@VIS]].
ERROR : REP_12014 : (1280|2208) An error occurred while accessing the repository
ERROR : REP_12400 : (1280|2208) Repository Error (
ORA-01461: can bind a LONG value only for insert into a LONG column

Database driver error...
Function Name : Execute
SQL Stmt : INSERT INTO OPB_SESS_TASK_LOG (WORKFLOW_ID, WORKFLOW_RUN_ID, WORKLET_RUN_ID, INSTANCE_ID, MAPPING_NAME, LOG_FILE, SRC_SUCCESS_ROWS, SRC_FAILED_ROWS, TARG_SUCCESS_ROWS, TARG_FAILED_ROWS, TOTAL_TRANS_ERRS, FIRST_ERROR_CODE, FIRST_ERROR_MSG, CODEPAGE_ID, VERSION_NUMBER) VALUES (?,?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?)
Oracle Fatal Error
Database driver error...
Function Name : Execute
SQL Stmt : INSERT INTO OPB_SESS_TASK_LOG (WORKFLOW_ID, WORKFLOW_RUN_ID, WORKLET_RUN_ID, INSTANCE_ID, MAPPING_NAME, LOG_FILE, SRC_SUCCESS_ROWS, SRC_FAILED_ROWS, TARG_SUCCESS_ROWS, TARG_FAILED_ROWS, TOTAL_TRANS_ERRS, FIRST_ERROR_CODE, FIRST_ERROR_MSG, CODEPAGE_ID, VERSION_NUMBER) VALUES (?,?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?)
Oracle Fatal Error)
ERROR : REP_12400 : (1280|2208) Repository Error ([REP_12014] An error occurred while accessing the repository
ORA-01461: can bind a LONG value only for insert into a LONG column

Database driver error...
Function Name : Execute
SQL Stmt : INSERT INTO OPB_SESS_TASK_LOG (WORKFLOW_ID, WORKFLOW_RUN_ID, WORKLET_RUN_ID, INSTANCE_ID, MAPPING_NAME, LOG_FILE, SRC_SUCCESS_ROWS, SRC_FAILED_ROWS, TARG_SUCCESS_ROWS, TARG_FAILED_ROWS, TOTAL_TRANS_ERRS, FIRST_ERROR_CODE, FIRST_ERROR_MSG, CODEPAGE_ID, VERSION_NUMBER) VALUES (?,?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?)
Oracle Fatal Error
Database driver error...
Function Name : Execute
SQL Stmt : INSERT INTO OPB_SESS_TASK_LOG (WORKFLOW_ID, WORKFLOW_RUN_ID, WORKLET_RUN_ID, INSTANCE_ID, MAPPING_NAME, LOG_FILE, SRC_SUCCESS_ROWS, SRC_FAILED_ROWS, TARG_SUCCESS_ROWS, TARG_FAILED_ROWS, TOTAL_TRANS_ERRS, FIRST_ERROR_CODE, FIRST_ERROR_MSG, CODEPAGE_ID, VERSION_NUMBER) VALUES (?,?,?,?,?, ?,?,?,?,?, ?,?,?,?, ?)
Oracle Fatal Error)
ERROR : LM_36405 : (1280|2208) Session task instance [SDE_ORA_GLJournals_Full]: error in logging the end of execution to repository.
ERROR : LM_36320 [Mon Apr 14 21:25:39 2008] : (1280|2208) Session task instance [SDE_ORA_GLJournals_Full]: Execution failed.
WARNING : LM_36331 : (1280|2208) 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 : (1280|2208) Workflow [SDE_ORA_GLJournals_Full]: Execution failed.







Can anyone tell me what is wrong?? Or where I have to look?

I first go to sleep now, caus it is getting late (different time-zone)
But I hope I have some respond tomorrow....

Thanx in advance!!!

Best regards,
Remc0