5 Replies Latest reply on Mar 9, 2017 7:56 AM by 3390309

    TypeError: cannot concatenate 'unicode' and 'NoneType' objects

    Nishant Fukate

      Hello Experts,

       

      We are trying to export the data with the help of Custom Application from HFM.

       

      We are succeed to extract the data till staging table. But while exporting it, it is throwing an error "TypeError: cannot concatenate 'unicode' and 'NoneType' objects".

       

      Kindly assist.

       

      Thanks

      Nishant

        • 1. Re: TypeError: cannot concatenate 'unicode' and 'NoneType' objects
          ThinkFDM

          Please set the log level to 5 (in System Settings) re-run the integration and attached the Process Details log to the discussion.  Thanks.

          • 2. Re: TypeError: cannot concatenate 'unicode' and 'NoneType' objects
            Nishant Fukate

            2017-02-07 16:04:07,815 INFO  [AIF]: FDMEE Process: 28, Log Level: 5, Log File: D:\hyperion\FDMEE_folder\Custom\outbox\logs\Custom_aps_28.log

            2017-02-07 16:04:07,816 INFO  [AIF]: Location     : Custom_loc (Partitionkey:1)

            2017-02-07 16:04:07,816 INFO  [AIF]: Period Name  : MAY16 (Period Key:5/31/16 12:00 AM)

            2017-02-07 16:04:07,816 INFO  [AIF]: Category Name: CORPORATE (Category key:4)

            2017-02-07 16:04:07,816 INFO  [AIF]: Rule Name    : Custom_rule (Rule ID:1)

            2017-02-07 16:04:10,104 INFO  [AIF]: FDM Version: 11.1.2.4.200

            2017-02-07 16:04:10,104 INFO  [AIF]: Log File Encoding: UTF-8

            2017-02-07 16:04:12,757 INFO  [AIF]: -------START IMPORT STEP-------

            2017-02-07 16:04:12,869 DEBUG [AIF]: CommData.preImportData - START

            2017-02-07 16:04:12,883 DEBUG [AIF]: CommData.getRuleInfo - START

            2017-02-07 16:04:12,895 DEBUG [AIF]:

                  SELECT adim.BALANCE_COLUMN_NAME DIMNAME, adim.DIMENSION_ID, dim.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 = 4

                  INNER JOIN AIF_DIMENSIONS dim

                    ON dim.DIMENSION_ID = adim.DIMENSION_ID

                  LEFT OUTER JOIN TBHVIMPITEMERPI tiie

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

                  WHERE tpp.PARTITIONKEY = 1

                  AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                  AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                  ORDER BY adim.BALANCE_COLUMN_NAME

                 

            2017-02-07 16:04:12,897 DEBUG [AIF]: {'APPLICATION_ID': 4L, 'SOURCE_APPLICATION_TYPE': u'HFM', 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'Custom_rule', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\hyperion\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 4L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'EXPLICIT', 'SOURCE_SYSTEM_TYPE': u'EPM', 'CHECK_FLAG': u'Y', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'Custom_aps', 'SOURCE_TGT_APP_NAME': u'UNICOMER', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 0L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'SOURCE_APP_NAME': u'UNICOMER', 'KK_FLAG': u'N', 'IMPGROUPKEY': None, 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'Y', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': u'6', 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5', u'UD6'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'admin', 'DIMNAME_MAP': {u'UD6': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD6', 'DIMENSION_ID': 49L}, u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 47L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 53L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 39L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 54L}, u'UD5': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD5', 'DIMENSION_ID': 50L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 51L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 21L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 48L}}, 'TARGET_APPLICATION_TYPE': u'CUSTOM', 'PARTITIONKEY': 1L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': u'N', 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': None, 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'EPM_EPM', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 1L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'SOURCE_DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://ZE42-V-NEWTON3.ind.zensar.com:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 4L, 'IMPTARGETSOURCESYSTEMID': 0L}

            2017-02-07 16:04:12,897 DEBUG [AIF]: CommData.getRuleInfo - END

            2017-02-07 16:04:12,905 DEBUG [AIF]: CommData.insertEpmPeriods - START

            2017-02-07 16:04:12,908 DEBUG [AIF]: doAppPeriodMappingsExist - Custom_aps: Y

            2017-02-07 16:04:12,910 DEBUG [AIF]: doAppPeriodMappingsExist - UNICOMER: N

            2017-02-07 16:04:12,910 DEBUG [AIF]: Period mapping section: EXPLICIT

            2017-02-07 16:04:12,910 DEBUG [AIF]:

                    INSERT INTO AIF_PROCESS_PERIODS (

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

                     ,GL_EFFECTIVE_PERIOD_NUM, YEARTARGET, PERIODTARGET, IMP_ENTITY_TYPE, IMP_ENTITY_NAME, TRANS_ENTITY_TYPE, TRANS_ENTITY_NAME, PRIOR_PERIOD_FLAG

                    )

                    SELECT DISTINCT brl.LOADID PROCESS_ID

                        ,tpp.PERIODKEY PERIODKEY

                        ,'N' ADJUSTMENT_PERIOD_FLAG

                        ,0 GL_PERIOD_YEAR

                        ,spp.YEARTARGET GL_PERIOD_YEAR_CHAR

                        ,0 GL_PERIOD_NUM

                        ,spp.PERIODTARGET GL_PERIOD_NAME

                        ,spp.PERIODKEY GL_PERIOD_CODE

                        ,0 GL_EFFECTIVE_PERIOD_NUM

                        ,tpp.YEARTARGET YEARTARGET

                        ,tpp.PERIODTARGET PERIODTARGET

                        ,'PROCESS_BAL_IMP_FILE' IMP_ENTITY_TYPE

                        ,'UNICOMER_28.dat' IMP_ENTITY_NAME

                        ,'PROCESS_BAL_TRANS' TRANS_ENTITY_TYPE

                        ,tpp.PERIODDESC TRANS_ENTITY_NAME

                        ,'N' PRIOR_PERIOD_FLAG

                    FROM (

                      AIF_BAL_RULE_LOADS brl

                      INNER JOIN TPOVCATEGORY pc

                        ON pc.CATKEY = brl.CATKEY

                       

                      INNER JOIN TPOVPERIODADAPTOR_FLAT_V tpp

                        ON tpp.PERIODFREQ = pc.CATFREQ

                        AND tpp.PERIODKEY >= brl.START_PERIODKEY

                        AND tpp.PERIODKEY <= brl.END_PERIODKEY

                        AND tpp.INTSYSTEMKEY = 'Custom_aps'

                      )

                      INNER JOIN TPOVPERIODSOURCE ppsrc

                        ON ppsrc.TARGET_PERIODKEY = tpp.PERIODKEY

                        AND ppsrc.SOURCE_SYSTEM_ID = 0

                        AND SOURCE_APPLICATION_NAME = 'UNICOMER'

                        AND TARGET_APPLICATION_NAME = 'Custom_aps'

                        AND ppsrc.MAPPING_TYPE = 'EXPLICIT'

                   

                      INNER JOIN TPOVPERIOD_FLAT_V spp

                        ON spp.PERIODFREQ = pc.CATFREQ

                        AND spp.PERIODKEY = ppsrc.PERIODKEY

                    WHERE brl.LOADID = 28

                    ORDER BY tpp.PERIODKEY, spp.PERIODKEY

                   

            2017-02-07 16:04:12,910 DEBUG [AIF]: periodSQL - periodParams: [u'UNICOMER_28.dat', u'Custom_aps', u'UNICOMER', u'Custom_aps', 28]

            2017-02-07 16:04:12,914 DEBUG [AIF]: CommData.insertEpmPeriods - END

            2017-02-07 16:04:12,922 DEBUG [AIF]: CommData.updateBalRuleLoadParams - START

            2017-02-07 16:04:12,925 DEBUG [AIF]: yearDimensionName=Year, yearFilter=2016

            2017-02-07 16:04:12,926 DEBUG [AIF]: periodDimensionName=Period, periodFilter=MAY

            2017-02-07 16:04:12,929 DEBUG [AIF]: CommData.updateBalRuleLoadParams - END

            2017-02-07 16:04:12,936 DEBUG [AIF]: CommData.getPovList - START

            2017-02-07 16:04:12,938 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 = 'Custom_aps'

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

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

                   

            2017-02-07 16:04:12,940 DEBUG [AIF]: CommData.getPovList - END

            2017-02-07 16:04:12,952 DEBUG [AIF]: Comm.doScriptInit - START

            2017-02-07 16:04:13,084 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\hyperion\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=D:\hyperion\FDMEE_folder\Custom\inbox, LOCNAME=Custom_loc, SOURCENAME=EPM, APPID=4, SOURCEID=0, APPROOTDIR=D:\hyperion\FDMEE_folder\Custom, IMPORTFORMAT=custom, SCRIPTSDIR=D:\hyperion\FDMEE_folder\Custom\data\scripts, EPMORACLEHOME=D:\hyperion\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=CUSTOM, RULEID=1, CATNAME=CORPORATE, EPMORACLEINSTANCEHOME=D:\hyperion\Oracle\Middleware\user_projects\epmsystem1, LOADID=28, PERIODNAME=MAY16, IMPORTMODE=REPLACE, SOURCETYPE=EPM, PERIODKEY=2016-05-31, EXPORTFLAG=Y, TARGETAPPDB=null, TARGETAPPNAME=Custom_aps, LOCKEY=1, RULENAME=Custom_rule, OUTBOXDIR=D:\hyperion\FDMEE_folder\Custom\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=4, USERNAME=admin, FILEDIR=null, IMPORTFLAG=Y, USERLOCALE=null}

            2017-02-07 16:04:13,092 DEBUG [AIF]: The executeEventScript is set to: YES

            2017-02-07 16:04:13,092 DEBUG [AIF]: The AppRootFolder is set to: D:\hyperion\FDMEE_folder\Custom

            2017-02-07 16:04:13,092 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

            2017-02-07 16:04:13,092 DEBUG [AIF]: The OleDatabaseProvider is set to: ORAOLEDB.ORACLE

            2017-02-07 16:04:13,092 DEBUG [AIF]: Comm.doScriptInit - END

            2017-02-07 16:04:13,092 DEBUG [AIF]: Comm.executeScript - START

            2017-02-07 16:04:13,095 INFO  [AIF]: Executing the following script: D:\hyperion\FDMEE_folder\Custom/data/scripts/event/BefImport.py

            2017-02-07 16:04:13,117 DEBUG [AIF]: Comm.executeVBScript - START

            2017-02-07 16:04:13,118 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp

            2017-02-07 16:04:13,119 INFO  [AIF]: Executing the following script: D:\hyperion\FDMEE_folder\Custom\data\scripts\event\BefImport.vbs

            2017-02-07 16:04:13,122 DEBUG [AIF]: The command to be executed is:

            cscript D:\hyperion\FDMEE_folder\Custom\data\scripts\event\BefImport.vbs "28" "****" "D%3A%5Chyperion%5COracle%5CMiddleware%5Cuser_projects%5Cepmsystem1" "%25EPM_ORACLE_HOME%25%2F..%2Fjdk160_35" "ORAOLEDB.ORACLE"

            Microsoft (R) Windows Script Host Version 5.8

            Copyright (C) Microsoft Corporation. All rights reserved.

             

             

            2017-02-07 16:04:13,420 DEBUG [AIF]: Comm.executeVBScript - END

            2017-02-07 16:04:13,420 DEBUG [AIF]: Comm.executeScript - END

            2017-02-07 16:04:13,420 DEBUG [AIF]: CommData.preImportData - END

            2017-02-07 16:04:19,358 DEBUG [AIF]: CommData.extractDataFromSource - START

            2017-02-07 16:04:19,367 DEBUG [AIF]: CommData.getRuleInfo - START

            2017-02-07 16:04:19,375 DEBUG [AIF]:

                  SELECT adim.BALANCE_COLUMN_NAME DIMNAME, adim.DIMENSION_ID, dim.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 = 4

                  INNER JOIN AIF_DIMENSIONS dim

                    ON dim.DIMENSION_ID = adim.DIMENSION_ID

                  LEFT OUTER JOIN TBHVIMPITEMERPI tiie

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

                  WHERE tpp.PARTITIONKEY = 1

                  AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                  AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                  ORDER BY adim.BALANCE_COLUMN_NAME

                 

            2017-02-07 16:04:19,376 DEBUG [AIF]: {'APPLICATION_ID': 4L, 'SOURCE_APPLICATION_TYPE': u'HFM', 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'Custom_rule', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\hyperion\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 4L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'EXPLICIT', 'SOURCE_SYSTEM_TYPE': u'EPM', 'CHECK_FLAG': u'Y', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'Custom_aps', 'SOURCE_TGT_APP_NAME': u'UNICOMER', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 0L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'SOURCE_APP_NAME': u'UNICOMER', 'KK_FLAG': u'N', 'IMPGROUPKEY': None, 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'Y', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': u'6', 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5', u'UD6'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'admin', 'DIMNAME_MAP': {u'UD6': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD6', 'DIMENSION_ID': 49L}, u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 47L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 53L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 39L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 54L}, u'UD5': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD5', 'DIMENSION_ID': 50L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 51L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 21L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 48L}}, 'TARGET_APPLICATION_TYPE': u'CUSTOM', 'PARTITIONKEY': 1L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': u'N', 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': None, 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'EPM_EPM', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 1L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'SOURCE_DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://ZE42-V-NEWTON3.ind.zensar.com:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 4L, 'IMPTARGETSOURCESYSTEMID': 0L}

            2017-02-07 16:04:19,377 DEBUG [AIF]: CommData.getRuleInfo - END

            2017-02-07 16:04:19,380 DEBUG [AIF]: AIFUtil.callOdiServlet - START

            2017-02-07 16:04:19,437 INFO  [AIF]: [HFMService] Info:extracting data from UNICOMER:ZE42-V-NEWTON3...

            2017-02-07 16:04:19,529 INFO  [AIF]: [HFMService] Info:Filter Slice: S#CORPORATE.Y#2016.P#MAY.W#YTD.E#3801_CONSO.V#USD.A#1031981.I#[ICP None].LOB#000.PC#0000000.CC#0000.SA#10.RP#TBINPUT.MV#M999

            2017-02-07 16:04:20,471 INFO  [AIF]: [HFMService] Info:Data extraction complete

            2017-02-07 16:04:20,523 INFO  [AIF]: [HFMService] Info:[extractData:28] END (true)

            2017-02-07 16:04:20,540 DEBUG [AIF]: AIFUtil.callOdiServlet - END

            2017-02-07 16:04:20,540 DEBUG [AIF]: CommData.extractDataFromSource - END

            2017-02-07 16:04:20,581 DEBUG [AIF]: CommData.insertImportProcessDetails - START

            2017-02-07 16:04:20,583 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, 'admin' 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 = 28

                      ) q

                      ORDER BY ENTITY_NAME_ORDER

                     

            2017-02-07 16:04:20,587 DEBUG [AIF]: CommData.insertImportProcessDetails - END

            2017-02-07 16:04:20,679 DEBUG [AIF]: FileData.importData - START

            2017-02-07 16:04:20,679 DEBUG [AIF]: Importing data for load id: 28

            2017-02-07 16:04:20,679 DEBUG [AIF]: CommData.getRuleInfo - START

            2017-02-07 16:04:20,683 DEBUG [AIF]:

                  SELECT adim.BALANCE_COLUMN_NAME DIMNAME, adim.DIMENSION_ID, dim.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 = 4

                  INNER JOIN AIF_DIMENSIONS dim

                    ON dim.DIMENSION_ID = adim.DIMENSION_ID

                  LEFT OUTER JOIN TBHVIMPITEMERPI tiie

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

                  WHERE tpp.PARTITIONKEY = 1

                  AND adim.BALANCE_COLUMN_NAME IS NOT NULL

                  AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                  ORDER BY adim.BALANCE_COLUMN_NAME

                 

            2017-02-07 16:04:20,686 DEBUG [AIF]: {'APPLICATION_ID': 4L, 'SOURCE_APPLICATION_TYPE': u'HFM', 'IMPORT_FROM_SOURCE_FLAG': u'Y', 'PLAN_TYPE': None, 'RULE_NAME': u'Custom_rule', 'ACTUAL_FLAG': None, 'IS_INCREMENTAL_LOAD': False, 'EPM_ORACLE_INSTANCE': u'D:\\hyperion\\Oracle\\Middleware\\user_projects\\epmsystem1', 'CATKEY': 4L, 'BAL_SEG_VALUE_OPTION_CODE': None, 'INCLUDE_ADJ_PERIODS_FLAG': u'N', 'PERIOD_MAPPING_TYPE': u'EXPLICIT', 'SOURCE_SYSTEM_TYPE': u'EPM', 'CHECK_FLAG': u'Y', 'LEDGER_GROUP': None, 'TARGET_APPLICATION_NAME': u'Custom_aps', 'SOURCE_TGT_APP_NAME': u'UNICOMER', 'RECALCULATE_FLAG': u'Y', 'SOURCE_SYSTEM_ID': 0L, 'TEMP_DATA_TABLE_NAME': 'TDATASEG_T', 'SOURCE_APP_NAME': u'UNICOMER', 'KK_FLAG': u'N', 'IMPGROUPKEY': None, 'AMOUNT_TYPE': u'MONETARY', 'DATA_TABLE_NAME': 'TDATASEG', 'EXPORT_TO_TARGET_FLAG': u'Y', 'JOURNAL_FLAG': None, 'SOURCE_APPLICATION_ID': u'6', 'DIMNAME_LIST': [u'ACCOUNT', u'ENTITY', u'ICP', u'UD1', u'UD2', u'UD3', u'UD4', u'UD5', u'UD6'], 'FCI_FLAG': 'N', 'IMPSOURCECOAID': 0L, 'TDATAMAPTYPE': 'ERP', 'LAST_UPDATED_BY': u'admin', 'DIMNAME_MAP': {u'UD6': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD6', 'DIMENSION_ID': 49L}, u'UD3': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD3', 'DIMENSION_ID': 47L}, u'ICP': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ICP', 'DIMENSION_ID': 53L}, u'ENTITY': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Entity', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ENTITY', 'DIMENSION_ID': 39L}, u'UD2': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD2', 'DIMENSION_ID': 54L}, u'UD5': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD5', 'DIMENSION_ID': 50L}, u'UD4': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD4', 'DIMENSION_ID': 51L}, u'ACCOUNT': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Account', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'ACCOUNT', 'DIMENSION_ID': 21L}, u'UD1': {'IMPCONCATCHAR': None, 'TARGET_DIMENSION_CLASS_NAME': u'Generic', 'COA_SEGMENT_NAME1': None, 'DIMNAME': u'UD1', 'DIMENSION_ID': 48L}}, 'TARGET_APPLICATION_TYPE': u'CUSTOM', 'PARTITIONKEY': 1L, 'PARTVALGROUP': u'[NONE]', 'LEDGER_GROUP_CODE': u'NONE', 'INCLUDE_ZERO_BALANCE_FLAG': u'N', 'EXECUTION_MODE': u'REPLACE', 'PLAN_NUMBER': 0L, 'MULTI_PERIOD_FILE_FLAG': None, 'PS_LEDGER': None, 'BALANCE_SELECTION': u'FUNCTIONAL', 'IMPGROUPFILETYPE': u'EPM_EPM', 'BALANCE_AMOUNT_IS': u'PERIODIC', 'RULE_ID': 1L, 'BALANCE_AMOUNT_BS': u'YTD', 'CURRENCY_CODE': None, 'SOURCE_ADAPTER_FLAG': u'N', 'SOURCE_DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'BALANCE_METHOD_CODE': None, 'SIGNAGE_METHOD': u'ABSOLUTE', 'WEB_SERVICE_URL': u'http://ZE42-V-NEWTON3.ind.zensar.com:6550/aif', 'DATA_LOAD_METHOD': u'CLASSIC_VIA_EPMI', 'PARTTARGETAPPLICATIONID': 4L, 'IMPTARGETSOURCESYSTEMID': 0L}

            2017-02-07 16:04:20,686 DEBUG [AIF]: CommData.getRuleInfo - END

            2017-02-07 16:04:20,689 DEBUG [AIF]: doAppPeriodMappingsExist - Custom_aps: Y

            2017-02-07 16:04:20,689 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,

                                              coalesce(br.MULTI_PERIOD_FILE_FLAG, 'N') MULTI_PERIOD_FILE_FLAG

                                            FROM aif_bal_rule_loads a,

                                            aif_balance_rules br,

                                              TPOVPERIODADAPTOR b,

                                              aif_processes c

                                            WHERE a.loadid       = 28

                                            AND a.start_periodkey=b.periodkey

                                            AND a.loadid         =c.process_id

                                            AND br.rule_id = a.rule_id

                                            AND b.INTSYSTEMKEY = 'Custom_aps'

                                           

            2017-02-07 16:04:20,692 DEBUG [AIF]: FileData.py: Importing Text data for load id: 28

            2017-02-07 16:04:20,799 INFO  [AIF]: EPMFDM-140274:Message - Log File Name :D:\hyperion\FDMEE_folder\Custom\outbox\logs\Custom_aps_28.log

            2017-02-07 16:04:20,800 INFO  [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH::28;1:4:1:[NONE]:D:\hyperion\FDMEE_folder\Custom/data

            2017-02-07 16:04:20,807 INFO  [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8

            2017-02-07 16:04:20,808 INFO  [AIF]: EPMFDM-140274:Message - ImportTextData - Start

            2017-02-07 16:04:20,857 INFO  [AIF]: EPMFDM-140274:Message - Log File Name :D:\hyperion\FDMEE_folder\Custom\outbox\logs\Custom_aps_28.log

            2017-02-07 16:04:20,861 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=null:StartPos=1:SourceClName=Amount

            2017-02-07 16:04:20,862 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=1:SourceClName=Account

            2017-02-07 16:04:20,862 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=null:StartPos=1:SourceClName=Cost_Center

            2017-02-07 16:04:20,862 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ENTITY:ImpFieldText=null:StartPos=1:SourceClName=Entity

            2017-02-07 16:04:20,862 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=null:StartPos=1:SourceClName=Line_of_Business

            2017-02-07 16:04:20,862 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD6:ImpFieldText=null:StartPos=1:SourceClName=Movement

            2017-02-07 16:04:20,862 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD5:ImpFieldText=null:StartPos=1:SourceClName=Report

            2017-02-07 16:04:20,862 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD4:ImpFieldText=null:StartPos=1:SourceClName=Sub_Account

            2017-02-07 16:04:20,862 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ICP:ImpFieldText=null:StartPos=1:SourceClName=ICP

            2017-02-07 16:04:20,863 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD2:ImpFieldText=null:StartPos=1:SourceClName=Profit_Center

            2017-02-07 16:04:20,863 INFO  [AIF]: EPMFDM-140274:Message - File Name UNICOMER_28.dat

            periodKey2016-05-31

            2017-02-07 16:04:20,863 INFO  [AIF]: EPMFDM-140274:Message - dataLoadEngine.getSourceSystemTypeEPM() HFM

            2017-02-07 16:04:21,023 DEBUG [AIF]: EPMFDM-140274:Message - HEADER: [Scenario, Year, Period, View, Entity, Value, Account, ICP, Line_of_Business, Profit_Center, Cost_Center, Sub_Account, Report, Movement]

            2017-02-07 16:04:21,023 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CURKEY:ImpFieldText=null:StartPos=1:SourceClName=Value

            2017-02-07 16:04:21,023 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ATTR2:ImpFieldText=null:StartPos=1:SourceClName=Period

            2017-02-07 16:04:21,024 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ATTR3:ImpFieldText=null:StartPos=1:SourceClName=Year

            2017-02-07 16:04:21,025 INFO  [AIF]: EPMFDM-140274:Message -  PROCESS ID: 28

            PARTITIONKEY: 1

            IMPORT GROUP: custom

            FILE TYPE: DELIMITED

            DELIMITER: ,

            SOURCE FILE: UNICOMER_28.dat

            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

             

             

             

             

            Rows Loaded: 1

            Rows Rejected: 0

             

             

            2017-02-07 16:04:21,029 INFO  [AIF]: EPMFDM-140274:Message - ARCHIVE MODE: Copy

            2017-02-07 16:04:21,029 INFO  [AIF]: EPMFDM-140274:Message - Start archiving file:

            2017-02-07 16:04:21,029 DEBUG [AIF]: EPMFDM-140274:Message - ArchiveId: 2820160531

            2017-02-07 16:04:21,029 DEBUG [AIF]: EPMFDM-140274:Message - Archive- SourceFileName: UNICOMER_28

            Extension: dat

            2017-02-07 16:04:21,030 INFO  [AIF]: EPMFDM-140274:Message - Archive file name: 2820160531.dat

            2017-02-07 16:04:21,031 INFO  [AIF]: EPMFDM-140274:Message - Deleting the source file: UNICOMER_28.dat

            2017-02-07 16:04:21,032 INFO  [AIF]: EPMFDM-140274:Message - File not deleted: D:\hyperion\FDMEE_folder\Custom\data\UNICOMER_28.dat

            2017-02-07 16:04:21,043 INFO  [AIF]: EPMFDM-140274:Message - PeriodKey:loadid:PERIOD:YEAR::2016-05-31:28:MAY:2016

            2017-02-07 16:04:21,046 INFO  [AIF]: EPMFDM-140274:Message - ImportTextData - End

            2017-02-07 16:04:21,046 INFO  [AIF]: EPMFDM-140274:Message - Total time taken for the import in ms = 238

            2017-02-07 16:04:21,049 DEBUG [AIF]: FileData.importData - END

            2017-02-07 16:04:21,168 DEBUG [AIF]: CommData.postImportData - START

            2017-02-07 16:04:21,191 DEBUG [AIF]: CommData.updateTDATASEG_T - START

            2017-02-07 16:04:21,196 DEBUG [AIF]: CommData.getLedgerListAndMap - START

            2017-02-07 16:04:21,197 DEBUG [AIF]: CommData.getLedgerSQL - START

            2017-02-07 16:04:21,197 DEBUG [AIF]: CommData.getLedgerSQL - END

            2017-02-07 16:04:21,198 DEBUG [AIF]:

                      SELECT COALESCE(br.SOURCE_LEDGER_ID,0) SOURCE_LEDGER_ID, NULL SOURCE_LEDGER_NAME, NULL SOURCE_COA_ID

                            ,br.CALENDAR_ID, NULL SETID, NULL PERIOD_TYPE, NULL LEDGER_TABLE_NAME

                      FROM AIF_BALANCE_RULES br

                      WHERE br.RULE_ID = 1

                     

            2017-02-07 16:04:21,199 DEBUG [AIF]: CommData.getLedgerListAndMap - END

            2017-02-07 16:04:21,205 DEBUG [AIF]: CommData.getPovList - START

            2017-02-07 16:04:21,207 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 = 'Custom_aps'

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

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

                   

            2017-02-07 16:04:21,209 DEBUG [AIF]: CommData.getPovList - END

            2017-02-07 16:04:21,209 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    = 28

                      AND en.process_id      = pp.process_id

                      AND pp.IMP_ENTITY_NAME = en.file_entity_name

                      order by en.entity_name_order

                     

            2017-02-07 16:04:21,213 INFO  [AIF]:

            Import Data from Source for Period 'MAY16'

            2017-02-07 16:04:21,225 DEBUG [AIF]: CommData.updateWorkflow - START

            2017-02-07 16:04:21,225 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 = 1 AND tlp.CATKEY = 4 AND tlp.PERIODKEY = '2016-05-31' AND tlp.RULE_ID = 1 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

               

            2017-02-07 16:04:21,227 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=1 AND CATKEY=4 AND PERIODKEY='2016-05-31' AND RULE_ID=1

                   

            2017-02-07 16:04:21,230 DEBUG [AIF]: CommData.updateWorkflow - END

            2017-02-07 16:04:21,230 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 = 1

                        AND dim.TARGET_DIMENSION_CLASS_NAME <> 'ICPTRANS'

                        ORDER BY adim.BALANCE_COLUMN_NAME

                       

            2017-02-07 16:04:21,232 DEBUG [AIF]: 

                        UPDATE TDATASEG_T

                        SET AMOUNTX = AMOUNT

                           ,ACCOUNTX = NULL

                           ,ENTITYX = NULL

                           ,ICPX = NULL

                           ,UD1X = NULL

                           ,UD2X = NULL

                           ,UD3X = NULL

                           ,UD4X = NULL

                           ,UD5X = NULL

                           ,UD6X = NULL

                        WHERE TDATASEG_T.LOADID = 28 AND TDATASEG_T.PARTITIONKEY = 1 AND TDATASEG_T.CATKEY = 4 AND TDATASEG_T.PERIODKEY = '2016-05-31'

                       

            2017-02-07 16:04:21,233 INFO  [AIF]: Generic Data Rows Imported from Source: 1

            2017-02-07 16:04:21,234 DEBUG [AIF]: 

                          INSERT INTO AIF_APPL_LOAD_AUDIT (

                            LOADID

                            ,TARGET_APPLICATION_TYPE

                            ,TARGET_APPLICATION_NAME

                            ,PLAN_TYPE

                            ,SOURCE_LEDGER_ID

                            ,EPM_YEAR

                            ,EPM_PERIOD

                            ,SNAPSHOT_FLAG

                            ,PARTITIONKEY

                            ,CATKEY

                            ,RULE_ID

                            ,PERIODKEY

                            ,EXPORT_TO_TARGET_FLAG

                          )

                          SELECT DISTINCT PROCESS_ID LOADID

                          ,'CUSTOM' TARGET_APPLICATION_TYPE

                          ,'Custom_aps' TARGET_APPLICATION_NAME

                          ,NULL PLAN_TYPE

                          ,0 SOURCE_LEDGER_ID

                          ,YEARTARGET EPM_YEAR

                          ,PERIODTARGET EPM_PERIOD

                          ,'Y' SNAPSHOT_FLAG

                          ,1 PARTITIONKEY

                          ,4 CATKEY

                          ,1 RULE_ID

                          ,PERIODKEY

                          ,'N' EXPORT_TO_TARGET_FLAG

                          FROM AIF_PROCESS_PERIODS

                          WHERE PROCESS_ID = 28

                          AND PERIODKEY = '2016-05-31'

                         

            2017-02-07 16:04:21,237 INFO  [AIF]: Total Data Rows Imported from Source: 1

            2017-02-07 16:04:21,238 DEBUG [AIF]: CommData.updateTDATASEG_T - END

            2017-02-07 16:04:21,249 DEBUG [AIF]: Comm.doScriptInit - START

            2017-02-07 16:04:21,383 DEBUG [AIF]: fdmContext: {BATCHSCRIPTDIR=D:\hyperion\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality, INBOXDIR=D:\hyperion\FDMEE_folder\Custom\inbox, LOCNAME=Custom_loc, SOURCENAME=EPM, APPID=4, SOURCEID=0, APPROOTDIR=D:\hyperion\FDMEE_folder\Custom, IMPORTFORMAT=custom, SCRIPTSDIR=D:\hyperion\FDMEE_folder\Custom\data\scripts, EPMORACLEHOME=D:\hyperion\Oracle\Middleware\EPMSystem11R1, TARGETAPPTYPE=CUSTOM, RULEID=1, CATNAME=CORPORATE, EPMORACLEINSTANCEHOME=D:\hyperion\Oracle\Middleware\user_projects\epmsystem1, LOADID=28, PERIODNAME=MAY16, IMPORTMODE=REPLACE, SOURCETYPE=EPM, PERIODKEY=2016-05-31, EXPORTFLAG=Y, TARGETAPPDB=null, TARGETAPPNAME=Custom_aps, LOCKEY=1, RULENAME=Custom_rule, OUTBOXDIR=D:\hyperion\FDMEE_folder\Custom\outbox, MULTIPERIODLOAD=N, EXPORTMODE=null, CATKEY=4, USERNAME=admin, FILEDIR=data, IMPORTFLAG=Y, USERLOCALE=null}

            2017-02-07 16:04:21,391 DEBUG [AIF]: The executeEventScript is set to: YES

            2017-02-07 16:04:21,391 DEBUG [AIF]: The AppRootFolder is set to: D:\hyperion\FDMEE_folder\Custom

            2017-02-07 16:04:21,391 DEBUG [AIF]: The JavaHome is set to: %EPM_ORACLE_HOME%/../jdk160_35

            2017-02-07 16:04:21,391 DEBUG [AIF]: The OleDatabaseProvider is set to: ORAOLEDB.ORACLE

            2017-02-07 16:04:21,391 DEBUG [AIF]: Comm.doScriptInit - END

            2017-02-07 16:04:21,391 DEBUG [AIF]: Comm.executeScript - START

            2017-02-07 16:04:21,392 INFO  [AIF]: Executing the following script: D:\hyperion\FDMEE_folder\Custom/data/scripts/event/AftImport.py

            2017-02-07 16:04:21,402 DEBUG [AIF]: Comm.executeVBScript - START

            2017-02-07 16:04:21,402 DEBUG [AIF]: The WindowsTempFolder is set to: c:\windows\temp

            2017-02-07 16:04:21,403 INFO  [AIF]: Executing the following script: D:\hyperion\FDMEE_folder\Custom\data\scripts\event\AftImport.vbs

            2017-02-07 16:04:21,406 DEBUG [AIF]: The command to be executed is:

            cscript D:\hyperion\FDMEE_folder\Custom\data\scripts\event\AftImport.vbs "28" "****" "D%3A%5Chyperion%5COracle%5CMiddleware%5Cuser_projects%5Cepmsystem1" "%25EPM_ORACLE_HOME%25%2F..%2Fjdk160_35" "ORAOLEDB.ORACLE"

            Microsoft (R) Windows Script Host Version 5.8

            Copyright (C) Microsoft Corporation. All rights reserved.

             

             

            2017-02-07 16:04:21,697 DEBUG [AIF]: Comm.executeVBScript - END

            2017-02-07 16:04:21,697 DEBUG [AIF]: Comm.executeScript - END

            2017-02-07 16:04:21,697 DEBUG [AIF]: CommData.postImportData - END

            2017-02-07 16:04:21,969 DEBUG [AIF]: LogicGroup.createLogicAccounts - START

            2017-02-07 16:04:21,969 DEBUG [AIF]: Comm.executeScript - START

            2017-02-07 16:04:21,970 INFO  [AIF]: Executing the following script: D:\hyperion\FDMEE_folder\Custom/data/scripts/event/BefProcLogicGrp.py

            2017-02-07 16:04:21,972 DEBUG [AIF]: Comm.executeVBScript - START

            2017-02-07 16:04:21,973 INFO  [AIF]: Executing the following script: D:\hyperion\FDMEE_folder\Custom\data\scripts\event\BefProcLogicGrp.vbs

            2017-02-07 16:04:21,974 DEBUG [AIF]: The command to be executed is:

            cscript D:\hyperion\FDMEE_folder\Custom\data\scripts\event\BefProcLogicGrp.vbs "28" "****" "D%3A%5Chyperion%5COracle%5CMiddleware%5Cuser_projects%5Cepmsystem1" "%25EPM_ORACLE_HOME%25%2F..%2Fjdk160_35" "ORAOLEDB.ORACLE"

            Microsoft (R) Windows Script Host Version 5.8

            Copyright (C) Microsoft Corporation. All rights reserved.

             

             

            2017-02-07 16:04:22,237 DEBUG [AIF]: Comm.executeVBScript - END

            2017-02-07 16:04:22,238 DEBUG [AIF]: Comm.executeScript - END

            2017-02-07 16:04:22,240 DEBUG [AIF]: CommLogicGroup.getRuleInfo - START

            2017-02-07 16:04:22,241 DEBUG [AIF]:

                    select part.PARTLOGICGROUP, lgrp.CALCGROUPTYPE

                    from AIF_PROCESSES prs, TPOVPARTITION part,TBHVLOGICGROUP lgrp

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

                    and part.PARTLOGICGROUP=lgrp.CALCGROUPKEY 

                   

            2017-02-07 16:04:22,242 DEBUG [AIF]: CommLogicGroup.getRuleInfo - END

            2017-02-07 16:04:22,243 DEBUG [AIF]: Comm.executeScript - START

            2017-02-07 16:04:22,244 INFO  [AIF]: Executing the following script: D:\hyperion\FDMEE_folder\Custom/data/scripts/event/AftProcLogicGrp.py

            2017-02-07 16:04:22,247 DEBUG [AIF]: Comm.executeVBScript - START

            2017-02-07 16:04:22,248 INFO  [AIF]: Executing the following script: D:\hyperion\FDMEE_folder\Custom\data\scripts\event\AftProcLogicGrp.vbs

            2017-02-07 16:04:22,250 DEBUG [AIF]: The command to be executed is:

            cscript D:\hyperion\FDMEE_folder\Custom\data\scripts\event\AftProcLogicGrp.vbs "28" "****" "D%3A%5Chyperion%5COracle%5CMiddleware%5Cuser_projects%5Cepmsystem1" "%25EPM_ORACLE_HOME%25%2F..%2Fjdk160_35" "ORAOLEDB.ORACLE"

            Microsoft (R) Windows Script Host Version 5.8

            Copyright (C) Microsoft Corporation. All rights reserved.

             

             

            2017-02-07 16:04:22,539 DEBUG [AIF]: Comm.executeVBScript - END

            2017-02-07 16:04:22,539 DEBUG [AIF]: Comm.executeScript - END

            2017-02-07 16:04:22,539 DEBUG [AIF]: LogicGroup.createLogicAccounts - END

            2017-02-07 16:04:22,581 DEBUG [AIF]: CommData.mapData - START

            2017-02-07 16:04:22,584 DEBUG [AIF]: CommData.insertTransProcessDetails - START

            2017-02-07 16:04:22,584 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, 'admin' 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 = 28

                        AND PRIOR_PERIOD_FLAG = 'N'

                        GROUP BY PROCESS_ID, TRANS_ENTITY_TYPE, TRANS_ENTITY_NAME

                      ) q

                      ORDER BY ENTITY_NAME_ORDER

                     

            2017-02-07 16:04:22,588 DEBUG [AIF]: CommData.insertTransProcessDetails - END

            2017-02-07 16:04:22,594 DEBUG [AIF]:

                    DELETE FROM TDATAMAP_T

                    WHERE LOADID < 28

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

                   

            2017-02-07 16:04:22,595 DEBUG [AIF]:

                    DELETE FROM TDATASEG_T

                    WHERE LOADID < 28

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

                   

            2017-02-07 16:04:22,597 DEBUG [AIF]:

                    DELETE FROM AIF_PROCESS_PERIODS

                    WHERE PROCESS_ID < 28

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

                   

            2017-02-07 16:04:22,604 DEBUG [AIF]: CommMap.loadTDATAMAP_T - START

            2017-02-07 16:04:22,607 DEBUG [AIF]: CommData.getMapPartitionKeyandName - START

            2017-02-07 16:04:22,607 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 = 1

                   

            2017-02-07 16:04:22,608 DEBUG [AIF]: CommData.getMapPartitionKeyandName - END

            2017-02-07 16:04:22,608 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 28, DATAKEY, 1 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 tdm

                    WHERE PARTITIONKEY = 1

                    AND ( RULE_ID IS NULL OR RULE_ID = 1 )

                    AND ( TDATAMAPTYPE = 'ERP'

                          OR

                          ( TDATAMAPTYPE = 'MULTIDIM'

                            AND EXISTS ( SELECT 1

                                         FROM TDATAMAP multidim

                                         WHERE multidim.PARTITIONKEY = tdm.PARTITIONKEY

                                         AND multidim.TDATAMAPTYPE = 'ERP'

                                         AND multidim.DATAKEY = tdm.TARGKEY )

                          )

                        )

                   

            2017-02-07 16:04:22,612 DEBUG [AIF]: Number of Rows inserted into TDATAMAP_T: 9

            2017-02-07 16:04:22,695 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - START

            2017-02-07 16:04:22,695 DEBUG [AIF]: Comm.executeScript - START

            2017-02-07 16:04:22,697 INFO  [AIF]: Executing the following script: D:\hyperion\FDMEE_folder\Custom/data/scripts/event/BefProcMap.py

            2017-02-07 16:04:22,700 DEBUG [AIF]: Comm.executeVBScript - START

            2017-02-07 16:04:22,701 INFO  [AIF]: Executing the following script: D:\hyperion\FDMEE_folder\Custom\data\scripts\event\BefProcMap.vbs

            2017-02-07 16:04:22,703 DEBUG [AIF]: The command to be executed is:

            cscript D:\hyperion\FDMEE_folder\Custom\data\scripts\event\BefProcMap.vbs "28" "****" "D%3A%5Chyperion%5COracle%5CMiddleware%5Cuser_projects%5Cepmsystem1" "%25EPM_ORACLE_HOME%25%2F..%2Fjdk160_35" "ORAOLEDB.ORACLE"

            Microsoft (R) Windows Script Host Version 5.8

            Copyright (C) Microsoft Corporation. All rights reserved.

             

             

            2017-02-07 16:04:22,990 DEBUG [AIF]: Comm.executeVBScript - END

            2017-02-07 16:04:22,990 DEBUG [AIF]: Comm.executeScript - END

            2017-02-07 16:04:22,991 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 = 28

                    AND atad.APPLICATION_ID = 4

                    AND tdm.PARTITIONKEY = 1

                    AND tdm.TDATAMAPTYPE = 'ERP'

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

                    AND tdm.WHERECLAUSETYPE IS NULL

                    UNION ALL

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

                          ,CASE tpp.PARTSEQMAP

                             WHEN 0 THEN 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     

                             ELSE tdm.SEQUENCE

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

                    AND atad.APPLICATION_ID = 4

                    AND tdm.PARTITIONKEY = 1

                    AND tdm.TDATAMAPTYPE = 'ERP'

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

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

                  ) q

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

                 

            2017-02-07 16:04:23,000 INFO  [AIF]:

            Map Data for Period 'MAY16'

            2017-02-07 16:04:23,002 DEBUG [AIF]: Comm.updateProcessDetail - START

            2017-02-07 16:04:23,004 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 ('admin' IS NULL) THEN LAST_UPDATED_BY ELSE 'admin' END

                   ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

                WHERE PROCESS_ID = 28 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'MAY16'

               

            2017-02-07 16:04:23,008 DEBUG [AIF]: Comm.updateProcessDetail - END

            2017-02-07 16:04:23,011 DEBUG [AIF]:

                  SELECT COUNT(*) ROW_COUNT

                  FROM TDATASEG_T

                  WHERE LOADID = 28

                  AND (PARTITIONKEY = 1 AND CATKEY = 4 AND PERIODKEY = '2016-05-31' AND RULE_ID = 1 AND VALID_FLAG = 'Y')

                 

            2017-02-07 16:04:23,013 INFO  [AIF]:

            Processing Mappings for Column 'ACCOUNT'

            2017-02-07 16:04:23,013 DEBUG [AIF]:

                          UPDATE TDATASEG_T

                          SET ACCOUNTX = ACCOUNT

                             ,ACCOUNTR = 1

                             ,ACCOUNTF = 3

                          WHERE LOADID = 28

                          AND PARTITIONKEY = 1

                          AND CATKEY = 4

                          AND (ACCOUNTX IS NULL OR ACCOUNTX = '')

                          AND (1=1)

                          AND PERIODKEY = '2016-05-31'

            2017-02-07 16:04:23,014 INFO  [AIF]: Data Rows Updated by Rule Mapping 'Acc' (LIKE): 1

            2017-02-07 16:04:23,014 INFO  [AIF]:

            Processing Mappings for Column 'ENTITY'

            2017-02-07 16:04:23,015 DEBUG [AIF]:

                          UPDATE TDATASEG_T

                          SET ENTITYX = ENTITY

                             ,ENTITYR = 3

                             ,ENTITYF = 3

                          WHERE LOADID = 28

                          AND PARTITIONKEY = 1

                          AND CATKEY = 4

                          AND (ENTITYX IS NULL OR ENTITYX = '')

                          AND (1=1)

                          AND PERIODKEY = '2016-05-31'

            2017-02-07 16:04:23,016 INFO  [AIF]: Data Rows Updated by Rule Mapping 'Ent' (LIKE): 1

            2017-02-07 16:04:23,016 INFO  [AIF]:

            Processing Mappings for Column 'ICP'

            2017-02-07 16:04:23,016 DEBUG [AIF]:

                          UPDATE TDATASEG_T

                          SET ICPX = ICP

                             ,ICPR = 21

                             ,ICPF = 3

                          WHERE LOADID = 28

                          AND PARTITIONKEY = 1

                          AND CATKEY = 4

                          AND (ICPX IS NULL OR ICPX = '')

                          AND (1=1)

                          AND PERIODKEY = '2016-05-31'

            2017-02-07 16:04:23,017 INFO  [AIF]: Data Rows Updated by Rule Mapping 'ICP' (LIKE): 1

            2017-02-07 16:04:23,018 INFO  [AIF]:

            Processing Mappings for Column 'UD1'

            2017-02-07 16:04:23,018 DEBUG [AIF]:

                          UPDATE TDATASEG_T

                          SET UD1X = UD1

                             ,UD1R = 4

                             ,UD1F = 3

                          WHERE LOADID = 28

                          AND PARTITIONKEY = 1

                          AND CATKEY = 4

                          AND (UD1X IS NULL OR UD1X = '')

                          AND (1=1)

                          AND PERIODKEY = '2016-05-31'

            2017-02-07 16:04:23,019 INFO  [AIF]: Data Rows Updated by Rule Mapping 'LOB' (LIKE): 1

            2017-02-07 16:04:23,019 INFO  [AIF]:

            Processing Mappings for Column 'UD2'

            2017-02-07 16:04:23,019 DEBUG [AIF]:

                          UPDATE TDATASEG_T

                          SET UD2X = UD2

                             ,UD2R = 22

                             ,UD2F = 3

                          WHERE LOADID = 28

                          AND PARTITIONKEY = 1

                          AND CATKEY = 4

                          AND (UD2X IS NULL OR UD2X = '')

                          AND (1=1)

                          AND PERIODKEY = '2016-05-31'

            2017-02-07 16:04:23,021 INFO  [AIF]: Data Rows Updated by Rule Mapping 'PC' (LIKE): 1

            2017-02-07 16:04:23,021 INFO  [AIF]:

            Processing Mappings for Column 'UD3'

            2017-02-07 16:04:23,021 DEBUG [AIF]:

                          UPDATE TDATASEG_T

                          SET UD3X = UD3

                             ,UD3R = 2

                             ,UD3F = 3

                          WHERE LOADID = 28

                          AND PARTITIONKEY = 1

                          AND CATKEY = 4

                          AND (UD3X IS NULL OR UD3X = '')

                          AND (1=1)

                          AND PERIODKEY = '2016-05-31'

            2017-02-07 16:04:23,022 INFO  [AIF]: Data Rows Updated by Rule Mapping 'CC' (LIKE): 1

            2017-02-07 16:04:23,022 INFO  [AIF]:

            Processing Mappings for Column 'UD4'

            2017-02-07 16:04:23,023 DEBUG [AIF]:

                          UPDATE TDATASEG_T

                          SET UD4X = UD4

                             ,UD4R = 7

                             ,UD4F = 3

                          WHERE LOADID = 28

                          AND PARTITIONKEY = 1

                          AND CATKEY = 4

                          AND (UD4X IS NULL OR UD4X = '')

                          AND (1=1)

                          AND PERIODKEY = '2016-05-31'

            2017-02-07 16:04:23,024 INFO  [AIF]: Data Rows Updated by Rule Mapping 'SA' (LIKE): 1

            2017-02-07 16:04:23,024 INFO  [AIF]:

            Processing Mappings for Column 'UD5'

            2017-02-07 16:04:23,024 DEBUG [AIF]:

                          UPDATE TDATASEG_T

                          SET UD5X = UD5

                             ,UD5R = 6

                             ,UD5F = 3

                          WHERE LOADID = 28

                          AND PARTITIONKEY = 1

                          AND CATKEY = 4

                          AND (UD5X IS NULL OR UD5X = '')

                          AND (1=1)

                          AND PERIODKEY = '2016-05-31'

            2017-02-07 16:04:23,025 INFO  [AIF]: Data Rows Updated by Rule Mapping 'Rpt' (LIKE): 1

            2017-02-07 16:04:23,026 INFO  [AIF]:

            Processing Mappings for Column 'UD6'

            2017-02-07 16:04:23,026 DEBUG [AIF]:

                          UPDATE TDATASEG_T

                          SET UD6X = UD6

                             ,UD6R = 5

                             ,UD6F = 3

                          WHERE LOADID = 28

                          AND PARTITIONKEY = 1

                          AND CATKEY = 4

                          AND (UD6X IS NULL OR UD6X = '')

                          AND (1=1)

                          AND PERIODKEY = '2016-05-31'

            2017-02-07 16:04:23,027 INFO  [AIF]: Data Rows Updated by Rule Mapping 'MVT' (LIKE): 1

            2017-02-07 16:04:23,029 DEBUG [AIF]: Comm.updateProcessDetail - START

            2017-02-07 16:04:23,030 DEBUG [AIF]:

                UPDATE AIF_PROCESS_DETAILS

                SET STATUS = 'SUCCESS'

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

                   ,EXECUTION_END_TIME = CURRENT_TIMESTAMP

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

                   ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

                WHERE PROCESS_ID = 28 AND ENTITY_TYPE = 'PROCESS_BAL_TRANS' AND ENTITY_NAME = 'MAY16'

               

            2017-02-07 16:04:23,033 DEBUG [AIF]: Comm.updateProcessDetail - END

            2017-02-07 16:04:23,033 DEBUG [AIF]: CommMap.updateTDATASEG_T_TDATASEGW - END

            2017-02-07 16:04:23,035 DEBUG [AIF]:

                  UPDATE TDATASEG_T

                  SET ATTR14 = DATAKEY

                  WHERE LOADID = 28 AND PARTITIONKEY = 1 AND CATKEY = 4 AND PERIODKEY = '2016-05-31'

                 

            2017-02-07 16:04:23,059 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - START

            2017-02-07 16:04:23,059 INFO  [AIF]:

            Stage Data for Period 'MAY16'

            2017-02-07 16:04:23,059 DEBUG [AIF]:

                    DELETE FROM TDATAMAPSEG

                    WHERE PARTITIONKEY = 1

                    AND CATKEY = 4

                    AND PERIODKEY = '2016-05-31'

                    AND ( TDATAMAPTYPE = 'ERP'

                          OR

                          ( TDATAMAPTYPE = 'MULTIDIM'

                            AND EXISTS ( SELECT 1

                                         FROM TDATAMAPSEG parent

                                         WHERE parent.PARTITIONKEY = TDATAMAPSEG.PARTITIONKEY

                                         AND parent.DATAKEY = TDATAMAPSEG.TARGKEY

                                         AND parent.CATKEY = TDATAMAPSEG.CATKEY

                                         AND parent.PERIODKEY = TDATAMAPSEG.PERIODKEY

                                         AND parent.TDATAMAPTYPE = 'ERP' )

                          )

                        )

                   

            2017-02-07 16:04:23,061 INFO  [AIF]: Number of Rows deleted from TDATAMAPSEG: 9

            2017-02-07 16:04:23,061 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, 4, '2016-05-31', DIMNAME, SRCKEY, SRCDESC, TARGKEY, WHERECLAUSETYPE,

                           WHERECLAUSEVALUE, CHANGESIGN, SEQUENCE, VBSCRIPT, TDATAMAPTYPE, SYSTEM_GENERATED_FLAG

                    FROM TDATAMAP_T

                    WHERE LOADID = 28

                   

            2017-02-07 16:04:23,064 INFO  [AIF]: Number of Rows inserted into TDATAMAPSEG: 9

            2017-02-07 16:04:23,064 DEBUG [AIF]:

                    DELETE FROM TDATAMAP_T

                    WHERE LOADID = 28

                   

            2017-02-07 16:04:23,066 INFO  [AIF]: Number of Rows deleted from TDATAMAP_T: 9

            2017-02-07 16:04:23,066 DEBUG [AIF]:

                        DELETE FROM TDATASEG

                        WHERE LOADID < 28 AND PARTITIONKEY = 1 AND CATKEY = 4 AND RULE_ID = 1 AND PERIODKEY = '2016-05-31'

                       

            2017-02-07 16:04:23,067 INFO  [AIF]: Number of Rows deleted from TDATASEG: 1

            2017-02-07 16:04:23,068 DEBUG [AIF]:

                        DELETE FROM TDATAMEMOITEMS

                        WHERE PARTITIONKEY = 1 AND PERIODKEY = '2016-05-31' AND CATKEY = 4 AND RULE_ID = 1

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

                       

            2017-02-07 16:04:23,069 INFO  [AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0

            2017-02-07 16:04:23,069 DEBUG [AIF]:

                        DELETE FROM TDATAARCHIVE

                        WHERE PARTITIONKEY = 1 AND PERIODKEY = '2016-05-31' AND CATKEY = 4 AND RULE_ID = 1

                        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 )

                       

            2017-02-07 16:04:23,070 INFO  [AIF]: Number of Rows deleted from TDATAARCHIVE: 0

            2017-02-07 16:04:23,071 DEBUG [AIF]:

                      INSERT INTO TDATASEG (

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

                        ,AMOUNT, AMOUNTX, AMOUNT_PTD, AMOUNT_YTD, 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, 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 = 28 AND PARTITIONKEY = 1 AND CATKEY = 4 AND PERIODKEY = '2016-05-31'

                     

            2017-02-07 16:04:23,072 INFO  [AIF]: Number of Rows inserted into TDATASEG: 1

            2017-02-07 16:04:23,072 DEBUG [AIF]:

                    DELETE FROM TDATASEG_T

                    WHERE LOADID = 28 AND PARTITIONKEY = 1 AND CATKEY = 4 AND PERIODKEY = '2016-05-31'

                   

            2017-02-07 16:04:23,074 INFO  [AIF]: Number of Rows deleted from TDATASEG_T: 1

            2017-02-07 16:04:23,086 DEBUG [AIF]: CommData.updateWorkflow - START

            2017-02-07 16:04:23,087 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=1 AND CATKEY=4 AND PERIODKEY='2016-05-31' AND RULE_ID=1

                   

            2017-02-07 16:04:23,090 DEBUG [AIF]: CommData.updateWorkflow - END

            2017-02-07 16:04:23,091 DEBUG [AIF]: CommMap.loadTDATAMAPSEG_TDATASEG - END

            2017-02-07 16:04:23,091 DEBUG [AIF]: Comm.executeScript - START

            2017-02-07 16:04:23,092 INFO  [AIF]: Executing the following script: D:\hyperion\FDMEE_folder\Custom/data/scripts/event/AftProcMap.py

            2017-02-07 16:04:23,095 DEBUG [AIF]: Comm.executeVBScript - START

            2017-02-07 16:04:23,096 INFO  [AIF]: Executing the following script: D:\hyperion\FDMEE_folder\Custom\data\scripts\event\AftProcMap.vbs

            2017-02-07 16:04:23,097 DEBUG [AIF]: The command to be executed is:

            cscript D:\hyperion\FDMEE_folder\Custom\data\scripts\event\AftProcMap.vbs "28" "****" "D%3A%5Chyperion%5COracle%5CMiddleware%5Cuser_projects%5Cepmsystem1" "%25EPM_ORACLE_HOME%25%2F..%2Fjdk160_35" "ORAOLEDB.ORACLE"

            Microsoft (R) Windows Script Host Version 5.8

            Copyright (C) Microsoft Corporation. All rights reserved.

             

             

            2017-02-07 16:04:23,388 DEBUG [AIF]: Comm.executeVBScript - END

            2017-02-07 16:04:23,388 DEBUG [AIF]: Comm.executeScript - END

            2017-02-07 16:04:23,388 DEBUG [AIF]: CommData.mapData - END

            2017-02-07 16:04:23,425 INFO  [AIF]: -------END IMPORT STEP-------

            2017-02-07 16:04:23,460 INFO  [AIF]: -------START VALIDATE STEP-------

            2017-02-07 16:04:23,507 DEBUG [AIF]: CommData.validateData - START

            2017-02-07 16:04:23,507 DEBUG [AIF]: Comm.executeScript - START

            2017-02-07 16:04:23,508 INFO  [AIF]: Executing the following script: D:\hyperion\FDMEE_folder\Custom/data/scripts/event/BefValidate.py

            2017-02-07 16:04:23,511 DEBUG [AIF]: Comm.executeVBScript - START

            2017-02-07 16:04:23,512 INFO  [AIF]: Executing the following script: D:\hyperion\FDMEE_folder\Custom\data\scripts\event\BefValidate.vbs

            2017-02-07 16:04:23,514 DEBUG [AIF]: The command to be executed is:

            cscript D:\hyperion\FDMEE_folder\Custom\data\scripts\event\BefValidate.vbs "28" "****" "D%3A%5Chyperion%5COracle%5CMiddleware%5Cuser_projects%5Cepmsystem1" "%25EPM_ORACLE_HOME%25%2F..%2Fjdk160_35" "ORAOLEDB.ORACLE"

            Microsoft (R) Windows Script Host Version 5.8

            Copyright (C) Microsoft Corporation. All rights reserved.

             

             

            2017-02-07 16:04:23,805 DEBUG [AIF]: Comm.executeVBScript - END

            2017-02-07 16:04:23,805 DEBUG [AIF]: Comm.executeScript - END

            2017-02-07 16:04:23,817 DEBUG [AIF]: CommMap.validateData - START

            2017-02-07 16:04:23,820 INFO  [AIF]:

            Validate Data Mappings for Period 'MAY16'

            2017-02-07 16:04:23,821 DEBUG [AIF]:

                  SELECT COUNT(*) ROW_COUNT

                  FROM TDATASEG

                  WHERE LOADID = 28

                  AND (PARTITIONKEY = 1 AND CATKEY = 4 AND PERIODKEY = '2016-05-31' AND RULE_ID = 1 AND VALID_FLAG = 'Y')

                 

            2017-02-07 16:04:23,822 DEBUG [AIF]: CommData.updateWorkflow - START

            2017-02-07 16:04:23,822 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 = 1 AND tlp.CATKEY = 4 AND tlp.PERIODKEY = '2016-05-31' AND tlp.RULE_ID = 1 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

               

            2017-02-07 16:04:23,824 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=1 AND CATKEY=4 AND PERIODKEY='2016-05-31' AND RULE_ID=1

                   

            2017-02-07 16:04:23,827 DEBUG [AIF]: CommData.updateWorkflow - END

            2017-02-07 16:04:23,827 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.UD1X IS NULL OR TDATASEG.UD1X = '')

                                  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 = '')

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

                                )

                            AND LOADID = 28 AND PARTITIONKEY = 1 AND CATKEY = 4 AND PERIODKEY = '2016-05-31'

                            AND VALID_FLAG = 'Y'

                            AND CALCACCTTYPE > 0

                           

            2017-02-07 16:04:23,829 DEBUG [AIF]: CommData.updateWorkflow - START

            2017-02-07 16:04:23,829 DEBUG [AIF]:

                    UPDATE TLOGPROCESS

                    SET PROCESSENDTIME=CURRENT_TIMESTAMP

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

                       ,PROCESSVALNOTE='AIF_WF_VAL_VALIDATE_OK_TXT'

                    WHERE PARTITIONKEY=1 AND CATKEY=4 AND PERIODKEY='2016-05-31' AND RULE_ID=1

                   

            2017-02-07 16:04:23,832 DEBUG [AIF]: CommData.updateWorkflow - END

            2017-02-07 16:04:23,832 INFO  [AIF]: Total Data Rows available for Export to Target: 1

            2017-02-07 16:04:23,833 DEBUG [AIF]: CommMap.validateData - END

            2017-02-07 16:04:23,834 INFO  [AIF]:

            Validate Data Members for Period 'MAY16'

            2017-02-07 16:04:23,834 DEBUG [AIF]:

                  SELECT COUNT(*) ROW_COUNT

                  FROM TDATASEG

                  WHERE LOADID = 28

                  AND (PARTITIONKEY = 1 AND CATKEY = 4 AND PERIODKEY = '2016-05-31' AND RULE_ID = 1 AND VALID_FLAG = 'Y')

                 

            2017-02-07 16:04:23,835 INFO  [AIF]: Total Data Rows available for Export to Target: 1

            2017-02-07 16:04:23,835 DEBUG [AIF]: Comm.executeScript - START

            2017-02-07 16:04:23,836 INFO  [AIF]: Executing the following script: D:\hyperion\FDMEE_folder\Custom/data/scripts/event/AftValidate.py

            2017-02-07 16:04:23,840 DEBUG [AIF]: Comm.executeVBScript - START

            2017-02-07 16:04:23,840 INFO  [AIF]: Executing the following script: D:\hyperion\FDMEE_folder\Custom\data\scripts\event\AftValidate.vbs

            2017-02-07 16:04:23,842 DEBUG [AIF]: The command to be executed is:

            cscript D:\hyperion\FDMEE_folder\Custom\data\scripts\event\AftValidate.vbs "28" "****" "D%3A%5Chyperion%5COracle%5CMiddleware%5Cuser_projects%5Cepmsystem1" "%25EPM_ORACLE_HOME%25%2F..%2Fjdk160_35" "ORAOLEDB.ORACLE"

            Microsoft (R) Windows Script Host Version 5.8

            Copyright (C) Microsoft Corporation. All rights reserved.

             

             

            2017-02-07 16:04:24,132 DEBUG [AIF]: Comm.executeVBScript - END

            2017-02-07 16:04:24,132 DEBUG [AIF]: Comm.executeScript - END

            2017-02-07 16:04:24,132 DEBUG [AIF]: CommData.validateData - END

            2017-02-07 16:04:24,169 INFO  [AIF]: -------END VALIDATE STEP-------

            2017-02-07 16:04:24,267 INFO  [AIF]: -------START EXPORT STEP-------

            2017-02-07 16:04:24,317 DEBUG [AIF]: CommData.exportData - START

            2017-02-07 16:04:24,317 DEBUG [AIF]: Comm.executeScript - START

            2017-02-07 16:04:24,318 INFO  [AIF]: Executing the following script: D:\hyperion\FDMEE_folder\Custom/data/scripts/event/BefExportToDat.py

            2017-02-07 16:04:24,321 DEBUG [AIF]: Comm.executeVBScript - START

            2017-02-07 16:04:24,322 INFO  [AIF]: Executing the following script: D:\hyperion\FDMEE_folder\Custom\data\scripts\event\BefExportToDat.vbs

            2017-02-07 16:04:24,324 DEBUG [AIF]: The command to be executed is:

            cscript D:\hyperion\FDMEE_folder\Custom\data\scripts\event\BefExportToDat.vbs "28" "****" "D%3A%5Chyperion%5COracle%5CMiddleware%5Cuser_projects%5Cepmsystem1" "%25EPM_ORACLE_HOME%25%2F..%2Fjdk160_35" "ORAOLEDB.ORACLE"

            Microsoft (R) Windows Script Host Version 5.8

            Copyright (C) Microsoft Corporation. All rights reserved.

             

             

            2017-02-07 16:04:24,614 DEBUG [AIF]: Comm.executeVBScript - END

            2017-02-07 16:04:24,614 DEBUG [AIF]: Comm.executeScript - END

            2017-02-07 16:04:24,616 DEBUG [AIF]: CommData.updateWorkflow - START

            2017-02-07 16:04:24,616 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 = 1 AND tlp.CATKEY = 4 AND tlp.PERIODKEY = '2016-05-31' AND tlp.RULE_ID = 1 AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

               

            2017-02-07 16:04:24,617 DEBUG [AIF]:

                    UPDATE TLOGPROCESS

                    SET PROCESSENDTIME=CURRENT_TIMESTAMP

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

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

                    WHERE PARTITIONKEY=1 AND CATKEY=4 AND PERIODKEY='2016-05-31' AND RULE_ID=1

                   

            2017-02-07 16:04:24,621 DEBUG [AIF]: CommData.updateWorkflow - END

            2017-02-07 16:04:24,624 DEBUG [AIF]: CommData.purgeInvalidRecordsTDATASEG - START

            2017-02-07 16:04:24,627 DEBUG [AIF]:

                    DELETE FROM TDATASEG

                    WHERE LOADID = 28

                   

                      AND (

                       

                    PARTITIONKEY = 1

                    AND CATKEY = 4

                    AND PERIODKEY = '2016-05-31'

                    AND RULE_ID = 1

                    AND VALID_FLAG = 'N'

                   

                      )

            2017-02-07 16:04:24,628 DEBUG [AIF]: Number of Rows deleted from TDATASEG: 0

            2017-02-07 16:04:24,628 DEBUG [AIF]: CommData.purgeInvalidRecordsTDATASEG - END

            2017-02-07 16:04:24,643 DEBUG [AIF]: CommData.exportCustomAppData - START

            2017-02-07 16:04:24,645 DEBUG [AIF]: Comm.createProcessDetail - START

            2017-02-07 16:04:24,648 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

                ) VALUES (

                  28, 'PROCESS_BAL_EXP_CUSTOM', NULL, 'Custom_aps', NULL, NULL, CURRENT_TIMESTAMP

                 ,NULL, NULL, 'RUNNING', 'admin', CURRENT_TIMESTAMP )

               

            2017-02-07 16:04:24,651 DEBUG [AIF]: Comm.createProcessDetail - END

            2017-02-07 16:04:24,653 DEBUG [AIF]: SELECT parameter_value FROM aif_bal_rule_load_params WHERE loadid = 28 and parameter_name = 'COLUMN_DELIMITER'

            2017-02-07 16:04:24,655 DEBUG [AIF]: SELECT parameter_value FROM aif_bal_rule_load_params WHERE loadid = 28 and parameter_name = 'FILE_CHARSET_ENCODING'

            2017-02-07 16:04:24,656 DEBUG [AIF]: SELECT parameter_value FROM aif_bal_rule_load_params WHERE loadid = 28 and parameter_name = 'ENABLE_EXPORT_TO_FILE'

            2017-02-07 16:04:24,657 DEBUG [AIF]: Load options: columnDelimiter=,, fileCharsetEncoding=WINDOWS-1250, enableExportToFile=1

            2017-02-07 16:04:24,657 DEBUG [AIF]:

                  SELECT dim.TARGET_DIMENSION_NAME

                  ,CASE dim.TARGET_DIMENSION_CLASS_NAME

                    WHEN 'Scenario' THEN 'SCENARIO'

                    WHEN 'Year' THEN 'YEAR'

                    WHEN 'Period' THEN 'PERIOD'

                    WHEN 'Currency' THEN 'CURRENCY'

                    ELSE adim.BALANCE_COLUMN_NAME

                    END BALANCE_COLUMN_NAME

                  ,dim.TARGET_DIMENSION_CLASS_NAME

                  FROM AIF_TARGET_APPLICATIONS app

                  ,AIF_TARGET_APPL_DIMENSIONS adim

                  ,AIF_DIMENSIONS dim

                  ,AIF_BAL_RULE_LOADS brl

                  WHERE app.TARGET_APPLICATION_NAME = 'Custom_aps'

                  AND adim.APPLICATION_ID = app.APPLICATION_ID

                  AND dim.DIMENSION_ID = adim.DIMENSION_ID

                  AND dim.TARGET_DIMENSION_CLASS_NAME IN (

                    SELECT lv.LOOKUP_CODE

                    FROM AIF_LOOKUP_TYPES lt

                    ,AIF_LOOKUP_VALUES lv

                    WHERE lt.LOOKUP_TYPE = 'AIF_APPL_DIM_CLASS'

                    AND lv.LOOKUP_TYPE_ID = lt.LOOKUP_TYPE_ID

                  )

                  AND brl.LOADID = 28

                  AND brl.APPLICATION_ID = app.APPLICATION_ID

                  ORDER BY CASE dim.TARGET_DIMENSION_CLASS_NAME

                                WHEN 'Scenario' THEN 'Z1'

                                WHEN 'Year' THEN 'Z2'

                                WHEN 'Period' THEN 'Z3'

                                WHEN 'Currency' THEN 'Z4'

                                ELSE adim.BALANCE_COLUMN_NAME END

                 

            2017-02-07 16:04:24,663 DEBUG [AIF]: Comm.updateProcessDetail - START

            2017-02-07 16:04:24,664 DEBUG [AIF]:

                UPDATE AIF_PROCESS_DETAILS

                SET STATUS = 'FAILED'

                   ,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 ('admin' IS NULL) THEN LAST_UPDATED_BY ELSE 'admin' END

                   ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

                WHERE PROCESS_ID = 28 AND ENTITY_TYPE = 'PROCESS_BAL_EXP_CUSTOM' AND ENTITY_NAME = 'Custom_aps'

               

            2017-02-07 16:04:24,667 DEBUG [AIF]: Comm.updateProcessDetail - END

            2017-02-07 16:04:24,669 FATAL [AIF]: Error in CommData.exportCustomAppData

            Traceback (most recent call last):

              File "<string>", line 3481, in exportCustomAppData

            TypeError: cannot concatenate 'unicode' and 'NoneType' objects

             

             

            2017-02-07 16:04:24,669 FATAL [AIF]: Error in CommData.exportData

            Traceback (most recent call last):

              File "<string>", line 4598, in exportData

              File "<string>", line 3481, in exportCustomAppData

            TypeError: cannot concatenate 'unicode' and 'NoneType' objects

             

             

            2017-02-07 16:04:24,669 DEBUG [AIF]: CommData.updateWorkflow - START

            2017-02-07 16:04:24,670 DEBUG [AIF]:

                    UPDATE TLOGPROCESS

                    SET PROCESSENDTIME=CURRENT_TIMESTAMP

                       ,PROCESSSTATUS=22,PROCESSEXP=0

                       ,PROCESSEXPNOTE='AIF_WF_EXP_EXPORT_ERR'

                    WHERE PARTITIONKEY=1 AND CATKEY=4 AND PERIODKEY='2016-05-31' AND RULE_ID=1

                   

            2017-02-07 16:04:24,673 DEBUG [AIF]: CommData.updateWorkflow - END

            2017-02-07 16:04:24,673 DEBUG [AIF]: Comm.executeScript - START

            2017-02-07 16:04:24,674 INFO  [AIF]: Executing the following script: D:\hyperion\FDMEE_folder\Custom/data/scripts/event/AftExportToDat.py

            2017-02-07 16:04:24,677 DEBUG [AIF]: Comm.executeVBScript - START

            2017-02-07 16:04:24,678 INFO  [AIF]: Executing the following script: D:\hyperion\FDMEE_folder\Custom\data\scripts\event\AftExportToDat.vbs

            2017-02-07 16:04:24,679 DEBUG [AIF]: The command to be executed is:

            cscript D:\hyperion\FDMEE_folder\Custom\data\scripts\event\AftExportToDat.vbs "28" "****" "D%3A%5Chyperion%5COracle%5CMiddleware%5Cuser_projects%5Cepmsystem1" "%25EPM_ORACLE_HOME%25%2F..%2Fjdk160_35" "ORAOLEDB.ORACLE"

            Microsoft (R) Windows Script Host Version 5.8

            Copyright (C) Microsoft Corporation. All rights reserved.

             

             

            2017-02-07 16:04:24,967 DEBUG [AIF]: Comm.executeVBScript - END

            2017-02-07 16:04:24,967 DEBUG [AIF]: Comm.executeScript - END

            2017-02-07 16:04:25,065 DEBUG [AIF]: Comm.finalizeProcess - START

            2017-02-07 16:04:25,066 DEBUG [AIF]: CommData.updateRuleStatus - START

            2017-02-07 16:04:25,067 DEBUG [AIF]:

                UPDATE AIF_BALANCE_RULES

                SET STATUS = CASE 'FAILED'

                  WHEN 'SUCCESS' THEN

                    CASE ( SELECT COUNT(*) FROM AIF_PROCESS_DETAILS pd WHERE pd.PROCESS_ID = 28 AND pd.STATUS IN ('FAILED','WARNING') )

                      WHEN 0 THEN 'SUCCESS'

                      ELSE ( SELECT MIN(pd.STATUS) FROM AIF_PROCESS_DETAILS pd WHERE pd.PROCESS_ID = 28 AND pd.STATUS IN ('FAILED','WARNING') ) END

                  ELSE 'FAILED' END

                WHERE RULE_ID = 1

               

            2017-02-07 16:04:25,070 DEBUG [AIF]: CommData.updateRuleStatus - END

            2017-02-07 16:04:25,071 FATAL [AIF]: Error in COMM Export Data

            2017-02-07 16:04:25,072 DEBUG [AIF]: Comm.updateProcess - START

            2017-02-07 16:04:25,077 DEBUG [AIF]: Comm.updateProcess - END

            2017-02-07 16:04:25,079 DEBUG [AIF]: The fdmAPI connection has been closed.

            2017-02-07 16:04:25,080 INFO  [AIF]: FDMEE Process End, Process ID: 28

            • 3. Re: TypeError: cannot concatenate 'unicode' and 'NoneType' objects
              Nishant Fukate

              Hello Expert,

               

              Please see the log updated above.

               

              Thanks

              Nishant

              • 4. Re: TypeError: cannot concatenate 'unicode' and 'NoneType' objects
                3389781

                Hello,

                 

                I am having the same issue. I'm reading from a csv file and my target is a Custom Application. The Import and Validation Steps complete successfully but once started to export that error appears:

                 

                2017-03-03 07:54:41,558 INFO  [AIF]: Total Data Rows available for Export to Target: 2606

                2017-03-03 07:54:41,609 INFO  [AIF]: -------END VALIDATE STEP-------

                2017-03-03 07:54:41,750 INFO  [AIF]: -------START EXPORT STEP-------

                2017-03-03 07:54:42,110 FATAL [AIF]: Error in CommData.exportCustomAppData

                Traceback (most recent call last):

                  File "<string>", line 3509, in exportCustomAppData

                TypeError: cannot concatenate 'unicode' and 'NoneType' objects

                 

                 

                2017-03-03 07:54:42,110 FATAL [AIF]: Error in CommData.exportData

                Traceback (most recent call last):

                  File "<string>", line 4621, in exportData

                  File "<string>", line 3509, in exportCustomAppData

                TypeError: cannot concatenate 'unicode' and 'NoneType' objects

                 

                 

                2017-03-03 07:54:42,378 FATAL [AIF]: Error in COMM Export Data

                2017-03-03 07:54:42,387 INFO  [AIF]: FDMEE Process End, Process ID: 729

                 

                Really appreciate your help!

                • 5. Re: TypeError: cannot concatenate 'unicode' and 'NoneType' objects
                  3390309

                  Hi Experts,

                   

                  Im also facing this issue. we are have integration with EBS. Pls tell me what might be the issue.

                   

                  Thanks

                   

                  Regards,

                   

                  Mike