ISSUE: After executing EIM, the IF_ROW_STAT field becomes REQUIRED_COLS and rows are not imported.
CAUSE: We get REQUIRED_COLS in IF_ROW_STAT when one or more of the required columns are not populated in EIM table.
ISSUE RESOLUTION: To resolve the issue, go through the log file of the eim process. In log file file you should find the following section if the log level has been set to the appropriate level. (Please note in our case, we had the above issue with EIM_PROD_INT.) The log file will give you the list of required fields. Please check which of the required fields are not being populated in the EIM table and supply a value for same. Then run the eim process again and it should work fine this time.
Extract from log file follows:
EIMTrace EIMTraceSubEvent 3 000000034d8c0740:0 2011-03-25 11:53:21 3/25/11 11:53 Warning: Inserting new rows into S_PROD_INT failed 44 rows.
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 -------------------------------------------------------------------------------
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 Process [Import EIM_PROD_INT] had 44 rows fail
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 on EIM_PROD_INT for batch 1000000 in step 9, pass 113:
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 NULL values in IF table for required base table columns. (severity 6, rows eliminated)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 Interface table:
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 EIM_PROD_INT (EIM_PROD_INT)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 ------------
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 ACTIVE_FLG (Active Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 ADD_TO_QUOTE_FLG (Add To Quote Flg)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 APPROVAL_FLG (APPROVAL_FLG)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 AUTO_UNGROUP_FLG (Automatic Ungroup Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 BILLABLE_FLG (Billable Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 CMPND_FLG (Compound Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 COMMISIONED_FLG (Commisioned Flg)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 COMPENSATABLE_FLG (Compensatable Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 NAME (Name)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 PROD_BI (Name)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 CG_COMPETITOR_FLG (Cg Competitor Flg)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 CRT_AGREEMENT_FLG (Create Agreement Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 CRT_AST_REC_FLG (Crt Ast Rec Flg)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 CRT_INST_FLG (Create Instance Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 DESIGN_REG_FLG (Design Registration Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 ENTERPRISE_FLG (Enterprise-Visible Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 FEATURED_FLG (Featured Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 INCLSV_ELIG_RL_FLG (Inclusive Eligibility Rule Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 LEAF_LEVEL_FLG (Leaf level flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 MODEL_PROD_FLG (Model Prod Flg)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 NEED_PH_NUM_FLG (Need Phone Number Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 ORDERABLE_FLG (Orderable Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 POSTN_BL_PROD_FLG (Position Billing Product Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 PRD_INCLALLCRSEFLG (Include All Course Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 PRODAPPLYECRULEFLG (Apply Eligibility Compatibility Rule Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 SALES_PROD_FLG (Sales product flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 SALES_SRVC_FLG (Sales/Service flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 SERVICE_FLG (Service Flg)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 SERV_INST_FLG (Serv Inst Flg)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 SHIP_FLG (Ship Flg)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 TARGET_VRSN_FLG (Target Vrsn Flg)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 TAX_SUBCOMP_FLG (Tax Subcomp Flg)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 TRANSFERABLE_FLG (Transferable Flg)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 TWOBARCODES_FLG (TWOBARCODES_FLG)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 UNIQUE_ASSET_FLG (UNIQUE_ASSET_FLG)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 Base table:
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 S_PROD_INT (Internal Product)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 ----------
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 ACTIVE_FLG (Active Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 ADD_TO_QUOTE_FLG (Add To Quote Flg)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 APPROVAL_FLG (APPROVAL_FLG)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 AUTO_UNGROUP_FLG (Automatic Ungroup Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 BILLABLE_FLG (Billable Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 CMPND_FLG (Compound Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 COMMISIONED_FLG (Commisioned Flg)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 COMPENSATABLE_FLG (Compensatable Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 NAME (Name)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 BU_ID (Business Unit Id)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 CG_COMPETITOR_FLG (Cg Competitor Flg)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 CRT_AGREEMENT_FLG (Create Agreement Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 CRT_AST_REC_FLG (Crt Ast Rec Flg)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 CRT_INST_FLG (Create Instance Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 DESIGN_REG_FLG (Design Registration Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 ENTERPRISE_FLG (Enterprise-Visible Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 FEATURED_FLG (Featured Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 INCLSV_ELIG_RL_FLG (Inclusive Eligibility Rule Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 LEAF_LEVEL_FLG (LEAF_LEVEL_FLG)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 MODEL_PROD_FLG (Model Prod Flg)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 NEED_PH_NUM_FLG (Need Phone Number Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 ORDERABLE_FLG (Orderable Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 POSTN_BL_PROD_FLG (Position Billing Product Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 INCL_ALL_CRSE_FLG (Include All Course Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 APPLY_EC_RULE_FLG (Apply Eligibility Compatibility Rule Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 SALES_PROD_FLG (Sales product flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 SALES_SRVC_FLG (Sales/Service flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 SERVICE_FLG (Service Flg)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 SERV_INST_FLG (Serv Inst Flg)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 SHIP_FLG (Ship Flg)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 TARGET_VRSN_FLG (Target Vrsn Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 TAX_SUBCOMP_FLG (Tax Subcomp Flag)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 TRANSFERABLE_FLG (Transferable Flg)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 TWOBARCODES_FLG (TWOBARCODES_FLG)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 UNIQUE_ASSET_FLG (UNIQUE_ASSET_FLG)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 CONFLICT_ID (Conflict Id)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 CREATED (Created)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 CREATED_BY (Created By)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 DB_LAST_UPD (Last Updated - This Database)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 DB_LAST_UPD_SRC (Source of Last Update - This Database)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 LAST_UPD (Last Updated)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 LAST_UPD_BY (Last Updated By)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 MODIFICATION_NUM (Modification Number)
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 These rows could not be inserted into the destination base table because some
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 of the required columns did not have values. Check that all columns which are
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 required in the base table have values in the interface table.
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 This failure caused the rows to be eliminated from further processing for the
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 target base table. This failure will prevent these rows from being imported at
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 all.
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 SQL query to return rows which were eliminated:
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 SELECT ROW_ID
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 FROM SIEBEL.EIM_PROD_INT
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 WHERE (T_PROD_INT__STA = 113 AND
EIMError EIMErrorSubEvent 0 000000034d8c0740:0 2011-03-25 11:53:21 IF_ROW_BATCH_NUM = 1000000)
EIMTrace EIMTraceSubEvent 3 000000034d8c0740:0 2011-03-25 11:53:21 > Step 9: inserting new rows S_PROD_INT 1s
SQLTraceAll SQLTraceAll 4 000000034d8c0740:0 2011-03-25 11:53:21 (SQLSetConnectOption) Conn Handle: 35461664, Time: 0s
SQLConnectOptions Set Connection Option 4 000000034d8c0740:0 2011-03-25 11:53:21 (SQLSetConnectOption) Handle: 35461664, Time: 0s
SQLConnectOptions Set Connection Option Detail 5 000000034d8c0740:0 2011-03-25 11:53:21 (SQLSetConnectOption) Option: 102, Param: 1
SQLTraceAll SQLTraceAll 4 000000034d8c0740:0 2011-03-25 11:53:21 (SQLTransact) Env Handle: 35461496, Conn Handle: 35461664, Time: 0s
SQLConnectOptions Transaction 4 000000034d8c0740:0 2011-03-25 11:53:21 (SQLTransact) Env Handle: 35461496, Conn Handle: 35461664, Time: 0s
SQLConnectOptions Transaction Detail 5 000000034d8c0740:0 2011-03-25 11:53:21 (SQLTransact) Type: SQL_COMMIT
EIMSQL EIMSQLSubEvent 4 000000034d8c0740:0 2011-03-25 11:53:21
No comments:
Post a Comment