Advantage 33xx Error Codes

Advantage Error Guide

3301 Incomplete index while expression
3302 Incorrect parameter count within a function call in index while expression
3303 Missing string delimiter in index while expression
3304 Literal value too long in index while expression
3305 Unsupported data type value in index while expression
3306 Unsupported operator found in index while expression
3307 Unsupported function found in index while expression
3308 Invalid delimiter in function parameter in index while expression
3309 Unsupported data type in function parameter in index while expression
3310 Unknown alias name used with field name in index while expression
3311 Unknown identifier found in index while expression
3314 Advantage Expression Engine memory allocation failed
3315 Invalid field type found in index while expression
3316 Advantage Expression Engine operator stack overflow
3317 Number of index while expression parameters exceed the capability of the parser
3318 Mismatched number of parentheses in the index while expression
3319 Parser working stack is about to overflow
3322 Advantage server thread's working stack about to overflow
3323 Missing index while expression string

3301 Incomplete index while expression

An error occurred in the Advantage Expression Engine parser. The error was in the index While expression.

Problem 1: The expression is invalid. The expression may be invalid due to an extra right paren(s) plus possible other invalid text following that parenthesis. The expression may also be invalid to an extra, illegal comma placed within the expression plus possible other invalid text following that comma.

Solution 1: Delete any indexes that have an invalid expression and rebuild the index with a valid index expression.

Problem 2: The parse finished but the expression was incomplete.

Solution 2: If Solution 1 above does not solve the problem and the error persists, contact Advantage Technical Support and send in a small re-creation.

3302 Incorrect parameter count within a function call in index while expression

Problem: An error occurred in the Advantage Expression Engine parser. A function in the index while expression contained too few or too many parameters.

Solution: Review the function calls within the index while expression to correct the number of parameters within the function call in error.

3303 Missing string delimiter in index while expression

Problem: An error occurred in the Advantage Expression Engine parser. A string in the index while expression is missing a delimiter.

Solution: Add a string delimiter (″) to the string that is missing the delimiter within the index while expression.

3304 Literal value too long in index while expression

Problem: An error occurred in the Advantage Expression Engine parser. A literal value in the index while expression is longer than 32K.

Solution: Use literal values less than 32K in length within the index while expression.

3305 Unsupported data type value in index while expression

Problem: An error occurred in the Advantage Expression Engine parser. A value in the index while expression is not a supported data type.

Solution: Contact Advantage Technical Support if this error occurs.

3306 Unsupported operator found in index while expression

Problem: An error occurred in the Advantage Expression Engine parser. The index while expression contains an unsupported operator.

Solution: Verify operators in the expression are valid client operators that are supported by the Advantage Expression Engine.

3307 Unsupported function found in index while expression

Problem: An error occurred in the Advantage Expression Engine parser. The index while expression contains an unsupported function.

Solution: Verify the function names are not misspelled and are supported by the Advantage Expression Engine. For a list of all supported, see Advantage Expression Engine.

3308 Invalid delimiter in function parameter in index while expression

Problem: An error occurred in the Advantage Expression Engine parser. Parameters to a function within the while expression are separated by an invalid delimiter.

Solution: Verify the delimiters separating parameters within a function call in the expression are valid.

3309 Unsupported data type in function parameter in index while expression

Problem: An error occurred in the Advantage Expression Engine parser. A parameter to a function or an operand within the key expression was of the wrong data type.

Solution: Verify the data types of the function parameters are of the correct data type.

3310 Unknown alias name used with field name in index while expression

Problem: An error occurred in the Advantage Expression Engine parser. A field name within the expression was aliased by an unknown alias name.

Solution: Advantage only supports aliases for the current work area. If an alias to another work area is referenced, this error will result. Verify the alias name is spelled properly.

3311 Unknown identifier found in index while expression

Problem: An error occurred in the Advantage Expression Engine parser. An identifier within the while expression is unknown to the parser.

Solution: This error is usually caused by the use of memory variables within the while expression. Memory variables are not supported by the Advantage Expression Engine as the variables are visible only to the client. This error may also result from a misspelled field name or from a field name that does not exist in the current work area.

3314 Advantage Expression Engine memory allocation failed

Problem: An error occurred in the Advantage Expression Engine parser. A memory allocation failed.

Solution: If this error occurs, retry the command. If this error repeatedly occurs, more memory is needed on the server.

3315 Invalid field type found in index while expression

Problem: An error occurred in the Advantage Expression Engine parser. The index while expression contained an invalid field type.

Solution: This error is most likely due to the use of a memo field within the while expression. Memo fields are not supported by the Advantage Expression Engine parser.

3316 Advantage Expression Engine operator stack overflow

Problem: An error occurred in the Advantage Expression Engine parser. The internal stack has exceeded the maximum number of operators.

Solution: This is most likely due to the index while expression containing an unusually high number of operators. Contact Advantage Technical Support.

3317 Number of index while expression parameters exceed the capability of the parser

Problem: An error occurred in the Advantage Expression Engine parser. The while expression contained too many parameters for the parser to handle.

Solution: Contact Advantage Technical Support.

3318 Mismatched number of parentheses in the index while expression

Problem: An error occurred in the Advantage Expression Engine parser. The while expression contains a mismatched number of parentheses.

Solution: Verify the parentheses are matched and are in the correct position.

3319 Parser working stack is about to overflow

Problem: An error occurred in the Advantage Expression Engine parser. The parser working stack was about to overflow.

Solution: This error is due to an extraordinarily large index while expression. Contact Advantage Technical Support.

3322 Advantage server thread's working stack about to overflow

Problem: An error occurred in the Advantage Expression Engine parser. The Advantage server thread's working stack was about to overflow. The problem is most likely due to an expression with a very large nesting of parentheses (hundreds of levels deep). This can occur when evaluating an Advantage Optimized Filter expression with a large number of OR operators on fields that are not indexed. It can also occur when evaluating the IN clause of an SQL statement on a field that is not indexed. For example, a query of the form "select * from T where F in (1, 2, 3, 4, .... 3000 )" could produce a very deep nesting if the field "F" is not indexed.

Solution: Either reduce the number of items in the filter or query, or create an index on the field so that it is fully optimized.

3323 Missing index while expression string

Problem: The user attempted to build an index on the server containing a while clause, but the application does not have an Advantage header file included in the source code. The while expression string could get passed to the Advantage server.

Solution: Include an appropriate Advantage header file in the application.