Analytics Software

Dears,

I'm running finance module using DAC, for the soruce ebiz:12.1.3

I'm getting error, log file for your reference.



DIRECTOR> VAR_27028 Use override value [DataWarehouse] for session parameter:[$DBConnection_OLAP].
DIRECTOR> VAR_27028 Use override value [ORA_R1213] for session parameter:[$DBConnection_OLTP].
DIRECTOR> VAR_27028 Use override value [ORA_R1213.DATAWAREHOUSE.SDE_ORAR1213_Adaptor.SDE_ORA_CodeDimension_Supply_Chain_Purch_Orders_Xact_SubType.log] for session parameter:[$PMSessionLogFile].
DIRECTOR> VAR_27027 Use default value [] for mapping parameter:[MPLT_ADI_CODES.$$CATEGORY].
DIRECTOR> VAR_27028 Use override value [1000] for mapping parameter:[MPLT_SA_ORA_CODES.$$DATASOURCE_NUM_ID].
DIRECTOR> VAR_27027 Use default value [] for mapping parameter:[mplt_BC_ORA_Codes_SUPPLY_CHAIN_PURCH_ORDERS_XACT_SUBTYPE.$$DFLT_LANG].
DIRECTOR> VAR_27028 Use override value [DEFAULT] for mapping parameter:[MPLT_SA_ORA_CODES.$$TENANT_ID].
DIRECTOR> TM_6014 Initializing session [SDE_ORA_CodeDimension_Supply_Chain_Purch_Orders_Xact_SubType] at [Sat Apr 13 20:09:47 2013].
DIRECTOR> TM_6683 Repository Name: [Oracle_BI_DW_Base]
DIRECTOR> TM_6684 Server Name: [Oracle_BI_DW_Base_Integration_Service]
DIRECTOR> TM_6686 Folder: [SDE_ORAR1213_Adaptor]
DIRECTOR> TM_6685 Workflow: [SDE_ORA_CodeDimension_Supply_Chain_Purch_Orders_Xact_SubType] Run Instance Name: [] Run Id: [2783]
DIRECTOR> TM_6101 Mapping name: SDE_ORA_CodeDimension_Supply_Chain_Purch_Orders_Xact_SubType [version 1].
DIRECTOR> TM_6963 Pre 85 Timestamp Compatibility is Enabled
DIRECTOR> TM_6964 Date format for the Session is [MM/DD/YYYY HH24:MI:SS]
DIRECTOR> TM_6827 [E:\Informatica\9.0.1\server\infa_shared\Storage] will be used as storage directory for session [SDE_ORA_CodeDimension_Supply_Chain_Purch_Orders_Xact_SubType].
DIRECTOR> CMN_1802 Session recovery cache initialization is complete.
DIRECTOR> TM_6708 Using configuration property [DisableDB2BulkMode,Yes]
DIRECTOR> TM_6708 Using configuration property [ServerPort,4006]
DIRECTOR> TM_6708 Using configuration property [SiebelUnicodeDB,apps@R12PLY baw@orcl]
DIRECTOR> TM_6708 Using configuration property [overrideMptlVarWithMapVar,Yes]

DIRECTOR> TM_6703 Session [SDE_ORA_CodeDimension_Supply_Chain_Purch_Orders_Xact_SubType] is run by 64-bit Integration Service [node01_OBIEETESTAPP], version [9.0.1 HotFix2], build [1111].
MANAGER> PETL_24058 Running Partition Group [1].
MANAGER> PETL_24000 Parallel Pipeline Engine initializing.
MANAGER> PETL_24001 Parallel Pipeline Engine running.
MANAGER> PETL_24003 Initializing session run.
MAPPING> CMN_1569 Server Mode: [ASCII]
MAPPING> CMN_1570 Server Code page: [MS Windows Latin 1 (ANSI), superset of Latin1]
MAPPING> TM_6151 The session sort order is [Binary].
MAPPING> TM_6156 Using low precision processing.
MAPPING> TM_6180 Deadlock retry logic will not be implemented.
MAPPING> TM_6187 Session target-based commit interval is [10000].
MAPPING> TM_6307 DTM error log disabled.
MAPPING> TE_7022 TShmWriter: Initialized
MAPPING> DBG_21075 Connecting to database [orcl], user [baw]
MAPPING> TM_6007 DTM initialized successfully for session [SDE_ORA_CodeDimension_Supply_Chain_Purch_Orders_Xact_SubType]
DIRECTOR> PETL_24033 All DTM Connection Info: [<NONE>].
MANAGER> PETL_24004 Starting pre-session tasks. : (Sat Apr 13 20:09:47 2013)
MANAGER> PETL_24027 Pre-session task completed successfully. : (Sat Apr 13 20:09:47 2013)
DIRECTOR> PETL_24006 Starting data movement.
MAPPING> TM_6660 Total Buffer Pool size is 12582912 bytes and Block size is 128000 bytes.
LKPDP_1> 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

