OBI APPS 7.9.6.2 ETL load error ora 00942
Hello everybody
I use OBI apps 7.9.6.2 with OBIEE 10.1.3.4.1
i launched an ETL which comes with error for this task SDE_JDE_Code_PAY_Terms_Load_Custumer_Account in the DAC
In informatica i see this error:
ORA-00942: table or view does not exist Database driver error... Function Name : Execute SQL Stmt : SELECT F0014.PNPTC, F0014.PNPTD FROM F0014
actually this table does not exist in my DW but exist in my source(Oracle DB).
If any idea
Thanks
Here is the log from Informatica:
2012-06-20 14:36:02 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : TM_6228 : Writing session output to log file [E:\OraApps\Infa\PowerCenter8.6.1\server\infa_shared\SessLogs\JDE_8_12_CTRL.DATAWAREHOUSE.SDE_JDEE1_812_Adaptor.s_SDE_JDE_Code_PayTerms_Load.log].
2012-06-20 14:36:02 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : VAR_27028 : Use override value [DataWarehouse] for session parameter:[$DBConnection_OLAP].
2012-06-20 14:36:02 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : VAR_27028 : Use override value [JDE_8_12_CTRL] for session parameter:[$DBConnection_OLTP].
2012-06-20 14:36:02 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : VAR_27028 : Use override value [JDE_8_12_CTRL.DATAWAREHOUSE.SDE_JDEE1_812_Adaptor.s_SDE_JDE_Code_PayTerms_Load.log] for session parameter:[$PMSessionLogFile].
2012-06-20 14:36:02 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : VAR_27028 : Use override value ['PAY_TERMS'] for mapping parameter:[MPLT_ADI_CODES.$$CATEGORY].
2012-06-20 14:36:02 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : VAR_27028 : Use override value [PAY_TERMS] for mapping variable:[mplt_BC_JDE_Code_PayTerms.$$CODE_D_CATEGORY].
2012-06-20 14:36:02 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : VAR_27028 : Use override value [15] for mapping parameter:[MPLT_SA_JDE_CODES.$$DATASOURCE_NUM_ID].
2012-06-20 14:36:02 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : VAR_27028 : Use override value [E] for mapping variable:[mplt_BC_JDE_Code_PayTerms.$$DOM_LANGUAGE_CODE].
2012-06-20 14:36:02 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : VAR_27028 : Use override value [DEFAULT] for mapping parameter:[MPLT_SA_JDE_CODES.$$TENANT_ID].
2012-06-20 14:36:02 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : TM_6014 : Initializing session [s_SDE_JDE_Code_PayTerms_Load] at [Wed Jun 20 14:36:02 2012].
2012-06-20 14:36:02 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : TM_6683 : Repository Name: [repservice]
2012-06-20 14:36:02 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : TM_6684 : Server Name: [intrepservice]
2012-06-20 14:36:02 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : TM_6686 : Folder: [SDE_JDEE1_812_Adaptor]
2012-06-20 14:36:02 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : TM_6685 : Workflow: [SDE_JDE_Code_PayTerms_Load] Run Instance Name: [] Run Id: [529]
2012-06-20 14:36:02 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : TM_6101 : Mapping name: SDE_JDE_Code_PayTerms_Load [version 1].
2012-06-20 14:36:03 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : TM_6963 : Pre 85 Timestamp Compatibility is Enabled
2012-06-20 14:36:03 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : TM_6964 : Date format for the Session is [MM/DD/YYYY HH24:MI:SS]
2012-06-20 14:36:03 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : TM_6708 : Using configuration property [SiebelUnicodeDB,CRPDTA@JDETEST obiadmin@DACtoOBAWDB]
2012-06-20 14:36:03 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : TM_6703 : Session [s_SDE_JDE_Code_PayTerms_Load] is run by 32-bit Integration Service [node01_BICTECK], version [8.6.1 HotFix10], build [0124].
2012-06-20 14:36:03 : INFO : (8116 | MANAGER) : (IS | intrepservice) : node01_BICTECK : PETL_24058 : Running Partition Group [1].
2012-06-20 14:36:03 : INFO : (8116 | MANAGER) : (IS | intrepservice) : node01_BICTECK : PETL_24000 : Parallel Pipeline Engine initializing.
2012-06-20 14:36:03 : INFO : (8116 | MANAGER) : (IS | intrepservice) : node01_BICTECK : PETL_24001 : Parallel Pipeline Engine running.
2012-06-20 14:36:03 : INFO : (8116 | MANAGER) : (IS | intrepservice) : node01_BICTECK : PETL_24003 : Initializing session run.
2012-06-20 14:36:03 : INFO : (8116 | MAPPING) : (IS | intrepservice) : node01_BICTECK : CMN_1569 : Server Mode: [UNICODE]
2012-06-20 14:36:03 : INFO : (8116 | MAPPING) : (IS | intrepservice) : node01_BICTECK : CMN_1570 : Server Code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
2012-06-20 14:36:03 : INFO : (8116 | MAPPING) : (IS | intrepservice) : node01_BICTECK : TM_6151 : The session sort order is [Binary].
2012-06-20 14:36:03 : INFO : (8116 | MAPPING) : (IS | intrepservice) : node01_BICTECK : TM_6185 : Warning. Code page validation is disabled in this session.
2012-06-20 14:36:03 : INFO : (8116 | MAPPING) : (IS | intrepservice) : node01_BICTECK : TM_6156 : Using low precision processing.
2012-06-20 14:36:03 : INFO : (8116 | MAPPING) : (IS | intrepservice) : node01_BICTECK : TM_6180 : Deadlock retry logic will not be implemented.
2012-06-20 14:36:03 : INFO : (8116 | MAPPING) : (IS | intrepservice) : node01_BICTECK : TM_6307 : DTM error log disabled.
2012-06-20 14:36:03 : INFO : (8116 | MAPPING) : (IS | intrepservice) : node01_BICTECK : TE_7022 : TShmWriter: Initialized
2012-06-20 14:36:04 : INFO : (8116 | MAPPING) : (IS | intrepservice) : node01_BICTECK : DBG_21075 : Connecting to database [BICTECK@obawdb], user [obiadmin]
2012-06-20 14:36:08 : INFO : (8116 | MAPPING) : (IS | intrepservice) : node01_BICTECK : CMN_1716 : Lookup [MPLT_ADI_CODES.Lkp_Master_Map] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2012-06-20 14:36:08 : INFO : (8116 | MAPPING) : (IS | intrepservice) : node01_BICTECK : CMN_1716 : Lookup [MPLT_ADI_CODES.Lkp_Master_Code] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2012-06-20 14:36:08 : INFO : (8116 | MAPPING) : (IS | intrepservice) : node01_BICTECK : CMN_1716 : Lookup [MPLT_ADI_CODES.Lkp_W_CODE_D] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2012-06-20 14:36:08 : INFO : (8116 | MAPPING) : (IS | intrepservice) : node01_BICTECK : TM_6007 : DTM initialized successfully for session [s_SDE_JDE_Code_PayTerms_Load]
2012-06-20 14:36:08 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : PETL_24033 : All DTM Connection Info: [<NONE>].
2012-06-20 14:36:08 : INFO : (8116 | MANAGER) : (IS | intrepservice) : node01_BICTECK : PETL_24004 : PETL_24004 Starting pre-session tasks. : (Wed Jun 20 14:36:08 2012)
2012-06-20 14:36:08 : INFO : (8116 | MANAGER) : (IS | intrepservice) : node01_BICTECK : PETL_24027 : PETL_24027 Pre-session task completed successfully. : (Wed Jun 20 14:36:08 2012)
2012-06-20 14:36:08 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : PETL_24006 : Starting data movement.
2012-06-20 14:36:08 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : TT_11183 : Enabled using [1 (auto)] additional concurrent pipelines to build lookup caches. (Session likely will build or refresh [3] lookup caches; [2] on-demand only).
2012-06-20 14:36:08 : INFO : (8116 | MAPPING) : (IS | intrepservice) : node01_BICTECK : TM_6660 : Total Buffer Pool size is 2705440 bytes and Block size is 148080 bytes.
2012-06-20 14:36:08 : INFO : (8116 | LKPDP_1) : (IS | intrepservice) : node01_BICTECK : DBG_21097 : Lookup Transformation [MPLT_ADI_CODES.Lkp_Master_Map]: Default sql to create lookup cache: SELECT MASTER_CODE,DATASOURCE_NUM_ID,SOURCE_CODE,CATEGORY,LANGUAGE_CODE FROM W_MASTER_MAP_D ORDER BY DATASOURCE_NUM_ID,SOURCE_CODE,CATEGORY,LANGUAGE_CODE,MASTER_CODE
2012-06-20 14:36:08 : INFO : (8116 | LKPDP_1) : (IS | intrepservice) : node01_BICTECK : TE_7212 : Increasing [Index Cache] size for transformation [MPLT_ADI_CODES.Lkp_Master_Map] from [1048576] to [1949696].
2012-06-20 14:36:09 : INFO : (8116 | LKPDP_2) : (IS | intrepservice) : node01_BICTECK : DBG_21097 : Lookup Transformation [MPLT_ADI_CODES.Lkp_Master_Code]: Default sql to create lookup cache: SELECT MASTER_VALUE,MASTER_DATASOURCE_NUM_ID,MASTER_CODE,CATEGORY,LANGUAGE_CODE FROM W_MASTER_CODE_D ORDER BY MASTER_DATASOURCE_NUM_ID,MASTER_CODE,CATEGORY,LANGUAGE_CODE,MASTER_VALUE
2012-06-20 14:36:09 : INFO : (8116 | LKPDP_3) : (IS | intrepservice) : node01_BICTECK : DBG_21097 : Lookup Transformation [MPLT_ADI_CODES.Lkp_W_CODE_D]: Default sql to create lookup cache: SELECT SOURCE_NAME_1,SOURCE_NAME_2,MASTER_DATASOURCE_NUM_ID,MASTER_CODE,MASTER_VALUE,W_INSERT_DT,TENANT_ID,DATASOURCE_NUM_ID,SOURCE_CODE,CATEGORY,LANGUAGE_CODE FROM W_CODE_D ORDER BY DATASOURCE_NUM_ID,SOURCE_CODE,CATEGORY,LANGUAGE_CODE,SOURCE_NAME_1,SOURCE_NAME_2,MASTER_DATASOURCE_NUM_ID,MASTER_CODE,MASTER_VALUE,W_INSERT_DT,TENANT_ID
2012-06-20 14:36:09 : INFO : (8116 | LKPDP_2) : (IS | intrepservice) : node01_BICTECK : TE_7212 : Increasing [Index Cache] size for transformation [MPLT_ADI_CODES.Lkp_Master_Code] from [1048576] to [1949696].
2012-06-20 14:36:09 : INFO : (8116 | LKPDP_3) : (IS | intrepservice) : node01_BICTECK : TE_7212 : Increasing [Index Cache] size for transformation [MPLT_ADI_CODES.Lkp_W_CODE_D] from [1048576] to [1949696].
2012-06-20 14:36:09 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : TT_11184 : Starting additional concurrent pipeline to build the lookup cache needed by Lookup transformation [MPLT_ADI_CODES.Lkp_W_CODE_D].
2012-06-20 14:36:09 : INFO : (8116 | LKPDP_3) : (IS | intrepservice) : node01_BICTECK : TM_6660 : Total Buffer Pool size is 609824 bytes and Block size is 65536 bytes.
2012-06-20 14:36:09 : INFO : (8116 | LKPDP_3:READER_1_1) : (IS | intrepservice) : node01_BICTECK : DBG_21438 : Reader: Source is [BICTECK@obawdb], user [obiadmin]
2012-06-20 14:36:09 : INFO : (8116 | LKPDP_3:READER_1_1) : (IS | intrepservice) : node01_BICTECK : BLKR_16051 : Source database connection [DataWarehouse] code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
2012-06-20 14:36:09 : INFO : (8116 | READER_1_1_1) : (IS | intrepservice) : node01_BICTECK : DBG_21438 : Reader: Source is [JDETEST], user [CRPCTL]
2012-06-20 14:36:09 : INFO : (8116 | LKPDP_3:READER_1_1) : (IS | intrepservice) : node01_BICTECK : BLKR_16003 : Initialization completed successfully.
2012-06-20 14:36:12 : INFO : (8116 | LKPDP_3:READER_1_1) : (IS | intrepservice) : node01_BICTECK : BLKR_16007 : Reader run started.
2012-06-20 14:36:12 : INFO : (8116 | LKPDP_3:READER_1_1) : (IS | intrepservice) : node01_BICTECK : RR_4049 : RR_4049 SQL Query issued to database : (Wed Jun 20 14:36:12 2012)
2012-06-20 14:36:14 : INFO : (8116 | LKPDP_3:READER_1_1) : (IS | intrepservice) : node01_BICTECK : RR_4050 : RR_4050 First row returned from database to reader : (Wed Jun 20 14:36:14 2012)
2012-06-20 14:36:14 : INFO : (8116 | LKPDP_3:TRANSF_1_1) : (IS | intrepservice) : node01_BICTECK : DBG_21079 : DBG_21079 Creating Lookup Cache : (Wed Jun 20 14:36:14 2012)
2012-06-20 14:36:14 : INFO : (8116 | LKPDP_3:TRANSF_1_1) : (IS | intrepservice) : node01_BICTECK : TT_11195 : Warning. Unsorted input found when building the cache for the Lookup transformation [MPLT_ADI_CODES.Lkp_W_CODE_D]. The current number of entries in the index cache is 1. The cache will be built by insertion. This will cause it to take longer and the index cache may require more space.
2012-06-20 14:36:16 : INFO : (8116 | LKPDP_3:READER_1_1) : (IS | intrepservice) : node01_BICTECK : BLKR_16008 : Reader run completed.
2012-06-20 14:36:16 : INFO : (8116 | LKPDP_3:TRANSF_1_1) : (IS | intrepservice) : node01_BICTECK : DBG_21682 : Lookup table row count : 10868
2012-06-20 14:36:16 : INFO : (8116 | LKPDP_3:TRANSF_1_1) : (IS | intrepservice) : node01_BICTECK : DBG_21297 : Lookup cache row count : 10868
2012-06-20 14:36:16 : INFO : (8116 | LKPDP_3:TRANSF_1_1) : (IS | intrepservice) : node01_BICTECK : DBG_21294 : DBG_21294 Lookup cache creation completed : (Wed Jun 20 14:36:16 2012)
2012-06-20 14:36:16 : INFO : (8116 | LKPDP_3:TRANSF_1_1) : (IS | intrepservice) : node01_BICTECK : CMN_1671 : Created new cache files PMLKUP16341_262148_0_529W32.[dat/idx] in directory E:\OraApps\Infa\PowerCenter8.6.1\server\infa_shared\Cache for Lookup [MPLT_ADI_CODES.Lkp_W_CODE_D].
2012-06-20 14:36:16 : INFO : (8116 | LKPDP_3:TRANSF_1_1) : (IS | intrepservice) : node01_BICTECK : DBG_21641 : MPLT_ADI_CODES.Lkp_W_CODE_D: Index cache size = [1949696], Data cache size = [2097152]
2012-06-20 14:36:16 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : TT_11185 : No more lookup cache to build by additional concurrent pipeline in the current concurrent source set.
2012-06-20 14:36:17 : INFO : (8116 | READER_1_1_1) : (IS | intrepservice) : node01_BICTECK : BLKR_16051 : Source database connection [JDE_8_12_CTRL] code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
2012-06-20 14:36:19 : INFO : (8116 | READER_1_1_1) : (IS | intrepservice) : node01_BICTECK : BLKR_16003 : Initialization completed successfully.
2012-06-20 14:36:19 : INFO : (8116 | WRITER_1_*_1) : (IS | intrepservice) : node01_BICTECK : WRT_8366 : Bulk mode is not applicable to delete, update, or data-driven sessions, default to normal mode.
2012-06-20 14:36:19 : INFO : (8116 | WRITER_1_*_1) : (IS | intrepservice) : node01_BICTECK : WRT_8148 : Writer: Target is database [BICTECK@obawdb], user [obiadmin], bulk mode [N/A]
2012-06-20 14:36:19 : INFO : (8116 | WRITER_1_*_1) : (IS | intrepservice) : node01_BICTECK : WRT_8221 : Target database connection [DataWarehouse] code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
2012-06-20 14:36:19 : INFO : (8116 | WRITER_1_*_1) : (IS | intrepservice) : node01_BICTECK : WRT_8124 : Target Table W_CODE_D :SQL INSERT statement:
INSERT INTO W_CODE_D(DATASOURCE_NUM_ID,SOURCE_CODE,SOURCE_CODE_1,SOURCE_CODE_2,SOURCE_CODE_3,SOURCE_NAME_1,SOURCE_NAME_2,CATEGORY,LANGUAGE_CODE,MASTER_DATASOURCE_NUM_ID,MASTER_CODE,MASTER_VALUE,W_INSERT_DT,W_UPDATE_DT,TENANT_ID) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2012-06-20 14:36:19 : INFO : (8116 | WRITER_1_*_1) : (IS | intrepservice) : node01_BICTECK : WRT_8124 : Target Table W_CODE_D :SQL UPDATE statement:
UPDATE W_CODE_D SET SOURCE_CODE_1 = ?, SOURCE_CODE_2 = ?, SOURCE_CODE_3 = ?, SOURCE_NAME_1 = ?, SOURCE_NAME_2 = ?, MASTER_DATASOURCE_NUM_ID = ?, MASTER_CODE = ?, MASTER_VALUE = ?, W_INSERT_DT = ?, W_UPDATE_DT = ?, TENANT_ID = ? WHERE DATASOURCE_NUM_ID = ? AND SOURCE_CODE = ? AND CATEGORY = ? AND LANGUAGE_CODE = ?
2012-06-20 14:36:19 : INFO : (8116 | WRITER_1_*_1) : (IS | intrepservice) : node01_BICTECK : WRT_8124 : Target Table W_CODE_D :SQL DELETE statement:
DELETE FROM W_CODE_D WHERE DATASOURCE_NUM_ID = ? AND SOURCE_CODE = ? AND CATEGORY = ? AND LANGUAGE_CODE = ?
2012-06-20 14:36:19 : INFO : (8116 | WRITER_1_*_1) : (IS | intrepservice) : node01_BICTECK : WRT_8270 : Target connection group #1 consists of target(s) [W_CODE_D]
2012-06-20 14:36:19 : INFO : (8116 | WRITER_1_*_1) : (IS | intrepservice) : node01_BICTECK : WRT_8003 : Writer initialization complete.
2012-06-20 14:36:19 : INFO : (8116 | READER_1_1_1) : (IS | intrepservice) : node01_BICTECK : BLKR_16007 : Reader run started.
2012-06-20 14:36:19 : INFO : (8116 | READER_1_1_1) : (IS | intrepservice) : node01_BICTECK : RR_4010 : SQ instance [mplt_BC_JDE_Code_PayTerms.SQ_F0014] SQL Query [SELECT F0014.PNPTC, F0014.PNPTD FROM F0014]
2012-06-20 14:36:19 : INFO : (8116 | READER_1_1_1) : (IS | intrepservice) : node01_BICTECK : RR_4049 : RR_4049 SQL Query issued to database : (Wed Jun 20 14:36:19 2012)
2012-06-20 14:36:19 : INFO : (8116 | WRITER_1_*_1) : (IS | intrepservice) : node01_BICTECK : WRT_8005 : Writer run started.
2012-06-20 14:36:19 : INFO : (8116 | WRITER_1_*_1) : (IS | intrepservice) : node01_BICTECK : WRT_8158 :
*****START LOAD SESSION*****
Load Start Time: Wed Jun 20 14:36:18 2012
Target tables:
W_CODE_D
2012-06-20 14:36:19 : ERROR : (8116 | READER_1_1_1) : (IS | intrepservice) : node01_BICTECK : RR_4035 : SQL Error [
ORA-00942: table or view does not exist
Database driver error...
Function Name : Execute
SQL Stmt : SELECT F0014.PNPTC, F0014.PNPTD FROM F0014
Oracle Fatal Error
Database driver error...
Function Name : Execute
SQL Stmt : SELECT F0014.PNPTC, F0014.PNPTD FROM F0014
Oracle Fatal Error].
2012-06-20 14:36:19 : ERROR : (8116 | READER_1_1_1) : (IS | intrepservice) : node01_BICTECK : BLKR_16004 : ERROR: Prepare failed.
2012-06-20 14:36:19 : INFO : (8116 | WRITER_1_*_1) : (IS | intrepservice) : node01_BICTECK : WRT_8333 : Rolling back all the targets due to fatal session error.
2012-06-20 14:36:19 : INFO : (8116 | WRITER_1_*_1) : (IS | intrepservice) : node01_BICTECK : WRT_8325 : Final rollback executed for the target [W_CODE_D] at end of load
2012-06-20 14:36:19 : INFO : (8116 | WRITER_1_*_1) : (IS | intrepservice) : node01_BICTECK : WRT_8035 : Load complete time: Wed Jun 20 14:36:18 2012
LOAD SUMMARY
============
WRT_8036 Target: W_CODE_D (Instance Name: [W_CODE_D])
WRT_8044 No data loaded for this target
2012-06-20 14:36:19 : INFO : (8116 | WRITER_1__1) : (IS | intrepservice) : node01_BICTECK : WRT_8043 : ****END LOAD SESSION*****
2012-06-20 14:36:19 : INFO : (8116 | MANAGER) : (IS | intrepservice) : node01_BICTECK : PETL_24031 :
***** RUN INFO FOR TGT LOAD ORDER GROUP [1], CONCURRENT SET [1] *****
Thread [READER_1_1_1] created for [the read stage] of partition point [mplt_BC_JDE_Code_PayTerms.SQ_F0014] has completed. The total run time was insufficient for any meaningful statistics.
Thread [TRANSF_1_1_1] created for [the transformation stage] of partition point [mplt_BC_JDE_Code_PayTerms.SQ_F0014] has completed. The total run time was insufficient for any meaningful statistics.
Thread [WRITER_1_*_1] created for [the write stage] of partition point [W_CODE_D] has completed. The total run time was insufficient for any meaningful statistics.
2012-06-20 14:36:19 : INFO : (8116 | MAPPING) : (IS | intrepservice) : node01_BICTECK : CMN_1793 : The index cache size that would hold [7340064] rows in the lookup table for [MPLT_ADI_CODES.Lkp_W_CODE_D], in memory, is [29555310648557682] bytes
2012-06-20 14:36:19 : INFO : (8116 | MAPPING) : (IS | intrepservice) : node01_BICTECK : CMN_1792 : The data cache size that would hold [7340064] rows in the lookup table for [MPLT_ADI_CODES.Lkp_W_CODE_D], in memory, is [12948046503805036] bytes
2012-06-20 14:36:19 : INFO : (8116 | MANAGER) : (IS | intrepservice) : node01_BICTECK : PETL_24005 : PETL_24005 Starting post-session tasks. : (Wed Jun 20 14:36:19 2012)
2012-06-20 14:36:19 : INFO : (8116 | MANAGER) : (IS | intrepservice) : node01_BICTECK : PETL_24029 : PETL_24029 Post-session task completed successfully. : (Wed Jun 20 14:36:19 2012)
2012-06-20 14:36:19 : INFO : (8116 | MAPPING) : (IS | intrepservice) : node01_BICTECK : TE_7216 : Deleting cache files [PMLKUP16341_262155_0_529W32] for transformation [MPLT_ADI_CODES.Lkp_Master_Map].
2012-06-20 14:36:19 : INFO : (8116 | MAPPING) : (IS | intrepservice) : node01_BICTECK : TE_7216 : Deleting cache files [PMLKUP16341_262156_0_529W32] for transformation [MPLT_ADI_CODES.Lkp_Master_Code].
2012-06-20 14:36:19 : INFO : (8116 | MAPPING) : (IS | intrepservice) : node01_BICTECK : TE_7216 : Deleting cache files [PMLKUP16341_262148_0_529W32] for transformation [MPLT_ADI_CODES.Lkp_W_CODE_D].
2012-06-20 14:36:19 : INFO : (8116 | MAPPING) : (IS | intrepservice) : node01_BICTECK : TM_6018 : The session completed with [0] row transformation errors.
2012-06-20 14:36:20 : INFO : (8116 | MANAGER) : (IS | intrepservice) : node01_BICTECK : PETL_24002 : Parallel Pipeline Engine finished.
2012-06-20 14:36:20 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : PETL_24013 : Session run completed with failure.
2012-06-20 14:36:21 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : TM_6022 :
SESSION LOAD SUMMARY
================================================
2012-06-20 14:36:21 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : TM_6252 : Source Load Summary.
2012-06-20 14:36:21 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : CMN_1740 : Table: [SQ_F0014] (Instance Name: [mplt_BC_JDE_Code_PayTerms.SQ_F0014])
Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]
2012-06-20 14:36:21 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : TM_6253 : Target Load Summary.
2012-06-20 14:36:21 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : CMN_1740 : Table: [W_CODE_D] (Instance Name: [W_CODE_D])
Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]
2012-06-20 14:36:21 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : TM_6023 :
===================================================
2012-06-20 14:36:21 : INFO : (8116 | DIRECTOR) : (IS | intrepservice) : node01_BICTECK : TM_6020 : Session [s_SDE_JDE_Code_PayTerms_Load] completed at [Wed Jun 20 14:36:20 2012].