Hi expert
The below error appears when I click Execute button in Data Load Rule under Data Load area in workspace 11.1.2.3. Actually I have already set in tabs Global Mapping (add 12 months' records), Application Mapping (add 12 months' records) and Source Mapping (add one month 'Apr 1, 2014' as Period name with Mapping Type = Explicit) in Period Mapping function. What else do I need to check for fixing this issue? Thanks.
2014-04-29 06:10:35,624 INFO [AIF]: FDMEE Process Start, Process ID: 56
2014-04-29 06:10:35,625 INFO [AIF]: FDMEE Logging Level: 4
2014-04-29 06:10:35,625 INFO [AIF]: FDMEE Log File: null\outbox\logs\AAES_56.log
2014-04-29 06:10:35,625 INFO [AIF]: User:admin
2014-04-29 06:10:35,625 INFO [AIF]: Location:AAESLocation (Partitionkey:2)
2014-04-29 06:10:35,626 INFO [AIF]: Period Name:Apr 1, 2014 (Period Key:4/1/14 12:00 AM)
2014-04-29 06:10:35,627 INFO [AIF]: Category Name:AAESGCM (Category key:2)
2014-04-29 06:10:35,627 INFO [AIF]: Rule Name:AAESDLR (Rule ID:7)
2014-04-29 06:10:37,504 INFO [AIF]: Jython Version: 2.5.1 (Release_2_5_1:6813, Sep 26 2009, 13:47:54)
[Oracle JRockit(R) (Oracle Corporation)]
2014-04-29 06:10:37,504 INFO [AIF]: Java Platform: java1.6.0_37
2014-04-29 06:10:39,364 INFO [AIF]: -------START IMPORT STEP-------
2014-04-29 06:10:45,727 INFO [AIF]:
Import Data from Source for Period 'Apr 1, 2014'
2014-04-29 06:10:45,742 INFO [AIF]:
Import Data from Source for Ledger 'ABC_LEDGER'
2014-04-29 06:10:45,765 INFO [AIF]: Monetary Data Rows Imported from Source: 12
2014-04-29 06:10:45,783 INFO [AIF]: Total Data Rows Imported from Source: 12
2014-04-29 06:10:46,270 INFO [AIF]:
Map Data for Period 'Apr 1, 2014'
2014-04-29 06:10:46,277 INFO [AIF]:
Processing Mappings for Column 'ACCOUNT'
2014-04-29 06:10:46,280 INFO [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 12
2014-04-29 06:10:46,280 INFO [AIF]:
Processing Mappings for Column 'ENTITY'
2014-04-29 06:10:46,281 INFO [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 12
2014-04-29 06:10:46,281 INFO [AIF]:
Processing Mappings for Column 'UD1'
2014-04-29 06:10:46,282 INFO [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 12
2014-04-29 06:10:46,282 INFO [AIF]:
Processing Mappings for Column 'UD2'
2014-04-29 06:10:46,283 INFO [AIF]: Data Rows Updated by Rule Mapping EXPLICIT: 12
2014-04-29 06:10:46,312 INFO [AIF]:
Stage Data for Period 'Apr 1, 2014'
2014-04-29 06:10:46,315 INFO [AIF]: Number of Rows deleted from TDATAMAPSEG: 171
2014-04-29 06:10:46,321 INFO [AIF]: Number of Rows inserted into TDATAMAPSEG: 171
2014-04-29 06:10:46,324 INFO [AIF]: Number of Rows deleted from TDATAMAP_T: 171
2014-04-29 06:10:46,325 INFO [AIF]: Number of Rows deleted from TDATASEG: 12
2014-04-29 06:10:46,331 INFO [AIF]: Number of Rows inserted into TDATASEG: 12
2014-04-29 06:10:46,332 INFO [AIF]: Number of Rows deleted from TDATASEG_T: 12
2014-04-29 06:10:46,366 INFO [AIF]: -------END IMPORT STEP-------
2014-04-29 06:10:46,408 INFO [AIF]: -------START VALIDATE STEP-------
2014-04-29 06:10:46,462 INFO [AIF]:
Validate Data Mappings for Period 'Apr 1, 2014'
2014-04-29 06:10:46,473 INFO [AIF]: Data Rows Marked as Invalid: 12
2014-04-29 06:10:46,473 ERROR [AIF]: Error: Data rows with unmapped dimensions exist for Period 'Apr 1, 2014'
2014-04-29 06:10:46,476 INFO [AIF]: Total Data Rows available for Export to Target: 0
2014-04-29 06:10:46,478 FATAL [AIF]: Error in CommMap.validateData
Traceback (most recent call last):
File "<string>", line 2348, in validateData
RuntimeError: [u"Error: Data rows with unmapped dimensions exist for Period 'Apr 1, 2014'"]
2014-04-29 06:10:46,551 FATAL [AIF]: Error in COMM Validate Data
2014-04-29 06:10:46,556 INFO [AIF]: FDMEE Process End, Process ID: 56