LKPDP_1> TE_7212 Increasing [Index Cache] size for transformation [mplt_ADI_Codes.Lkp_Master_Map] from [1000000] to [2541568].
LKPDP_1> TE_7212 Increasing [Data Cache] size for transformation [mplt_ADI_Codes.Lkp_Master_Map] from [2000000] to [2007040].
LKPDP_2> 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

LKPDP_3> DBG_21312 Lookup Transformation [mplt_ADI_Codes.Lkp_W_CODE_D]: Lookup override sql to create cache: SELECT W_CODE_D.SOURCE_NAME_1 AS SOURCE_NAME_1, W_CODE_D.SOURCE_NAME_2 AS SOURCE_NAME_2, W_CODE_D.MASTER_DATASOURCE_NUM_ID AS MASTER_DATASOURCE_NUM_ID, W_CODE_D.MASTER_CODE AS MASTER_CODE, W_CODE_D.MASTER_VALUE AS MASTER_VALUE, W_CODE_D.W_INSERT_DT AS W_INSERT_DT, W_CODE_D.TENANT_ID AS TENANT_ID, W_CODE_D.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID, W_CODE_D.SOURCE_CODE AS SOURCE_CODE, W_CODE_D.CATEGORY AS CATEGORY, W_CODE_D.LANGUAGE_CODE AS LANGUAGE_CODE FROM W_CODE_D

WHERE

W_CODE_D.CATEGORY IN () 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

LKPDP_2> TE_7212 Increasing [Index Cache] size for transformation [mplt_ADI_Codes.Lkp_Master_Code] from [1000000] to [2541568].
LKPDP_2> TE_7212 Increasing [Data Cache] size for transformation [mplt_ADI_Codes.Lkp_Master_Code] from [2000000] to [2007040].
LKPDP_3> TE_7212 Increasing [Index Cache] size for transformation [mplt_ADI_Codes.Lkp_W_CODE_D] from [1000000] to [2541568].
LKPDP_3> TE_7212 Increasing [Data Cache] size for transformation [mplt_ADI_Codes.Lkp_W_CODE_D] from [2000000] to [2007040].
READER_1_1_1> DBG_21438 Reader: Source is [R12PLY], user [apps]
READER_1_1_1> BLKR_16003 Initialization completed successfully.
WRITER_1_*_1> WRT_8147 Writer: Target is database [orcl], user [baw], bulk mode [OFF]
WRITER_1_*_1> 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 ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
WRITER_1_*_1> 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 = ?
WRITER_1_*_1> 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 = ?
WRITER_1_*_1> WRT_8270 Target connection group #1 consists of target(s) [W_CODE_D]
WRITER_1_*_1> WRT_8003 Writer initialization complete.
WRITER_1_*_1> WRT_8005 Writer run started.
WRITER_1_*_1> WRT_8158

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

Load Start Time: Sat Apr 13 20:09:48 2013

Target tables:

W_CODE_D


