This document describes calculation error messages and information messages.
The discussions of error messages include possible causes and possible
solutions for each problem, with links to the Analytic Services Database
Administrator's Guide and the Analytic Services Technical Reference
for more information on how to fix errors.
Click an error message number to view information about that error message.
Analytic Services encountered a command in a calculation script that is not a valid calculation command.
Make sure that the calculation command is correct.
Analytic Services encountered a syntax error in a calculation script.
Make sure that the calculation script is valid.
See also "Understanding Calculation Script Syntax".
Analytic Services encountered an invalid member name in the calculation script.
Make sure that the member name is valid.
Analytic Services encountered an invalid dimension name in the calculation script.
Make sure that the dimension name is valid.
Analytic Services encountered a variable name that is too long. Variable names must be no more than 32 bytes.
Make sure that the dimension name is valid.
The variable was declared more than once in a single calculation script.
Check the calculation script and remove the extra variable declarations. Make sure that you are declaring the variable correctly before you use it.
The name assigned to the listed variable was the same as the name of a member in the outline.
Assign the variable a unique name. Remember that the variable name must be 32 bytes or fewer and must follow Analytic Services naming rules. Make sure that you are declaring the variable correctly before you use it.
The dimension in the calculation script that determines the size of the array variable was not a valid dimension.
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.
Analytic Services encountered a CALC ALL command inside a FIX-ENDFIX command block.
Make sure 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 fixes on a part of the database and calculates only that part.
The calculation script contained a calculation that tried to calculate a member after restricting the calculation to a different member in the same dimension.
Make sure that the member is correctly positioned in the FIX statement.
If you fix on a member, you can calculate only that member. For example,
the following FIX statement is incorrect because the FIX is on the Sales
member, but the statement tries to calculate Profit, which is a different
member:
FIX(Sales)
Profit;
ENDFIX
The following FIX statement is correct:
FIX (Sales)
Sales;
ENDFIX
The calculation script contained a calculation that tried to calculate a dimension after restricting the calculation to a member of the same dimension.
Make sure 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, the following FIX statement is incorrect because
the FIX is on the Sales member, which is part of the the Measures dimension,
but the statement tries to calculate the entire Measures dimension:
FIX(Sales)
CALC DIM Measures;
ENDFIX
The dimension name was declared more than once in a single AGG command.
Check the calculation script and remove the extra dimension name declarations.
The calculation script did not have the correct number of opening or closing parentheses.
Check the calculation script to add the missing parenthesis or delete the extra parenthesis.
The listed calculation script command was not complete.
Make sure that the calculation script command contains all pertinent data.
Analytic Services cannot use the AGG command with dense dimensions.
Check the calculation script to make sure that you are not using the AGG command on a dimension tagged as dense.
The calculation script contains a calculation that tries to aggregate a dimension after restricting the calculation to a member of the same dimension.
Make sure that the dimension is correctly positioned in the FIX statement.
If you fix on a member, you can aggregate only that member. For example,
the following 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
The following FIX statement is correct:
FIX (Sales)
AGG (Sales);
ENDFIX
Analytic Services tried to perform a calculation that required a currency database but no currency database existed.
$ARBORPATH/app/applicationName/databaseName/databaseName.db
file to something else.databaseName.db
file you created in step 3 to the application and database you stopped
in step 1.Analytic Services tried to FIX on a member that was not a member of the CURPARTITION dimension.
When using the CCONV command, make sure that all members that appear inside the FIX command belong to the CURPARTITION dimension.
Analytic Services tried to FIX on a member of the CURPARTITION dimension but the CURPARTITION dimension is not defined for the database.
When using the CCONV command, make sure that all members that appear inside the FIX command belong to the CURPARTITION dimension and that the CURPARTITION dimension is correctly defined.
Analytic Services cannot use the CCONV command without a currency partition defined.
When using the CCONV command, make sure that all members that appear inside the FIX command belong to the CURPARTITION dimension.
The DATACOPY command did not have the same number of members in the source range as the target range.
Make sure that the source range (the set of members you are copying
from) has the same number of members as the target range (the set of members
you are copying to).
Make sure that the DATACOPY command
is correct.
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.
Analytic Services tried to copy a range of members that was outside of the range you fixed on.
Make the DATACOPY range and FIX range compatible, either by making the ranges match or by making the DATACOPY range a subset of the FIX range.
Analytic Services tried to use the FIX command while using DATACOPY to copy a currency partition and this is not permitted.
Make sure 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.
This command is available only if your company has purchased the Currency Conversion option for Analytic Services.
The variable used in the calculation script is not declared.
Make sure that you are declaring the variable correctly before you use it.
The variable listed must be of VAR type instead of ARRAY type.
Make sure that you are declaring the variable correctly.
Analytic Services encountered a block command that was not closed.
Make sure that each FIX command
is closed by an ENDFIX command.
Make sure that each LOOP command
is closed by an ENDLOOP command.
Analytic Services tried to calculate a formula on a shared member.
Because shared members do not store data, you cannot attach formulas
to them.
Make sure that the listed member is not shared, either because the storage
property of the member is explicitly tagged
as shared or because the member is implicitly
shared.
Analytic Services tried to assign a value that was not a number to the listed variable. The listed variable can accept only numeric values.
Make sure that you are declaring the variable correctly.
Analytic Services tried to assign a value that was not a number to the listed array variable. The listed array variable can accept only numeric values.
Make sure that you are assigning the array variable correctly.
Analytic Services tried to assign more values to the array than there are members in the dimension with which it is associated.
Make sure that you are using the ARRAY
command correctly.
Make sure that you are assigning the values to the correct dimension.
Analytic Services tried to specify the currency type using a member that was not part of the dimension tagged as CurType in the Analytic Services database.
Make sure you are using the CCONV
function correctly and that you have set
up the currency database correctly.
Make sure that the listed member is defined
as the currency type member.
The calculation script cannot find the listed substitution variable.
Make sure that you created the
substitution variable correctly.
Make sure that the substitution variable was created at the correct level.
The calculation script tried to set the value of a Dynamic Calc member or request the 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. Make sure that the Dynamic
Calc member is not on the left side of the equation; for example,
if Qtr1 is Dynamic Calc, the following equation is incorrect:
Qtr1 = Jan + Feb + Mar;
If Qtr1 is Dynamic Calc, the following equation is also incorrect:
vbb Qtr1;
The following equation is correct, if Year is not Dynamic Calc, but
Qtr1 and Qtr2 are Dynamic Calc:
Year = Qtr1 + Qtr2;
Contact Hyperion Technical Support.
Contact Hyperion Technical Support.
Contact Hyperion Technical Support.
Analytic Services tried to calculate the listed attribute dimension using the AGG command.
Make sure 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.
Analytic Services tried to calculate the listed attribute dimension using the CALC DIM command.
Make sure 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.
Analytic Services 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 any member of an attribute dimension.
Analytic Services tried to copy data into the listed attribute dimension using the DATACOPY command.
Make sure 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.
Analytic Services tried to FIX on a Dynamic Calc member.
Make sure 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.
The data blocks that were changed by a calculation were left in an inconsistent state.
Stop and restart the database or contact Hyperion Technical Support. Analytic Services either reverted all values to their previous state or retained any values calculated before the error. How Analytic Services handles the cancellation depends on the Analytic Services kernel isolation level settings.
This information message states that the user pressed the cancel button while performing the calculation. Analytic Services either reverted all values to their previous state or retained any values calculated before the cancellation. How Analytic Services handles the cancellation depends on the Analytic Services kernel isolation level settings.
Analytic Services tried to FIX on a dimension that contains no stored members.
Make sure that at least one member in the dimension that the calculation script fixes on is tagged as stored. Make sure that at least one stored member is not tagged as Two Pass.
Analytic Services tried to fix on a member or set of members that do not exist.
Make sure 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, make sure that the function returns at least one member. The following 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
The following calculation script is correct, because Qtr1 is not a level 0 member:
FIX(@CHILDREN (Qtr1)) CALC DIM (Product); ENDFIX
Analytic Services 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.
Your substitution variable name contains more characters than allowed.
Rename the variable so that it does not exceed the allowable number of characters.
You have attempted to process unicode-encoded data in a non-unicode application.
Verify that you have migrated your application to unicode mode.
The listed function needed a left parenthesis (
.
Insert the left parenthesis (
after the function name,
with the function parameters separated by commas, and a closing parenthesis.
Check the syntax of the function.
Analytic Services could not compile the formula attached to the member because of one or more syntax errors.
Check the application log ($ARBORPATH/app/applicationName/applicationName.log
)
for a list of syntax errors. Correct the syntax errors. Check the calculation
script command syntax.
Analytic Services encountered a generation number that was not an integer.
Make sure that all generations are numbered with integers.
Analytic Services encountered a level number that was not an integer.
Make sure that all levels are numbered with integers.
Analytic Services encountered a generation name that is not defined in the database.
Make sure that the generation name is properly defined in the database.
Analytic Services encountered a level name that is not defined in the database.
Make sure that the level name is properly defined in the database.
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, make sure that there is a dimension tagged as accounts in the outline and that the dimension tagged as accounts contains the following members:
The pattern specified in the @MATCH function was not valid.
Check the syntax of the @MATCH function and correct the problem.
Analytic Services encountered a generation or level number or a generation or level name that was not valid.
Make sure that all generations or levels are numbered with integers or valid names. Follow the same rules as for naming members.
Analytic Services could not search for the listed string because it was not enclosed in quotation marks.
Check the syntax of the @MATCH command.
Analytic Services could not open the listed calculation script.
Make sure that Analytic Services can find the calculation script.
Make sure that Analytic Services can use the calculation script.
.csc
.Analytic Services could not read the calculation script.
Make sure that the client is correctly passing the location of the calculation script to Analytic Server.
This information message states how long it took Analytic Services to perform the calculation. There is nothing wrong.
This information message states that Analytic Services is converting the currency type for the listed database. There is nothing wrong.
This information message states that Analytic Services is copying the data from the listed range of cells. There is nothing wrong.
This information message states that Analytic Services is copying the data from the listed range of cells. There is nothing wrong.
This information message states that Analytic Services is clearing the data from the listed partition. There is nothing wrong.
This information message states that Analytic Services is clearing the data from the listed partition. There is nothing wrong.
This information message states that the listed user canceled the calculation before it completed. There is nothing wrong. Analytic Services either reverted all values to their previous state or retained any values calculated before the cancellation. How Analytic Services handles the cancellation depends on the Analytic Services kernel isolation level settings.
This information message states that Analytic Services is clearing the data from the listed partition. There is nothing wrong.
This information message states that Analytic Services is clearing the data from the listed partition. There is nothing wrong.
This information message states that Analytic Services is clearing the data from the upper level data blocks in the listed partition. There is nothing wrong.
This information message states that Analytic Services is clearing the data from the upper level data blocks in the listed partition. There is nothing wrong.
This information message states that Analytic Services is clearing the data from the noninput data blocks in the listed partition. There is nothing wrong.
This information message states that Analytic Services is clearing the data from the noninput data blocks in the listed partition. There is nothing wrong.
Possible Problems
Analytic Services canceled the calculation because it encountered a floating point error, such as overflow, underflow, or a division by zero.
Analytic Services canceled the calculation because it encountered a floating point error, such as overflow, underflow, or a division by zero.
This information message states that Analytic Services is looping through the calculation script commands the listed number of times. There is nothing wrong.
This information message states that Analytic Services completed the loop specified in the calculation script the listed number of times. There is nothing wrong.
This information message states that Analytic Server changed the commit blocks interval to optimize performance. There is nothing wrong.
This information message states that the formula on the listed member requires that the calculation be performed in serial mode instead of parallel mode. There is nothing wrong. To run the calculation in parallel mode, consider removing the formula or tagging the member as Dynamic Calc.
This information message states that the listed dimension contains a dependency that requires the calculation be executed in serial mode instead of parallel mode. There is nothing wrong. To run the calculation in parallel mode, consider removing the formula or tagging the member as Dynamic Calc.
This information message states that calculation will be executed in serial mode instead of parallel mode. Formulas or calculation scripts that use variables with the @XREF function must be calculated in serial mode. There is nothing wrong.
When calculating the listed member, Analytic Services 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 make sure that all values used in the calculation are valid.
Your Analytic Server does not have the currency conversion option.
To use currency conversion functionality, you must purchase the Currency Conversion option for Analytic Services.
This information message states which members Analytic Services is calculating and which members are fixed. There is nothing wrong.
This information message states which members Analytic Services is calculating. There is nothing wrong.
This information message states which members Analytic Services is aggregating and which members are fixed. There is nothing wrong.
This information message states which members Analytic Services is aggregating. There is nothing wrong.
This information message states that Analytic Services is performing a specific action. The information is logged because you requested it. For example, if you use the SET MSG command, specific details about the calculation are logged. There is nothing wrong.
Analytic Services had no more hash memory.
$ARBORPATH/bin/ essbase.cfg
file on the server computer, create one using a text editor.essbase.cfg
file on the server
computer, add or increase the value for CALCHASHTBLMEMORY.This information message states the number of blocks committed at a time. There is nothing wrong.
Analytic Services cannot calculate the @POWER or @FACTORIAL function because the value is too large.
Make sure that the formula or calculation script is not requesting extremely large values, such as 2 raised to the 1 millionth power.
Analytic 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 $ARBORPATH/app/applicationName/applicationName.log
for more information.
See Also
This information message states that Analytic Server is performing the calculations in the calculation script in parallel using the listed number of threads. You can set the number of threads using the CALCPARALLEL configuration setting or the SET CALCPARALLEL calculation script command. If the listed number is different from the value you set using CALCPARALLEL, the calculator picked the listed number as the optimal degree of parallelism for your database. There is nothing wrong.
This information message states the number of tasks that can be executed concurrently at any one time and, therefore, indicates the kind of performance gain you can expect from parallel calculation. Larger numbers indicate more parallel calculation. If the listed number(s) are smaller than the number of threads you specified using the CALCPARALLEL configuration setting or the SET CALCPARALLEL calculation script command, you will not experience a large performance gain from parallel calculation. There is nothing wrong.
This information message states the number of task dimensions Analytic
Services is using for parallel calculation.
If the number of task dimension was reduced from the listed number, the
message will also state that the "Usage of calculator cache caused
reduction in task dimensions." To set the number of task dimensions,
use the CALCPARALLEL
configuration setting or the SET
CALCPARALLEL calculation script command. There is nothing wrong.
This information message states the 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. There is nothing wrong.
This information message states that the calculator cache memory tried
to use more bitmaps than allowed, causing Analytic Services to abort the
calculation. To continue the calculation with more bitmaps, set MULTIPLEBITMAPCHECK
to FALSE in the $ARBORPATH/bin/essbase.cfg
file on the server computer.
This information message states that the calculator cache memory is
using more bitmaps than allowed. To prevent this from happening, set MULTIPLEBITMAPCHECK
to TRUE in the $ARBORPATH/bin/essbase.cfg
file on the server computer.
This information message states the number of bitmaps Analytic Services can use in the calculator cache. There is nothing wrong.
Analytic Services cannot allocate enough blocks to perform the calculation.
Increase the number of blocks that Analytic Services can allocate for a calculation:
$ARBORPATH/bin/ essbase.cfg
file on the
server computer, create one using a text editor.essbase.cfg
file on the server
computer, set CALCLOCKBLOCKHIGH
to 500.Contact Hyperion Technical Support.
Contact Hyperion Technical Support.
Contact Hyperion Technical Support.
Analytic Services could not lock enough blocks to perform the calculation.
Increase the number of blocks that Analytic Services can allocate for a calculation:
$ARBORPATH/bin/essbase.cfg
file on the
server computer, create one using a text editor.essbase.cfg
file on the server
computer, set CALCLOCKBLOCKHIGH
to 500.Contact Hyperion Technical Support.
Analytic Services tried to retrieve the time series data without knowing the latest time period.
Set the latest time period member name in the retrieval tool.
Analytic Services tried to retrieve the latest time period, but the time member is not at level 0 in the outline.
Make sure 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.
This information message states the number of blocks that Analytic Services will need to retrieve to perform the dynamic calculation along a sparse dimension. You can use this to estimate the retrieval performance for members of sparse dimensions that are tagged as Dynamic Calc. There is nothing wrong.
This information message states that Analytic Services is clearing data blocks from the listed partition. There is nothing wrong.
This information message states that Analytic Services is clearing data blocks from the listed partition. There is nothing wrong.
This information message states that the listed member is tagged as Two Pass but not tagged as Dynamic Calc and is not a member of the dimension tagged as accounts. 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. There is nothing wrong.
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.
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 either of the following methods:
Analytic Services encountered a remote partition region that has not been validated.
Open the partition definition and validate it. If necessary, correct any errors.
This information message states whether the bitmap cache is turned on or off. Analytic Server determines whether to turn the bitmap cache on or off; you cannot change this setting. There is nothing wrong.
The latest period setting was at a higher generation than the time series member.
Make sure 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).
Contact Hyperion Technical Support.
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 $ARBORPATH/bin/essbase.cfg
file. To fix this problem:
$ARBORPATH/bin/ essbase.cfg
file on the server computer, create one using a text editor.essbase.cfg
file on the server
computer, increase the value of DYNCALCCACHECOMPRBLKBUFSIZE.essbase.cfg
file on the server
computer, set DYNCALCCACHEWAITFORBLK
and DYNCALCCACHEBLKRELEASE
to FALSE.Analytic Services waited for a block to become available in the Dynamic Calc cache, but the cache was full.
You can solve this problem in any of the following ways:
$ARBORPATH/bin/ essbase.cfg
file on the
server computer, create one using a text editor.essbase.cfg
file on the server
computer, add or increase the value of DYNCALCCACHEBLKTIMEOUT.$ARBORPATH/bin/ essbase.cfg
file on the
server computer, create one using a text editor.essbase.cfg
file on the server
computer, set DYNCALCCACHEWAITFORBLK
to FALSE.Contact Hyperion Technical Support.
This information message states the maximum number of blocks that the Dynamic Calc cache for the listed database can hold. There is nothing wrong. To change the number of blocks in the Dynamic Calc cache:
$ARBORPATH/bin/ essbase.cfg
file on the server computer, create one using a text editor.essbase.cfg
file one the server,
add or change DYNCALCCACHEMAXSIZE.This information message states that Analytic Services will perform the following action when the dynamic calculator cache is full:
essbase.cfg
file is TRUE, Analytic Services waits to store and calculate data blocks
for the current query in the dynamic calculator cache.$ARBORPATH/bin/essbase.cfg
file is FALSE, Analytic Services checks DYNCALCCACHEONLY.
There is nothing wrong.
This information message states the current value of DYNCALCCACHEBLKTIMEOUT. There is nothing wrong.
This information message states that Analytic Services will perform the following action when the specified waiting period is over:
$ARBORPATH/bin/essbase.cfg
file is TRUE, Analytic Services makes room available in the dynamic calculator
cache by temporarily storing inactive blocks in a separate, compressed-block
buffer.$ARBORPATH/bin/essbase.cfg
file is FALSE, Analytic Services does not find room in the dynamic calculator
cache for a different set of blocks. Instead, Analytic Services checks
DYNCALCCACHEONLY .There is nothing wrong.
This information message states the current value of DYNCALCCACHECOMPRBLKBUFSIZE. There is nothing wrong.
This information message states the current value of DYNCALCCACHEONLY is TRUE. There is nothing wrong.
This information message states that the listed member was skipped during Two Pass calculation because the listed member has no member formula or the listed member has a run-time dependency. Run-time dependent functions include: @CURRMBR, @PARENT, @PARENTVAL, @MDPARENTVAL, @ANCEST, @ANCESTVAL, and @MDANCESTVAL. There is nothing wrong.
Analytic Services cannot update cells that are part of a relational partition.
Make sure that none of the cells being updated is part of a relational partition.