Forum Stats

  • 3,874,295 Users
  • 2,266,718 Discussions
  • 7,911,804 Comments

Discussions

what is the error in below DM log file and how to overcome this

User_73UZC
User_73UZC Member Posts: 2 Green Ribbon

2022-03-28 19:39:48,788 INFO [AIF]: FDMEE Process: 761, Log Level: 4

2022-03-28 19:39:48,789 INFO [AIF]: Location   : xxxxx (Partitionkey:15)

2022-03-28 19:39:48,789 INFO [AIF]: Period Name : Jan-21 (Period Key:1/31/21 12:00 AM)

2022-03-28 19:39:48,789 INFO [AIF]: Category Name: xxxxxx (Category key:25)

2022-03-28 19:39:48,789 INFO [AIF]: Rule Name  : xxxxxxxxx(Rule ID:64)

2022-03-28 19:40:03,324 INFO [AIF]: Log File Encoding: UTF-8

2022-03-28 19:40:04,155 INFO [AIF]: -------START IMPORT STEP-------

2022-03-28 19:40:04,379 INFO [AIF]: Executing the following script: BefExtract.py

2022-03-28 19:40:04,467 INFO [AIF]: No business rules found for load id:761

2022-03-28 19:40:04,658 INFO [AIF]: File Name: Earned_Premium_Source_202101_20220302155752.csv

2022-03-28 19:40:04,745 INFO [AIF]: Executing the following script: BefImport.py

2022-03-28 19:40:04,871 INFO [AIF]: No business rules found for load id:761

