Forum Stats

  • 3,752,068 Users
  • 2,250,454 Discussions
  • 7,867,707 Comments

Discussions

FDM export Issue

Hussein Mahmoud
Hussein Mahmoud Member Posts: 26 Green Ribbon
edited Feb 19, 2020 11:28AM in Financial Data Management

Hello FDM expertise,

I follow all the steps to upload the data into FCCS it imported successfully but failed in export
please check the log file and advise

Thank you,

2020-02-19 12:48:34,808 INFO [AIF]: FDMEE Process: 395, Log Level: 5

2020-02-19 12:48:34,808 INFO [AIF]: Location     : LRL_LOC (Partitionkey:42)

2020-02-19 12:48:34,808 INFO [AIF]: Period Name  : Dec-19 (Period Key:12/31/19 12:00 AM)

2020-02-19 12:48:34,808 INFO [AIF]: Category Name: Actual (Category key:1)

2020-02-19 12:48:34,808 INFO [AIF]: Rule Name    : LRL_TB (Rule ID:17)

2020-02-19 12:48:36,106 DEBUG [AIF]: FDMEE Version: 11.1.2.4.000, p1_2002_008.drv

2020-02-19 12:48:36,106 INFO [AIF]: Log File Encoding: UTF-8

2020-02-19 12:48:37,111 INFO [AIF]: -------START IMPORT STEP-------

2020-02-19 12:48:37,234 DEBUG [AIF]: FileData.extractDataFromSource - START

2020-02-19 12:48:37,234 DEBUG [AIF]: CommData.getRuleInfo - START

2020-02-19 12:48:37,236 DEBUG [AIF]:

      SELECT adim.BALANCE_COLUMN_NAME DIMNAME, adim.DIMENSION_ID, adim.TARGET_DIMENSION_CLASS_NAME, tiie.IMPCONCATCHAR

            ,(SELECT COA_SEGMENT_NAME FROM AIF_COA_SEGMENTS cs WHERE cs.COA_LINE_ID = tiie.IMPSOURCECOALINEID1) COA_SEGMENT_NAME1

      FROM TPOVPARTITION tpp

      INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

        ON adim.APPLICATION_ID = 7

      LEFT OUTER JOIN TBHVIMPITEMERPI tiie

        ON tiie.IMPGROUPKEY = tpp.PARTIMPGROUP AND tiie.IMPFLDFIELDNAME = adim.BALANCE_COLUMN_NAME AND tiie.IMPMAPTYPE = 'ERP'

      WHERE tpp.PARTITIONKEY = 42

      AND adim.BALANCE_COLUMN_NAME IS NOT NULL

      AND adim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

      AND (adim.VALID_FOR_PLAN1 = 1 OR adim.TARGET_DIMENSION_CLASS_NAME = 'LOOKUP')

      ORDER BY adim.BALANCE_COLUMN_NAME

     

2020-02-19 12:48:37,237 DEBUG [AIF]: SELECT property_value FROM aif_target_appl_properties WHERE application_id = 7 and property_type = 'WORKFLOW_MODE'

