Forum Stats

  • 3,874,078 Users
  • 2,266,673 Discussions
  • 7,911,721 Comments

Discussions

Error while running check report for Essbase Target application

Indira Reddy
Indira Reddy Member Posts: 2
edited Sep 26, 2019 3:38AM in Financial Data Management

Hi,

Am loading data from a text file to Essbase target application. Everything fine until exporting data, but the check report is not getting generated and am getting the following error:

Error encountered while connecting to Essbase.

The rule logic I have used for comparing source and target values is:

def runVal:

    msg="

dbVal=abs(~,Mar-18,,,RE-001,,,,LE-Monitor,Hyd,Actual,,,,,,,,,,,,,,~)-(|,Mar,,,,RE-001,,,FY2018,LE-Monitor,Hyd,Actual,,,,,,,,,,,,,,|)

if dbVal==0:

    RESULT="True"

msg='Trial Balance is balanced'

else:

    RESULT="False"

msg='Out of balance'

return [RESULT,msg]

Can anyone help me out on this pls..?

Answers

  • Abdul Sherif-Oracle
    Abdul Sherif-Oracle Member Posts: 89 Employee
    edited Jul 12, 2019 12:52AM

    What is the error you see in the process log?

  • Indira Reddy
    Indira Reddy Member Posts: 2
    edited Jul 18, 2019 6:05AM

    Please find the below logs informatiopn from process details.

    2019-07-03 06:20:06,871 INFO  [AIF]: FDMEE Process: 2204, Log Level: 5, Log File: \\DON-HYCPW01\FDMEEApps\outbox\logs\FDMEE-FDMEE_DB_2204.log

    2019-07-03 06:20:06,871 INFO  [AIF]: Location     : Hyd1 (Partitionkey:33)

    2019-07-03 06:20:06,871 INFO  [AIF]: Period Name  : Mar-18 (Period Key:3/31/18 12:00 AM)

    2019-07-03 06:20:06,871 INFO  [AIF]: Category Name: Actual (Category key:1)

    2019-07-03 06:20:06,871 INFO  [AIF]: Rule Name    : FDMEE_DB Laod (Rule ID:46)

    2019-07-03 06:20:11,659 INFO  [AIF]: FDM Version: 11.1.2.4.220

    2019-07-03 06:20:11,660 INFO  [AIF]: Log File Encoding: UTF-8

    2019-07-03 06:20:13,796 INFO  [AIF]: -------START IMPORT STEP-------

    2019-07-03 06:20:14,534 DEBUG [AIF]: FileData.extractDataFromSource - START

    2019-07-03 06:20:14,542 DEBUG [AIF]: CommData.getRuleInfo - START

    2019-07-03 06:20:14,547 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 = 29

          LEFT OUTER JOIN TBHVIMPITEMERPI tiie

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

          WHERE tpp.PARTITIONKEY = 33

          AND adim.BALANCE_COLUMN_NAME IS NOT NULL

          AND adim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

          ORDER BY adim.BALANCE_COLUMN_NAME

         

    2019-07-03 06:20:14,547 DEBUG [AIF]: {'TGT_SOURCE_SYSTEM_ID': 0L, 'RECALCULATE_FLAG': u'Y', 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'TGT_APP_ID': 29L, 'PLAN_TYPE': None, 'TGT_APP_NAME': u'FDMEE-FDMEE_DB', 'KK_FLAG': u'N', 'TGT_APP_TYPE': u'ESSBASE', 'TGT_TARGET_APP_NAME': u'FDMEE', 'IS_INCREMENTAL_LOAD': False, 'IMPGROUPKEY': u'Essbase_FDMEE1', 'EXPORT_TO_TARGET_FLAG': u'Y', 'CATKEY': 1L, 'JOURNAL_FLAG': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'DEFAULT', 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'UD4'], 'FCI_FLAG': 'N', 'CHECK_FLAG': u'Y', 'LEDGER_GROUP': None, 'LAST_UPDATED_BY': u'indirab', 'DIMNAME_MAP': {u'ENTITY': {'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'DIMNAME': u'ENTITY'}, u'UD4': {'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'DIMNAME': u'UD4'}, u'ACCOUNT': {'TARGET_DIMENSION_CLASS_NAME': u'Account', 'DIMNAME': u'ACCOUNT'}}, 'PARTITIONKEY': 33L, 'TGT_APP_SUB_TYPE': None, 'TGT_COA_ID': 0L, 'PARTVALGROUP': u'FDMEE_DB_chk', 'TGT_METADATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': None, 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 0L, 'PS_LEDGER': None, 'IMPGROUPFILETYPE': u'DELIMITED', 'RULE_ID': 46L, 'TGT_SOURCE_SYSTEM_TYPE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'SRC_APP_ID': None, 'SRC_SOURCE_SYSTEM_TYPE': u'FILE', 'CALENDAR_ID': None, 'WEB_SERVICE_URL': u'http://DON-HYCPW01.don.s365.us:6550/aif', 'SRC_SOURCE_SYSTEM_ID': 20L, 'TGT_DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI'}

    2019-07-03 06:20:14,548 DEBUG [AIF]: {u'Entity': {'BCN': u'ENTITY', 'DCN': u'Entity'}, u'Period': {'BCN': None, 'DCN': u'Period'}, u'Year': {'BCN': None, 'DCN': u'Year'}, u'Scenario': {'BCN': None, 'DCN': u'Scenario'}, u'Account': {'BCN': u'ACCOUNT', 'DCN': u'Account'}, u'Product': {'BCN': u'UD4', 'DCN': u'Generic'}}

    2019-07-03 06:20:14,549 DEBUG [AIF]: {u'UD6': {'IMPFLDSOURCECOLNAME': u'Scenario'}, u'ENTITY': {'IMPFLDSOURCECOLNAME': u'Entity'}, u'AMOUNT': {'IMPFLDSOURCECOLNAME': u'Data'}, u'DATA': {'IMPFLDSOURCECOLNAME': u'Data'}, u'UD2': {'IMPFLDSOURCECOLNAME': u'Period'}, u'UD5': {'IMPFLDSOURCECOLNAME': u'Entity'}, u'UD4': {'IMPFLDSOURCECOLNAME': u'Product'}, u'ACCOUNT': {'IMPFLDSOURCECOLNAME': u'Account'}, u'UD1': {'IMPFLDSOURCECOLNAME': u'Account'}}

    2019-07-03 06:20:14,549 DEBUG [AIF]: CommData.getRuleInfo - END

    2019-07-03 06:20:14,549 DEBUG [AIF]: FileData.extractDataFromSource - END

    2019-07-03 06:20:14,657 DEBUG [AIF]: FileData.preProcessDataFile - START

    2019-07-03 06:20:14,682 DEBUG [AIF]: FileData.preProcessDataFile - END

    2019-07-03 06:20:14,797 DEBUG [AIF]: CommData.preImportData - START

    2019-07-03 06:20:14,804 DEBUG [AIF]: CommData.insertFilePeriods - START

    2019-07-03 06:20:14,807 DEBUG [AIF]: doAppPeriodMappingsExist - FDMEE-FDMEE_DB: Y

    2019-07-03 06:20:14,807 DEBUG [AIF]: SELECT 1 FROM AIF_BAL_RULE_LOAD_PARAMS WHERE LOADID = 2204 AND PARAMETER_TYPE = 'SOURCE_PERIODS'

    2019-07-03 06:20:14,807 DEBUG [AIF]: Period mapping section: SINGLE-COLUMN/DEFAULT

    2019-07-03 06:20:14,807 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 TPOVPERIODADAPTOR_FLAT_V pp

              ON pp.PERIODFREQ = pc.CATFREQ AND pp.INTSYSTEMKEY = 'FDMEE-FDMEE_DB' AND pp.PERIODKEY >= brl.START_PERIODKEY AND pp.PERIODKEY <= brl.END_PERIODKEY

                WHERE brl.LOADID = 2204

                ORDER BY PERIODKEY

               

    2019-07-03 06:20:14,808 INFO  [AIF]: File Name: Essbase_FDMEE_Data.txt

    2019-07-03 06:20:14,809 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 (2204,'2018-03-31','N',0,'0' ,'0',0,1,'FY2018','Mar', 'PROCESS_BAL_IMP_FILE','Essbase_FDMEE_Data.txt','PROCESS_BAL_TRANS','Mar-18','N', 0)

           

    2019-07-03 06:20:14,809 DEBUG [AIF]: insertRowCount: 1

    2019-07-03 06:20:14,821 DEBUG [AIF]: CommData.insertFilePeriods - END

    2019-07-03 06:20:14,825 DEBUG [AIF]: CommData.getPovList - START

    2019-07-03 06:20:14,826 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 TPOVPERIODADAPTOR pp

              ON pp.PERIODKEY = pprd.PERIODKEY AND pp.INTSYSTEMKEY = 'FDMEE-FDMEE_DB'

            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 = 2204

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

           

    2019-07-03 06:20:14,826 DEBUG [AIF]: CommData.getPovList - END

    2019-07-03 06:20:14,835 DEBUG [AIF]: Comm.doScriptInit - START

    2019-07-03 06:20:14,918 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=\\DON-HYCPW01\FDMEEApps\inbox, LOCNAME=Hyd1, SOURCENAME=Essbase_FDMEE, APPID=29, SOURCEID=20, APPROOTDIR=\\DON-HYCPW01\FDMEEApps, IMPORTFORMAT=Essbase_FDMEE1, SCRIPTSDIR=\\DON-HYCPW01\FDMEEApps\data\scripts, EPMORACLEHOME=D:\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=ESSBASE, RULEID=46, CATNAME=Actual, EPMORACLEINSTANCEHOME=D:\Oracle\Middleware\user_projects\epmsystem1, LOADID=2204, PERIODNAME=Mar-18, IMPORTMODE=REPLACE, SOURCETYPE=FILE, PERIODKEY=2018-03-31, EXPORTFLAG=Y, TARGETAPPDB=FDMEE_DB, TARGETAPPNAME=FDMEE, FILENAME=null, LOCKEY=33, RULENAME=FDMEE_DB Laod, OUTBOXDIR=\\DON-HYCPW01\FDMEEApps\outbox, MULTIPERIODLOAD=N, EXPORTMODE=STORE_DATA, CATKEY=1, USERNAME=indirab, FILEDIR=null, APPNAME=FDMEE-FDMEE_DB, IMPORTFLAG=Y, USERLOCALE=null}

    2019-07-03 06:20:14,922 DEBUG [AIF]: The executeEventScript is set to: YES

    2019-07-03 06:20:14,923 DEBUG [AIF]: The AppRootFolder is set to: \\DON-HYCPW01\FDMEEApps

    2019-07-03 06:20:14,923 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

    2019-07-03 06:20:14,923 DEBUG [AIF]: The OleDatabaseProvider is set to: ORAOLEDB.ORACLE

    2019-07-03 06:20:14,923 DEBUG [AIF]: Comm.doScriptInit - END

    2019-07-03 06:20:14,923 DEBUG [AIF]: Comm.executeScript - START

    2019-07-03 06:20:14,928 INFO  [AIF]: Executing the following script: \\DON-HYCPW01\FDMEEApps/data/scripts/event/BefImport.py

    2019-07-03 06:20:14,949 DEBUG [AIF]: Comm.executeVBScript - START

    2019-07-03 06:20:14,950 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp

    2019-07-03 06:20:14,950 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps\data\scripts\event\BefImport.vbs

    2019-07-03 06:20:14,950 DEBUG [AIF]: Comm.executeVBScript - END

    2019-07-03 06:20:14,950 DEBUG [AIF]: Comm.executeScript - END

    2019-07-03 06:20:14,950 DEBUG [AIF]: CommData.preImportData - END

    2019-07-03 06:20:15,078 DEBUG [AIF]: CommData.insertImportProcessDetails - START

    2019-07-03 06:20:15,080 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, 'indirab' 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 = 2204

              ) q

              ORDER BY ENTITY_NAME_ORDER

             

    2019-07-03 06:20:15,086 DEBUG [AIF]: CommData.insertImportProcessDetails - END

    2019-07-03 06:20:15,211 DEBUG [AIF]: FileData.importData - START

    2019-07-03 06:20:15,212 DEBUG [AIF]: Importing data for load id: 2204

    2019-07-03 06:20:15,212 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,

                     tpovperiodadaptor b,

                     aif_processes c

                WHERE a.loadid       = 2204

                AND a.start_periodkey=b.periodkey

                AND a.loadid         =c.process_id

                AND br.rule_id = a.rule_id

                AND b.INTSYSTEMKEY = 'FDMEE-FDMEE_DB'

               

    2019-07-03 06:20:15,215 DEBUG [AIF]: FileData.py: Importing Text data for load id: 2204

    2019-07-03 06:20:15,275 INFO  [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH:IMPGROUPFILETYPE::2204;33:1:46:[NONE]:\\DON-HYCPW01\FDMEEApps/:DELIMITED

    2019-07-03 06:20:15,278 INFO  [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8

    2019-07-03 06:20:15,278 INFO  [AIF]: EPMFDM-140274:Message - ImportTextData - Start

    2019-07-03 06:20:15,278 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

    2019-07-03 06:20:15,325 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=null:StartPos=1:SourceClName=Account

    2019-07-03 06:20:15,326 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=DATA:ImpFieldText=null:StartPos=7:SourceClName=Data

    2019-07-03 06:20:15,326 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD5:ImpFieldText=null:StartPos=5:SourceClName=Entity

    2019-07-03 06:20:15,326 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD2:ImpFieldText=null:StartPos=2:SourceClName=Period

    2019-07-03 06:20:15,326 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD6:ImpFieldText=null:StartPos=6:SourceClName=Scenario

    2019-07-03 06:20:15,326 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=null:StartPos=7:SourceClName=Data

    2019-07-03 06:20:15,326 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD4:ImpFieldText=null:StartPos=4:SourceClName=Product

    2019-07-03 06:20:15,327 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=1:SourceClName=Account

    2019-07-03 06:20:15,327 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ENTITY:ImpFieldText=null:StartPos=5:SourceClName=Entity

    2019-07-03 06:20:15,327 INFO  [AIF]: EPMFDM-140274:Message - Initialize error maps

    2019-07-03 06:20:15,327 INFO  [AIF]: EPMFDM-140274:Message - File Name Essbase_FDMEE_Data.txt

    periodKey2018-03-31

    2019-07-03 06:20:15,351 INFO  [AIF]: EPMFDM-140274:Message -  PROCESS ID: 2204

    PARTITIONKEY: 33

    IMPORT GROUP: Essbase_FDMEE1

    FILE TYPE: DELIMITED

    DELIMITER:

    SOURCE FILE: Essbase_FDMEE_Data.txt

    PROCESSING CODES:

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

    BLANK............. Line is blank or empty.

    NN................ Non-Numeric, Amount field contains non numeric characters.

    TC................ Type Conversion, Amount field could not be converted to a number.

    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] Account Period Year Product Entity Scenario Data

    Rows Loaded: 20

    Rows Rejected: 1

    2019-07-03 06:20:15,352 DEBUG [AIF]: EPMFDM-140274:Message - Script- archiveDataFile- Start

    2019-07-03 06:20:15,352 INFO  [AIF]: EPMFDM-140274:Message - ARCHIVE MODE: null

    2019-07-03 06:20:15,352 INFO  [AIF]: EPMFDM-140274:Message - Start archiving file:

    2019-07-03 06:20:15,352 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveId: 220420180331

    2019-07-03 06:20:15,353 DEBUG [AIF]: EPMFDM-140274:Message - Archive- SourceFileName: Essbase_FDMEE_Data

    Extension: txt

    2019-07-03 06:20:15,353 INFO  [AIF]: EPMFDM-140274:Message - Archive file name: 220420180331.txt

    2019-07-03 06:20:15,354 INFO  [AIF]: EPMFDM-140274:Message - Deleting the source file: Essbase_FDMEE_Data.txt

    2019-07-03 06:20:15,354 INFO  [AIF]: EPMFDM-140274:Message - File not deleted: \\DON-HYCPW01\FDMEEApps\Essbase_FDMEE_Data.txt

    2019-07-03 06:20:15,356 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveDocKey:Essbase_FDMEE_Data-indirab-20190703_062015-1

    2019-07-03 06:20:15,367 DEBUG [AIF]: EPMFDM-140274:Message - Script- archiveDataFile- End

    2019-07-03 06:20:15,382 INFO  [AIF]: EPMFDM-140274:Message - ImportTextData - End

    2019-07-03 06:20:15,383 INFO  [AIF]: EPMFDM-140274:Message - Total time taken for the import in ms = 105

    2019-07-03 06:20:15,414 DEBUG [AIF]: FileData.importData - END

    2019-07-03 06:20:15,780 DEBUG [AIF]: CommData.postImportData - START

    2019-07-03 06:20:15,786 DEBUG [AIF]: CommData.updateTDATASEG_T - START

    2019-07-03 06:20:15,787 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    = 2204

              AND en.process_id      = pp.process_id

              AND pp.IMP_ENTITY_NAME = en.file_entity_name

              order by en.entity_name_order

             

    2019-07-03 06:20:15,789 INFO  [AIF]:

    Import Data from Source for Period 'Mar-18'

    2019-07-03 06:20:15,795 DEBUG [AIF]: CommData.updateWorkflow - START

    2019-07-03 06:20:15,796 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 = 33 AND tlp.CATKEY = 1 AND tlp.PERIODKEY = '2018-03-31' AND tlp.RULE_ID = 46 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

       

    2019-07-03 06:20:15,796 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=33 AND CATKEY=1 AND PERIODKEY='2018-03-31' AND RULE_ID=46

           

    2019-07-03 06:20:15,804 DEBUG [AIF]: CommData.updateWorkflow - END

    2019-07-03 06:20:15,804 DEBUG [AIF]:

                SELECT adim.BALANCE_COLUMN_NAME DIMNAME, dim.TARGET_DIMENSION_CLASS_NAME

                FROM TPOVPARTITION tpp

                INNER JOIN AIF_TARGET_APPL_DIMENSIONS adim

                  ON adim.APPLICATION_ID = tpp.PARTTARGETAPPLICATIONID AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                INNER JOIN AIF_DIMENSIONS dim

                  ON dim.DIMENSION_ID = adim.DIMENSION_ID

                WHERE tpp.PARTITIONKEY = 33

                AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                ORDER BY adim.BALANCE_COLUMN_NAME

               

    2019-07-03 06:20:15,805 DEBUG [AIF]: 

                UPDATE TDATASEG_T

                SET AMOUNTX = AMOUNT, DATAX = NULL

                   ,ACCOUNTX = NULL

                   ,ENTITYX = NULL

                   ,UD4X = NULL

                WHERE TDATASEG_T.LOADID = 2204 AND TDATASEG_T.PARTITIONKEY = 33 AND TDATASEG_T.CATKEY = 1 AND TDATASEG_T.PERIODKEY = '2018-03-31'

               

    2019-07-03 06:20:15,806 INFO  [AIF]: Generic Data Rows Imported from Source: 20

    2019-07-03 06:20:15,819 INFO  [AIF]: Total Data Rows Imported from Source: 20

    2019-07-03 06:20:15,819 DEBUG [AIF]: CommData.updateTDATASEG_T - END

    2019-07-03 06:20:15,819 DEBUG [AIF]: Comm.executeScript - START

    2019-07-03 06:20:15,822 INFO  [AIF]: Executing the following script: \\DON-HYCPW01\FDMEEApps/data/scripts/event/AftImport.py

    2019-07-03 06:20:15,828 INFO  [AIF]: test

    2019-07-03 06:20:15,828 DEBUG [AIF]: Comm.executeVBScript - START

    2019-07-03 06:20:15,829 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps\data\scripts\event\AftImport.vbs

    2019-07-03 06:20:15,829 DEBUG [AIF]: Comm.executeVBScript - END

    2019-07-03 06:20:15,829 DEBUG [AIF]: Comm.executeScript - END

    2019-07-03 06:20:15,829 DEBUG [AIF]: CommData.postImportData - END

    2019-07-03 06:20:15,946 DEBUG [AIF]: LogicGroup.createLogicAccounts - START

    2019-07-03 06:20:15,947 DEBUG [AIF]: Comm.executeScript - START

    2019-07-03 06:20:15,947 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps/data/scripts/event/BefProcLogicGrp.py

    2019-07-03 06:20:15,947 DEBUG [AIF]: Comm.executeVBScript - START

    2019-07-03 06:20:15,948 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps\data\scripts\event\BefProcLogicGrp.vbs

    2019-07-03 06:20:15,948 DEBUG [AIF]: Comm.executeVBScript - END

    2019-07-03 06:20:15,948 DEBUG [AIF]: Comm.executeScript - END

    2019-07-03 06:20:15,950 DEBUG [AIF]: CommLogicGroup.getRuleInfo - START

    2019-07-03 06:20:15,950 DEBUG [AIF]:

            select part.PARTLOGICGROUP, lgrp.CALCGROUPTYPE

            from AIF_PROCESSES prs, TPOVPARTITION part,TBHVLOGICGROUP lgrp

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

            and part.PARTLOGICGROUP=lgrp.CALCGROUPKEY 

           

    2019-07-03 06:20:15,951 DEBUG [AIF]: CommLogicGroup.getRuleInfo - END

    2019-07-03 06:20:15,952 DEBUG [AIF]: Comm.executeScript - START

    2019-07-03 06:20:15,952 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps/data/scripts/event/AftProcLogicGrp.py

    2019-07-03 06:20:15,952 DEBUG [AIF]: Comm.executeVBScript - START

    2019-07-03 06:20:15,952 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps\data\scripts\event\AftProcLogicGrp.vbs

    2019-07-03 06:20:15,953 DEBUG [AIF]: Comm.executeVBScript - END

    2019-07-03 06:20:15,953 DEBUG [AIF]: Comm.executeScript - END

    2019-07-03 06:20:15,953 DEBUG [AIF]: LogicGroup.createLogicAccounts - END

    2019-07-03 06:20:16,061 DEBUG [AIF]: CommData.mapData - START

    2019-07-03 06:20:16,062 DEBUG [AIF]: CommData.insertTransProcessDetails - START

    2019-07-03 06:20:16,063 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, 'indirab' 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 = 2204

                AND PRIOR_PERIOD_FLAG = 'N'

                GROUP BY PROCESS_ID, TRANS_ENTITY_TYPE, TRANS_ENTITY_NAME

              ) q

              ORDER BY ENTITY_NAME_ORDER

             

    2019-07-03 06:20:16,069 DEBUG [AIF]: CommData.insertTransProcessDetails - END

    2019-07-03 06:20:16,072 DEBUG [AIF]:

            DELETE FROM TDATAMAP_T

            WHERE LOADID < 2204

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

           

    2019-07-03 06:20:16,072 DEBUG [AIF]:

            DELETE FROM TDATASEG_T

            WHERE LOADID < 2204

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

           

    2019-07-03 06:20:16,077 DEBUG [AIF]:

            DELETE FROM AIF_PROCESS_PERIODS

            WHERE PROCESS_ID < 2204

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

           

    2019-07-03 06:20:16,086 DEBUG [AIF]: CommMap.loadTDATAMAP_T - START

    2019-07-03 06:20:16,088 DEBUG [AIF]: CommData.getMapPartitionKeyandName - START

    2019-07-03 06:20:16,088 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 = 33

           

    2019-07-03 06:20:16,089 DEBUG [AIF]: CommData.getMapPartitionKeyandName - END

    2019-07-03 06:20:16,089 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 2204, DATAKEY, 33 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 = 33

            AND ( RULE_ID IS NULL OR RULE_ID = 46 )

           

    2019-07-03 06:20:16,090 DEBUG [AIF]: Number of Rows inserted into TDATAMAP_T: 8

    2019-07-03 06:20:16,151 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - START

    2019-07-03 06:20:16,151 DEBUG [AIF]: Comm.executeScript - START

    2019-07-03 06:20:16,152 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps/data/scripts/event/BefProcMap.py

    2019-07-03 06:20:16,152 DEBUG [AIF]: Comm.executeVBScript - START

    2019-07-03 06:20:16,152 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps\data\scripts\event\BefProcMap.vbs

    2019-07-03 06:20:16,152 DEBUG [AIF]: Comm.executeVBScript - END

    2019-07-03 06:20:16,152 DEBUG [AIF]: Comm.executeScript - END

    2019-07-03 06:20:16,153 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 = 2204

              AND atad.APPLICATION_ID = 29

              AND tdm.PARTITIONKEY = 33

              AND tdm.TDATAMAPTYPE = 'ERP'

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

              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 = 2204

              AND atad.APPLICATION_ID = 29

              AND tdm.PARTITIONKEY = 33

              AND tdm.TDATAMAPTYPE = 'ERP'

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

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

            ) q

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

           

    2019-07-03 06:20:16,157 INFO  [AIF]:

    Map Data for Period 'Mar-18'

    2019-07-03 06:20:16,158 DEBUG [AIF]: Comm.updateProcessDetail - START

    2019-07-03 06:20:16,159 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 ('indirab' IS NULL) THEN LAST_UPDATED_BY ELSE 'indirab' END

           ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

        WHERE PROCESS_ID = 2204 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'Mar-18'

       

    2019-07-03 06:20:16,162 DEBUG [AIF]: Comm.updateProcessDetail - END

    2019-07-03 06:20:16,165 DEBUG [AIF]:

          SELECT COUNT(*) ROW_COUNT

          FROM TDATASEG_T

          WHERE LOADID = 2204

          AND (PARTITIONKEY = 33 AND CATKEY = 1 AND PERIODKEY = '2018-03-31' AND RULE_ID = 46 AND VALID_FLAG = 'Y')

         

    2019-07-03 06:20:16,166 INFO  [AIF]:

    Processing Mappings for Column 'ACCOUNT'

    2019-07-03 06:20:16,166 DEBUG [AIF]:

                  UPDATE TDATASEG_T

                  SET ACCOUNTX = ACCOUNT

                     ,ACCOUNTR = 540

                     ,ACCOUNTF = 3

                  WHERE LOADID = 2204

                  AND PARTITIONKEY = 33

                  AND CATKEY = 1

                  AND (ACCOUNTX IS NULL OR ACCOUNTX = '')

                  AND (1=1)

                  AND PERIODKEY = '2018-03-31'

    2019-07-03 06:20:16,167 INFO  [AIF]: Data Rows Updated by Location Mapping 'AllAccount' (LIKE): 20

    2019-07-03 06:20:16,167 INFO  [AIF]:

    Processing Mappings for Column 'ENTITY'

    2019-07-03 06:20:16,167 DEBUG [AIF]:

                  UPDATE TDATASEG_T

                  SET ENTITYX = ENTITY

                     ,ENTITYR = 908

                     ,ENTITYF = 3

                  WHERE LOADID = 2204

                  AND PARTITIONKEY = 33

                  AND CATKEY = 1

                  AND (ENTITYX IS NULL OR ENTITYX = '')

                  AND (1=1)

                  AND PERIODKEY = '2018-03-31'

    2019-07-03 06:20:16,168 INFO  [AIF]: Data Rows Updated by Location Mapping 'AllEntity' (LIKE): 20

    2019-07-03 06:20:16,168 INFO  [AIF]:

    Processing Mappings for Column 'UD4'

    2019-07-03 06:20:16,168 DEBUG [AIF]:

                  UPDATE TDATASEG_T

                  SET UD4X = UD4

                     ,UD4R = 416

                     ,UD4F = 3

                  WHERE LOADID = 2204

                  AND PARTITIONKEY = 33

                  AND CATKEY = 1

                  AND (UD4X IS NULL OR UD4X = '')

                  AND (1=1)

                  AND PERIODKEY = '2018-03-31'

    2019-07-03 06:20:16,170 INFO  [AIF]: Data Rows Updated by Location Mapping 'AllProduct' (LIKE): 20

    2019-07-03 06:20:16,178 DEBUG [AIF]: Comm.updateProcessDetail - START

    2019-07-03 06:20:16,178 DEBUG [AIF]:

        UPDATE AIF_PROCESS_DETAILS

        SET STATUS = 'SUCCESS'

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

           ,EXECUTION_END_TIME = CURRENT_TIMESTAMP

           ,LAST_UPDATED_BY = CASE WHEN ('indirab' IS NULL) THEN LAST_UPDATED_BY ELSE 'indirab' END

           ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

        WHERE PROCESS_ID = 2204 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'Mar-18'

       

    2019-07-03 06:20:16,194 DEBUG [AIF]: Comm.updateProcessDetail - END

    2019-07-03 06:20:16,194 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - END

    2019-07-03 06:20:16,205 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - START

    2019-07-03 06:20:16,205 INFO  [AIF]:

    Stage Data for Period 'Mar-18'

    2019-07-03 06:20:16,205 DEBUG [AIF]:

            DELETE FROM TDATAMAPSEG

            WHERE PARTITIONKEY = 33

            AND CATKEY = 1

            AND PERIODKEY = '2018-03-31'

           

    2019-07-03 06:20:16,206 INFO  [AIF]: Number of Rows deleted from TDATAMAPSEG: 8

    2019-07-03 06:20:16,206 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, '2018-03-31', DIMNAME, SRCKEY, SRCDESC, TARGKEY, WHERECLAUSETYPE,

                   WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG

            FROM TDATAMAP_T

            WHERE LOADID = 2204

           

    2019-07-03 06:20:16,207 INFO  [AIF]: Number of Rows inserted into TDATAMAPSEG: 8

    2019-07-03 06:20:16,207 DEBUG [AIF]:

            DELETE FROM TDATAMAP_T

            WHERE LOADID = 2204

           

    2019-07-03 06:20:16,208 INFO  [AIF]: Number of Rows deleted from TDATAMAP_T: 8

    2019-07-03 06:20:16,208 DEBUG [AIF]:

                DELETE FROM TDATASEG

                WHERE LOADID < 2204 AND PARTITIONKEY = 33 AND CATKEY = 1 AND RULE_ID = 46 AND PERIODKEY = '2018-03-31'

               

    2019-07-03 06:20:16,209 INFO  [AIF]: Number of Rows deleted from TDATASEG: 20

    2019-07-03 06:20:16,210 DEBUG [AIF]:

                DELETE FROM TDATAMEMOITEMS

                WHERE PARTITIONKEY = 33 AND PERIODKEY = '2018-03-31' AND CATKEY = 1 AND RULE_ID = 46

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

               

    2019-07-03 06:20:16,210 INFO  [AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0

    2019-07-03 06:20:16,210 DEBUG [AIF]:

                DELETE FROM TDATAARCHIVE

                WHERE PARTITIONKEY = 33 AND PERIODKEY = '2018-03-31' AND CATKEY = 1 AND RULE_ID = 46

                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 )

               

    2019-07-03 06:20:16,211 INFO  [AIF]: Number of Rows deleted from TDATAARCHIVE: 0

    2019-07-03 06:20:16,211 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

                ,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

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

              FROM TDATASEG_T

              WHERE LOADID = 2204 AND PARTITIONKEY = 33 AND CATKEY = 1 AND PERIODKEY = '2018-03-31'

             

    2019-07-03 06:20:16,222 INFO  [AIF]: Number of Rows inserted into TDATASEG: 20

    2019-07-03 06:20:16,223 DEBUG [AIF]:

            DELETE FROM TDATASEG_T

            WHERE LOADID = 2204 AND PARTITIONKEY = 33 AND CATKEY = 1 AND PERIODKEY = '2018-03-31'

           

    2019-07-03 06:20:16,224 INFO  [AIF]: Number of Rows deleted from TDATASEG_T: 20

    2019-07-03 06:20:16,224 DEBUG [AIF]: CommData.updateWorkflow - START

    2019-07-03 06:20:16,225 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=33 AND CATKEY=1 AND PERIODKEY='2018-03-31' AND RULE_ID=46

           

    2019-07-03 06:20:16,240 DEBUG [AIF]: CommData.updateWorkflow - END

    2019-07-03 06:20:16,241 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - END

    2019-07-03 06:20:16,241 DEBUG [AIF]: Comm.executeScript - START

    2019-07-03 06:20:16,241 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps/data/scripts/event/AftProcMap.py

    2019-07-03 06:20:16,241 DEBUG [AIF]: Comm.executeVBScript - START

    2019-07-03 06:20:16,242 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps\data\scripts\event\AftProcMap.vbs

    2019-07-03 06:20:16,242 DEBUG [AIF]: Comm.executeVBScript - END

    2019-07-03 06:20:16,242 DEBUG [AIF]: Comm.executeScript - END

    2019-07-03 06:20:16,242 DEBUG [AIF]: CommData.mapData - END

    2019-07-03 06:20:16,354 INFO  [AIF]: -------END IMPORT STEP-------

    2019-07-03 06:20:16,463 INFO  [AIF]: -------START VALIDATE STEP-------

    2019-07-03 06:20:16,578 DEBUG [AIF]: CommData.validateData - START

    2019-07-03 06:20:16,579 DEBUG [AIF]: Comm.executeScript - START

    2019-07-03 06:20:16,579 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps/data/scripts/event/BefValidate.py

    2019-07-03 06:20:16,579 DEBUG [AIF]: Comm.executeVBScript - START

    2019-07-03 06:20:16,580 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps\data\scripts\event\BefValidate.vbs

    2019-07-03 06:20:16,580 DEBUG [AIF]: Comm.executeVBScript - END

    2019-07-03 06:20:16,580 DEBUG [AIF]: Comm.executeScript - END

    2019-07-03 06:20:16,585 DEBUG [AIF]: CommMap.validateData - START

    2019-07-03 06:20:16,587 INFO  [AIF]:

    Validate Data Mappings for Period 'Mar-18'

    2019-07-03 06:20:16,587 DEBUG [AIF]:

          SELECT COUNT(*) ROW_COUNT

          FROM TDATASEG

          WHERE LOADID = 2204

          AND (PARTITIONKEY = 33 AND CATKEY = 1 AND PERIODKEY = '2018-03-31' AND RULE_ID = 46 AND VALID_FLAG = 'Y')

         

    2019-07-03 06:20:16,588 DEBUG [AIF]: CommData.updateWorkflow - START

    2019-07-03 06:20:16,588 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 = 33 AND tlp.CATKEY = 1 AND tlp.PERIODKEY = '2018-03-31' AND tlp.RULE_ID = 46 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

       

    2019-07-03 06:20:16,588 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=33 AND CATKEY=1 AND PERIODKEY='2018-03-31' AND RULE_ID=46

           

    2019-07-03 06:20:16,620 DEBUG [AIF]: CommData.updateWorkflow - END

    2019-07-03 06:20:16,620 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.UD4X IS NULL OR TDATASEG.UD4X = '')

                      )

                  AND LOADID = 2204 AND PARTITIONKEY = 33 AND CATKEY = 1 AND PERIODKEY = '2018-03-31'

                  AND VALID_FLAG = 'Y'

                AND CALCACCTTYPE > 0

               

    2019-07-03 06:20:16,621 DEBUG [AIF]: CommData.updateWorkflow - START

    2019-07-03 06:20:16,621 DEBUG [AIF]:

            UPDATE TLOGPROCESS

            SET PROCESSENDTIME=CURRENT_TIMESTAMP

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

               ,PROCESSVALNOTE='AIF_WF_VAL_VALIDATE_OK_TXT'

            WHERE PARTITIONKEY=33 AND CATKEY=1 AND PERIODKEY='2018-03-31' AND RULE_ID=46

           

    2019-07-03 06:20:16,630 DEBUG [AIF]: CommData.updateWorkflow - END

    2019-07-03 06:20:16,630 INFO  [AIF]: Total Data Rows available for Export to Target: 20

    2019-07-03 06:20:16,631 DEBUG [AIF]: CommMap.validateData - END

    2019-07-03 06:20:16,631 INFO  [AIF]:

    Validate Data Members for Period 'Mar-18'

    2019-07-03 06:20:16,631 DEBUG [AIF]:

          SELECT COUNT(*) ROW_COUNT

          FROM TDATASEG

          WHERE LOADID = 2204

          AND (PARTITIONKEY = 33 AND CATKEY = 1 AND PERIODKEY = '2018-03-31' AND RULE_ID = 46 AND VALID_FLAG = 'Y')

         

    2019-07-03 06:20:16,632 INFO  [AIF]: Total Data Rows available for Export to Target: 20

    2019-07-03 06:20:16,632 DEBUG [AIF]: Comm.executeScript - START

    2019-07-03 06:20:16,633 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps/data/scripts/event/AftValidate.py

    2019-07-03 06:20:16,633 DEBUG [AIF]: Comm.executeVBScript - START

    2019-07-03 06:20:16,633 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps\data\scripts\event\AftValidate.vbs

    2019-07-03 06:20:16,633 DEBUG [AIF]: Comm.executeVBScript - END

    2019-07-03 06:20:16,633 DEBUG [AIF]: Comm.executeScript - END

    2019-07-03 06:20:16,633 DEBUG [AIF]: CommData.validateData - END

    2019-07-03 06:20:16,744 INFO  [AIF]: -------END VALIDATE STEP-------

    2019-07-03 06:20:17,102 INFO  [AIF]: -------START EXPORT STEP-------

    2019-07-03 06:20:17,221 DEBUG [AIF]: CommData.exportData - START

    2019-07-03 06:20:17,221 DEBUG [AIF]: Comm.executeScript - START

    2019-07-03 06:20:17,222 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps/data/scripts/event/BefExportToDat.py

    2019-07-03 06:20:17,222 DEBUG [AIF]: Comm.executeVBScript - START

    2019-07-03 06:20:17,222 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps\data\scripts\event\BefExportToDat.vbs

    2019-07-03 06:20:17,222 DEBUG [AIF]: Comm.executeVBScript - END

    2019-07-03 06:20:17,223 DEBUG [AIF]: Comm.executeScript - END

    2019-07-03 06:20:17,223 DEBUG [AIF]: CommData.updateWorkflow - START

    2019-07-03 06:20:17,223 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 = 33 AND tlp.CATKEY = 1 AND tlp.PERIODKEY = '2018-03-31' AND tlp.RULE_ID = 46 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

       

    2019-07-03 06:20:17,224 DEBUG [AIF]:

            UPDATE TLOGPROCESS

            SET PROCESSENDTIME=CURRENT_TIMESTAMP

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

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

            WHERE PARTITIONKEY=33 AND CATKEY=1 AND PERIODKEY='2018-03-31' AND RULE_ID=46

           

    2019-07-03 06:20:17,239 DEBUG [AIF]: CommData.updateWorkflow - END

    2019-07-03 06:20:17,239 DEBUG [AIF]:

                UPDATE TDATASEG

                SET LOADID = 2204

                WHERE PARTITIONKEY = 33

                AND PERIODKEY = '2018-03-31'

                AND CATKEY = 1

                AND RULE_ID = 46

                AND LOADID < 2204

               

    2019-07-03 06:20:17,240 DEBUG [AIF]: Number of Rows updated on TDATASEG: 0

    2019-07-03 06:20:17,241 DEBUG [AIF]: CommData.purgeInvalidRecordsTDATASEG - START

    2019-07-03 06:20:17,243 DEBUG [AIF]:

            DELETE FROM TDATASEG

            WHERE LOADID = 2204

           

              AND (

               

            PARTITIONKEY = 33

            AND CATKEY = 1

            AND PERIODKEY = '2018-03-31'

            AND RULE_ID = 46

            AND VALID_FLAG = 'N'

           

              )

    2019-07-03 06:20:17,244 DEBUG [AIF]: Number of Rows deleted from TDATASEG: 0

    2019-07-03 06:20:17,244 DEBUG [AIF]: CommData.purgeInvalidRecordsTDATASEG - END

    2019-07-03 06:20:17,245 DEBUG [AIF]: AIFUtil.callOdiServlet - START

    2019-07-03 06:20:17,256 INFO  [AIF]: EssbaseService.exportData - START

    2019-07-03 06:20:17,257 DEBUG [AIF]: appId:29, appType:ESSBASE, mcFlag:false, dataLoadMethod:CLASSIC_VIA_EPMI, mDataFlowNode:LOCAL, textDataLoad:N, isFccsLoad:false, isJournalLoad:false

    2019-07-03 06:20:17,257 DEBUG [AIF]: LOAD_METHOD:ESSFILE, LOAD_TYPE:DATA, EXPORT_MODE:STORE_DATA, CREATE_DRILL_REGION:false, PURGE_DATA_FILE:false, EXPORT_FILE_DELIMITER:comma, BATCH_SIZE:10000

    2019-07-03 06:20:17,257 DEBUG [AIF]: GlobalUserForAppAccess from Profile: null

    2019-07-03 06:20:17,271 INFO  [AIF]: cloudServiceType: NONE, Resolved user name for application access: indirab

    2019-07-03 06:20:17,272 DEBUG [AIF]: We need to connect to Essbase server.

    2019-07-03 06:20:17,324 DEBUG [AIF]: Obtained connection to essbase cube: FDMEE_DB

    2019-07-03 06:20:17,353 DEBUG [AIF]: SELECT '"'||ACCOUNT||'"','"'||ENTITY||'"','"'||UD4||'"','"'||SCENARIO||'"','"'||YEAR||'"','"'||PERIOD||'"',AMOUNT

    FROM AIF_HS_BALANCES

    WHERE LOADID = 2204

    2019-07-03 06:20:17,354 INFO  [AIF]: Creating data file: \\DON-HYCPW01\FDMEEApps\outbox\FDMEE-FDMEE_DB_2204.dat

    2019-07-03 06:20:17,769 INFO  [AIF]: Data file creation completed: 20

    2019-07-03 06:20:17,778 DEBUG [AIF]: Created rule file: AIF0046

    2019-07-03 06:20:17,779 DEBUG [AIF]: Locked rule file: AIF0046

    2019-07-03 06:20:17,780 INFO  [AIF]: Saved rule file to essbase server

    2019-07-03 06:20:17,781 DEBUG [AIF]: Unlocked rule file: AIF0046

    2019-07-03 06:20:17,789 INFO  [AIF]: EssbaseService.exportData - END (true)

    2019-07-03 06:20:17,798 DEBUG [AIF]: AIFUtil.callOdiServlet - END

    2019-07-03 06:20:17,798 DEBUG [AIF]: CommData.updateWorkflow - START

    2019-07-03 06:20:17,798 DEBUG [AIF]:

            UPDATE TLOGPROCESS

            SET PROCESSENDTIME=CURRENT_TIMESTAMP

               ,PROCESSSTATUS=21,PROCESSEXP=1

               ,PROCESSEXPNOTE='AIF_WF_EXP_EXPORT_OK_TXT'

            WHERE PARTITIONKEY=33 AND CATKEY=1 AND PERIODKEY='2018-03-31' AND RULE_ID=46

           

    2019-07-03 06:20:17,800 DEBUG [AIF]: CommData.updateWorkflow - END

    2019-07-03 06:20:17,800 DEBUG [AIF]: Comm.executeScript - START

    2019-07-03 06:20:17,801 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps/data/scripts/event/AftExportToDat.py

    2019-07-03 06:20:17,801 DEBUG [AIF]: Comm.executeVBScript - START

    2019-07-03 06:20:17,801 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps\data\scripts\event\AftExportToDat.vbs

    2019-07-03 06:20:17,801 DEBUG [AIF]: Comm.executeVBScript - END

    2019-07-03 06:20:17,802 DEBUG [AIF]: Comm.executeScript - END

    2019-07-03 06:20:17,802 DEBUG [AIF]: CommData.exportData - END

    2019-07-03 06:20:18,294 DEBUG [AIF]: CommData.loadData - START

    2019-07-03 06:20:18,294 DEBUG [AIF]: Comm.executeScript - START

    2019-07-03 06:20:18,295 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps/data/scripts/event/BefLoad.py

    2019-07-03 06:20:18,295 DEBUG [AIF]: Comm.executeVBScript - START

    2019-07-03 06:20:18,295 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps\data\scripts\event\BefLoad.vbs

    2019-07-03 06:20:18,295 DEBUG [AIF]: Comm.executeVBScript - END

    2019-07-03 06:20:18,295 DEBUG [AIF]: Comm.executeScript - END

    2019-07-03 06:20:18,296 DEBUG [AIF]: CommData.updateWorkflow - START

    2019-07-03 06:20:18,296 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 = 33 AND tlp.CATKEY = 1 AND tlp.PERIODKEY = '2018-03-31' AND tlp.RULE_ID = 46 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

       

    2019-07-03 06:20:18,297 DEBUG [AIF]:

            UPDATE TLOGPROCESS

            SET PROCESSENDTIME=CURRENT_TIMESTAMP

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

               ,PROCESSENTLOADNOTE=NULL,PROCESSENTVALNOTE=NULL

            WHERE PARTITIONKEY=33 AND CATKEY=1 AND PERIODKEY='2018-03-31' AND RULE_ID=46

           

    2019-07-03 06:20:18,299 DEBUG [AIF]: CommData.updateWorkflow - END

    2019-07-03 06:20:18,300 DEBUG [AIF]: AIFUtil.callOdiServlet - START

    2019-07-03 06:20:18,310 INFO  [AIF]: EssbaseService.loadData - START

    2019-07-03 06:20:18,310 DEBUG [AIF]: appId:29, appType:ESSBASE, mcFlag:false, dataLoadMethod:CLASSIC_VIA_EPMI, mDataFlowNode:LOCAL, textDataLoad:N, isFccsLoad:false, isJournalLoad:false

    2019-07-03 06:20:18,310 DEBUG [AIF]: LOAD_METHOD:ESSFILE, LOAD_TYPE:DATA, EXPORT_MODE:STORE_DATA, CREATE_DRILL_REGION:false, PURGE_DATA_FILE:false, EXPORT_FILE_DELIMITER:comma, BATCH_SIZE:10000

    2019-07-03 06:20:18,311 DEBUG [AIF]: GlobalUserForAppAccess from Profile: null

    2019-07-03 06:20:18,325 INFO  [AIF]: cloudServiceType: NONE, Resolved user name for application access: indirab

    2019-07-03 06:20:18,325 DEBUG [AIF]: We need to connect to Essbase server.

    2019-07-03 06:20:18,419 DEBUG [AIF]: Obtained connection to essbase cube: FDMEE_DB

    2019-07-03 06:20:18,420 DEBUG [AIF]: Resolved essbase rule file name for loading: AIF0046

    2019-07-03 06:20:18,420 DEBUG [AIF]: Fetching rule file from essbase server for data loading: AIF0046

    2019-07-03 06:20:18,422 INFO  [AIF]: Starting executeDataRuleFile...

    2019-07-03 06:20:18,423 DEBUG [AIF]: Locked rule file: AIF0046

    2019-07-03 06:20:18,424 INFO  [AIF]: Loading data into cube using data file...

    2019-07-03 06:20:18,435 INFO  [AIF]: The data has been loaded by the rule file.

    2019-07-03 06:20:18,436 DEBUG [AIF]: Unlocked rule file: AIF0046

    2019-07-03 06:20:18,444 INFO  [AIF]: The Drill Region option is not enabled for the application.

    2019-07-03 06:20:18,444 INFO  [AIF]: EssbaseService.loadData - END (true)

    2019-07-03 06:20:18,448 DEBUG [AIF]: AIFUtil.callOdiServlet - END

    2019-07-03 06:20:18,448 DEBUG [AIF]: CommData.updateWorkflow - START

    2019-07-03 06:20:18,448 DEBUG [AIF]:

            UPDATE TLOGPROCESS

            SET PROCESSENDTIME=CURRENT_TIMESTAMP

               ,PROCESSSTATUS=31,PROCESSENTLOAD=1

               ,PROCESSENTLOADNOTE='AIF_WF_LD_LOAD_OK_TXT'

            WHERE PARTITIONKEY=33 AND CATKEY=1 AND PERIODKEY='2018-03-31' AND RULE_ID=46

           

    2019-07-03 06:20:18,456 DEBUG [AIF]: CommData.updateWorkflow - END

    2019-07-03 06:20:18,456 DEBUG [AIF]: Comm.executeScript - START

    2019-07-03 06:20:18,461 INFO  [AIF]: Executing the following script: \\DON-HYCPW01\FDMEEApps/data/scripts/event/AftLoad.py

    2019-07-03 06:20:18,465 DEBUG [AIF]: Comm.executeVBScript - START

    2019-07-03 06:20:18,465 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps\data\scripts\event\AftLoad.vbs

    2019-07-03 06:20:18,465 DEBUG [AIF]: Comm.executeVBScript - END

    2019-07-03 06:20:18,465 DEBUG [AIF]: Comm.executeScript - END

    2019-07-03 06:20:18,465 DEBUG [AIF]: CommData.loadData - END

    2019-07-03 06:20:18,569 INFO  [AIF]: -------END EXPORT STEP-------

    2019-07-03 06:20:18,808 DEBUG [AIF]: CommData.consolidateData - START

    2019-07-03 06:20:18,808 DEBUG [AIF]: Comm.executeScript - START

    2019-07-03 06:20:18,809 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps/data/scripts/event/BefConsolidate.py

    2019-07-03 06:20:18,809 DEBUG [AIF]: Comm.executeVBScript - START

    2019-07-03 06:20:18,809 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps\data\scripts\event\BefConsolidate.vbs

    2019-07-03 06:20:18,810 DEBUG [AIF]: Comm.executeVBScript - END

    2019-07-03 06:20:18,810 DEBUG [AIF]: Comm.executeScript - END

    2019-07-03 06:20:18,810 DEBUG [AIF]: AIFUtil.callOdiServlet - START

    2019-07-03 06:20:18,846 INFO  [AIF]: ***** Consolidation Initialization - BEGIN *****

    2019-07-03 06:20:18,846 DEBUG [AIF]: Connection established to FDMEE database.

    2019-07-03 06:20:18,849 INFO  [AIF]: ***** Consolidation Initialization - END *****

    2019-07-03 06:20:18,849 INFO  [AIF]: ******** Consolidation Execution - BEGIN ********

    2019-07-03 06:20:18,914 DEBUG [AIF]: Disconnected from FDMEE database.

    2019-07-03 06:20:18,916 INFO  [AIF]: ******** Consolidation Execution - END ********

    2019-07-03 06:20:18,924 INFO  [AIF]: [consolidateData:2204,Mar-18] END (true)

    2019-07-03 06:20:18,927 DEBUG [AIF]: AIFUtil.callOdiServlet - END

    2019-07-03 06:20:18,927 DEBUG [AIF]: Comm.executeScript - START

    2019-07-03 06:20:18,928 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps/data/scripts/event/AftConsolidate.py

    2019-07-03 06:20:18,928 DEBUG [AIF]: Comm.executeVBScript - START

    2019-07-03 06:20:18,928 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps\data\scripts\event\AftConsolidate.vbs

    2019-07-03 06:20:18,928 DEBUG [AIF]: Comm.executeVBScript - END

    2019-07-03 06:20:18,929 DEBUG [AIF]: Comm.executeScript - END

    2019-07-03 06:20:18,929 DEBUG [AIF]: CommData.consolidateData - END

    2019-07-03 06:20:19,041 DEBUG [AIF]: CommData.checkData - START

    2019-07-03 06:20:19,042 DEBUG [AIF]: Comm.executeScript - START

    2019-07-03 06:20:19,042 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps/data/scripts/event/BefCheck.py

    2019-07-03 06:20:19,042 DEBUG [AIF]: Comm.executeVBScript - START

    2019-07-03 06:20:19,043 DEBUG [AIF]: The following script does not exist: \\DON-HYCPW01\FDMEEApps\data\scripts\event\BefCheck.vbs

    2019-07-03 06:20:19,043 DEBUG [AIF]: Comm.executeVBScript - END

    2019-07-03 06:20:19,043 DEBUG [AIF]: Comm.executeScript - END

    2019-07-03 06:20:19,044 DEBUG [AIF]: CommData.updateWorkflow - START

    2019-07-03 06:20:19,044 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 = 33 AND tlp.CATKEY = 1 AND tlp.PERIODKEY = '2018-03-31' AND tlp.RULE_ID = 46 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

       

    2019-07-03 06:20:19,044 DEBUG [AIF]:

            UPDATE TLOGPROCESS

            SET PROCESSENDTIME=CURRENT_TIMESTAMP

               ,PROCESSSTATUS=40,PROCESSENTVAL=0

               ,PROCESSENTVALNOTE=NULL

            WHERE PARTITIONKEY=33 AND CATKEY=1 AND PERIODKEY='2018-03-31' AND RULE_ID=46

           

    2019-07-03 06:20:19,048 DEBUG [AIF]: CommData.updateWorkflow - END

    2019-07-03 06:20:19,048 DEBUG [AIF]: AIFUtil.callOdiServlet - START

    2019-07-03 06:20:19,058 DEBUG [AIF]: appId:29, appType:ESSBASE, mcFlag:false, dataLoadMethod:CLASSIC_VIA_EPMI, mDataFlowNode:LOCAL, textDataLoad:N, isFccsLoad:false, isJournalLoad:false

    2019-07-03 06:20:19,058 DEBUG [AIF]: LOAD_METHOD:ESSFILE, LOAD_TYPE:DATA, EXPORT_MODE:STORE_DATA, CREATE_DRILL_REGION:false, PURGE_DATA_FILE:false, EXPORT_FILE_DELIMITER:comma, BATCH_SIZE:10000

    2019-07-03 06:20:19,058 DEBUG [AIF]: GlobalUserForAppAccess from Profile: null

    2019-07-03 06:20:19,073 INFO  [AIF]: cloudServiceType: NONE, Resolved user name for application access: indirab

    2019-07-03 06:20:19,073 DEBUG [AIF]: We need to connect to Essbase server.

    2019-07-03 06:20:19,115 INFO  [AIF]: [checkData:2204,Mar-18] BEGIN

    2019-07-03 06:20:19,127 INFO  [AIF]: ***** Check Initialization - BEGIN *****

    2019-07-03 06:20:19,127 INFO  [AIF]: Connection established to FDMEE database.

    2019-07-03 06:20:19,128 DEBUG [AIF]: GlobalUserForAppAccess from Profile:

  • user9513598
    user9513598 Member Posts: 1 Blue Ribbon
    edited Sep 25, 2019 6:14PM

    I'm experiencing the same issue. Did you find a resolution perhaps?

  • WPaffhausen
    WPaffhausen Member Posts: 412
    edited Sep 25, 2019 6:57PM

    Hello,

    What check entity and check rule group do you have assigned to your location?  Can you show us the rules you also have assigned in the check rule group? From the log it doesn't look like you have everything fully vetted out.

    Thank you,

    Wayne

  • user6692921
    user6692921 Member Posts: 179 Silver Badge
    edited Sep 26, 2019 3:38AM

    It's difficult to tell if your Jython script is correct . For instance the line msg=" - is that a single double quote (wrong) or 2 single quotes?

    For the return syntax your line is wrong - you must return 3 messages. The Admin manual:

    pastedImage_0.png