1012000 to 1012750: Calculation Messages

Table 6 lists error and informational messages that are specific to calculations.

Table 6. Calculation Messages 1012000 to 1012750

Message Number Message Possible Cause Possible Solution

1012000

Invalid Syntax - Not a CALC command invalidCommandName

Essbase encountered a command in a calculation script that is not a valid calculation command.

Ensure that the calculation command is correct.

  • Is the calculation command spelled correctly?

  • Are all variables in the calculation command spelled correctly?

  • Is the calculation command valid?

1012001

Invalid Calc Script syntax calculationCommandWithErrors

Essbase encountered a syntax error in a calculation script.

Ensure that the calculation script is valid.

See also "Understanding Calculation Script Syntax" in the Oracle Essbase Database Administrator's Guide.

  • Is everything enclosed in quotation marks that needs to be?

  • Can you verify the syntax of the calculation script in the Calc Script Editor?

  • Are all member names correct, including spaces? Member names with spaces must be enclosed in quotation marks.

  • Is the syntax correct for all formulas?

  • Is the syntax correct for commands that define calculation behavior, such as SET?

1012004

Related Topics

1012005

Invalid member name memberName

Essbase encountered an invalid member name in the calculation script.

Ensure that the member name is valid.

  • Does the member still exist in the outline? This error message usually occurs when a member is deleted from the outline but not from the calculation script. If a member does not exist in the outline, delete all references to that member from the calculation script.

  • Is the member name spelled correctly, including spaces?

  • If the member name contains special characters, such as spaces, periods, or numbers only, ensure that the member name is enclosed in quotation marks.

  • Instead of typing in the member name, try associating the correct outline with the calculation script and using the Calc Script Editor to fill in the member name.

1012005

Related Topics

1012004

Invalid dimension name dimensionName

Essbase encountered an invalid dimension name in the calculation script.

Ensure that the dimension name is valid.

Does the dimension still exist in the outline? This message usually occurs when a dimension is deleted from the outline but not from the calculation script. If a dimension does not exist in the outline, delete all references to that dimension and its members from the calculation script.

Is the dimension name spelled correctly, including spaces?

If the dimension name contains special characters, such as spaces, ensure that the dimension name is enclosed in quotation marks.

Instead of typing in the dimension name, try associating the correct outline with the calculation script and using the Calc Script Editor to fill in the dimension name.

1012009

Variable name variableName too long

Essbase encountered a variable name that is too long. Variable names must be no more than 32 bytes.

Find the variable name and make it 32 bytes or fewer.

Ensure that the dimension name is valid.

Ensure that you are declaring the variable correctly before you use it.

1012010

Redeclared Variable name variableName

The variable was declared multiple times in one calculation script.

Check the calculation script and remove the extra variable declarations. Ensure that you are declaring the variable correctly before you use it.

1012011

Variable name variableName conflicts with member name

The name assigned to the listed variable matches a member name in the outline.

Assign the variable a unique name. Remember that the variable name must be 32 bytes or fewer and must follow Essbase naming rules. Ensure that you are declaring the variable correctly before you use it.

1012012

The array variable range specifier dimensionName is not a dimension

The dimension in the calculation script that determines the size of the array variable was not a valid dimension.

Ensure that the dimension name is valid.

  • Does the dimension exist in the outline?

  • Is the dimension spelled correctly, including spaces? Instead of typing in the member, try associating the correct outline with the calculation script and using the Calc Script Editor to fill in the member name.

  • If the dimension name contains special characters, such as spaces, ensure that the dimension name is enclosed in quotation marks.

Ensure that the dimension name is enclosed in brackets [dimensionName] in the calculation script.

Ensure that the ARRAY command in the calculation script is valid.

1012013

Calc Script Error - Unexpected End of File reached

The calculation script contained a comment open symbol /*, but did not contain a matching comment close symbol */.

Add the comment close symbol */ at the end of the comment.

1012015

CALC ALL cannot be used in restricted calculation

Essbase encountered a CALC ALL command inside a FIX-ENDFIX command block.

Ensure that the CALC ALL command is not used inside FIX-ENDFIX command blocks. The CALC ALL command calculates the entire database but the FIX command calculates only a part of the database.

1012016

Related Topics

1012017

Cannot calculate dimension member memberName with restricted member memberName

The calculation script contained a calculation that tried to calculate a member after restricting the calculation to another member in the same dimension.

Ensure that the member is correctly positioned in the FIX statement. If you fix on a member, you can calculate only that member. For example, this FIX statement is incorrect because the FIX is on the Sales member, but the statement tries to calculate Profit, which is another member:

FIX(Sales) Profit; ENDFIX

This FIX statement is correct:

FIX (Sales) Sales; ENDFIX

1012017

Related Topics

1012016

Cannot calculate dimension dimensionName with restricted member memberName

The calculation script contained a calculation that tried to calculate a dimension after restricting the calculation to a member of that dimension.

