Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FDMEE Data load- File Character Set Error (PBCS)

user11203834Sep 9 2019 — edited Sep 9 2019

Hello,

I am trying to push data from one PBCS Application to Another. I get below error while import. It looks like the issue is with the file character set.

In the application, the member name is like "Estimé" but on the error log it is displayed as "Estimé"

I used the file character set as UTF-8 in System, Application and User Settings.

1. Can anyone tell me how to get the data with the original character "é"

2. Please guide me how i can download the .dat file created by FDMEE in PBCS.

2019-09-08 11:39:36,997 INFO [AIF]: Uploading data file to PBCS: /u03/inbox/outbox/CASH_115.dat

I tried below but couldn't succeed

pastedImage_0.png

No file generated in the process detail as well

pastedImage_5.png

2019-09-08 11:39:37,822 DEBUG [AIF]: We need to connect to Essbase server.

2019-09-08 11:39:37,911 DEBUG [AIF]: Overrode info.dataFileFullName to: /u03/inbox/data/CASH_162.op.dat

2019-09-08 11:39:37,988 DEBUG [AIF]: Obtained connection to essbase cube: BUDXX

2019-09-08 11:39:37,989 DEBUG [AIF]: Resolved essbase rule file name for loading: AIFH0006

2019-09-08 11:39:37,991 DEBUG [AIF]: Fetching rule file from essbase server for data loading: AIFH0006

2019-09-08 11:39:37,999 INFO [AIF]: Starting executeDataRuleFile...

2019-09-08 11:39:38,004 DEBUG [AIF]: Locked rule file: AIFH0006

2019-09-08 11:39:38,008 INFO [AIF]: Loading data into cube using data file...

2019-09-08 11:39:38,022 INFO [AIF]: Load data encountered the following errors:

| Error: 3303 | Estimé | "414400","D_INIT","VC","V_INIT","Estimé","FY19","M01",567767148 |

| Error: 3303 | Estimé | "414661","D_INIT","VC","V_INIT","Estimé","FY19","M01",26865232 |

| Error: 3303 | Estimé | "413310","D_INIT","VC","V_INIT","Estimé","FY19","M01",3975494212 |

| Error: 3303 | Estimé | "416130","D_INIT","VC","V_INIT","Estimé","FY19","M01",123333332 |

2019-09-08 11:39:38,022 INFO [AIF]: Load data failed.

2019-09-08 11:39:38,030 DEBUG [AIF]: Unlocked rule file: AIFH0006

2019-09-08 11:39:38,030 ERROR [AIF]: Load data failed.

2019-09-08 11:39:38,037 INFO [AIF]: EssbaseService.loadData - END (false)

2019-09-08 11:39:38,037 ERROR [AIF]: false

--------------------------------------------------------- END: Process Log From the Rest Job ---------------------------------------------------------

2019-09-08 11:39:52,958 ERROR [AIF]: The rest service job has failed, see details above.

2019-09-08 11:39:52,961 INFO [AIF]: EssbaseService.loadData - END (false)

2019-09-08 11:39:52,969 DEBUG [AIF]: AIFUtil.callOdiServlet - END

2019-09-08 11:39:52,969 FATAL [AIF]: Error in CommData.loadData

Traceback (most recent call last):

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

RuntimeError: false

Comments

Processing