Skip to Main Content
Forums

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!

Error parsing formula for [FIX STATEMENT] (line 1): unknown member name ["Explicit"] in function [@I

SardonixJun 5 2015 — edited Jun 5 2015

First and foremost we're having similar issue as Nathan below -- with slightly different errors for different period loads.  I load Jul-FY14 and data loads, returns error list with 10-15 lines similar to Essbase load errors (rejected members).  I load Aug-FY14 and get the message below.  My question is this -- if the same location, category and only period is different, why is the error behavior different.  I would expect BOTH to either return the error list (rejected members) with errors in the error report box or both blow up with the below error.

Thoughts??

Thanks, Tim Smith

(Thanks to Nathan -- sure you got your issue resolved by now)

========= Nathan's post =========

Hi,

V11.1.2

I am trying to export data to essbase from fdm. I have got a data file to import and validate. However, when I do an export I receive the following error

Data Clear Error

Calc Script Failed.

Code=10410

Description=Essbase API Procedure: [EsbCalc] Threw code: 1200497 - 1200497 - [Tue Mar 01 10:19:59 2011]<server</<appname>/<databasename>/nathan.goodearl/Error(1200497)

Error parsing formula for [FIX STATEMENT] (line 1): unknown member name ["Explicit"] in function [@IDESCENDANTS]

I have exported the data load and there is a single data entry which shows each dimension and the amount aggregated. From the error is appears it is trying to load this one line instead of the level zero data. I am fairly new to FDM so the way to data is presented might be correct....either way the data isn't being loaded to Essbase.

Thanks,

Nathan

Comments

What is appearing in the logs of both servers in regards to the connection failure?

3720642

As shown on syslog:

[ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'replica@belem.cidades.gov.br:3306 - retry-time: 60  retries: 1040, Error_code: MY-001129

The last error code given, after a stop slave and some changes to the master (file and log_pos), was Error_code: MY-002061, the rest of the line was the same.

Again, I have no idea what these errors actually are, nor why they went away as soon as I connected manually to the mysql console with the replication user.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 3 2015
Added on Jun 5 2015
#business-intelligence-applications, #fdm, #financial-data-management, #performance-management-applications
0 comments
125 views