Ensure that the dimension is correctly positioned in the FIX statement. If you fix on a member, you can calculate only that member in the same dimension. For example, this FIX statement is incorrect because the FIX is on the Sales member, which is part of the Measures dimension, but the statement tries to calculate the entire Measures dimension:

FIX(Sales) CALC DIM Measures; ENDFIX

1012018

Redeclared dimension dimensionName in AGG command

The dimension name was declared multiple times in one AGG command.

Check the calculation script and remove the extra dimension name declarations.

1012019

Calc Script block delimiter delimiterName not balanced delimiterName

The calculation script is missing opening or closing parentheses.

Check the calculation script to add the missing parenthesis or delete the extra parenthesis.

1012021

Calc Script command calculationScriptCommand is incomplete

The listed calculation script command was not complete.

Ensure that the calculation script command contains all pertinent data.

  • Are there open flow control commands, such as a FIX command without an ENDFIX command, or a LOOP command without an ENDLOOP command?

  • Are semicolons missing?

  • Are all left parentheses closed by right parentheses?

1012023

Aggregating on Dense Dimension dimensionName is currently not supported

Essbase cannot use the AGG command with dense dimensions.

Check the calculation script to Ensure that you are not using the AGG command on a dimension tagged as dense.

1012024

Cannot aggregate dimension dimensionName with restricted member memberName

The calculation script contains a calculation that tries to aggregate a dimension after restricting the calculation to a member of that dimension.

Ensure that the dimension is correctly positioned in the FIX statement. If you fix on a member, you can aggregate only that member. For example, This FIX statement is incorrect because the FIX is on the Sales member, but the statement tries to aggregate Measures, which is a dimension:

FIX(Sales) AGG(Measures); ENDFIX

This FIX statement is correct:

FIX (Sales) AGG (Sales); ENDFIX

1012025

No Currency Database has been set on this database

Essbase tried to perform a calculation that required a currency database but no currency database existed.

Ensure that the main database is linked to the currency database.

Ensure that the main database can connect to the currency database. First, try these two steps:

Stop and restart the application.

Ensure that the main database is linked to the currency database.

If these steps do not work, perform these steps on the application and main database:

  1. Stop the application and main database.

  2. Rename the main database ARBORPATH/app/appName/databaseName/databaseName.db file to something else.

  3. Create a new application and database.

  4. Move the databaseName.db file you created in step 3 to the application and database you stopped in step 1.

  5. Restart the application you stopped in step 1.

1012026

commandName command can only be fixed on a CURPARTITION member

Essbase tried to FIX on a member that does not belong to the CURPARTITION dimension.

When using the CCONV command, ensure that all members that appear inside the FIX command belong to the CURPARTITION dimension.

1012027

No dimension is tagged CURPARTITION, commandName command cannot be fixed on any member

Essbase tried to FIX on a member of the CURPARTITION dimension but the CURPARTITION dimension is not defined for the database.

Essbase tried to FIX on a member of the CURPARTITION dimension but the CURPARTITION dimension is not defined for the database.

1012028

commandName command must be fixed on a CURPARTITION member

Essbase cannot use the CCONV command without a currency partition defined.

When using the CCONV command, ensure that all members that appear inside the FIX command belong to the CURPARTITION dimension.

1012029

Invalid target range range of DCOPY command

In the DATACOPY command, the number of members in the source range do not match those in the target range.

Ensure that the number of members in the source range (the set of members you are copying from) matches the number of members in the target range (the set of members you are copying to). Ensure that the DATACOPY command is correct.

1012030

DATACOPY command command cannot copy data to itself

The DATACOPY command copies a range of members from a source range to a target range. The DATACOPY command cannot copy a range of members from a source range back onto the source range.

Ensure that the DATACOPY command is set to copy the correct range. Compare the source and target ranges to Ensure that the DATACOPY command is not copying the data back onto the source range.

1012031

DATACOPY command command is conflict with Range Fix

Essbase tried to copy a range of members that was outside of the range you fixed on.

Make the DATACOPY range and FIX range compatible by making the ranges match, or by making the DATACOPY range a subset of the FIX range.

1012032

When CURPARTITION is tagged, DATACOPY command command can only be used to copy a whole Currency Partition

Essbase tried to use the FIX command while using DATACOPY to copy a currency partition and this is not permitted.

Ensure that you are not using a FIX command in the DATACOPY command if you are copying a currency partition. Use the DATACOPY command to copy the entire currency partition.

1012033

Currency Conversion is not available with this server, calc command commandName is not supported

This command is available only when using Currency Conversion applications.

 

1012034

Variable variableName not declared

The variable used in the calculation script is not declared.

Ensure that you are declaring the variable correctly before you use it.

1012035

Variable variableName must be of VAR type

The variable listed must be of VAR type instead of ARRAY type.

Ensure that you are declaring the variable correctly.

