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
