Categories
- All Categories
- 135 Oracle Analytics News
- 24 Oracle Analytics Videos
- 14.6K Oracle Analytics Forums
- 5.6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 51 Oracle Analytics Trainings
- 9 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 3 Oracle Analytics Industry
- Find Partners
- For Partners
OBIA 7964 - OOB SIL_PurchaseReceiptFact mapping failed
Hi All,
we are using OBIA 7964 with EBS source system when incremental loads are running PurchaseReceiptFact failure with the following error.
I checked the source and Stage Fact table, I could not find any duplicates in it. the task running from a year without any issue.
there were no changes in mapping as well as source side.
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6228 : Writing session output to log file [/Informatica/9.5.1/server/infa_shared/SessLogs/.SIL_PurchaseReceiptFact.DATAWAREHOUSE.log].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : VAR_27028 : Use override value [DataWarehouse] for session parameter:[$DBConnection_OLAP].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : VAR_27028 : Use override value [.SIL_PurchaseReceiptFact.DATAWAREHOUSE.log] for session parameter:[$PMSessionLogFile].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : VAR_27028 : Use override value [25075300] for mapping parameter:[MPLT_GET_ETL_PROC_WID.$$ETL_PROC_WID].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : VAR_27028 : Use override value [N] for mapping parameter:[$$INSERT_ONLY_FLG].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : VAR_27028 : Use override value [E] for mapping parameter:[mplt_SIL_PurchaseReceiptFact.$$LANGUAGE_CODE].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : VAR_27028 : Use override value [] for mapping parameter:[mplt_SIL_PurchaseReceiptFact.$$MASTER_CODE_NOT_FOUND].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : VAR_27028 : Use override value [] for mapping parameter:[mplt_SIL_PurchaseReceiptFact.$$SOURCE_CODE_NOT_SUPPLIED].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6014 : Initializing session [SIL_PurchaseReceiptFact] at [Mon Sep 04 20:45:21 2017].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6683 : Repository Name: [BIA_RS_PRD]
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6684 : Server Name: [BIA_IS_PRD]
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6686 : Folder: [SILOS]
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6685 : Workflow: [SIL_PurchaseReceiptFact] Run Instance Name: [] Run Id: [911465]
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6101 : Mapping name: SIL_PurchaseReceiptFact [version 1].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6963 : Pre 85 Timestamp Compatibility is Enabled
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6964 : Date format for the Session is [MM/DD/YYYY HH24:MI:SS]
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6827 : [/Informatica/9.5.1/server/infa_shared/Storage] will be used as storage directory for session [SIL_PurchaseReceiptFact].
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1805 : Recovery cache will be deleted when running in normal mode.
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1802 : Session recovery cache initialization is complete.
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6708 : Using configuration property [overrideMpltVarWithMapVar,Yes]
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6708 : Using configuration property [AggSupprtWithNoPartLic,Yes]
2017-09-05 00:15:21 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6703 : Session [SIL_PurchaseReceiptFact] is run by 64-bit Integration Service [node01_nlaobixva01], version [9.5.1 HotFix2], build [0621].
2017-09-05 00:15:21 : INFO : (17891420 | MANAGER) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : PETL_24058 : Running Partition Group [1].
2017-09-05 00:15:21 : INFO : (17891420 | MANAGER) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : PETL_24000 : Parallel Pipeline Engine initializing.
2017-09-05 00:15:21 : INFO : (17891420 | MANAGER) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : PETL_24001 : Parallel Pipeline Engine running.
2017-09-05 00:15:21 : INFO : (17891420 | MANAGER) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : PETL_24003 : Initializing session run.
2017-09-05 00:15:21 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1569 : Server Mode: [UNICODE]
2017-09-05 00:15:21 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1570 : Server Code page: [ISO 8859-1 Western European]
2017-09-05 00:15:21 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6151 : The session sort order is [Binary].
2017-09-05 00:15:21 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6156 : Using low precision processing.
2017-09-05 00:15:21 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6180 : Deadlock retry logic will not be implemented.
2017-09-05 00:15:21 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6187 : Session target-based commit interval is [10000].
2017-09-05 00:15:21 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6307 : DTM error log disabled.
2017-09-05 00:15:21 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7022 : TShmWriter: Initialized
2017-09-05 00:15:21 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21075 : Connecting to database [pobiee], user [SO_BAW_PROD]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [Lkp_W_PURCH_RCPT_F] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_PRODUCT_D_STD_UOM] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_INVENTORY_PRODUCT_D_PRIMARY_UOM] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_INVENTORY_PRODUCT_D_INVENTORY_ORG_ID] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_INT_ORG_D] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_LKP_W_SUPPLIER_PRODUCT_D.LKP_W_SUPPLIER_PRODUCT_D_Primary] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_LKP_W_SUPPLIER_PRODUCT_D.LKP_W_SUPPLIER_PRODUCT_D_2nd] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_LKP_W_SUPPLIER_PRODUCT_D.LKP_W_SUPPLIER_PRODUCT_D_3rd] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_LKP_W_SUPPLIER_PRODUCT_D.LKP_W_SUPPLIER_PRODUCT_D_4th] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_UOM_CONVERSION_G_ITEM_LEVEL_RATES_PRIMARY_UOM] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_UOM_CONVERSION_G_ITEM_LEVEL_RATES_STANDARD_UOM] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_UOM_CONVERSION_G_RATES_PRIMARY_UOM] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_UOM_CONVERSION_G_RATES_STANDARD_UOM] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_UOM_CONVERSION_G_ITEM_LEVEL_RATES_STANDARD_UOM_INV] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_UOM_CONVERSION_G_ITEM_LEVEL_RATES_PRIMARY_UOM_INV] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_UOM_CONVERSION_G_RATES_STANDARD_UOM_INV] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [MPLT_GET_UOM_CONVERSIONS.LKP_W_UOM_CONVERSION_G_RATES_PRIMARY_UOM_INV] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.Lkp_W_PRODUCT_D_Product_Wid] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.Lkp_Codes_UOM] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.Lkp_W_SUPPLIER_D_Supplier_Wid] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.LKP_W_SUPPLIER_ACCOUNT_D] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.Lkp_W_XACT_TYPE_D_Xact_Type_Wid_SHIPMENT_TYPE] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.Lkp_W_XACT_TYPE_D_Xact_Type_Wid_PAYMENT_TYPE] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.Lkp_W_XACT_TYPE_D_Xact_Type_Wid] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.lkp_W_XACT_TYPE_D_Line_Type_Wid] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.LKP_W_XACT_TYPE_D_CONSIGNED_TYPE_WID] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.Lkp_W_Inventory_Product_D_Inventory_Prod_Wid] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_SIL_PurchaseReceiptFact.Lkp_W_SUPPLIER_PRODUCT_D_Supplier_Prod_Wid] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_Curcy_Conversion_Rates.LKP_W_EXCH_RATE] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_Curcy_Conversion_Rates.LKP_W_EXCH_RATE] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_Curcy_Conversion_Rates.LKP_W_EXCH_RATE] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_Curcy_Conversion_Rates.LKP_W_EXCH_RATE] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_Curcy_Conversion_Rates.GET_GLOBAL_CURR_CODES_AND_RATE_TYPES] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : CMN_1716 : Lookup [mplt_Get_Etl_Proc_Wid.LKP_ETL_PROC_WID] uses database connection [Relational:DataWarehouse] in code page [MS Windows Latin 1 (ANSI), superset of Latin1]
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6007 : DTM initialized successfully for session [SIL_PurchaseReceiptFact]
2017-09-05 00:15:22 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : PETL_24033 : All DTM Connection Info: [<NONE>].
2017-09-05 00:15:22 : INFO : (17891420 | MANAGER) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : PETL_24004 : PETL_24004 Starting pre-session tasks. : (Mon Sep 04 20:45:22 2017)
2017-09-05 00:15:22 : INFO : (17891420 | MANAGER) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : PETL_24027 : PETL_24027 Pre-session task completed successfully. : (Mon Sep 04 20:45:22 2017)
2017-09-05 00:15:22 : INFO : (17891420 | DIRECTOR) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : PETL_24006 : Starting data movement.
2017-09-05 00:15:22 : INFO : (17891420 | MAPPING) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TM_6660 : Total Buffer Pool size is 32000000 bytes and Block size is 128000 bytes.
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21312 : Lookup Transformation [Lkp_W_PURCH_RCPT_F]: Lookup override sql to create cache: SELECT TARGET_TABLE.CHANGED_ON_DT AS CHANGED_ON_DT, TARGET_TABLE.AUX1_CHANGED_ON_DT AS AUX1_CHANGED_ON_DT, TARGET_TABLE.AUX2_CHANGED_ON_DT AS AUX2_CHANGED_ON_DT, TARGET_TABLE.AUX3_CHANGED_ON_DT AS AUX3_CHANGED_ON_DT, TARGET_TABLE.AUX4_CHANGED_ON_DT AS AUX4_CHANGED_ON_DT, TARGET_TABLE.DELETE_FLG AS DELETE_FLG, TARGET_TABLE.W_INSERT_DT AS W_INSERT_DT, TARGET_TABLE.ETL_PROC_WID AS ETL_PROC_WID, TARGET_TABLE.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID, TARGET_TABLE.INTEGRATION_ID AS INTEGRATION_ID FROM W_PURCH_RCPT_FS STAGE_TABLE, W_PURCH_RCPT_F TARGET_TABLE
WHERE
STAGE_TABLE.DATASOURCE_NUM_ID = TARGET_TABLE.DATASOURCE_NUM_ID AND
STAGE_TABLE.INTEGRATION_ID = TARGET_TABLE.INTEGRATION_ID
ORDER BY
TARGET_TABLE.DATASOURCE_NUM_ID,
TARGET_TABLE.INTEGRATION_ID -- ORDER BY DATASOURCE_NUM_ID,INTEGRATION_ID,CHANGED_ON_DT,AUX1_CHANGED_ON_DT,AUX2_CHANGED_ON_DT,AUX3_CHANGED_ON_DT,AUX4_CHANGED_ON_DT,DELETE_FLG,W_INSERT_DT,ETL_PROC_WID
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_1) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [Lkp_W_PURCH_RCPT_F] from [1048576] to [1392640].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_2) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21097 : Lookup Transformation [MPLT_GET_UOM_CONVERSIONS.LKP_W_PRODUCT_D_STD_UOM]: Default sql to create lookup cache: SELECT BASE_UOM_CODE,INTEGRATION_ID,DATASOURCE_NUM_ID,CURRENT_FLG FROM W_PRODUCT_D ORDER BY INTEGRATION_ID,DATASOURCE_NUM_ID,CURRENT_FLG
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_2) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [MPLT_GET_UOM_CONVERSIONS.LKP_W_PRODUCT_D_STD_UOM] from [1048576] to [1497088].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_3) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21097 : Lookup Transformation [MPLT_GET_UOM_CONVERSIONS.LKP_W_INVENTORY_PRODUCT_D_PRIMARY_UOM]: Default sql to create lookup cache: SELECT PRIMARY_UOM_CODE,DATASOURCE_NUM_ID,INTEGRATION_ID,CURRENT_FLG FROM W_INVENTORY_PRODUCT_D ORDER BY DATASOURCE_NUM_ID,INTEGRATION_ID,CURRENT_FLG
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_3) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [MPLT_GET_UOM_CONVERSIONS.LKP_W_INVENTORY_PRODUCT_D_PRIMARY_UOM] from [1048576] to [1497088].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_4) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21097 : Lookup Transformation [MPLT_GET_UOM_CONVERSIONS.LKP_W_INVENTORY_PRODUCT_D_INVENTORY_ORG_ID]: Default sql to create lookup cache: SELECT INVENTORY_ORG_WID,DATASOURCE_NUM_ID,INTEGRATION_ID,CURRENT_FLG FROM W_INVENTORY_PRODUCT_D ORDER BY DATASOURCE_NUM_ID,INTEGRATION_ID,CURRENT_FLG
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_4) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [MPLT_GET_UOM_CONVERSIONS.LKP_W_INVENTORY_PRODUCT_D_INVENTORY_ORG_ID] from [1048576] to [1497088].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_5) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21097 : Lookup Transformation [MPLT_GET_UOM_CONVERSIONS.LKP_W_INT_ORG_D]: Default sql to create lookup cache: SELECT INTEGRATION_ID,ROW_WID FROM W_INT_ORG_D ORDER BY ROW_WID
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_5) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [MPLT_GET_UOM_CONVERSIONS.LKP_W_INT_ORG_D] from [1048576] to [1050000].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_6) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21312 : Lookup Transformation [MPLT_LKP_W_SUPPLIER_PRODUCT_D.LKP_W_SUPPLIER_PRODUCT_D_Primary]: Lookup override sql to create cache: SELECT LOOKUP_TABLE.ROW_WID AS ROW_WID, LOOKUP_TABLE.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID, LOOKUP_TABLE.INTEGRATION_ID AS INTEGRATION_ID, LOOKUP_TABLE.EFFECTIVE_FROM_DT AS EFFECTIVE_FROM_DT, LOOKUP_TABLE.EFFECTIVE_TO_DT AS EFFECTIVE_TO_DT FROM W_SUPPLIER_PRODUCT_D LOOKUP_TABLE ORDER BY DATASOURCE_NUM_ID,INTEGRATION_ID,EFFECTIVE_FROM_DT,EFFECTIVE_TO_DT,ROW_WID
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_6) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [MPLT_LKP_W_SUPPLIER_PRODUCT_D.LKP_W_SUPPLIER_PRODUCT_D_Primary] from [1048576] to [1740800].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_10) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21097 : Lookup Transformation [MPLT_GET_UOM_CONVERSIONS.LKP_W_UOM_CONVERSION_G_ITEM_LEVEL_RATES_PRIMARY_UOM]: Default sql to create lookup cache: SELECT CONVERSION_RATE,TO_UOM_CODE,DATASOURCE_NUM_ID,INTEGRATION_ID FROM W_UOM_CONVERSION_G ORDER BY DATASOURCE_NUM_ID,INTEGRATION_ID
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_10) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [MPLT_GET_UOM_CONVERSIONS.LKP_W_UOM_CONVERSION_G_ITEM_LEVEL_RATES_PRIMARY_UOM] from [1048576] to [1392640].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_18) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21312 : Lookup Transformation [mplt_SIL_PurchaseReceiptFact.Lkp_W_PRODUCT_D_Product_Wid]: Lookup override sql to create cache: SELECT LOOKUP_TABLE.ROW_WID AS ROW_WID, LOOKUP_TABLE.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID, LOOKUP_TABLE.INTEGRATION_ID AS INTEGRATION_ID, LOOKUP_TABLE.EFFECTIVE_FROM_DT AS EFFECTIVE_FROM_DT, LOOKUP_TABLE.EFFECTIVE_TO_DT AS EFFECTIVE_TO_DT FROM W_PRODUCT_D LOOKUP_TABLE, W_PURCH_RCPT_FS TARGET_STAGE
WHERE
LOOKUP_TABLE.INTEGRATION_ID = TARGET_STAGE.PRODUCT_ID AND
LOOKUP_TABLE.DATASOURCE_NUM_ID = TARGET_STAGE.DATASOURCE_NUM_ID
ORDER BY
LOOKUP_TABLE.DATASOURCE_NUM_ID,
LOOKUP_TABLE.INTEGRATION_ID,
LOOKUP_TABLE.EFFECTIVE_FROM_DT,
LOOKUP_TABLE.EFFECTIVE_TO_DT,
LOOKUP_TABLE.ROW_WID -- ORDER BY DATASOURCE_NUM_ID,INTEGRATION_ID,EFFECTIVE_FROM_DT,EFFECTIVE_TO_DT,ROW_WID
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_18) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [mplt_SIL_PurchaseReceiptFact.Lkp_W_PRODUCT_D_Product_Wid] from [1048576] to [1740800].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_19) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21312 : Lookup Transformation [mplt_SIL_PurchaseReceiptFact.Lkp_Codes_UOM]: Lookup override sql to create cache: SELECT W_CODE_D.MASTER_CODE AS MASTER_CODE, W_CODE_D.SOURCE_CODE AS SOURCE_CODE, W_CODE_D.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID FROM W_CODE_D
WHERE
W_CODE_D.CATEGORY = 'UOM' AND
W_CODE_D.LANGUAGE_CODE = 'E' ORDER BY SOURCE_CODE,DATASOURCE_NUM_ID,MASTER_CODE
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_19) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [mplt_SIL_PurchaseReceiptFact.Lkp_Codes_UOM] from [1048576] to [1050000].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_20) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21312 : Lookup Transformation [mplt_SIL_PurchaseReceiptFact.Lkp_W_SUPPLIER_D_Supplier_Wid]: Lookup override sql to create cache: SELECT LOOKUP_TABLE.ROW_WID AS ROW_WID, LOOKUP_TABLE.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID, LOOKUP_TABLE.SUPPLIER_ID AS SUPPLIER_ID, LOOKUP_TABLE.EFFECTIVE_FROM_DT AS EFFECTIVE_FROM_DT, LOOKUP_TABLE.EFFECTIVE_TO_DT AS EFFECTIVE_TO_DT FROM W_PARTY_ORG_D LOOKUP_TABLE
WHERE LOOKUP_TABLE.SUPPLIER_ID IS NOT NULL ORDER BY DATASOURCE_NUM_ID,SUPPLIER_ID,EFFECTIVE_FROM_DT,EFFECTIVE_TO_DT,ROW_WID
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_20) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [mplt_SIL_PurchaseReceiptFact.Lkp_W_SUPPLIER_D_Supplier_Wid] from [1048576] to [1740800].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_21) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21312 : Lookup Transformation [mplt_SIL_PurchaseReceiptFact.LKP_W_SUPPLIER_ACCOUNT_D]: Lookup override sql to create cache: SELECT LOOKUP_TABLE.ROW_WID AS ROW_WID, LOOKUP_TABLE.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID, LOOKUP_TABLE.INTEGRATION_ID AS INTEGRATION_ID, LOOKUP_TABLE.EFFECTIVE_FROM_DT AS EFFECTIVE_FROM_DT, LOOKUP_TABLE.EFFECTIVE_TO_DT AS EFFECTIVE_TO_DT FROM W_SUPPLIER_ACCOUNT_D LOOKUP_TABLE ORDER BY DATASOURCE_NUM_ID,INTEGRATION_ID,EFFECTIVE_FROM_DT,EFFECTIVE_TO_DT,ROW_WID
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_21) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [mplt_SIL_PurchaseReceiptFact.LKP_W_SUPPLIER_ACCOUNT_D] from [1048576] to [1740800].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_22) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21312 : Lookup Transformation [mplt_SIL_PurchaseReceiptFact.Lkp_W_XACT_TYPE_D_Xact_Type_Wid_SHIPMENT_TYPE]: Lookup override sql to create cache: SELECT LOOKUP_TABLE.ROW_WID AS ROW_WID, LOOKUP_TABLE.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID, LOOKUP_TABLE.INTEGRATION_ID AS INTEGRATION_ID FROM W_XACT_TYPE_D LOOKUP_TABLE ORDER BY DATASOURCE_NUM_ID,INTEGRATION_ID,ROW_WID
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_22) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [mplt_SIL_PurchaseReceiptFact.Lkp_W_XACT_TYPE_D_Xact_Type_Wid_SHIPMENT_TYPE] from [1048576] to [1392640].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_27) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21312 : Lookup Transformation [mplt_SIL_PurchaseReceiptFact.Lkp_W_Inventory_Product_D_Inventory_Prod_Wid]: Lookup override sql to create cache: SELECT LOOKUP_TABLE.ROW_WID AS ROW_WID, LOOKUP_TABLE.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID, LOOKUP_TABLE.INTEGRATION_ID AS INTEGRATION_ID, LOOKUP_TABLE.EFFECTIVE_FROM_DT AS EFFECTIVE_FROM_DT, LOOKUP_TABLE.EFFECTIVE_TO_DT AS EFFECTIVE_TO_DT FROM W_INVENTORY_PRODUCT_D LOOKUP_TABLE, W_PURCH_RCPT_FS TARGET_STAGE
WHERE
LOOKUP_TABLE.INTEGRATION_ID = TARGET_STAGE.INVENTORY_PROD_ID AND
LOOKUP_TABLE.DATASOURCE_NUM_ID = TARGET_STAGE.DATASOURCE_NUM_ID
ORDER BY
LOOKUP_TABLE.DATASOURCE_NUM_ID,
LOOKUP_TABLE.INTEGRATION_ID,
LOOKUP_TABLE.EFFECTIVE_FROM_DT,
LOOKUP_TABLE.EFFECTIVE_TO_DT,
LOOKUP_TABLE.ROW_WID -- ORDER BY DATASOURCE_NUM_ID,INTEGRATION_ID,EFFECTIVE_FROM_DT,EFFECTIVE_TO_DT,ROW_WID
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_27) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [mplt_SIL_PurchaseReceiptFact.Lkp_W_Inventory_Product_D_Inventory_Prod_Wid] from [1048576] to [1740800].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_29) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21312 : Lookup Transformation [mplt_Curcy_Conversion_Rates.LKP_W_EXCH_RATE]: Lookup override sql to create cache: SELECT W_EXCH_RATE_G.EXCH_RATE AS EXCH_RATE, W_EXCH_RATE_G.FROM_CURCY_CD AS FROM_CURCY_CD, W_EXCH_RATE_G.TO_CURCY_CD AS TO_CURCY_CD, W_EXCH_RATE_G.START_DT AS START_DT, W_EXCH_RATE_G.END_DT AS END_DT, W_EXCH_RATE_G.RATE_TYPE AS RATE_TYPE, W_EXCH_RATE_G.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID FROM W_EXCH_RATE_G,
(
SELECT
GLOBAL1_CURR_CODE REQUIRED_TO_CURR,
GLOBAL1_RATE_TYPE REQUIRED_RATE_TYPE,
DATASOURCE_NUM_ID DSN
FROM
W_GLOBAL_CURR_G
UNION
SELECT
GLOBAL2_CURR_CODE REQUIRED_TO_CURR,
GLOBAL2_RATE_TYPE REQUIRED_RATE_TYPE,
DATASOURCE_NUM_ID DSN
FROM
W_GLOBAL_CURR_G
UNION
SELECT
GLOBAL3_CURR_CODE REQUIRED_TO_CURR,
GLOBAL3_RATE_TYPE REQUIRED_RATE_TYPE,
DATASOURCE_NUM_ID DSN
FROM
W_GLOBAL_CURR_G
) GLOBAL_CURR
WHERE
W_EXCH_RATE_G.TO_CURCY_CD = GLOBAL_CURR.REQUIRED_TO_CURR AND
W_EXCH_RATE_G.RATE_TYPE = GLOBAL_CURR.REQUIRED_RATE_TYPE AND
W_EXCH_RATE_G.DATASOURCE_NUM_ID = GLOBAL_CURR.DSN ORDER BY FROM_CURCY_CD,TO_CURCY_CD,START_DT,END_DT,RATE_TYPE,DATASOURCE_NUM_ID,EXCH_RATE
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_29) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [mplt_Curcy_Conversion_Rates.LKP_W_EXCH_RATE] from [40000000] to [40003584].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_29) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Data Cache] size for transformation [mplt_Curcy_Conversion_Rates.LKP_W_EXCH_RATE] from [20000000] to [20004864].
2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_33) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : DBG_21097 : Lookup Transformation [mplt_Curcy_Conversion_Rates.GET_GLOBAL_CURR_CODES_AND_RATE_TYPES]: Default sql to create lookup cache: SELECT GLOBAL1_CURR_CODE,GLOBAL2_CURR_CODE,GLOBAL3_CURR_CODE,GLOBAL1_RATE_TYPE,GLOBAL2_RATE_TYPE,GLOBAL3_RATE_TYPE,DEFAULT_LOC_RATE_TYPE,DATASOURCE_NUM_ID,TENANT_ID FROM W_GLOBAL_CURR_G ORDER BY DATASOURCE_NUM_ID,TENANT_ID,GLOBAL1_CURR_CODE,GLOBAL2_CURR_CODE,GLOBAL3_CURR_CODE,GLOBAL1_RATE_TYPE,GLOBAL2_RATE_TYPE,GLOBAL3_RATE_TYPE,DEFAULT_LOC_RATE_TYPE
<
p>2017-09-05 00:15:22 : INFO : (17891420 | LKPDP_33) : (IS | BIA_IS_PRD) : node01_nlaobixva01 : TE_7212 : Increasing [Index Cache] size for transformation [mplt_Curcy_Conversion_R
Answers
-
Hi Avinash,
Just before my mouse broke down (after all the scrolling) I saw the following; ORA-00001: unique constraint (SO_BAW_PROD.W_PURCH_RCPT_F_U1) violated
That should be the source of the problem.
Good luck.
Daan Bakboord
0 -
Daan beat me to it.
Is it too hard to search through the log file??
0 -
Hi Avinash,
The issue is when it is trying to insert, there is going to be a duplicate, not that there is a duplicate in either the temp, staging, or target table. In this situation, drop the index (or disable the constraint), run the mapping again manually, and then check the target for duplicates, remediate (take backups, remove duplicates, etc) and add the index back.
Cheers
--Becky
0