1012036

Calc Script block command blockCommandName does not end with blockEndCommandName

Essbase encountered a block command that was not closed.

Ensure that each FIX command is closed by an ENDFIX command. Ensure that each LOOP command is closed by an ENDLOOP command.

1012037

Custom calculation is not allowed for kindOfShare share member sharedMemberName

Essbase tried to calculate a formula on a shared member.

Because shared members do not store data, you cannot attach formulas to them. Ensure that the listed member is not shared, either because the member's storage property is explicitly tagged as shared or because the member is implicitly shared.

1012038

The constant constantName assigned to variable variableName is not a number

Essbase tried to assign a value that was not a number to the listed variable. The listed variable can accept only numeric values.

Ensure that you are declaring the variable correctly.

1012039

The constant constantName assigned to array variable arrayVariableName is not a number

Essbase tried to assign a value that was not a number to the listed array variable. The listed array variable can accept only numeric values.

Ensure that you are assigning the array variable correctly.

1012040

Too many initial constants assigned to array variable arrayVariableName

EssbaseThe number of values that Essbase tried to assign to the array exceeds the number of members in the associated dimension.

Ensure that you are using the ARRAY command correctly.

Ensure that you are assigning the values to the correct dimension.

1012041

memberName is not a valid currency type member

Essbase tried to specify the currency type using a member that does not belong to the CurType dimension.

Ensure you are using the CCONV function correctly and that the currency database is set up correctly. Ensure that the listed member is defined as the currency type member.

1012042

Substitution variable substitionVariableName doesn't exist

The calculation script cannot find the listed substitution variable.

Ensure that you created the substitution variable correctly. Ensure that the substitution variable was created at the correct level.

  • Substitution variables created at the database level are available to all calculation scripts within that database.

  • Substitution variables created at the application level are available to all calculation scripts within that application.

  • Substitution variables created at the server level are available to all calculation scripts on the Essbase Server.

1012043

Calculation is not allowed for virtual member memberName in the Calc script

The calculation script tried to set a Dynamic Calc member value or request calculation of a Dynamic Calc member.

Dynamic Calc members are calculated at query time if a query requests the value of the member. They cannot be calculated through calculation scripts. Ensure that the Dynamic Calc member is not on the left side of the equation; for example, if Qtr1 is Dynamic Calc, this equation is incorrect:

Qtr1 = Jan + Feb + Mar;

If Qtr1 is Dynamic Calc, this equation is also incorrect:

vbb Qtr1;

This equation is correct, if Year is not Dynamic Calc, but Qtr1 and Qtr2 are Dynamic Calc:

Year = Qtr1 + Qtr2;

1012044

Invalid fix member count number when converting from Bitmap

 

Contact Oracle Support.

1012045

Unable to convert bitmap to fix member in function functionName

 

Contact Oracle Support.

1012046

Unable to convert MEMNOR to MEMNO in function functionName

 

Contact Oracle Support.

1012047

Aggregating on Attribute Dimension attributeDimensionName is currently not supported

Essbase tried to calculate the listed attribute dimension using the AGG command.

Ensure that you are not using the AGG command to calculate an attribute dimension. Attribute dimensions do not store data. They are calculated at query time if a query requests the value of the member.

1012048

Calc Dim on Attribute Dimension attributeDimensionName is not supported

Essbase tried to calculate the listed attribute dimension using the CALC DIM command.

Ensure that you are not using the CALC DIM command to calculate an attribute dimension. Attribute dimensions do not store data. They are calculated at query time if a query requests the value of the member.

1012049

Cannot clear data from Attribute dimension member memberName

Essbase tried to clear data from the listed attribute dimension.

Attribute dimensions do not store data. They are calculated at query time if a query requests the value of the member. You cannot clear data from an attribute dimension or attribute dimension member.

1012050

Cannot DATACOPY on Attribute dimension member memberName

Essbase tried to copy data into the listed attribute dimension using the DATACOPY command.

Ensure that you are not using the DATACOPY command to copy data into an attribute dimension. Attribute dimensions do not store data. They are calculated at query time if a query requests the value of the member.

1012051

Batch calc error, FIX statement cannot contain Dynamic Calc member from dimension dimensionName

Essbase tried to FIX on a Dynamic Calc member.

Ensure that you are not fixing on a member that is tagged as Dynamic Calc. Dynamic Calc members do not store data. They are calculated at query time if a query requests the value of the member. To FIX on the listed member, change the member from Dynamic Calc to store.

1012052

Unable to unfix blocks after calculation encounters an error

The data blocks that were changed by a calculation were left in an inconsistent state.

Stop and restart the database or contact Oracle Support. Essbase reverted all values to their previous state or retained values calculated before the error. How Essbase handles the cancellation depends on the Essbase kernel isolation level settings.

1012053

Calculation is cancelled by user

The user pressed Cancel while performing the calculation. Essbase reverted all values to their previous state or retained values calculated before the cancellation.