2022-03-28 19:40:05,054 INFO [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:IMPGROUPFILETYPE::761;15:25:64:[NONE]::DELIMITED

2022-03-28 19:40:05,055 INFO [AIF]: EPMFDM-140274:Message - Method - getUser

2022-03-28 19:40:05,057 INFO [AIF]: EPMFDM-140274:Message - Method - getUser

2022-03-28 19:40:05,058 INFO [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8

2022-03-28 19:40:05,058 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - Start

2022-03-28 19:40:05,074 INFO [AIF]: EPMFDM-140274:Message - Is source application sub type FCCS/TRCS :false

2022-03-28 19:40:05,076 INFO [AIF]: EPMFDM-140274:Message - Checking MDX execution with parameters Source Application Type:null , Source Application Sub Type:null , Source App Data Load Method:null

2022-03-28 19:40:05,076 INFO [AIF]: EPMFDM-140274:Message - Is data load MDX File Import :false

2022-03-28 19:40:05,122 INFO [AIF]: EPMFDM-140274:Message - Initialize error maps

2022-03-28 19:40:05,122 INFO [AIF]: EPMFDM-140274:Message - File Name Earned_Premium_Source_202101_20220302155752.csv

periodKey2021-01-31

GL PeriodName0

2022-03-28 19:40:05,139 INFO [AIF]: EPMFDM-140274:Message - PROCESS ID: 761

 PARTITIONKEY: 15

 IMPORT GROUP: xxxxxx

 FILE TYPE: DELIMITED 

DELIMITER: ,

SOURCE FILE: xxxxxx2.csv

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.

2022-03-28 19:39:48,788 INFO [AIF]: FDMEE Process: 761, Log Level: 4

2022-03-28 19:39:48,789 INFO [AIF]: Location   : EP_WP_CI (Partitionkey:15)

2022-03-28 19:39:48,789 INFO [AIF]: Period Name : Jan-21 (Period Key:1/31/21 12:00 AM)

2022-03-28 19:39:48,789 INFO [AIF]: Category Name: PENP_Load (Category key:25)

2022-03-28 19:39:48,789 INFO [AIF]: Rule Name  : Earned_Premium (Rule ID:64)

2022-03-28 19:40:03,324 INFO [AIF]: Log File Encoding: UTF-8

2022-03-28 19:40:04,155 INFO [AIF]: -------START IMPORT STEP-------

2022-03-28 19:40:04,379 INFO [AIF]: Executing the following script: BefExtract.py

2022-03-28 19:40:04,467 INFO [AIF]: No business rules found for load id:761

2022-03-28 19:40:04,658 INFO [AIF]: File Name: Earned_Premium_Source_202101_20220302155752.csv

2022-03-28 19:40:04,745 INFO [AIF]: Executing the following script: BefImport.py

2022-03-28 19:40:04,871 INFO [AIF]: No business rules found for load id:761

2022-03-28 19:40:05,054 INFO [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:IMPGROUPFILETYPE::761;15:25:64:[NONE]::DELIMITED

2022-03-28 19:40:05,055 INFO [AIF]: EPMFDM-140274:Message - Method - getUser

2022-03-28 19:40:05,057 INFO [AIF]: EPMFDM-140274:Message - Method - getUser

2022-03-28 19:40:05,058 INFO [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8

2022-03-28 19:40:05,058 INFO [AIF]: EPMFDM-140274:Message - ImportTextData - Start

2022-03-28 19:40:05,074 INFO [AIF]: EPMFDM-140274:Message - Is source application sub type FCCS/TRCS :false

2022-03-28 19:40:05,076 INFO [AIF]: EPMFDM-140274:Message - Checking MDX execution with parameters Source Application Type:null , Source Application Sub Type:null , Source App Data Load Method:null

2022-03-28 19:40:05,076 INFO [AIF]: EPMFDM-140274:Message - Is data load MDX File Import :false

2022-03-28 19:40:05,122 INFO [AIF]: EPMFDM-140274:Message - Initialize error maps

2022-03-28 19:40:05,122 INFO [AIF]: EPMFDM-140274:Message - File Name Earned_Premium_Source_202101_20220302155752.csv

periodKey2021-01-31

GL PeriodName0

2022-03-28 19:40:05,139 INFO [AIF]: EPMFDM-140274:Message - PROCESS ID: 761

 PARTITIONKEY: 15

 IMPORT GROUP: EP_WP_CI

 FILE TYPE: DELIMITED 

DELIMITER: ,

SOURCE FILE: Earned_Premium_Source_202101_20220302155752.csv

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.

Stage Data for Period 'Jan-21'

2022-03-28 19:40:05,539 INFO [AIF]: Number of Rows deleted from TDATAMAPSEG: 19

2022-03-28 19:40:05,546 INFO [AIF]: Number of Rows inserted into TDATAMAPSEG: 19

2022-03-28 19:40:05,549 INFO [AIF]: Number of Rows deleted from TDATAMAP_T: 19

2022-03-28 19:40:05,551 INFO [AIF]: Executing delete statement:

2022-03-28 19:40:05,569 INFO [AIF]: Successfully executed delete statement

2022-03-28 19:40:05,569 INFO [AIF]: Number of Rows deleted from TDATASEG: 16

2022-03-28 19:40:05,574 INFO [AIF]: Number of Rows deleted from TDATAMEMOITEMS: 0

2022-03-28 19:40:05,582 INFO [AIF]: Number of Rows deleted from TDATAARCHIVE: 0

2022-03-28 19:40:05,583 INFO [AIF]: Executing insert statement:

2022-03-28 19:40:05,628 INFO [AIF]: Successfully executed insert statement

2022-03-28 19:40:05,628 INFO [AIF]: Number of Rows inserted into TDATASEG: 16

2022-03-28 19:40:05,629 INFO [AIF]: Executing delete statement:

2022-03-28 19:40:05,635 INFO [AIF]: Successfully executed delete statement

2022-03-28 19:40:05,635 INFO [AIF]: Number of Rows deleted from TDATASEG_T: 16

2022-03-28 19:40:05,666 INFO [AIF]: -------END IMPORT STEP-------

2022-03-28 19:40:05,686 INFO [AIF]: -------START VALIDATE STEP-------

2022-03-28 19:40:05,711 INFO [AIF]: 

Validate Data Mappings for Period 'Jan-21'

2022-03-28 19:40:05,723 INFO [AIF]: 

Validate Data Members for Period 'Jan-21'

2022-03-28 19:40:05,724 INFO [AIF]: Number of Valid Data Rows: 16

2022-03-28 19:40:05,744 INFO [AIF]: -------END VALIDATE STEP-------

2022-03-28 19:40:05,780 INFO [AIF]: -------START EXPORT STEP-------

2022-03-28 19:40:05,916 INFO [AIF]: EssbaseService.exportData - START

2022-03-28 19:40:13,244 INFO [AIF]: Creating data file: xxxxxxxx_761.dat

2022-03-28 19:40:13,332 INFO [AIF]: Data file creation completed: 8

2022-03-28 19:40:13,444 INFO [AIF]: Saved rule file to essbase server

2022-03-28 19:40:13,485 INFO [AIF]: EssbaseService.exportData - END (true)

2022-03-28 19:40:13,548 INFO [AIF]: Executing the following script: BefLoad.py

2022-03-28 19:40:13,634 INFO [AIF]: No business rules found for load id:761

2022-03-28 19:40:13,667 INFO [AIF]: EssbaseService.loadData - START

2022-03-28 19:40:13,824 INFO [AIF]: Starting executeDataRuleFile...

2022-03-28 19:40:13,869 INFO [AIF]: Getting load buffer for ASO data load...

2022-03-28 19:40:13,893 INFO [AIF]: Initializing load buffer [1]

2022-03-28 19:40:13,915 INFO [AIF]: Successfully initialized the load buffer

2022-03-28 19:40:13,915 INFO [AIF]: Building and executing replace data script...

2022-03-28 19:40:13,915 INFO [AIF]: EssbaseRuleFile.getReplaceDataScript - START

2022-03-28 19:40:13,986 INFO [AIF]: Replace data script: 

CROSSJOIN({[Allocation Method].[xxxxx},CROSSJOIN({[Company].[1001]},CROSSJOIN({[Period].[Jan]},{[Year].[FY21]})))

2022-03-28 19:40:13,986 INFO [AIF]: EssbaseRuleFile.getReplaceDataScript - END

2022-03-28 19:40:14,083 INFO [AIF]: The load buffer [1] has been closed (finally clause).

2022-03-28 19:40:14,083 ERROR [AIF]: Cannot Clear Partial Data. Essbase Error(1270028): The cube has no data

2022-03-28 19:40:14,094 INFO [AIF]: EssbaseService.loadData - END (false)

2022-03-28 19:40:14,111 FATAL [AIF]: Error in CommData.loadData

Traceback (most recent call last):

 File "<string>", line 2430, in loadData

RuntimeError: false


2022-03-28 19:40:14,203 FATAL [AIF]: Error in COMM Load Data

2022-03-28 19:40:14,208 INFO [AIF]: FDMEE Process End, Process ID: 761

Answers

  • Stu G-Oracle
    Stu G-Oracle Member Posts: 96 Employee

    This line is saying that it cannot clear the data as there is no data to clear

    Are you running the load with the Export mode = Replace?

    The syntax in the replace data script looks a bit wrong too, I would expect there to be a closing ] where I have highlighted, i.e. {[Allocation Method].[xxxxx]}

    Regards

    Stu