# Essbase Error Codes Reference: Data Load, Outline and Calc Messages > Source: https://netray.co/tools/essbase-data-load-dimension-build-error-codes-reference > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Look up Essbase message numbers from data loads, outline builds, calcs and sessions with the message text, likely cause and a practical fix. ## Category oracle ## Erp Oracle Hyperion / Essbase ## Audience - Essbase administrator - Hyperion support analyst - FDMEE / Data Management admin ## Tool **Kind:** worksheet **Mode:** reference **Columns:** #### Error number **Key:** code **Type:** text #### Message (short) **Key:** message **Type:** text #### Category **Key:** category **Type:** text #### Likely cause **Key:** cause **Type:** text #### Fix **Key:** fix **Type:** text **Rows:** #### A field in the record is not a member, alias or recognised token **Code:** 1003000 **Message:** Unknown item in data load **Category:** Data load (1003xxx) **Fix:** Add the member, map it in the rules file, or ignore the field #### Two fields on one record resolve to members of the same dimension **Code:** 1003001 **Message:** Duplicate members from same dimension on data record **Category:** Data load (1003xxx) **Fix:** Fix the field mapping or drop one field in the rules file #### Load stopped on a fatal record problem **Code:** 1003003 **Message:** Unable to continue data load after item **Category:** Data load (1003xxx) **Fix:** Read the preceding message and the error file, fix the record, reload #### Header defines more or fewer data columns than the rows carry **Code:** 1003004 **Message:** Incorrect number of column members in symmetric file **Category:** Data load (1003xxx) **Fix:** Check delimiters, quotes and blank trailing columns #### A number appears before every dimension has a member (missing field, header or mapping) **Code:** 1003007 **Message:** Data value encountered before all dimensions selected **Category:** Data load (1003xxx) **Fix:** Make sure each dimension is in the record, header or rules file; check numbers in member columns #### More data values than data columns defined **Code:** 1003008 **Message:** Too many values in row **Category:** Data load (1003xxx) **Fix:** Fix the delimiter or the column header in the rules file #### Member name or alias not in the outline (new account, entity, typo, trailing space) **Code:** 1003014 **Message:** Unknown member in data load **Category:** Data load (1003xxx) **Fix:** Build the member first or correct the source value; reload rejected records #### Record field and header both supply the same dimension **Code:** 1003015 **Message:** Member is from the same dimension as members defined in header **Category:** Data load (1003xxx) **Fix:** Remove the dimension from the header or the record #### More rejects than the DATAERRORLIMIT setting **Code:** 1003025 **Message:** DATAERRORLIMIT reached; rejected records no longer logged **Category:** Data load (1003xxx) **Fix:** Fix the root cause of the first rejects; raise DATAERRORLIMIT in essbase.cfg only if needed #### Line exceeds the maximum length, often a missing line break **Code:** 1003032 **Message:** Input line too long near record **Category:** Data load (1003xxx) **Fix:** Check line endings and file encoding #### A non-numeric value sits in a field Essbase treats as a data column **Code:** 1003034 **Message:** Invalid member in data column **Category:** Data load (1003xxx) **Fix:** Check delimiters, quotes and the rules file field types so text does not land in data columns #### All records rejected, filtered by select/reject rules, or values unchanged **Code:** 1003035 **Message:** No data values modified by load of this data file **Category:** Data load (1003xxx) **Fix:** Review the error file and rules file select criteria #### Field exceeds the member name length limit **Code:** 1003036 **Message:** Member name too long **Category:** Data load (1003xxx) **Fix:** Trim or map the source value #### Loading to a parent with a single child that Essbase treats as implied share **Code:** 1003039 **Message:** Implied shared member does not have a real child **Category:** Data load (1003xxx) **Fix:** Load to the child, or set the parent to Never Share #### UTF-8 file loaded into a non-Unicode application **Code:** 1003048 **Message:** Unicode-encoded data to non-Unicode application not supported **Category:** Data load (1003xxx) **Fix:** Convert the file encoding or migrate the application to Unicode mode #### Data file contains upper-level values for an ASO cube **Code:** 1003055 **Message:** Aggregate storage applications ignore update to derived cells **Category:** Data load, ASO **Fix:** Load level-0 only; ASO calculates upper levels #### Formula, filter or string references a member not in the outline **Code:** 1019026 **Message:** Unknown member found while processing string **Category:** Outline / database object **Fix:** Correct the member reference or restore the member #### Restructure after a dimension build blocked by sessions **Code:** 1013101 **Message:** Cannot restructure; other active users on database **Category:** Outline / dimension build **Fix:** Disable connects, log users off, rerun the build or restructure #### Upper-level member in Accounts or a dynamic hierarchy is stored without a formula **Code:** 1060147 **Message:** ASO outlines require non level-0 accounts and dynamic hierarchy members to be non-stored or have formulas **Category:** Outline verification, ASO **Fix:** Tag it label only or add a formula #### Label-only member below a non-label parent in a stored hierarchy **Code:** 1060149 **Message:** Label-only members must span all of the uppermost levels **Category:** Outline verification, ASO **Fix:** Tag the parents label only or remove the tag #### Same member shared twice in one stored hierarchy **Code:** 1060172 **Message:** Shared member allowed once in a stored hierarchy **Category:** Outline verification, ASO **Fix:** Move the extra share to a dynamic or alternate hierarchy #### First hierarchy of a multiple-hierarchy dimension set to dynamic **Code:** 1060180 **Message:** The primary hierarchy must be tagged as Stored **Category:** Outline verification, ASO **Fix:** Tag the first hierarchy Stored #### Unknown command or missing semicolon in calc script **Code:** 1012000 **Message:** Invalid syntax: not a CALC command **Category:** Calculation (1012xxx) **Fix:** Check spelling and semicolons near the reported command #### Syntax error in the script **Code:** 1012001 **Message:** Invalid calc script syntax **Category:** Calculation (1012xxx) **Fix:** Validate the script in EAS or the 21c editor and fix the reported line #### CALC ALL inside FIX/ENDFIX **Code:** 1012015 **Message:** CALC ALL cannot be used in restricted calculation **Category:** Calculation (1012xxx) **Fix:** Use CALC DIM or AGG inside the FIX #### AGG used on a dense dimension **Code:** 1012023 **Message:** Aggregating on dense dimension not supported **Category:** Calculation (1012xxx) **Fix:** Use CALC DIM for dense dimensions #### &Variable not defined at server, app or database level **Code:** 1012042 **Message:** Substitution variable does not exist **Category:** Calculation (1012xxx) **Fix:** Create the substitution variable or fix its name #### FIX on a Dynamic Calc member **Code:** 1012051 **Message:** FIX statement cannot contain Dynamic Calc member **Category:** Calculation (1012xxx) **Fix:** FIX on stored members only #### FIX members or functions return nothing (wrong UDA, deleted member, empty variable) **Code:** 1012055 **Message:** Expression inside FIX evaluates to an empty set **Category:** Calculation (1012xxx) **Fix:** Check members, UDAs and substitution variable values #### Script not in the database directory or wrong name **Code:** 1012500 **Message:** Requested calc script not found **Category:** Calculation (1012xxx) **Fix:** Check the .csc file location and name #### Dynamic calcs need more blocks than CALCLOCKBLOCK or the data cache allows **Code:** 1012704 **Message:** Dynamic Calc processor cannot lock more than n ESM blocks **Category:** Calculation (1012xxx) **Fix:** Raise the CALCLOCKBLOCK setting and the data cache, or reduce dynamic members in the query #### Data cache too small for the operation **Code:** 1006023 **Message:** Data cache is full **Category:** Cache **Fix:** Increase the data cache size for the database #### Another user or a crashed session holds the outline or script lock **Code:** 1053010 **Message:** Object is already locked by user **Category:** Agent / objects **Fix:** Wait, or unlock the object in EAS or MaxL #### Connects disabled for maintenance **Code:** 1051004 **Message:** Logins are currently not permitted **Category:** Agent / session **Fix:** Enable connects after the maintenance window **Notes:** Message text is paraphrased from the Oracle Essbase Error Message Reference (11.1.2): data load 1003000 to 1003048, calculation 1012000 to 1012750, data cache, database object, agent and aggregate storage messages. Codes in the 1020xxx, 1200xxx and 1260xxx ranges (for example 1020098 or 1260046, often seen in Smart View or Fusion GL reports) are not listed in that reference, so they are left out here rather than guessed; read the full text Essbase prints with them. ## Content **Intro:** This is a searchable list of Essbase message numbers that admins hit during data loads, outline builds, calculations and logins, each with a short message, the likely cause and a fix. It covers Essbase 11.1.2.x and the same message numbers carried into 21c. **Sections:** #### How to use it **Body:** Type the seven-digit number from the log or the Smart View pop-up into the search box. The message column is a short paraphrase; the real message includes the member, file or record number, which usually tells you exactly where to look. Export the table to Excel if you want to add your own codes and fixes for your applications, such as the rejected records your nightly load produces most often. **Bullets:** - 1003xxx: data load messages, mostly about the record or the rules file. - 1012xxx: calculation script and formula messages. - 1060xxx: aggregate storage outline verification. - 1051xxx to 1053xxx: agent, session and object locks. #### Where to read the full message **Body:** On 11.1.2.x the application log is appname.log under EPM_ORACLE_INSTANCE/diagnostics/logs/essbase/essbase_0/app/appname (with an ODL-format log alongside it, depending on configuration). Rejected data load records go to the error file you name in EAS or MaxL, often dataload.err; each rejected line is written with the message in front of it, so you can fix and reload just that file. In 21c the job details in the web interface show the error file and the job output, and the REST GET /jobs/{id} response includes jobOutputInfo. Smart View shows only the first message, so always cross-check the server log. #### Worked example: error 1003007 **Body:** A load fails with Data value 1.03134e+007 encountered before all dimensions selected. Essbase read a number while at least one dimension still had no member. Typical causes are a missing column in the source extract, a header definition that lost a dimension after a rules file change, a new member (for example a new year) not mapped in the rules file, or a number sitting in a member column because a delimiter is wrong. Open the error file, take the first rejected record and count fields against the rules file field list. Fixing the mapping and reloading the error file usually clears the rest. #### Common mistakes **Body:** Raising DATAERRORLIMIT hides the problem instead of fixing it. Loading upper-level values into an ASO cube produces 1003055 and the values are skipped. Duplicate member name outlines need qualified names in the source, otherwise members can resolve wrongly or be rejected. After an outline restructure, check the application log for 1013101 before assuming the build succeeded. For calc errors, the line reported is where the parser gave up, so look one or two lines earlier for a missing semicolon or unbalanced parenthesis (1012019). **Cta:** If you want a private assistant that reads your Essbase logs and error files and explains each reject in plain English, we can run it on your own servers. **Faq:** #### What does Essbase error 1003007 mean? **Answer:** Data value encountered before all dimensions selected. Essbase found a number on a record before it had a member for every dimension. Check that each dimension is supplied by the record, the header or the rules file, that new members are mapped, and that delimiters are correct so numbers do not slide into member columns. #### Where is the Essbase data load error file? **Answer:** You choose it when you run the load: in EAS it is the error file field on the data load dialog, and in MaxL it is the on error write to clause of import database. In 21c jobs the error file is listed in the job details. Each rejected record is written with its message so you can fix and reload it. #### Why is error 1020098 or 1260046 not in this list? **Answer:** These numbers are not in the 11.1.2 Essbase Error Message Reference ranges this list is built from, and we only list codes we could confirm. When you see them, read the full text Essbase or Smart View prints with the code, which names the member or problem, and check the server application log for the matching entry. #### How do I fix unknown member errors during an Essbase load? **Answer:** Error 1003014 means the member or alias in the record is not in the outline. Run the dimension build before the data load, check for trailing spaces and case differences, confirm the right alias table is active, and reload only the rejected records from the error file once the outline is fixed. ## Search terms essbase error 1003007, essbase error codes, essbase data load error, essbase error 1003014 unknown member, essbase error 1012023, essbase dataload.err, essbase error message reference --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json