How Essbase handles the cancellation depends on the Essbase kernel isolation level settings.

1012054

Batch calc error. All members that need to be calculated in dimension dimensionName are Two Pass Calc and Dynamic

Essbase tried to FIX on a dimension that contains no stored members.

Ensure that at least one member in the dimension that the calculation script fixes on is tagged as stored. Ensure that at least one stored member is not tagged as Two Pass.

1012055

The expression inside FIX evaluates to an empty set. Operation aborted

Essbase tried to fix on a member or set of members that do not exist.

Ensure that the members that the calculation script fixes on are valid. If the calculation script fixes on a set of members determined by a function, ensure that the function returns at least one member. This calculation script is incorrect because January is a level 0 member; that is, it has no children and the calculation script tries to fix on the children of January:

FIX(@CHILDREN (January))     CALC DIM (Product); ENDFIX

This calculation script is correct, because Qtr1 is not a level 0 member:

FIX(@CHILDREN (Qtr1))     CALC DIM (Product); ENDFIX

1012061

The CALC command commandName can only be used within a CALC Member Formula

Essbase cannot execute the listed command.

The IF and ELSE commands must be used within a member formula. They cannot be used in a calculation script.

1012062

Substitution variable name variable name exceeds the maximum length number of characters

Your substitution variable name contains more characters than allowed.

Rename the variable so that it does not exceed the maximum character length.

1012063

Substitution variable cannot process UTF-8 encoded data in non-Unicode configured application

You attempted to process Unicode encoded data in a non-Unicode application.

Verify that you migrated your application to Unicode mode.

1012106

Calc String function functionName must be followed by '('

