In previous versions of PBCS, I was able to load data from an ASO cube into BSO without any issues.
In recent versions, I no longer can load data as it's complaining about invalid period specified in file. Not sure why it's not getting that info from Start/End Period when I run the rule?
Any help would be appreciated!
Import Format (where Source is ASO and Target is BSO):
Location:
Period Setup (it's required to use fully qualified member according to Oracle):
Data Load Rule Setup (it's required to use fully qualified member for Account as well):
Full qualified Account member...
"[NET INCOME].[NON OPERATING COSTS].[OTHER INCOME/EXPENSE].[A60161]"
Error I'm getting in the Log:
2017-04-13 20:11:41,237 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=null:StartPos=1:SourceClName=Amount
2017-04-13 20:11:41,237 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=1:SourceClName=Account
2017-04-13 20:11:41,237 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD4:ImpFieldText=null:StartPos=1:SourceClName=Cost Center
2017-04-13 20:11:41,237 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD2:ImpFieldText=null:StartPos=1:SourceClName=Currency
2017-04-13 20:11:41,237 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ENTITY:ImpFieldText=null:StartPos=1:SourceClName=Entity
2017-04-13 20:11:41,237 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=null:StartPos=1:SourceClName=Project
2017-04-13 20:11:41,237 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=null:StartPos=1:SourceClName=Version
2017-04-13 20:11:41,239 INFO [AIF]: EPMFDM-140274:Message - Initialize error maps
2017-04-13 20:11:41,239 INFO [AIF]: EPMFDM-140274:Message - File Name AQCONSOL_845.dat
periodKey2016-01-31
2017-04-13 20:11:41,239 INFO [AIF]: EPMFDM-140274:Message - dataLoadEngine.getSourceSystemTypeEPM() ESSBASE
2017-04-13 20:11:41,240 DEBUG [AIF]: EPMFDM-140274:Message - HEADER: ["Scenario", "Project", "Currency", "Entity", "Location", "Account", "Cost Center", "Product", "Version", "Years", "Group", "Period"]
2017-04-13 20:11:41,248 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CURKEY:ImpFieldText=null:StartPos=1:SourceClName=Currency
2017-04-13 20:11:41,301 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["Oracle","J00000","Functional","01","L000","A60161","C80020","P0000","Default Version","FY16","G00",145055.0]
2017-04-13 20:11:41,301 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["Oracle","J00000","Functional","01","L000","A60161","C80020","P0000","Default Version","FY16","G00",145055.0]
2017-04-13 20:11:41,301 INFO [AIF]: EPMFDM-140274:Message - PROCESS ID: 845
PARTITIONKEY: 67
IMPORT GROUP: ASO_BSO_TEST
FILE TYPE: DELIMITED
DELIMITER: ,
SOURCE FILE: AQCONSOL_845.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
HEADER ROW.............. Header Row
ERROR_INVALID_PERIOD.............. Invalid period specified in the file.
[BLANK] "Oracle","J00000","Functional","01","L000","A60161","C80020","P0000","Default Version","FY16","G00",145055.0
[BLANK] "Oracle","J00000","Functional","01","L000","A60161","C80020","P0000","Default Version","FY16","G00",145055.0
Rows Loaded: 0
Rows Rejected: 2