2020-02-19 12:48:37,238 DEBUG [AIF]: {'PLAN_NUMBER': 1L, 'EXPORT_TO_TARGET_FLAG': u'Y', 'SRC_TARGET_APP_NAME': 'NA', 'JOURNAL_FLAG': None, 'DIMNAME_MAP': {u'UD2': {'DIMNAME': u'UD2', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD4': {'DIMNAME': u'UD4', 'TARGET_DIMENSION_CLASS_NAME': u'Data Source'}, u'UD3': {'DIMNAME': u'UD3', 'TARGET_DIMENSION_CLASS_NAME': u'Generic'}, u'UD5': {'DIMNAME': u'UD5', 'TARGET_DIMENSION_CLASS_NAME': u'Movement'}, u'ACCOUNT': {'DIMNAME': u'ACCOUNT', 'TARGET_DIMENSION_CLASS_NAME': u'Account'}, u'ENTITY': {'DIMNAME': u'ENTITY', 'TARGET_DIMENSION_CLASS_NAME': u'Entity'}, u'ICP': {'DIMNAME': u'ICP', 'TARGET_DIMENSION_CLASS_NAME': u'ICP'}}, 'CATKEY': 1L, 'TGT_APP_SUB_TYPE': u'FCCS', 'TGT_APP_ID': 7L, 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD2', u'UD3', u'UD4', u'UD5'], 'SRC_SOURCE_SYSTEM_ID': 1L, 'TGT_SOURCE_SYSTEM_TYPE': None, 'TGT_APP_TYPE': u'HPL', 'CALENDAR_ID': None, 'TGT_TARGET_APP_NAME': u'RL_CONS', 'PARTITIONKEY': 42L, 'EXECUTION_MODE': u'REPLACE', 'LEDGER_GROUP_CODE': u'NONE', 'PS_LEDGER': None, 'SRC_DATA_LOAD_METHOD': 'NA', 'PARTVALGROUP': u'[NONE]', 'WEB_SERVICE_URL': u'http://nladpbcsr914033.nldc1.oraclecloud.com:9000/aif', 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'IS_INCREMENTAL_LOAD': False, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'SRC_APP_NAME': 'NA', 'FCI_FLAG': 'N', 'KK_FLAG': u'N', 'LAST_UPDATED_BY': u'[email protected]', 'CHECK_FLAG': u'Y', 'RULE_ID': 17L, 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'SRC_APP_ID': None, 'INCLUDE_ZERO_BALANCE_FLAG': None, 'IMPGROUPKEY': u'RL_TB', 'WORKFLOW_MODE': u'FULL', 'TGT_SOURCE_SYSTEM_ID': 0L, 'SRC_APP_TYPE': 'NA', 'TGT_APP_NAME': u'RL_CONS', 'IMPGROUPFILETYPE': u'DELIMITED', 'LEDGER_GROUP': None, 'TGT_COA_ID': 0L, 'SOURCE_ADAPTER_FLAG': u'N', 'RECALCULATE_FLAG': u'Y', 'TGT_DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'SRC_SOURCE_SYSTEM_TYPE': u'FILE', 'PLAN_TYPE': u'PLAN1', 'TGT_METADATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI'}

2020-02-19 12:48:37,239 DEBUG [AIF]: {u'Intercompany': {'BCN': u'ICP', 'DCN': u'ICP'}, u'Account': {'BCN': u'ACCOUNT', 'DCN': u'Account'}, u'Entity': {'BCN': u'ENTITY', 'DCN': u'Entity'}, u'Business Segment': {'BCN': u'UD2', 'DCN': u'Generic'}, u'Movement': {'BCN': u'UD5', 'DCN': u'Movement'}, u'Years': {'BCN': None, 'DCN': u'Year'}, u'Period': {'BCN': None, 'DCN': u'Period'}, u'View': {'BCN': None, 'DCN': u'View'}, u'Scenario': {'BCN': None, 'DCN': u'Scenario'}, u'Commodity': {'BCN': u'UD3', 'DCN': u'Generic'}, u'Consolidation': {'BCN': None, 'DCN': u'Consolidation'}, u'Data Source': {'BCN': u'UD4', 'DCN': u'Data Source'}, u'Currency': {'BCN': None, 'DCN': u'Currency'}}

2020-02-19 12:48:37,239 DEBUG [AIF]: {u'UD2': {'IMPFLDSOURCECOLNAME': u'Class'}, u'UD3': {'IMPFLDSOURCECOLNAME': u'Location'}, u'ACCOUNT': {'IMPFLDSOURCECOLNAME': u'AccountNumber'}, u'ENTITY': {'IMPFLDSOURCECOLNAME': u'Company'}, u'AMOUNT': {'IMPFLDSOURCECOLNAME': u'Amount_homebase'}, u'ICP': {'IMPFLDSOURCECOLNAME': u'Dealer'}, u'DESC1': {'IMPFLDSOURCECOLNAME': u'Account Name Long'}}

2020-02-19 12:48:37,239 DEBUG [AIF]: CommData.getRuleInfo - END

2020-02-19 12:48:37,240 DEBUG [AIF]: FileData.extractDataFromSource - END

2020-02-19 12:48:37,259 DEBUG [AIF]: FileData.preProcessDataFile - START

2020-02-19 12:48:37,290 DEBUG [AIF]: FileData.preProcessDataFile - END

2020-02-19 12:48:37,311 DEBUG [AIF]: CommData.preImportData - START

2020-02-19 12:48:37,311 DEBUG [AIF]: CommData.insertFilePeriods - START

2020-02-19 12:48:37,313 DEBUG [AIF]: doAppPeriodMappingsExist - RL_CONS: N

2020-02-19 12:48:37,313 DEBUG [AIF]: SELECT 1 FROM AIF_BAL_RULE_LOAD_PARAMS WHERE LOADID = 395 AND PARAMETER_TYPE = 'SOURCE_PERIODS'

2020-02-19 12:48:37,313 DEBUG [AIF]: Period mapping section: SINGLE-COLUMN/DEFAULT

2020-02-19 12:48:37,314 DEBUG [AIF]:

            SELECT pp.PERIODKEY, pp.PERIODDESC, pp.YEARTARGET, pp.PERIODTARGET, brl.FILE_NAME_STATIC, brl.FILE_NAME_SUFFIX_TYPE, brl.FILE_NAME_DATE_FORMAT

                  ,0 GL_EFFECTIVE_PERIOD_NUM, 0 GL_PERIOD_NUM, '0' GL_PERIOD_NAME, 0 GL_PERIOD_YEAR

            FROM AIF_BAL_RULE_LOADS brl

            INNER JOIN TPOVCATEGORY pc

              ON pc.CATKEY = brl.CATKEY

        INNER JOIN TPOVPERIOD_FLAT_V pp

          ON pp.PERIODFREQ = pc.CATFREQ AND pp.PERIODKEY >= brl.START_PERIODKEY AND pp.PERIODKEY <= brl.END_PERIODKEY

            WHERE brl.LOADID = 395

            ORDER BY PERIODKEY

           

2020-02-19 12:48:37,314 INFO [AIF]: File Name: LRL YTD TB Dec-19.csv

2020-02-19 12:48:37,314 DEBUG [AIF]:

        INSERT INTO AIF_PROCESS_PERIODS (

          PROCESS_ID, PERIODKEY, ADJUSTMENT_PERIOD_FLAG, GL_PERIOD_YEAR, GL_PERIOD_CODE, GL_PERIOD_NAME, GL_PERIOD_NUM, GL_EFFECTIVE_PERIOD_NUM

         ,YEARTARGET, PERIODTARGET, IMP_ENTITY_TYPE, IMP_ENTITY_NAME, TRANS_ENTITY_TYPE, TRANS_ENTITY_NAME, PRIOR_PERIOD_FLAG, GL_PERIOD_YEAR_CHAR)

        VALUES (395,'2019-12-31','N',0,'0' ,'0',0,1,'FY19','Dec', 'PROCESS_BAL_IMP_FILE','LRL YTD TB Dec-19.csv','PROCESS_BAL_TRANS','Dec-19','N', 0)

       

2020-02-19 12:48:37,315 DEBUG [AIF]: insertRowCount: 1

2020-02-19 12:48:37,317 DEBUG [AIF]: CommData.insertFilePeriods - END

2020-02-19 12:48:37,317 DEBUG [AIF]: CommData.getPovList - START

2020-02-19 12:48:37,317 DEBUG [AIF]:

        SELECT DISTINCT brl.PARTITIONKEY, part.PARTNAME, brl.CATKEY, cat.CATNAME, pprd.PERIODKEY

,COALESCE(pp.PERIODDESC, TO_CHAR(pprd.PERIODKEY,'YYYY-MM-DD HH24:MI:SS')) PERIODDESC

,brl.RULE_ID, br.RULE_NAME, CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG

        FROM AIF_BAL_RULE_LOADS brl

        INNER JOIN AIF_BALANCE_RULES br

          ON br.RULE_ID = brl.RULE_ID

        INNER JOIN TPOVPARTITION part

          ON part.PARTITIONKEY = brl.PARTITIONKEY

        INNER JOIN TPOVCATEGORY cat

          ON cat.CATKEY = brl.CATKEY

        INNER JOIN AIF_PROCESS_PERIODS pprd

          ON pprd.PROCESS_ID = brl.LOADID

        LEFT OUTER JOIN TPOVPERIOD pp

          ON pp.PERIODKEY = pprd.PERIODKEY

        LEFT OUTER JOIN TLOGPROCESS tlp

          ON tlp.PARTITIONKEY = brl.PARTITIONKEY AND tlp.CATKEY = brl.CATKEY AND tlp.PERIODKEY = pprd.PERIODKEY AND tlp.RULE_ID = brl.RULE_ID

        WHERE brl.LOADID = 395

        ORDER BY brl.PARTITIONKEY, brl.CATKEY, pprd.PERIODKEY, brl.RULE_ID

       

2020-02-19 12:48:37,318 DEBUG [AIF]: CommData.getPovList - END

2020-02-19 12:48:37,318 DEBUG [AIF]: CommData.preImportData - END

2020-02-19 12:48:37,338 DEBUG [AIF]: CommData.insertImportProcessDetails - START

2020-02-19 12:48:37,338 DEBUG [AIF]:

          INSERT INTO AIF_PROCESS_DETAILS (

PROCESS_ID, ENTITY_TYPE, ENTITY_ID, ENTITY_NAME, ENTITY_NAME_ORDER, TARGET_TABLE_NAME, EXECUTION_START_TIME

,EXECUTION_END_TIME, RECORDS_PROCESSED, STATUS, LAST_UPDATED_BY, LAST_UPDATE_DATE

          )

          SELECT PROCESS_ID, ENTITY_TYPE, ENTITY_ID, ENTITY_NAME, ENTITY_NAME_ORDER, 'TDATASEG' TARGET_TABLE_NAME, CURRENT_TIMESTAMP EXECUTION_START_TIME

                ,NULL EXECUTION_END_TIME, 0 RECORDS_PROCESSED, 'PENDING' STATUS, '[email protected]' LAST_UPDATED_BY, CURRENT_TIMESTAMP LAST_UPDATE_DATE

          FROM (

            SELECT DISTINCT PROCESS_ID, IMP_ENTITY_TYPE ENTITY_TYPE, IMP_ENTITY_ID ENTITY_ID, IMP_ENTITY_NAME ENTITY_NAME

,(COALESCE(SOURCE_LEDGER_ID,0) * 100000000 + GL_EFFECTIVE_PERIOD_NUM) ENTITY_NAME_ORDER

            FROM AIF_PROCESS_PERIODS

            WHERE PROCESS_ID = 395

          ) q

          ORDER BY ENTITY_NAME_ORDER

         

2020-02-19 12:48:37,340 DEBUG [AIF]: Comm.doScriptInit - START

2020-02-19 12:48:37,391 DEBUG [AIF]: fdmContext: {PERIODKEY=2019-12-31, CATKEY=1, APPNAME=RL_CONS, EXPORTFLAG=Y, SOURCEID=1, TARGETAPPNAME=RL_CONS, USERLOCALE=en, IMPORTFLAG=Y, SOURCENAME=File, PERIODNAME=Dec-19, LOCNAME=LRL_LOC, [email protected], FILENAME=LRL YTD TB Dec-19.csv, TARGETAPPTYPE=HPL, TARGETAPPDB=PLAN1, FILEDIR=inbox/Group.LRL, APPID=7, MULTIPERIODLOAD=N, LOADID=395, RULEID=17, IMPORTMODE=REPLACE, SOURCETYPE=FILE, CATNAME=Actual, RULENAME=LRL_TB, LOCKEY=42, EXPORTMODE=Merge, IMPORTFORMAT=RL_TB}

2020-02-19 12:48:37,392 DEBUG [AIF]: Comm.doScriptInit - END

2020-02-19 12:48:37,392 DEBUG [AIF]: CommData.insertImportProcessDetails - END

2020-02-19 12:48:37,412 DEBUG [AIF]: FileData.importData - START

2020-02-19 12:48:37,412 DEBUG [AIF]: Importing data for load id: 395

2020-02-19 12:48:37,413 DEBUG [AIF]:

            SELECT a.partitionkey, a.catkey, a.start_periodkey, b.perioddesc, coalesce(a.journal_flag,'N') JOURNAL_FLAG, c.last_updated_by,

coalesce(a.FILE_NAME_STATIC,'') FILE_NAME_STATIC, a.FILE_PATH, a.RULE_ID, a.application_id

            FROM aif_bal_rule_loads a,

aif_balance_rules br,

tpovperiod b,

aif_processes c

            WHERE a.loadid       = 395

            AND a.start_periodkey=b.periodkey

            AND a.loadid         =c.process_id

            AND br.rule_id = a.rule_id

           

2020-02-19 12:48:37,414 DEBUG [AIF]: FileData.py: Importing Text data for load id: 395

2020-02-19 12:48:37,468 INFO [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:IMPGROUPFILETYPE::395;42:1:17:Entity Currency::DELIMITED

2020-02-19 12:48:37,472 INFO [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8

2020-02-19 12:48:37,472 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - Start

2020-02-19 12:48:37,472 DEBUG [AIF]: EPMFDM-140274:Message -  SELECT pp.PERIODKEY,

  pp.PERIODTARGET,

  pp.GL_PERIOD_NAME,

  en.FILE_ENTITY_NAME,

en.ENTITY_NAME_ORDER,

  br.MULTI_PERIOD_FILE_FLAG,

pp.TRANS_ENTITY_NAME,

pp.GL_PERIOD_YEAR_CHAR,

  pp.GL_PERIOD_NUM ,

  pp.YEARTARGET

FROM AIF_PROCESS_PERIODS pp,

  AIF_BALANCE_RULES br,

  AIF_PROCESSES p,

  (SELECT DISTINCT entity_name FILE_ENTITY_NAME,

    pd.process_id,

    pd.entity_name_order

  FROM aif_process_details pd

  WHERE pd.entity_type     = 'PROCESS_BAL_IMP_FILE'

  AND pd.target_table_name = 'TDATASEG'

  AND pd.status            = 'PENDING'

  ) en

WHERE pp.PROCESS_ID             = ?

AND p.process_id = pp.process_id

AND en.process_id               = pp.process_id

AND pp.IMP_ENTITY_NAME          = en.file_entity_name

AND br.rule_id                  = p.rule_id

AND en.entity_name_order        = pp.GL_EFFECTIVE_PERIOD_NUM

ORDER BY en.entity_name_order

2020-02-19 12:48:37,505 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=null:StartPos=9:SourceClName=Amount_homebase:ImpFldTargetExp=null

2020-02-19 12:48:37,506 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=DESC1:ImpFieldText=null:StartPos=3:SourceClName=Account Name Long:ImpFldTargetExp=null

2020-02-19 12:48:37,506 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=2:SourceClName=AccountNumber:ImpFldTargetExp=null

2020-02-19 12:48:37,506 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD2:ImpFieldText=null:StartPos=4:SourceClName=Class:ImpFldTargetExp=null

2020-02-19 12:48:37,506 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=null:StartPos=5:SourceClName=Location:ImpFldTargetExp=null

2020-02-19 12:48:37,506 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ENTITY:ImpFieldText=null:StartPos=1:SourceClName=Company:ImpFldTargetExp=null

2020-02-19 12:48:37,506 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ICP:ImpFieldText=null:StartPos=6:SourceClName=Dealer:ImpFldTargetExp=null

2020-02-19 12:48:37,506 INFO [AIF]: EPMFDM-140274:Message - Initialize error maps

2020-02-19 12:48:37,506 INFO [AIF]: EPMFDM-140274:Message - File Name LRL YTD TB Dec-19.csv

periodKey2019-12-31

2020-02-19 12:48:37,514 INFO [AIF]: EPMFDM-140274:Message - PROCESS ID: 395

PARTITIONKEY: 42

IMPORT GROUP: RL_TB

FILE TYPE: DELIMITED

DELIMITER: ,

SOURCE FILE: LRL YTD TB Dec-19.csv

PROCESSING CODES:

-----------------------------------------------------------------------------------

  1. BLANK............. Line is blank or empty.
  2. NN................ Non-Numeric, Amount field contains non numeric characters.
  3. TC................ Type Conversion, Amount field could not be converted to a number.
  4. ZP................ Zero Suppress, Amount field contains a 0 value and zero suppress is ON.

SKIP FIELD.............. SKIP field value was found

NULL ACCOUNT VALUE.............. Account Field is null

SKIP FROM SCRIPT.............. Skipped through Script

HEADER ROW.............. Header Row

ERROR_INVALID_PERIOD.............. Invalid period specified in the file.

[TC] - [Amount=NN] company,AccountNumber,AccountNameLong,Class,Location,Dealer,OriginalDealerName,ICT, Amount_homebase ,Year1,Month1, Currency , Rate to USD , Amount_USD , Comment

Rows Loaded: 56

Rows Rejected: 1

2020-02-19 12:48:37,514 DEBUG [AIF]: EPMFDM-140274:Message - Script- archiveDataFile- Start

2020-02-19 12:48:37,514 INFO [AIF]: EPMFDM-140274:Message - ARCHIVE MODE: Copy

2020-02-19 12:48:37,514 INFO [AIF]: EPMFDM-140274:Message - Start archiving file:

2020-02-19 12:48:37,514 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveId: 39520191231

2020-02-19 12:48:37,514 DEBUG [AIF]: EPMFDM-140274:Message - Archive- SourceFileName: LRL YTD TB Dec-19

Extension: csv

2020-02-19 12:48:37,515 INFO [AIF]: EPMFDM-140274:Message - Archive file name: 39520191231.csv

2020-02-19 12:48:37,516 INFO [AIF]: EPMFDM-140274:Message - Deleting the source file: LRL YTD TB Dec-19.csv

2020-02-19 12:48:37,516 INFO [AIF]: EPMFDM-140274:Message - File not deleted: LRL YTD TB Dec-19.csv

2020-02-19 12:48:37,518 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveDocKey:LRL YTD TB [email protected]-20200219_124837-1

2020-02-19 12:48:37,520 DEBUG [AIF]: EPMFDM-140274:Message - Script- archiveDataFile- End

2020-02-19 12:48:37,522 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - End

2020-02-19 12:48:37,522 INFO [AIF]: EPMFDM-140274:Message - Total time taken for the import in ms = 50

2020-02-19 12:48:37,525 DEBUG [AIF]: FileData.importData - END

2020-02-19 12:48:37,582 DEBUG [AIF]: CommData.postImportData - START

2020-02-19 12:48:37,582 DEBUG [AIF]: CommData.updateTDATASEG_T - START

2020-02-19 12:48:37,583 DEBUG [AIF]:

          SELECT pp.PERIODKEY

          FROM AIF_PROCESS_PERIODS pp

             ,( SELECT entity_name FILE_ENTITY_NAME, pd.process_id, pd.entity_name_order 

                FROM aif_process_details pd

                WHERE pd.entity_type = 'PROCESS_BAL_IMP_FILE' AND pd.target_table_name = 'TDATASEG' AND pd.status = 'FAILED'

              ) en

          WHERE pp.PROCESS_ID    = 395

          AND en.process_id      = pp.process_id

          AND pp.IMP_ENTITY_NAME = en.file_entity_name

          order by en.entity_name_order

         

2020-02-19 12:48:37,583 INFO [AIF]:

Import Data from Source for Period 'Dec-19'

2020-02-19 12:48:37,584 DEBUG [AIF]: CommData.updateWorkflow - START

2020-02-19 12:48:37,584 DEBUG [AIF]:

    SELECT tlp.PROCESSSTATUS, tlps.PROCESSSTATUSDESC, CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG

    FROM TLOGPROCESS tlp, TLOGPROCESSSTATES tlps

    WHERE tlp.PARTITIONKEY = 42 AND tlp.CATKEY = 1 AND tlp.PERIODKEY = '2019-12-31' AND tlp.RULE_ID = 17 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

   

2020-02-19 12:48:37,584 DEBUG [AIF]:

        UPDATE TLOGPROCESS

        SET PROCESSENDTIME=CURRENT_TIMESTAMP

,PROCESSSTATUS=0,PROCESSIMP=0,PROCESSVAL=0,PROCESSEXP=0,PROCESSENTLOAD=0,PROCESSENTVAL=0,BLNWCDIRTY=0,BLNLOGICDIRTY=0,BLNVALDIRTY=0

,PROCESSIMPNOTE=NULL,PROCESSVALNOTE=NULL,PROCESSEXPNOTE=NULL,PROCESSENTLOADNOTE=NULL,PROCESSENTVALNOTE=NULL

        WHERE PARTITIONKEY=42 AND CATKEY=1 AND PERIODKEY='2019-12-31' AND RULE_ID=17

       

2020-02-19 12:48:37,586 DEBUG [AIF]: CommData.updateWorkflow - END

2020-02-19 12:48:37,586 DEBUG [AIF]: CommData.updateTDATASEG_T - END

2020-02-19 12:48:37,586 DEBUG [AIF]: CommData.postImportData - END

2020-02-19 12:48:37,603 DEBUG [AIF]: LogicGroup.createLogicAccounts - START

2020-02-19 12:48:37,603 DEBUG [AIF]: CommLogicGroup.getRuleInfo - START

2020-02-19 12:48:37,603 DEBUG [AIF]:

        select part.PARTLOGICGROUP, lgrp.CALCGROUPTYPE

        from AIF_PROCESSES prs, TPOVPARTITION part,TBHVLOGICGROUP lgrp

        where prs.PROCESS_ID=395 and prs.PARTITIONKEY=part.PARTITIONKEY

        and part.PARTLOGICGROUP=lgrp.CALCGROUPKEY 

       

2020-02-19 12:48:37,604 DEBUG [AIF]: CommLogicGroup.getRuleInfo - END

2020-02-19 12:48:37,604 DEBUG [AIF]: LogicGroup.createLogicAccounts - END

2020-02-19 12:48:37,622 DEBUG [AIF]: CommData.mapData - START

2020-02-19 12:48:37,622 DEBUG [AIF]: CommData.insertTransProcessDetails - START

2020-02-19 12:48:37,622 DEBUG [AIF]:

          INSERT INTO AIF_PROCESS_DETAILS (

PROCESS_ID, ENTITY_TYPE, ENTITY_ID, ENTITY_NAME, ENTITY_NAME_ORDER, TARGET_TABLE_NAME, EXECUTION_START_TIME

,EXECUTION_END_TIME, RECORDS_PROCESSED, STATUS, LAST_UPDATED_BY, LAST_UPDATE_DATE

          )

          SELECT PROCESS_ID, ENTITY_TYPE, ENTITY_ID, ENTITY_NAME, ENTITY_NAME_ORDER, 'TDATASEG' TARGET_TABLE_NAME, CURRENT_TIMESTAMP EXECUTION_START_TIME

                ,NULL EXECUTION_END_TIME, 0 RECORDS_PROCESSED, 'PENDING' STATUS, '[email protected]' LAST_UPDATED_BY, CURRENT_TIMESTAMP LAST_UPDATE_DATE

          FROM (

            SELECT PROCESS_ID, TRANS_ENTITY_TYPE ENTITY_TYPE, MIN(TRANS_ENTITY_ID) ENTITY_ID, TRANS_ENTITY_NAME ENTITY_NAME

,MIN(COALESCE(SOURCE_LEDGER_ID,0) * 100000000 + GL_EFFECTIVE_PERIOD_NUM) ENTITY_NAME_ORDER

            FROM AIF_PROCESS_PERIODS

            WHERE PROCESS_ID = 395

            AND PRIOR_PERIOD_FLAG = 'N'

            GROUP BY PROCESS_ID, TRANS_ENTITY_TYPE, TRANS_ENTITY_NAME

          ) q

          ORDER BY ENTITY_NAME_ORDER

         

2020-02-19 12:48:37,624 DEBUG [AIF]: CommData.insertTransProcessDetails - END

2020-02-19 12:48:37,624 DEBUG [AIF]:

        DELETE FROM TDATAMAP_T

        WHERE LOADID < 395

        AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 17 AND p.PROCESS_ID = TDATAMAP_T.LOADID )

       

2020-02-19 12:48:37,625 DEBUG [AIF]:

          SELECT COUNT(*) FROM TDATASEG_T

          WHERE LOADID < 395

          AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 17 AND p.PROCESS_ID = TDATASEG_T.LOADID )

         

2020-02-19 12:48:37,626 DEBUG [AIF]: intermediateCommit: True, skipRegularSql: False

2020-02-19 12:48:37,626 INFO [AIF]: Executing delete statement:

2020-02-19 12:48:37,626 DEBUG [AIF]:

        DELETE FROM TDATASEG_T

        WHERE LOADID < 395

        AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 17 AND p.PROCESS_ID = TDATASEG_T.LOADID )

       

2020-02-19 12:48:37,627 INFO [AIF]: Successfully executed delete statement

2020-02-19 12:48:37,627 DEBUG [AIF]:

        DELETE FROM AIF_PROCESS_PERIODS

        WHERE PROCESS_ID < 395

        AND EXISTS ( SELECT 1 FROM AIF_PROCESSES p WHERE p.RULE_ID = 17 AND p.PROCESS_ID = AIF_PROCESS_PERIODS.PROCESS_ID )

       

2020-02-19 12:48:37,629 DEBUG [AIF]: CommMap.loadTDATAMAP_T - START

2020-02-19 12:48:37,629 DEBUG [AIF]: CommData.getMapPartitionKeyandName - START

2020-02-19 12:48:37,629 DEBUG [AIF]:

        SELECT COALESCE(part_parent.PARTITIONKEY, part.PARTITIONKEY) PARTITIONKEY, COALESCE(part_parent.PARTNAME, part.PARTNAME) PARTNAME

        FROM TPOVPARTITION part

        LEFT OUTER JOIN TPOVPARTITION part_parent

          ON part_parent.PARTITIONKEY = part.PARTPARENTKEY

        WHERE part.PARTITIONKEY = 42

       

2020-02-19 12:48:37,629 DEBUG [AIF]: CommData.getMapPartitionKeyandName - END

2020-02-19 12:48:37,630 DEBUG [AIF]:

        INSERT INTO TDATAMAP_T (

          LOADID, DATAKEY, PARTITIONKEY, DIMNAME, SRCKEY, SRCDESC, TARGKEY

,WHERECLAUSETYPE, WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG, RULE_ID

        )

        SELECT 395, DATAKEY, 42 PARTITIONKEY, DIMNAME, SRCKEY, SRCDESC, CASE WHEN TARGKEY = '<BLANK>' THEN ' ' ELSE TARGKEY END

,WHERECLAUSETYPE, WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG, RULE_ID

        FROM TDATAMAP

        WHERE PARTITIONKEY = 42

        AND ( RULE_ID IS NULL OR RULE_ID = 17 )

       

2020-02-19 12:48:37,631 DEBUG [AIF]: Number of Rows inserted into TDATAMAP_T: 21

2020-02-19 12:48:37,632 DEBUG [AIF]: CommMap.loadTDATAMAP_T - END

2020-02-19 12:48:37,632 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - START

2020-02-19 12:48:37,632 DEBUG [AIF]:

        SELECT DIMNAME, SRCKEY, TARGKEY, WHERECLAUSETYPE, WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, DATAKEY, MAPPING_TYPE

              ,CASE WHEN (RULE_ID IS NOT NULL) THEN 'Y' ELSE 'N' END IS_RULE_MAP

        FROM (

          SELECT DISTINCT tdm.DIMNAME, tdm.RULE_ID, NULL SRCKEY, NULL TARGKEY, tdm.WHERECLAUSETYPE, tdm.WHERECLAUSEVALUE, NULL CHANGESIGN

                ,1 SEQUENCE, COALESCE(tdm.SYSTEM_GENERATED_FLAG,'N') SYSTEM_GENERATED_FLAG, NULL DATAKEY

                ,CASE WHEN tdm.WHERECLAUSETYPE IS NULL THEN 1 ELSE 3 END MAPPING_TYPE, COALESCE(atad.CALC_SEQ,9999999999) CALC_SEQ

          FROM TDATAMAP_T tdm

            INNER JOIN AIF_TARGET_APPL_DIMENSIONS atad ON atad.BALANCE_COLUMN_NAME = tdm.DIMNAME

          WHERE tdm.LOADID = 395

          AND atad.APPLICATION_ID = 7

          AND tdm.PARTITIONKEY = 42

          AND tdm.TDATAMAPTYPE = 'ERP'

          AND (tdm.RULE_ID IS NULL OR tdm.RULE_ID = 17)

          AND tdm.WHERECLAUSETYPE IS NULL

          UNION ALL

          SELECT tdm.DIMNAME, tdm.RULE_ID, tdm.SRCKEY, tdm.TARGKEY, tdm.WHERECLAUSETYPE, tdm.WHERECLAUSEVALUE, tdm.CHANGESIGN

                ,CASE WHEN (tdm.WHERECLAUSETYPE = 'BETWEEN') THEN 2  WHEN (tdm.WHERECLAUSETYPE = 'IN')   THEN 3

WHEN (tdm.WHERECLAUSETYPE = 'MULTIDIM') THEN 4  WHEN (tdm.WHERECLAUSETYPE = 'LIKE') THEN 5

ELSE 0 END SEQUENCE

,COALESCE(tdm.SYSTEM_GENERATED_FLAG,'N') SYSTEM_GENERATED_FLAG, tdm.DATAKEY

                ,CASE WHEN tdm.WHERECLAUSETYPE IS NULL THEN 1 ELSE 3 END MAPPING_TYPE, COALESCE(atad.CALC_SEQ,9999999999) CALC_SEQ

          FROM TDATAMAP_T tdm

            INNER JOIN TPOVPARTITION tpp ON tpp.PARTITIONKEY = tdm.PARTITIONKEY

            INNER JOIN AIF_TARGET_APPL_DIMENSIONS atad ON atad.BALANCE_COLUMN_NAME = tdm.DIMNAME

          WHERE tdm.LOADID = 395

          AND atad.APPLICATION_ID = 7

          AND tdm.PARTITIONKEY = 42

          AND tdm.TDATAMAPTYPE = 'ERP'

          AND (tdm.RULE_ID IS NULL OR tdm.RULE_ID = 17)

          AND tdm.WHERECLAUSETYPE IN ('BETWEEN','IN','MULTIDIM','LIKE')

        ) q

        ORDER BY CALC_SEQ, DIMNAME, SEQUENCE, RULE_ID, SYSTEM_GENERATED_FLAG, SRCKEY

       

2020-02-19 12:48:37,634 DEBUG [AIF]: SELECT VBSCRIPT FROM TDATAMAP_T WHERE LOADID = 395 AND PARTITIONKEY = 42 AND DATAKEY = 2461

2020-02-19 12:48:37,635 INFO [AIF]:

Map Data for Period 'Dec-19'

2020-02-19 12:48:37,635 DEBUG [AIF]: Comm.updateProcessDetail - START

2020-02-19 12:48:37,635 DEBUG [AIF]:

    UPDATE AIF_PROCESS_DETAILS

    SET STATUS = 'RUNNING'

,RECORDS_PROCESSED = CASE WHEN RECORDS_PROCESSED IS NULL THEN 0 ELSE RECORDS_PROCESSED END + NULL

,EXECUTION_END_TIME = CURRENT_TIMESTAMP

,LAST_UPDATED_BY = CASE WHEN ('[email protected]' IS NULL) THEN LAST_UPDATED_BY ELSE '[email protected]' END

,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

    WHERE PROCESS_ID = 395 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'Dec-19'

   

2020-02-19 12:48:37,636 DEBUG [AIF]: Comm.updateProcessDetail - END

2020-02-19 12:48:37,636 DEBUG [AIF]:

      SELECT COUNT(*) ROW_COUNT

      FROM TDATASEG_T

      WHERE LOADID = 395

      AND (PARTITIONKEY = 42 AND CATKEY = 1 AND PERIODKEY = '2019-12-31' AND RULE_ID = 17 AND VALID_FLAG = 'Y')

     

2020-02-19 12:48:37,637 INFO [AIF]:

Processing Mappings for Column 'ACCOUNT'

2020-02-19 12:48:37,637 DEBUG [AIF]:

              UPDATE TDATASEG_T

              SET (ACCOUNTX ,ACCOUNTR, AMOUNTX, CHANGESIGN, VALID_FLAG) = (

                SELECT tdm.TARGKEY

,tdm.DATAKEY

,AMOUNTX * CASE tdm.CHANGESIGN WHEN 1 THEN -1 ELSE 1 END

,CASE tdm.CHANGESIGN

WHEN 1 THEN CASE TDATASEG_T.CHANGESIGN

                                       WHEN 1 THEN 0

                                       WHEN 0 THEN 1

                                       ELSE TDATASEG_T.CHANGESIGN

                                     END

ELSE TDATASEG_T.CHANGESIGN

END

,CASE tdm.TARGKEY WHEN 'IGNORE' THEN 'I' ELSE TDATASEG_T.VALID_FLAG END  

FROM TDATAMAP_T tdm

WHERE tdm.LOADID = TDATASEG_T.LOADID

AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

AND tdm.DIMNAME = 'ACCOUNT'

AND tdm.WHERECLAUSETYPE IS NULL

AND tdm.SRCKEY = TDATASEG_T.ACCOUNT

AND tdm.RULE_ID IS NULL

AND tdm.TDATAMAPTYPE <> 'MULTIDIM'

              )

,ACCOUNTF = 1

              WHERE LOADID = 395

              AND PARTITIONKEY = 42

              AND CATKEY = 1

              AND (ACCOUNTX IS NULL OR ACCOUNTX = '')

              AND EXISTS ( SELECT 1  

FROM TDATAMAP_T tdm

WHERE tdm.LOADID = TDATASEG_T.LOADID

AND tdm.PARTITIONKEY = TDATASEG_T.PARTITIONKEY

AND tdm.DIMNAME = 'ACCOUNT'

AND tdm.WHERECLAUSETYPE IS NULL

AND tdm.SRCKEY = TDATASEG_T.ACCOUNT

AND tdm.RULE_ID IS NULL

AND tdm.TDATAMAPTYPE <> 'MULTIDIM' )

              AND PERIODKEY = '2019-12-31'

2020-02-19 12:48:37,640 INFO [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 56

2020-02-19 12:48:37,641 INFO [AIF]:

Processing Mappings for Column 'ENTITY'

2020-02-19 12:48:37,641 DEBUG [AIF]:

              UPDATE TDATASEG_T

              SET ENTITYX = 'Group.LRL'

,ENTITYR = 2459

,ENTITYF = 3

              WHERE LOADID = 395

              AND PARTITIONKEY = 42

              AND CATKEY = 1

              AND (ENTITYX IS NULL OR ENTITYX = '')

              AND (1=1)

              AND PERIODKEY = '2019-12-31'

2020-02-19 12:48:37,643 INFO [AIF]: Data Rows Updated by Location Mapping 'e1' (LIKE): 56

2020-02-19 12:48:37,643 INFO [AIF]:

Processing Mappings for Column 'ICP'

2020-02-19 12:48:37,644 DEBUG [AIF]:

              UPDATE TDATASEG_T

              SET ICPX = Case

When ICP = 'Alliance Stream Limited'  Then 'ICP_Group.ASZ'

When ICP = 'Reload Logistics Limited' Then 'ICP_Group.RLM'

When ICP = 'Reload Logistics Ltd (Malta)   RLM' Then 'ICP_Group.RLM'

When ICP = 'Alliance Stream Limited (ZMB)   ASZ' Then 'ICP_Group.ASZ'

When ICP = 'Reload Logistics' Then 'ICP_Group.MAU'

When ICP = 'Reload Logistics Tanzania Limited' Then 'ICP_Group.RLT'

When ICP = 'Solena Property (Pty) Limited   SPL ZAR' Then 'ICP_Group.SOP'

When ICP = 'Siana Property (Pty) Ltd   SIPL ZAR' Then 'ICP_Group.SIA'

When ICP = 'Cust - Reload Aquarius Shipping International (Pty) Ltd  ZAR' Then 'ICP_Group.CWM'

When ICP = 'Reload Logistics Ltd (Malta)' Then 'ICP_Group.RLM'

When ICP = 'Lions Resources Holding Ltd   LRHL' Then 'ICP_Group.LRH'

When ICP = 'Solena Enterprises Ltd (ZMB)   SESA' Then 'ICP_Group.SOE'

ELSE 'FCCS_No Intercompany'

END

                 ,ICPR = 2461

                 ,ICPF = 3

              WHERE LOADID = 395

              AND PARTITIONKEY = 42

              AND CATKEY = 1

              AND (ICPX IS NULL OR ICPX = '')

              AND (1=1)

              AND PERIODKEY = '2019-12-31'

2020-02-19 12:48:37,645 INFO [AIF]: Data Rows Updated by Location Mapping 'IN1' (LIKE): 56

2020-02-19 12:48:37,646 INFO [AIF]:

Processing Mappings for Column 'UD2'

2020-02-19 12:48:37,646 DEBUG [AIF]:

              UPDATE TDATASEG_T

              SET UD2X = 'No Business Segment'

                 ,UD2R = 2456

                 ,UD2F = 3

              WHERE LOADID = 395

              AND PARTITIONKEY = 42

              AND CATKEY = 1

              AND (UD2X IS NULL OR UD2X = '')

              AND (1=1)

              AND PERIODKEY = '2019-12-31'

2020-02-19 12:48:37,648 INFO [AIF]: Data Rows Updated by Location Mapping 'b1' (LIKE): 56

2020-02-19 12:48:37,649 INFO [AIF]:

Processing Mappings for Column 'UD3'

2020-02-19 12:48:37,649 DEBUG [AIF]:

              UPDATE TDATASEG_T

              SET UD3X = 'No Commodity'

                 ,UD3R = 2457

                 ,UD3F = 3

              WHERE LOADID = 395

              AND PARTITIONKEY = 42

              AND CATKEY = 1

              AND (UD3X IS NULL OR UD3X = '')

              AND (1=1)

              AND PERIODKEY = '2019-12-31'

2020-02-19 12:48:37,651 INFO [AIF]: Data Rows Updated by Location Mapping 'c1' (LIKE): 56

2020-02-19 12:48:37,652 INFO [AIF]:

Processing Mappings for Column 'UD4'

2020-02-19 12:48:37,653 DEBUG [AIF]:

              UPDATE TDATASEG_T

              SET UD4X = 'FCCS_Managed Data'

                 ,UD4R = 1853

                 ,UD4F = 3

              WHERE LOADID = 395

              AND PARTITIONKEY = 42

              AND CATKEY = 1

              AND (UD4X IS NULL OR UD4X = '')

              AND (1=1)

              AND PERIODKEY = '2019-12-31'

2020-02-19 12:48:37,654 INFO [AIF]: Data Rows Updated by Location Mapping 'System Generated Map' (LIKE): 56

2020-02-19 12:48:37,656 INFO [AIF]:

Processing Mappings for Column 'UD5'

2020-02-19 12:48:37,656 DEBUG [AIF]:

              UPDATE TDATASEG_T

              SET UD5X = 'FCCS_OpeningBalanceAdjustment'

                 ,UD5R = 1854

                 ,UD5F = 3

              WHERE LOADID = 395

              AND PARTITIONKEY = 42

              AND CATKEY = 1

              AND (UD5X IS NULL OR UD5X = '')

              AND (1=1)

              AND PERIODKEY = '2019-12-31'

2020-02-19 12:48:37,658 INFO [AIF]: Data Rows Updated by Location Mapping 'System Generated Map' (LIKE): 56

2020-02-19 12:48:37,659 DEBUG [AIF]: Comm.updateProcessDetail - START

2020-02-19 12:48:37,659 DEBUG [AIF]:

    UPDATE AIF_PROCESS_DETAILS

    SET STATUS = 'SUCCESS'

,RECORDS_PROCESSED = CASE WHEN RECORDS_PROCESSED IS NULL THEN 0 ELSE RECORDS_PROCESSED END + 56

,EXECUTION_END_TIME = CURRENT_TIMESTAMP

,LAST_UPDATED_BY = CASE WHEN ('[email protected]' IS NULL) THEN LAST_UPDATED_BY ELSE '[email protected]' END

,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

    WHERE PROCESS_ID = 395 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'Dec-19'

   

2020-02-19 12:48:37,661 DEBUG [AIF]: Comm.updateProcessDetail - END

2020-02-19 12:48:37,661 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - END

2020-02-19 12:48:37,661 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - START

2020-02-19 12:48:37,661 DEBUG [AIF]: intermediateCommit: True, skipRegularSql: False

2020-02-19 12:48:37,661 INFO [AIF]:

Stage Data for Period 'Dec-19'

2020-02-19 12:48:37,662 DEBUG [AIF]:

        DELETE FROM TDATAMAPSEG

        WHERE PARTITIONKEY = 42

        AND CATKEY = 1

        AND PERIODKEY = '2019-12-31'

       

2020-02-19 12:48:37,662 INFO [AIF]: Number of Rows deleted from TDATAMAPSEG: 20

2020-02-19 12:48:37,662 DEBUG [AIF]:

        INSERT INTO TDATAMAPSEG (

DATAKEY, PARTITIONKEY, CATKEY, PERIODKEY, DIMNAME, SRCKEY, SRCDESC, TARGKEY, WHERECLAUSETYPE,

WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG

        )

        SELECT DATAKEY, PARTITIONKEY, 1, '2019-12-31', DIMNAME, SRCKEY, SRCDESC, TARGKEY, WHERECLAUSETYPE,

WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG

        FROM TDATAMAP_T

        WHERE LOADID = 395

       

2020-02-19 12:48:37,676 INFO [AIF]: Number of Rows inserted into TDATAMAPSEG: 21

2020-02-19 12:48:37,676 DEBUG [AIF]:

        DELETE FROM TDATAMAP_T

        WHERE LOADID = 395

       

2020-02-19 12:48:37,677 INFO [AIF]: Number of Rows deleted from TDATAMAP_T: 21

2020-02-19 12:48:37,679 INFO [AIF]: Executing delete statement:

2020-02-19 12:48:37,679 DEBUG [AIF]:

          DELETE FROM TDATASEG

          WHERE LOADID < 395 AND PARTITIONKEY = 42 AND CATKEY = 1 AND RULE_ID = 17 AND PERIODKEY = '2019-12-31'

         

2020-02-19 12:48:37,686 INFO [AIF]: Successfully executed delete statement

2020-02-19 12:48:37,686 INFO [AIF]: Number of Rows deleted from TDATASEG: 56

2020-02-19 12:48:37,687 DEBUG [AIF]:

          DELETE FROM TDATAMEMOITEMS

          WHERE PARTITIONKEY = 42 AND PERIODKEY = '2019-12-31' AND CATKEY = 1 AND RULE_ID = 17

          AND NOT EXISTS (SELECT 1 FROM TDATASEG WHERE TDATASEG.DATAKEY = TDATAMEMOITEMS.DATAKEY)

         

2020-02-19 12:48:37,687 INFO [AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0

2020-02-19 12:48:37,687 DEBUG [AIF]:

          DELETE FROM TDATAARCHIVE

          WHERE PARTITIONKEY = 42 AND PERIODKEY = '2019-12-31' AND CATKEY = 1 AND RULE_ID = 17 AND ARCHIVEPROCTYPEID = 1

          AND NOT EXISTS ( SELECT 1

FROM TDATAMEMOITEMS

WHERE TDATAMEMOITEMS.MEMOITEMSD1 = TDATAARCHIVE.ARCHIVEID OR TDATAMEMOITEMS.MEMOITEMSD2 = TDATAARCHIVE.ARCHIVEID

OR TDATAMEMOITEMS.MEMOITEMSD3 = TDATAARCHIVE.ARCHIVEID OR TDATAMEMOITEMS.MEMOITEMSD4 = TDATAARCHIVE.ARCHIVEID

OR TDATAMEMOITEMS.MEMOITEMSD5 = TDATAARCHIVE.ARCHIVEID OR TDATAMEMOITEMS.MEMOITEMSD6 = TDATAARCHIVE.ARCHIVEID

OR TDATAMEMOITEMS.MEMOITEMSD7 = TDATAARCHIVE.ARCHIVEID OR TDATAMEMOITEMS.MEMOITEMSD8 = TDATAARCHIVE.ARCHIVEID

                           OR TDATAMEMOITEMS.MEMOITEMSD9 = TDATAARCHIVE.ARCHIVEID OR TDATAMEMOITEMS.MEMOITEMSD10 = TDATAARCHIVE.ARCHIVEID )

         

2020-02-19 12:48:37,688 INFO [AIF]: Number of Rows deleted from TDATAARCHIVE: 0

2020-02-19 12:48:37,688 INFO [AIF]: Executing insert statement:

2020-02-19 12:48:37,688 DEBUG [AIF]:

        INSERT INTO TDATASEG (

          DATAKEY, PARTITIONKEY, CATKEY, PERIODKEY,CURKEY, DATAVIEW, CALCACCTTYPE, CHANGESIGN, JOURNALID

          ,AMOUNT, AMOUNTX, AMOUNT_PTD, AMOUNT_YTD, DATA, DATAX, DESC1, DESC2

          ,ACCOUNT, ACCOUNTX, ACCOUNTR, ACCOUNTF, ENTITY, ENTITYX, ENTITYR, ENTITYF, ICP, ICPX, ICPR, ICPF

          ,UD1, UD1X, UD1R, UD1F, UD2, UD2X, UD2R, UD2F, UD3, UD3X, UD3R, UD3F, UD4, UD4X, UD4R, UD4F

          ,UD5, UD5X, UD5R, UD5F, UD6, UD6X, UD6R, UD6F, UD7, UD7X, UD7R, UD7F, UD8, UD8X, UD8R, UD8F

          ,UD9, UD9X, UD9R, UD9F, UD10, UD10X, UD10R, UD10F, UD11, UD11X, UD11R, UD11F, UD12, UD12X, UD12R, UD12F

          ,UD13, UD13X, UD13R, UD13F, UD14, UD14X, UD14R, UD14F, UD15, UD15X, UD15R, UD15F, UD16, UD16X, UD16R, UD16F

          ,UD17, UD17X, UD17R, UD17F, UD18, UD18X, UD18R, UD18F, UD19, UD19X, UD19R, UD19F, UD20, UD20X, UD20R, UD20F

          ,ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ATTR6, ATTR7, ATTR8, ATTR9, ATTR10, ATTR11, ATTR12, ATTR13, ATTR14

          ,ATTR15, ATTR16, ATTR17, ATTR18, ATTR19, ATTR20, ATTR21, ATTR22, ATTR23, ATTR24, ATTR25, ATTR26, ATTR27

          ,ATTR28, ATTR29, ATTR30, ATTR31, ATTR32, ATTR33, ATTR34, ATTR35, ATTR36, ATTR37, ATTR38, ATTR39, ATTR40

          ,ARCHIVEID, HASMEMOITEM, STATICDATAKEY, LOADID, RULE_ID, CODE_COMBINATION_ID,STAT_BALANCE_FLAG, VALID_FLAG )

        SELECT

          DATAKEY, PARTITIONKEY, CATKEY, PERIODKEY,CURKEY, DATAVIEW, CALCACCTTYPE, CHANGESIGN, JOURNALID

          ,AMOUNT, AMOUNTX, AMOUNT_PTD, AMOUNT_YTD, DATA, DATAX, DESC1, DESC2

          ,ACCOUNT, ACCOUNTX, ACCOUNTR, ACCOUNTF, ENTITY, ENTITYX, ENTITYR, ENTITYF, ICP, ICPX, ICPR, ICPF

          ,UD1, UD1X, UD1R, UD1F, UD2, UD2X, UD2R, UD2F, UD3, UD3X, UD3R, UD3F, UD4, UD4X, UD4R, UD4F

          ,UD5, UD5X, UD5R, UD5F, UD6, UD6X, UD6R, UD6F, UD7, UD7X, UD7R, UD7F, UD8, UD8X, UD8R, UD8F

          ,UD9, UD9X, UD9R, UD9F, UD10, UD10X, UD10R, UD10F, UD11, UD11X, UD11R, UD11F, UD12, UD12X, UD12R, UD12F

          ,UD13, UD13X, UD13R, UD13F, UD14, UD14X, UD14R, UD14F, UD15, UD15X, UD15R, UD15F, UD16, UD16X, UD16R, UD16F

          ,UD17, UD17X, UD17R, UD17F, UD18, UD18X, UD18R, UD18F, UD19, UD19X, UD19R, UD19F, UD20, UD20X, UD20R, UD20F

          ,ATTR1, ATTR2, ATTR3, ATTR4, ATTR5, ATTR6, ATTR7, ATTR8, ATTR9, ATTR10, ATTR11, ATTR12, ATTR13, ATTR14

          ,ATTR15, ATTR16, ATTR17, ATTR18, ATTR19, ATTR20, ATTR21, ATTR22, ATTR23, ATTR24, ATTR25, ATTR26, ATTR27

          ,ATTR28, ATTR29, ATTR30, ATTR31, ATTR32, ATTR33, ATTR34, ATTR35, ATTR36, ATTR37, ATTR38, ATTR39, ATTR40

          ,ARCHIVEID, HASMEMOITEM, STATICDATAKEY, LOADID, RULE_ID, CODE_COMBINATION_ID,STAT_BALANCE_FLAG, VALID_FLAG

        FROM TDATASEG_T

        WHERE LOADID = 395 AND PARTITIONKEY = 42 AND CATKEY = 1 AND PERIODKEY = '2019-12-31'

       

2020-02-19 12:48:37,697 INFO [AIF]: Successfully executed insert statement

2020-02-19 12:48:37,697 INFO [AIF]: Number of Rows inserted into TDATASEG: 56

2020-02-19 12:48:37,697 INFO [AIF]: Executing delete statement:

2020-02-19 12:48:37,697 DEBUG [AIF]:

        DELETE FROM TDATASEG_T

        WHERE LOADID = 395 AND PARTITIONKEY = 42 AND CATKEY = 1 AND PERIODKEY = '2019-12-31'

       

2020-02-19 12:48:37,700 INFO [AIF]: Successfully executed delete statement

2020-02-19 12:48:37,700 INFO [AIF]: Number of Rows deleted from TDATASEG_T: 56

2020-02-19 12:48:37,700 DEBUG [AIF]: CommData.updateWorkflow - START

2020-02-19 12:48:37,700 DEBUG [AIF]:

        UPDATE TLOGPROCESS

        SET PROCESSENDTIME=CURRENT_TIMESTAMP

,PROCESSSTATUS=1,PROCESSIMP=1,BLNWCDIRTY=0,BLNLOGICDIRTY=0,BLNVALDIRTY=0

,PROCESSIMPNOTE='AIF_WF_IMP_IMPORT_OK_TXT'

        WHERE PARTITIONKEY=42 AND CATKEY=1 AND PERIODKEY='2019-12-31' AND RULE_ID=17

       

2020-02-19 12:48:37,702 DEBUG [AIF]: CommData.updateWorkflow - END

2020-02-19 12:48:37,702 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - END

2020-02-19 12:48:37,702 DEBUG [AIF]: CommData.mapData - END

2020-02-19 12:48:37,721 INFO [AIF]: -------END IMPORT STEP-------

2020-02-19 12:48:37,740 INFO [AIF]: -------START VALIDATE STEP-------

2020-02-19 12:48:37,760 DEBUG [AIF]: CommData.validateData - START

2020-02-19 12:48:37,760 DEBUG [AIF]: CommMap.validateData - START

2020-02-19 12:48:37,761 INFO [AIF]:

Validate Data Mappings for Period 'Dec-19'

2020-02-19 12:48:37,761 DEBUG [AIF]:

      SELECT COUNT(*) ROW_COUNT

      FROM TDATASEG

      WHERE LOADID = 395

      AND (PARTITIONKEY = 42 AND CATKEY = 1 AND PERIODKEY = '2019-12-31' AND RULE_ID = 17 AND VALID_FLAG = 'Y')

     

2020-02-19 12:48:37,761 DEBUG [AIF]: CommData.updateWorkflow - START

2020-02-19 12:48:37,762 DEBUG [AIF]:

    SELECT tlp.PROCESSSTATUS, tlps.PROCESSSTATUSDESC, CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG

    FROM TLOGPROCESS tlp, TLOGPROCESSSTATES tlps

    WHERE tlp.PARTITIONKEY = 42 AND tlp.CATKEY = 1 AND tlp.PERIODKEY = '2019-12-31' AND tlp.RULE_ID = 17 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

   

2020-02-19 12:48:37,762 DEBUG [AIF]:

        UPDATE TLOGPROCESS

        SET PROCESSENDTIME=CURRENT_TIMESTAMP

,PROCESSSTATUS=10,PROCESSVAL=0,PROCESSEXP=0,PROCESSENTLOAD=0,PROCESSENTVAL=0,BLNVALDIRTY=0

,PROCESSVALNOTE=NULL,PROCESSEXPNOTE=NULL,PROCESSENTLOADNOTE=NULL,PROCESSENTVALNOTE=NULL

        WHERE PARTITIONKEY=42 AND CATKEY=1 AND PERIODKEY='2019-12-31' AND RULE_ID=17

       

2020-02-19 12:48:37,764 DEBUG [AIF]: CommData.updateWorkflow - END

2020-02-19 12:48:37,764 DEBUG [AIF]:

              UPDATE TDATASEG

              SET VALID_FLAG = 'N'

              WHERE 1=1

              AND ( (1=0)

                    OR (TDATASEG.ACCOUNTX IS NULL OR TDATASEG.ACCOUNTX = '')

                    OR (TDATASEG.ENTITYX IS NULL OR TDATASEG.ENTITYX = '')

                    OR (TDATASEG.ICPX IS NULL OR TDATASEG.ICPX = '')

                    OR (TDATASEG.UD2X IS NULL OR TDATASEG.UD2X = '')

                    OR (TDATASEG.UD3X IS NULL OR TDATASEG.UD3X = '')

                    OR (TDATASEG.UD4X IS NULL OR TDATASEG.UD4X = '')

                    OR (TDATASEG.UD5X IS NULL OR TDATASEG.UD5X = '')

                  )

              AND LOADID = 395 AND PARTITIONKEY = 42 AND CATKEY = 1 AND PERIODKEY = '2019-12-31'

              AND VALID_FLAG = 'Y'

            AND CALCACCTTYPE > 0

           

2020-02-19 12:48:37,765 DEBUG [AIF]: CommData.updateWorkflow - START

2020-02-19 12:48:37,765 DEBUG [AIF]:

        UPDATE TLOGPROCESS

        SET PROCESSENDTIME=CURRENT_TIMESTAMP

,PROCESSSTATUS=11,PROCESSVAL=1,BLNVALDIRTY=0

,PROCESSVALNOTE='AIF_WF_VAL_VALIDATE_OK_TXT'

        WHERE PARTITIONKEY=42 AND CATKEY=1 AND PERIODKEY='2019-12-31' AND RULE_ID=17

       

2020-02-19 12:48:37,766 DEBUG [AIF]: CommData.updateWorkflow - END

2020-02-19 12:48:37,766 INFO [AIF]: Total Data Rows available for Export to Target: 56

2020-02-19 12:48:37,766 DEBUG [AIF]: CommMap.validateData - END

2020-02-19 12:48:37,767 INFO [AIF]:

Validate Data Members for Period 'Dec-19'

2020-02-19 12:48:37,767 DEBUG [AIF]:

      SELECT COUNT(*) ROW_COUNT

      FROM TDATASEG

      WHERE LOADID = 395

      AND (PARTITIONKEY = 42 AND CATKEY = 1 AND PERIODKEY = '2019-12-31' AND RULE_ID = 17 AND VALID_FLAG = 'Y')

     

2020-02-19 12:48:37,767 INFO [AIF]: Total Data Rows available for Export to Target: 56

2020-02-19 12:48:37,767 DEBUG [AIF]: CommData.validateData - END

2020-02-19 12:48:37,785 INFO [AIF]: -------END VALIDATE STEP-------

2020-02-19 12:48:37,832 INFO [AIF]: -------START EXPORT STEP-------

2020-02-19 12:48:37,851 DEBUG [AIF]: CommData.exportData - START

2020-02-19 12:48:37,852 DEBUG [AIF]: CommData.updateWorkflow - START

2020-02-19 12:48:37,852 DEBUG [AIF]:

    SELECT tlp.PROCESSSTATUS, tlps.PROCESSSTATUSDESC, CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG

    FROM TLOGPROCESS tlp, TLOGPROCESSSTATES tlps

    WHERE tlp.PARTITIONKEY = 42 AND tlp.CATKEY = 1 AND tlp.PERIODKEY = '2019-12-31' AND tlp.RULE_ID = 17 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

   

2020-02-19 12:48:37,853 DEBUG [AIF]:

        UPDATE TLOGPROCESS

        SET PROCESSENDTIME=CURRENT_TIMESTAMP

,PROCESSSTATUS=20,PROCESSEXP=0,PROCESSENTLOAD=0,PROCESSENTVAL=0

,PROCESSEXPNOTE=NULL,PROCESSENTLOADNOTE=NULL,PROCESSENTVALNOTE=NULL

        WHERE PARTITIONKEY=42 AND CATKEY=1 AND PERIODKEY='2019-12-31' AND RULE_ID=17

       

2020-02-19 12:48:37,854 DEBUG [AIF]: CommData.updateWorkflow - END

2020-02-19 12:48:37,855 DEBUG [AIF]:

              UPDATE TDATASEG

              SET LOADID = 395

              WHERE PARTITIONKEY = 42

              AND PERIODKEY = '2019-12-31'

              AND CATKEY = 1

              AND RULE_ID = 17

              AND LOADID < 395

             

2020-02-19 12:48:37,855 DEBUG [AIF]: Number of Rows updated on TDATASEG: 0

2020-02-19 12:48:37,855 DEBUG [AIF]: CommData.purgeInvalidRecordsTDATASEG - START

2020-02-19 12:48:37,855 DEBUG [AIF]:

        DELETE FROM TDATASEG

        WHERE LOADID = 395

       

          AND (

           

        PARTITIONKEY = 42

        AND CATKEY = 1

        AND PERIODKEY = '2019-12-31'

        AND RULE_ID = 17

        AND VALID_FLAG = 'N'

       

          )

2020-02-19 12:48:37,856 DEBUG [AIF]: Number of Rows deleted from TDATASEG: 0

2020-02-19 12:48:37,856 DEBUG [AIF]: CommData.purgeInvalidRecordsTDATASEG - END

2020-02-19 12:48:37,856 DEBUG [AIF]: AIFUtil.callOdiServlet - START

2020-02-19 12:48:37,870 INFO [AIF]: EssbaseService.exportData - START

2020-02-19 12:48:37,902 DEBUG [AIF]: appId:7, appType:HPL, mcFlag:false, workflowMode:FULL, dataLoadMethod:CLASSIC_VIA_EPMI, mDataFlowNode:LOCAL, textDataLoad:N, isFccsLoad:true, isJournalLoad:false

2020-02-19 12:48:37,903 DEBUG [AIF]: LOAD_METHOD:HPL, LOAD_TYPE:Data, EXPORT_MODE:Merge, CREATE_DRILL_REGION:true, PURGE_DATA_FILE:false, EXPORT_FILE_DELIMITER:comma, BATCH_SIZE:10000

2020-02-19 12:48:37,989 INFO [AIF]: cloudServiceType: FCCS, Resolved user: [email protected], planningUserName: [email protected]

2020-02-19 12:48:38,041 DEBUG [AIF]: Overrode info.loadMethod for the admin user: OLU

2020-02-19 12:48:38,043 DEBUG [AIF]: No need to connect to Essbase server.

2020-02-19 12:48:38,046 DEBUG [AIF]: enableZeroLoad: 1

2020-02-19 12:48:38,046 DEBUG [AIF]: SELECT '"'||ACCOUNT||'"', '"'||ENTITY||','||ICP||','||UD2||','||UD3||','||UD4||','||UD5||','||DATAVALUE||','||

CASE DATAVIEW WHEN 'YTD' THEN 'FCCS_YTD_Input' WHEN 'Periodic' THEN 'FCCS_Periodic' ELSE DATAVIEW END||','||SCENARIO||','||YEAR||','||PERIOD||','||

CASE WHEN (DATAVALUE = 'FCCS_Entity Input') THEN 'Entity Currency' ELSE CURRENCY END||'"', 'Consol',AMOUNT

FROM AIF_HS_BALANCES

WHERE LOADID = 395

2020-02-19 12:48:38,048 INFO [AIF]: Creating data file: RL_CONS_395.dat

2020-02-19 12:48:38,074 INFO [AIF]: Data file creation completed: 14

2020-02-19 12:48:38,074 INFO [AIF]: EssbaseService.exportData - END (true)

2020-02-19 12:48:38,079 DEBUG [AIF]: AIFUtil.callOdiServlet - END

2020-02-19 12:48:38,079 DEBUG [AIF]: CommData.updateWorkflow - START

2020-02-19 12:48:38,079 DEBUG [AIF]:

        UPDATE TLOGPROCESS

        SET PROCESSENDTIME=CURRENT_TIMESTAMP

,PROCESSSTATUS=21,PROCESSEXP=1

,PROCESSEXPNOTE='AIF_WF_EXP_EXPORT_OK_TXT'

        WHERE PARTITIONKEY=42 AND CATKEY=1 AND PERIODKEY='2019-12-31' AND RULE_ID=17

       

2020-02-19 12:48:38,081 DEBUG [AIF]: CommData.updateWorkflow - END

2020-02-19 12:48:38,081 DEBUG [AIF]: CommData.exportData - END

2020-02-19 12:48:38,150 DEBUG [AIF]: CommData.loadData - START

2020-02-19 12:48:38,151 DEBUG [AIF]: CommData.updateWorkflow - START

2020-02-19 12:48:38,151 DEBUG [AIF]:

    SELECT tlp.PROCESSSTATUS, tlps.PROCESSSTATUSDESC, CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG

    FROM TLOGPROCESS tlp, TLOGPROCESSSTATES tlps

    WHERE tlp.PARTITIONKEY = 42 AND tlp.CATKEY = 1 AND tlp.PERIODKEY = '2019-12-31' AND tlp.RULE_ID = 17 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

   

2020-02-19 12:48:38,152 DEBUG [AIF]:

        UPDATE TLOGPROCESS

        SET PROCESSENDTIME=CURRENT_TIMESTAMP

,PROCESSSTATUS=30,PROCESSENTLOAD=0,PROCESSENTVAL=0

,PROCESSENTLOADNOTE=NULL,PROCESSENTVALNOTE=NULL

        WHERE PARTITIONKEY=42 AND CATKEY=1 AND PERIODKEY='2019-12-31' AND RULE_ID=17

       

2020-02-19 12:48:38,154 DEBUG [AIF]: CommData.updateWorkflow - END

2020-02-19 12:48:38,154 DEBUG [AIF]: AIFUtil.callOdiServlet - START

2020-02-19 12:48:38,166 INFO [AIF]: EssbaseService.loadData - START

2020-02-19 12:48:38,194 DEBUG [AIF]: appId:7, appType:HPL, mcFlag:false, workflowMode:FULL, dataLoadMethod:CLASSIC_VIA_EPMI, mDataFlowNode:LOCAL, textDataLoad:N, isFccsLoad:true, isJournalLoad:false

2020-02-19 12:48:38,194 DEBUG [AIF]: LOAD_METHOD:HPL, LOAD_TYPE:Data, EXPORT_MODE:Merge, CREATE_DRILL_REGION:true, PURGE_DATA_FILE:false, EXPORT_FILE_DELIMITER:comma, BATCH_SIZE:10000

2020-02-19 12:48:38,270 INFO [AIF]: cloudServiceType: FCCS, Resolved user: [email protected], planningUserName: [email protected]

2020-02-19 12:48:38,319 DEBUG [AIF]: Overrode info.loadMethod for the admin user: OLU

2020-02-19 12:48:38,319 DEBUG [AIF]: No need to connect to Essbase server.

2020-02-19 12:48:39,191 DEBUG [AIF]: CommHpl - performLoadOluFile - START

2020-02-19 12:48:39,195 DEBUG [AIF]: targetApplicationName: RL_CONS

2020-02-19 12:48:39,195 DEBUG [AIF]: metadataLoadMethod: CLASSIC_VIA_EPMI

2020-02-19 12:48:39,196 DEBUG [AIF]: dataFileName: RL_CONS_395.dat

2020-02-19 12:48:39,196 DEBUG [AIF]: SELECT parameter_value FROM aif_bal_rule_load_params WHERE loadid = 395 and parameter_name = 'EXPORT_FILE_DELIMITER'

2020-02-19 12:48:39,197 DEBUG [AIF]: fileDelimiter: comma

2020-02-19 12:48:39,197 DEBUG [AIF]: SELECT parameter_value FROM aif_bal_rule_load_params WHERE loadid = 395 and parameter_name = 'DATE_FORMAT'

2020-02-19 12:48:39,197 DEBUG [AIF]: dateFormat: MM-DD-YYYY

2020-02-19 12:48:39,198 DEBUG [AIF]: SELECT parameter_value FROM aif_bal_rule_load_params WHERE loadid = 395 and parameter_name = 'LOAD_METHOD'

2020-02-19 12:48:39,198 DEBUG [AIF]: Data Load: exportMode=Merge, loadMethod=HPL

[Wed Feb 19 12:48:39 UTC 2020]Batch Mode (/B) turned off (/-B) for strict data loads or save of metadata specified as false (/-IMD).

[Wed Feb 19 12:48:39 UTC 2020]Saving metadata on data loads (/IMD)

Property file arguments: /DF:MM-DD-YYYY /DL:comma /I:***RL_CONS_395.dat /TR

No arguments were derived from the command line.Submitted (merged) command line:

/DF:MM-DD-YYYY /DL:comma /I:***RL_CONS_395.dat /TR

[Wed Feb 19 12:48:39 UTC 2020]Successfully located and opened input file.

[Wed Feb 19 12:48:39 UTC 2020]Input file being read with UTF-8 encoding.

[Wed Feb 19 12:48:39 UTC 2020]Date format pattern "MM-DD-YYYY" specified for date data type loading.

[Wed Feb 19 12:48:39 UTC 2020]Header record fields: Driver Member, Point-of-View, Data Load Cube Name, Value

[Wed Feb 19 12:48:39 UTC 2020]Located and using "OFADataLoadDimension" dimension for loading data in "RL_CONS" application.

[Wed Feb 19 12:48:39 UTC 2020]Parent-child ordering option (/H switch) will not be performed: this option is not available for the "OFADataLoadDimension" dimension.

[Wed Feb 19 12:48:39 UTC 2020]Input file member load ordering option (/O switch) will not be performed: this option is only available for (non /IE) import operations.

[Wed Feb 19 12:48:39 UTC 2020]HspOutlineLoad::dateFormatSpecified is true, SessionHalDateFormat stored on session: M/d/yy, sessionId: 357530019

[Wed Feb 19 12:48:39 UTC 2020]Unable to obtain dimension information and/or perform a data load: com.hyperion.planning.HspCallbackInvocationException: Business rule failed to execute. See the job console page for error details.

Outline data store load process finished. 14 data records were read, 15 data records were processed, 15 were accepted for loading (verify actual load with Essbase log files), 0 were rejected.

[Wed Feb 19 12:48:39 UTC 2020]Outline data store load process finished. 14 data records were read, 15 data records were processed, 15 were accepted for loading (verify actual load with Essbase log files), 0 were rejected.

2020-02-19 12:48:39,314 DEBUG [AIF]: loadStatus.errorsWereLogged: True, loadStatus.warningsWereLogged: True

2020-02-19 12:48:39,425 DEBUG [AIF]: Session ID: 369501, Status: ERROR, Status Message: Session Failed :369501 : ODI-1217: Session COMM_EXECUTE_GENERIC_PROCESS (369501) fails with return code 7000.

ODI-1226: Step Execute Data Load - OLU fails after 1 attempt(s).

ODI-1232: Procedure COMM Execute Data Load - OLU execution fails.

Caused By: org.apache.bsf.BSFException: exception from Jython:

Traceback (most recent call last):

  File "<string>", line 8, in <module>

  File "<string>", line 255, in performLoadOluFile

RuntimeError: CommHpl - performLoadOluFile did not complete successfully

                at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)

                at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

                at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

                at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472)

                at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)

                at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)

                at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

                at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

                at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

                at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

                at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

                at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

                at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

                at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

                at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

                at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

                at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

                at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

                at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

                at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)

                at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:564)

                at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:518)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

                at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

                at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(

Best Answer

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Feb 19, 2020 8:22AM Accepted Answer

    From the log:

    "Business rule failed to execute. See the job console page for error details."

    Check jobs in the FCCS application for more details on the business rule failure.

    Cheers

    John

Answers