The listed function needs an opening parenthesis “(”.

Insert the opening parenthesis after the function name, with the function parameters separated by commas, and a closing parenthesis. Check the function syntax.

1012121

Error encountered when loading member memberName's calc string memberFormula, ignored

Essbase could not compile the formula attached to the member because of one or more syntax errors.

Check the application log (HYPERION_HOME/logs/essbase/app/appName/appName.log) for a list of syntax errors. Correct the syntax errors. Check the calculation script command syntax.

1012134

Generation number number must be an integer

Essbase encountered a generation number that was not an integer.

Ensure that all generations are numbered with integers.

1012135

Level number number must be an integer

Essbase encountered a level number that was not an integer.

Ensure that all levels are numbered with integers.

1012136

Named generation generationName is not defined

Essbase encountered a generation name that is not defined in the database.

Ensure that the generation name is properly defined in the database.

1012137

Named Level levelName is not defined

Essbase encountered a level name that is not defined in the database.

Ensure that the level name is properly defined in the database.

1012139

No memberType member found in Account dimension

The listed member type was not found in the dimension tagged as accounts.

If you are using the CALC FIRST, CALC LAST, CALC AVERAGE, or CALC TWOPASS commands, ensure that the outline contains a dimension tagged as accounts, and that the dimension tagged as accounts contains these members:

  • If you are using the CALC FIRST command, the accounts dimension must contain a member tagged with a time balance of First.

  • If you are using the CALC LAST command, the accounts dimension must contain a member tagged with a time balance of Last.

  • If you are using the CALC AVERAGE command, the accounts dimension must contain a member tagged with a time balance of Average.

  • If you are using the CALC TWOPASS command, the accounts dimension must contain a member tagged as Two-Pass.

1012141

Illegal match string stringToMatch

The pattern specified in the @MATCH function was not valid.

Check the syntax of the @MATCH function and correct the problem.

1012142

Input inputValue is not a valid gen/level name or valid gen/level number

Essbase encountered a generation or level number or a generation or level name that was not valid.

Ensure that all generations or levels are numbered with integers or valid names. Follow the same rules as for naming members.

1012143

@MATCH search string stringToSearchFor should always be in double quote

Essbase could not search for the listed string because it was not enclosed in quotation marks.

Check the @MATCH command syntax.

1012500

The requested calc script calcScriptName not found

Essbase could not open the listed calculation script.

Ensure that Essbase can find the calculation script.

  • Are the calculation script name and path name correct? Check for misspellings.

  • If the calculation script is on a UNIX platform, is capitalization correct?

  • Is the calculation script in the specified location? Ensure that no one has moved or deleted the calculation script.

Ensure that Essbase can use the calculation script.

  • Is the calculation script being used by another user or application?

  • Is the file extension correct for the calculation script? All calculation scripts must have a file extension of .csc.

  • Is the calculation script valid?

  • Are the permissions set up correctly for the Essbase database you are calculating?

1012501

Calculator internal error -- invalid input type inputTypes

Essbase could not read the calculation script.

Ensure that the client is correctly passing the calculation script location to Essbase Server.

1012550

Total Calc Elapsed Time : number seconds

Length of time it took Essbase to perform the calculation.

Not applicable

1012551

Converting database databaseName's currency to currencyType

Essbase is converting the currency type for the listed database.

Not applicable

1012552

Copying data from rangeOfCells

Essbase is copying the data from the listed range of cells.

Not applicable

1012553

Copying data from rangeOfCells with fixed members memberNames

Essbase is copying the data from the listed range of cells.

Not applicable

1012554

Clearing data from partitionName partition

Essbase is clearing the data from the listed partition.

Not applicable

1012555

Clearing data from partitionName partition with fixed members memberNames

Essbase is clearing the data from the listed partition.

Not applicable

1012556

Calculation canceled by user userName

The listed user canceled the calculation before it completed.

Not applicable

Essbase reverted all values to their previous state or retained values calculated before the cancellation. How Essbase handles the cancellation depends on the Essbase kernel isolation level settings.

1012557

Clearing all data blocks from partitionName partition

Essbase is clearing the data from the listed partition.

Not applicable

1012558

Clearing all data blocks from partitionName partition with fixed members memberNames

Essbase is clearing the data from the listed partition.

Not applicable

1012559

Clearing upper level data blocks from partitionName partition

Essbase is clearing the data from the upper level data blocks in the listed partition.

Not applicable

1012560

Clearing upper level data blocks from partitionName partition with fixed members memberNames

Essbase is clearing the data from the upper level data blocks in the listed partition.

Not applicable

1012561

Clearing noninput data blocks from partitionName partition

Essbase is clearing the data from the noninput data blocks in the listed partition.

Not applicable

1012562

Clearing noninput data blocks from partitionName partition with fixed members memberNames

Essbase is clearing the data from the noninput data blocks in the listed partition.

Not applicable

1012563

Calculation is aborted due to floating point error errorType

Essbase canceled the calculation because it encountered a floating point error, such as overflow, underflow, or a division by zero.

  1. Correct the floating point error.

    Overflow errors result when you try to multiply two very large numbers and the result is so large that it is not supported by the computer hardware.

    Underflow errors result when you try to divide a very small number by a very large number and the result is so small that it is not supported by the computer hardware.

    Division by zero errors result when you try to divide one member by another member that is zero.

  2. Return the data values to their previous states.

    Essbase reverted all values to their previous states or retained values calculated before the cancellation. How Essbase handled the cancellation depends on the Essbase kernel isolation level settings.

  3. Run the calculation again.

1012564

Calculation is aborted due to floating point error

Essbase canceled the calculation because it encountered a floating point error, such as overflow, underflow, or a division by zero.

  1. Correct the floating point error.

    Overflow errors result when you try to multiply two very large numbers and the result is so large that it is not supported by the computer hardware.

    Underflow errors result when you try to divide a very small number by a very large number and the result is so small that it is not supported by the computer hardware.

    Division by zero errors result when you try to divide one member by another member that is zero.

  2. Return the data values to their previous states.

    Essbase reverted all values to their previous states or retained values calculated before the cancellation. How Essbase handled the cancellation depends on the Essbase kernel isolation level settings.

  3. Run the calculation again.

1012566

Begin of LOOP -- looping following commands number times

Essbase is looping through the calculation script commands the listed number of times.

Not applicable

1012567

End of LOOP -- actually looped above commands number times

Essbase completed the loop specified in the calculation script the listed number of times.

Not applicable

1012568

Commit Blocks Interval was adjusted to be number blocks

Essbase Server changed the commit blocks interval to optimize performance.

Not applicable

1012569

Formula on (or backward dependence from) member memberName forces calculation to execute in serial mode

The formula on the listed member requires that the calculation be performed in serial mode instead of parallel mode.

Not applicable

To run the calculation in parallel mode, consider removing the formula or tagging the member as Dynamic Calc.

1012570

A circular or recursive dependency along dimension dimensionName forces calculation to execute in serial mode

The listed dimension contains a dependency that requires the calculation be executed in serial mode instead of parallel mode.

Not applicable

To run the calculation in parallel mode, consider removing the formula or tagging the member as Dynamic Calc.

1012571

Presence of variables or formulas with @XREF function forces calculation to execute in serial mode

Calculation is executed in serial mode instead of parallel mode.

Not applicable

Formulas or calculation scripts that use variables with the @XREF function must be calculated in serial mode.

1012600

Member memberName attempts to divide by Missing, Invalid, or Near Zero value (Message will not repeat)

When calculating the listed member, Essbase attempted to perform a division by an invalid value, such as zero or a missing value.

Check the formula or calculation script that calculated the listed member to Ensure that all values used in the calculation are valid.

1012667

Your Server does not have a Currency Conversion Option, the Calc Script command [CCONV] is ignored

Your Essbase Server does not have the currency conversion option.

This command is available only when using Currency Conversion applications.

1012668

Calculating memberNames with fixed members memberNames

Members that Essbase is calculating and members that are fixed.

Not applicable

1012669

Calculating memberNames

Members that Essbase is calculating.

Not applicable

1012670

Aggregating memberNames with fixed members memberName

Members that Essbase is aggregating and members that are fixed.

Not applicable

1012671

Aggregating memberNames

Members that Essbase is aggregating.

Not applicable

1012672

Calculator Information Message: messageInformation

Essbase is performing an action. The information is logged because you requested it. For example, if you use the SET MSG command, details about the calculation are logged.

Not applicable

1012674

Hash memory number allocated for Calc is used up, Hash Table is turned off. Please increase the CalcHashTblMemLimit in the essbase.cfg file.

Essbase had no more hash memory.

  1. If ESSBASEPATH/bin/ essbase.cfg does not exist on the server computer, create one using a text editor.

  2. In the essbase.cfg file on the server computer, add or increase the value for CALCHASHTBLMEMORY.

  3. Stop and restart Essbase Server.

  4. Perform the calculation again.

1012675

Commit Blocks Interval for the calculation is number

Number of blocks committed at one time.

Not applicable

1012676

Member memberName attempts to execute @POWER/@FACTORIAL function. Arguments are out of range. Results may be different from versions before 6.0 (Message will not repeat)

Essbase cannot calculate the @POWER or @FACTORIAL function because the value is too large.

Ensure that the formula or calculation script is not requesting extremely large values, such as 2 raised to the 1 millionth power.

1012677

Related Topics

1012569

1012570

1012571

Calculating in serial

Essbase Server is performing the calculations in the calculation script serially, instead of in parallel.

If you requested the calculation run in parallel mode, look in HYPERION_HOME/logs/essbase/app/appName/appName.log.

1012678

Calculating in parallel with number threads

Essbase Server is performing the calculations in the calculation script in parallel using the listed number of threads.

Not applicable

You can set the number of threads using the CALCPARALLEL configuration setting or the SET CALCPARALLEL calculation script command. If the listed number differs from the value you set using CALCPARALLEL, the calculator picked the listed number as the optimal degree of parallelism for your database.

1012679

Calculation task schedule number

Number of tasks that can be executed concurrently.

This indicates the kind of performance gain you can expect from parallel calculation. Larger numbers indicate more parallel calculation.

Not applicable

If the listed numbers are smaller than the number of threads you specified using the CALCPARALLEL configuration setting or the SET CALCPARALLEL calculation script command, parallel calculation does not provide a large performance gain.

1012680

Parallelizing using number task dimensions.

Number of task dimensions Essbase is using for parallel calculation.

If the number of task dimensions is less than the listed number, "Usage of calculator cache caused reduction in task dimensions" is displayed.

Not applicable

To set the number of task dimensions, use the CALCPARALLEL configuration setting or the SET CALCPARALLEL calculation script command.

1012681

Empty tasks number

Number of tasks that contain no calculations.

The number of empty tasks affect the gains you can receive from parallel calculation. The ideal number of empty tasks is 0.

Not applicable

1012682

Multiple bitmap mode calculator cache memory usage attempted to cross limit of number bitmaps. To ignore limit, do not set MultipleBitmapMemCheck to TRUE in $ESSBASEPATH/bin/essbase.cfg.

The calculator cache memory tried to use more bitmaps than allowed, causing Essbase to abort the calculation.

To continue the calculation with more bitmaps, set MULTIPLEBITMAPCHECK to FALSE in the ESSBASEPATH/bin/essbase.cfg file on the server computer.

1012683

Multiple bitmap mode calculator cache memory usage crossed limit of number bitmaps. Set MultipleBitmapMemCheck to TRUE in $ESSBASEPATH/bin/essbase.cfg to enforce limit.

The calculator cache memory is using more bitmaps than allowed.

To prevent this from happening, set MULTIPLEBITMAPCHECK to TRUE in the ESSBASEPATH/bin/essbase.cfg file on the server computer.

1012684

Multiple bitmap mode calculator cache memory usage has a limit of number bitmaps.

Number of bitmaps Essbase can use in the calculator cache.

Not applicable

1012700

Dynamic calc processor cannot allocate more than number blocks from the heap. Please increase CalcLockBlock setting and then retry

Essbase cannot allocate enough blocks to perform the calculation.

Increase the number of blocks that Essbase can allocate for a calculation:

  1. Set the maximum number of blocks that Essbase can allocate to at least 500:

    1. If ESSBASEPATH/bin/ essbase.cfg does not exist on the server computer, create one using a text editor.

    2. In the essbase.cfg file on the server computer, set CALCLOCKBLOCKHIGH to 500.

    3. Stop and restart Essbase Server.

  2. Add the SET LOCKBLOCK HIGH command to the beginning of the calculation script.

  3. Set the data cache large enough to hold all blocks specified in the CALCLOCKBLOCKHIGH setting.

    • Determine the block size.

    • Set the data cache size.

1012701

Unknown block type during the dynamic calculation, neither an ESM block nor a heap block. Essbase internal error, Please report to Hyperion.

 

Contact Oracle Support.

1012702

The block in the dynamic calc processor block array is not marked correctly. Essbase internal error. Please report to Hyperion.

 

Contact Oracle Support.

1012703

Unknown calculation type calculationType during the dynamic calculation. Only default agg/formula/time balance operations are handled.

 

Contact Oracle Support.

1012704

Dynamic Calc processor cannot lock more than number ESM blocks during the calculation, please increase CalcLockBlock setting and then retry (a small data cache setting could also cause this problem, please check the data cache size setting).

Essbase could not lock enough blocks to perform the calculation.

Increase the number of blocks that Essbase can allocate for a calculation:

  1. Set the maximum number of blocks that Essbase can allocate to at least 500.

    1. If ESSBASEPATH/bin/essbase.cfg does not exist on the server computer, create one using a text editor.

    2. In the essbase.cfg file on the server computer, set CALCLOCKBLOCKHIGH to 500.

    3. Stop and restart Essbase Server.

  2. Add the SET LOCKBLOCK HIGH command to the beginning of the calculation script.

  3. Set the data cache large enough to hold all blocks specified in the CALCLOCKBLOCKHIGH setting.

    • Determine the block size.

    • Set the data cache size.

1012706

Need to copy to Esm block during the dynamic calculation. Esm Block not found. Essbase internal error, Please report to Hyperion.

 

Contact Oracle Support.

1012708

For virtual time series timePeriod retrieval, the latest time period is not set

Essbase tried to retrieve the time series data without knowing the latest time period.

Set the latest time period member name in the retrieval tool.

  • For Essbase Spreadsheet Add-in, specify the “Latest Time Series” option. See the Oracle Essbase Spreadsheet Add-in User's Guide.

  • For Report Writer, use the LATEST command.

1012709

For virtual time series, the latest time period setting timePeriod is not a level 0 member

Essbase tried to retrieve the latest time period, but the time member is not at level 0 in the outline.

Ensure that the time period you want to use to calculate the period-to-date value is a level 0 member of the dimension tagged as time.

1012710

Essbase needs to retrieve number Essbase Kernel blocks in order to calculate the top dynamically-calculated block.

Number of blocks thatEssbase must retrieve to perform the dynamic calculation along a sparse dimension.

Not applicable

You can use this to estimate the retrieval performance for members of sparse dimensions that are tagged as Dynamic Calc.

1012711

Clearing dynamic calc store data blocks from partitionName partition

Essbase is clearing data blocks from the listed partition.

Not applicable

1012712

Clearing dynamic calc store data blocks from partitionName partition with fixed members memberNames

Essbase is clearing data blocks from the listed partition.

Not applicable

1012713

Two-pass Member memberName is not tagged as Dynamic Calc.

The listed member is tagged as Two Pass but not tagged as Dynamic Calc and is not a member of the Accounts dimension.

Not applicable

Generally, it is recommended that you tag all Two Pass members as Dynamic Calc and that all Two Pass members be in the accounts dimension.

1012714

Regular member memberName depends on dynamic-calc member memberName.

The listed regular member depends on a Dynamic Calc member to calculate its value. The listed member may be a parent of the Dynamic Calc member or may use the Dynamic Calc member in a formula.

Because you are calculating the listed Dynamic Calc member during batch calculation in order to calculate the regular member that depends on it, you are losing the benefits of tagging the listed member as Dynamic Calc.

Consider tagging the listed Dynamic Calc member as stored or tagging the dependent regular member as Dynamic Calc.

1012715

Regular member memberName depends on member memberName from transparent partition. Consider making this member Dynamic or replicating the dependents.

The listed member is calculated using members in a transparent partition.

When you calculate a member in a target database using values from a source database transparent partition, the calculation can take a long time to complete. To improve calculation speed, use one method:

  • At the target database, tag the member as Dynamic Calc.

  • At the source database, roll up the members needed to calculate the target member into an upper level member. Put the upper level member in the source database into a replicated partition.

1012716

Remote region regionDefinition is not validated correctly yet. Cannot continue the calc.

Essbase encountered a remote partition region that has not been validated.

Open the partition definition and validate it. If necessary, correct any errors.

1012717

Remote bitmap cache is on/off

Status of bitmap cache (on or off).

Not applicable

Essbase Server determines whether to turn the bitmap cache on or off; you cannot change this setting.

1012718

For dynamic time series, the latest period settingName setting has higher generation member than the time series member memberName

The latest period setting was at a higher generation than the time series member.

Ensure that the latest period setting, such as May, is lower in the outline than the time series member, such as Q-T-D (quarter-to-date).

1012727

Dynamic calc cache sanity failed

 

Contact Oracle Support.

1012733

Dynamic calc cache compression buffer full

The Dynamic Calc cache buffer was out of space.

The Dynamic Calc cache compression buffer is used only when you set DYNCALCCACHEWAITFORBLK and DYNCALCCACHEBLKRELEASE to TRUE in the ESSBASEPATH/bin/essbase.cfg file. To fix this problem:

  1. If ESSBASEPATH/bin/ essbase.cfg does not exist on the server computer, create one using a text editor.

  2. In the essbase.cfg file on the server computer, increase the value of DYNCALCCACHECOMPRBLKBUFSIZE.

  3. In the essbase.cfg file on the server computer, set DYNCALCCACHEWAITFORBLK and DYNCALCCACHEBLKRELEASE to FALSE.

  4. Stop and restart Essbase Server.

1012734

Timed out waiting for blocks from the dynamic calc cache.

Essbase waited for a block to become available in the Dynamic Calc cache, but the cache was full.

Decrease the number of concurrent queries to keep the cache from becoming full.

Increase the amount of time that Essbase waits for blocks in the Dynamic Calc cache:

  1. If ESSBASEPATH/bin/ essbase.cfg does not exist on the server computer, create one using a text editor.

  2. In the essbase.cfg file on the server computer, add or increase the value of DYNCALCCACHEBLKTIMEOUT.

  3. Stop and restart Essbase Server.

Specify that queries should not wait for available blocks in the Dynamic Calc cache:

  1. If ESSBASEPATH/bin/ essbase.cfg does not exist on the server computer, create one using a text editor.

  2. In the essbase.cfg file on the server computer, set DYNCALCCACHEWAITFORBLK to FALSE.

  3. Stop and restart Essbase Server.

1012735

Thread synchronization error when allocating from the dynamic calc cache.

 

Contact Oracle Support

1012736

The Dyn.Calc.Cache for database databaseName can hold a maximum of number blocks.

Maximum number of blocks that the Dynamic Calc cache for the listed database can hold.

Not applicable

To change the number of blocks in the Dynamic Calc cache:

  1. If ESSBASEPATH/bin/ essbase.cfg does not exist on the server computer, create one using a text editor.

  2. In the essbase.cfg file one the server, add or change DYNCALCCACHEMAXSIZE.

  3. Stop and restart Essbase Server.

1012737

The Dyn.Calc.Cache for database databaseName, when full, will result in action.

Essbase performs these actions when the dynamic calculator cache is full:

  • If DYNCALCCACHEWAITFORBLK in the essbase.cfg file is TRUE, Essbase waits to store and calculate data blocks for the current query in the dynamic calculator cache

  • If DYNCALCCACHEWAITFORBLK in the ESSBASEPATH/bin/essbase.cfg file is FALSE, Essbase checks DYNCALCCACHEONLY

    • If DYNCALCCACHEONLY is TRUE, Essbase generates an error message

    • If DYNCALCCACHEONLY is FALSE, Essbase stores and calculates data blocks for the current query in memory outside of the dynamic calculator cache

Not applicable

1012738

The Dyn.Calc.Cache for database databaseName has a timeout of number seconds when waiting for free blocks.

Current value of DYNCALCCACHEBLKTIMEOUT.

Not applicable

1012739

The Dyn.Calc.Cache for database databaseName, upon timeout of a wait for free blocks, will result in action.

Essbase performs this action after the specified waiting period:

  • If DYNCALCCACHEBLKRELEASE in the ESSBASEPATH/bin/essbase.cfg file is TRUE, Essbase makes room available in the dynamic calculator cache by temporarily storing inactive blocks in another, compressed-block buffer.

  • If DYNCALCCACHEBLKRELEASE in the ESSBASEPATH/bin/essbase.cfg file is FALSE, Essbase does not find room in the dynamic calculator cache for another set of blocks, soEssbase checks DYNCALCCACHEONLY

    • If DYNCALCCACHEONLY is TRUE, Essbase generates an error message

    • If DYNCALCCACHEONLY is FALSE, Essbase stores and calculates data blocks for the current query in memory outside of the dynamic calculator cache.

Not applicable

1012740

The Dyn.Calc.Cache for database databaseName uses a buffer of size number bytes to store compressed released blocks.

Current value of DYNCALCCACHECOMPRBLKBUFSIZE.

Not applicable

1012741

Allocation outside the dynamic calc cache is disallowed

Current value of DYNCALCCACHEONLY is TRUE.

Not applicable

1012742

Two-pass calc skipped on member memberName in attribute calc

The listed member was skipped during Two Pass calculation because the listed member has no member formula or the listed member has a runtime dependency. Runtime dependent functions include: @CURRMBR, @PARENT, @PARENTVAL, @MDPARENTVAL, @ANCEST, @ANCESTVAL, and @MDANCESTVAL.

Not applicable

1012750

Retrieve & Lock operation is not supported on attribute cells

Essbase cannot update cells that belong to a relational partition.

Ensure that the cells being updated do not belong to a relational partition.