Advantage 35xx Error Codes
Advantage Error Guide
Contents
3501 Incomplete expression 3502 Incorrect parameter count within a function call in expression 3503 Missing string delimiter in expression 3504 Literal value too long in expression 3505 Unsupported data type value in expression 3506 Unsupported operator found in expression 3507 Unsupported function found in expression 3508 Invalid delimiter in function parameter in expression 3509 Unsupported data type in function parameter in expression 3510 Unknown alias name used with field name in expression 3511 Unknown identifier found in expression 3514 Advantage Expression Engine memory allocation failed 3515 Invalid field type found in expression 3516 Advantage Expression Engine operator stack overflow 3517 Number of expression parameters exceed the capability of the parser 3518 Mismatched number of parentheses in the expression 3519 Parser working stack is about to overflow 3521 Advantage Expression Engine is not being used 3522 Advantage server thread's working stack about to overflow
3501 Incomplete expression
An error occurred in the Advantage Expression Engine parser. The error was in the 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 expression.
Problem 2: The parse finished but the expression was incomplete.
Solution 2: If Solution 1 above does not solve the problem and this error persists, contact Advantage Technical Support and send in a small re-creation.
3502 Incorrect parameter count within a function call in expression
Problem: An error occurred in the Advantage Expression Engine parser. A function in the expression contained too few or too many parameters.
Solution: Review the function calls within the expression to correct the number of parameters within the function call in error.
3503 Missing string delimiter in expression
Problem: An error occurred in the Advantage Expression Engine parser. A string in the expression is missing a delimiter.
Solution: Add a string delimiter (″) to the string that is missing the delimiter within the expression.
3504 Literal value too long in expression
Problem: An error occurred in the Advantage Expression Engine parser. A literal value in the expression is longer than 32K.
Solution: Use literal values less than 32K in length within the expression.
3505 Unsupported data type value in expression
Problem: An error occurred in the Advantage Expression Engine parser. A value in the expression is not a supported data type.
Solution: Contact Advantage Technical Support if this error occurs.
3506 Unsupported operator found in expression
Problem: An error occurred in the Advantage Expression Engine parser. The expression contains an unsupported operator.
Solution: Verify operators in the expression are valid client operators that are supported by the Advantage Expression Engine.
3507 Unsupported function found in expression
Problem: An error occurred in the Advantage Expression Engine parser. The 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.
3508 Invalid delimiter in function parameter in expression
Problem: An error occurred in the Advantage Expression Engine parser. Parameters to a function within the expression are separated by an invalid delimiter.
Solution: Verify the delimiters separating parameters within a function call in the expression is valid.
3509 Unsupported data type in function parameter in 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.
3510 Unknown alias name used with field name in 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.
3511 Unknown identifier found in expression
Problem: An error occurred in the Advantage Expression Engine parser. An identifier within the expression is unknown to the parser.
Solution: This error is usually caused by the use of memory variables within the 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.
3514 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.
3515 Invalid field type found in expression
Problem: An error occurred in the Advantage Expression Engine parser. The expression contained an invalid field type.
Solution: This error is most likely due to the use of a memo field within the expression. Memo fields are not supported by the Advantage Expression Engine parser.
3516 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 expression containing an unusually high number of operators. Contact Advantage Technical Support.
3517 Number of expression parameters exceed the capability of the parser
Problem: An error occurred in the Advantage Expression Engine parser. The expression contained too many parameters for the parser to handle.
Solution: Contact Advantage Technical Support.
3518 Mismatched number of parentheses in the expression
Problem: An error occurred in the Advantage Expression Engine parser. The expression contains a mismatched number of parentheses.
Solution: Verify the parentheses are matched and are in the correct position.
3519 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 expression. Contact Advantage Technical Support.
3521 Advantage Expression Engine is not being used
Problem: An error occurred in the Advantage Expression Engine parser. The engine is not being used to build an index.
Solution: This error is returned to indicate the Expression Engine has been disabled by the SET EXPRESSION ENGINE command. Turn the Expression Engine ON or ignore this error.
3522 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.