READER_1_1_1> BLKR_16007 Reader run started.
READER_1_1_1> RR_4029 SQ Instance [mplt_BC_ORA_Codes_SUPPLY_CHAIN_PURCH_ORDERS_XACT_SUBTYPE.SQ_PO_DOCUMENT_TYPES_ALL_TL] User specified SQL Query [SELECT DOCUMENT_SUBTYPE||'~'||ORG_ID,TYPE_NAME FROM PO_DOCUMENT_TYPES_ALL_TL

WHERE

PO_DOCUMENT_TYPES_ALL_TL.LANGUAGE='' AND

PO_DOCUMENT_TYPES_ALL_TL.DOCUMENT_TYPE_CODE IN ('PO', 'PA') AND

PO_DOCUMENT_TYPES_ALL_TL.DOCUMENT_SUBTYPE <> 'CONTRACT']
READER_1_1_1> RR_4049 SQL Query issued to database : (Sat Apr 13 20:09:48 2013)
READER_1_1_1> BLKR_16019 Read [0] rows, read [0] error rows for source table [PO_DOCUMENT_TYPES_ALL_TL] instance name [mplt_BC_ORA_Codes_SUPPLY_CHAIN_PURCH_ORDERS_XACT_SUBTYPE.PO_DOCUMENT_TYPES_ALL_TL]
READER_1_1_1> BLKR_16008 Reader run completed.
TRANSF_1_1_1> DBG_21216 Finished transformations for Source Qualifier [mplt_BC_ORA_Codes_SUPPLY_CHAIN_PURCH_ORDERS_XACT_SUBTYPE.SQ_PO_DOCUMENT_TYPES_ALL_TL]. Total errors [0]
WRITER_1_*_1> WRT_8167 Start loading table [W_CODE_D] at: Sat Apr 13 20:09:48 2013
WRITER_1_*_1> WRT_8168 End loading table [W_CODE_D] at: Sat Apr 13 20:09:48 2013
WRITER_1_*_1> WRT_8035 Load complete time: Sat Apr 13 20:09:48 2013

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

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



WRITER_1__1> WRT_8043 ****END LOAD SESSION*****
WRITER_1_*_1> WRT_8006 Writer run completed.
MANAGER> 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_ORA_Codes_SUPPLY_CHAIN_PURCH_ORDERS_XACT_SUBTYPE.SQ_PO_DOCUMENT_TYPES_ALL_TL] 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_ORA_Codes_SUPPLY_CHAIN_PURCH_ORDERS_XACT_SUBTYPE.SQ_PO_DOCUMENT_TYPES_ALL_TL] 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.

MAPPING> CMN_1793 The index cache size that would hold [0] rows in the lookup table for [mplt_ADI_Codes.Lkp_W_CODE_D], in memory, is [0] bytes
MAPPING> CMN_1792 The data cache size that would hold [0] rows in the lookup table for [mplt_ADI_Codes.Lkp_W_CODE_D], in memory, is [0] bytes
MANAGER> PETL_24005 Starting post-session tasks. : (Sat Apr 13 20:09:49 2013)
MANAGER> PETL_24029 Post-session task completed successfully. : (Sat Apr 13 20:09:49 2013)
MAPPING> TE_7216 Deleting cache files [PMLKUP12931_131084_0_2783W32] for transformation [mplt_ADI_Codes.Lkp_Master_Map].
MAPPING> TE_7216 Deleting cache files [PMLKUP12931_131083_0_2783W32] for transformation [mplt_ADI_Codes.Lkp_Master_Code].
MAPPING> TE_7216 Deleting cache files [PMLKUP12931_131081_0_2783W32] for transformation [mplt_ADI_Codes.Lkp_W_CODE_D].
MAPPING> TM_6018 The session completed with [0] row transformation errors.
MANAGER> PETL_24002 Parallel Pipeline Engine finished.
DIRECTOR> PETL_24012 Session run completed successfully.
DIRECTOR> TM_6022

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

DIRECTOR> TM_6252 Source Load Summary.
DIRECTOR> CMN_1740 Table: [SQ_PO_DOCUMENT_TYPES_ALL_TL] (Instance Name: [mplt_BC_ORA_Codes_SUPPLY_CHAIN_PURCH_ORDERS_XACT_SUBTYPE.SQ_PO_DOCUMENT_TYPES_A])
Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]
DIRECTOR> TM_6253 Target Load Summary.
DIRECTOR> CMN_1740 Table: [W_CODE_D] (Instance Name: [W_CODE_D])
Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]
DIRECTOR> TM_6023
===================================================

DIRECTOR> TM_6020 Session [SDE_ORA_CodeDimension_Supply_Chain_Purch_Orders_Xact_SubType] completed at [Sat Apr 13 20:09:49 2013].