# Advantage 32xx Error Codes *Advantage Error Guide* ## Contents - [3201 Incomplete conditional index expression](#3201-incomplete-conditional-index-expression) - [3202 Incorrect parameter count within a function call in conditional index expression](#3202-incorrect-parameter-count-within-a-function-call-in-conditional-index-expression) - [3203 Missing string delimiter in conditional index expression](#3203-missing-string-delimiter-in-conditional-index-expression) - [3204 Literal value too long in conditional index expression](#3204-literal-value-too-long-in-conditional-index-expression) - [3205 Unsupported data type value in conditional index expression](#3205-unsupported-data-type-value-in-conditional-index-expression) - [3206 Unsupported operator found in conditional index expression](#3206-unsupported-operator-found-in-conditional-index-expression) - [3207 Unsupported function found in conditional index expression](#3207-unsupported-function-found-in-conditional-index-expression) - [3208 Invalid delimiter in function parameter in conditional index expression](#3208-invalid-delimiter-in-function-parameter-in-conditional-index-expression) - [3209 Unsupported data type in function parameter in conditional index expression](#3209-unsupported-data-type-in-function-parameter-in-conditional-index-expression) - [3210 Unknown alias name used with field name in conditional index expression](#3210-unknown-alias-name-used-with-field-name-in-conditional-index-expression) - [3211 Unknown identifier found in conditional index expression](#3211-unknown-identifier-found-in-conditional-index-expression) - [3214 Advantage Expression Engine memory allocation failed](#3214-advantage-expression-engine-memory-allocation-failed) - [3215 Invalid field type found in conditional index expression](#3215-invalid-field-type-found-in-conditional-index-expression) - [3216 Advantage Expression Engine operator stack overflow](#3216-advantage-expression-engine-operator-stack-overflow) - [3217 Number of conditional index expression parameters exceed the capability of the parser](#3217-number-of-conditional-index-expression-parameters-exceed-the-capability-of-the-parser) - [3218 Mismatched number of parentheses in the conditional index expression](#3218-mismatched-number-of-parentheses-in-the-conditional-index-expression) - [3219 Parser working stack is about to overflow](#3219-parser-working-stack-is-about-to-overflow) - [3222 Advantage server thread's working stack about to overflow](#3222-advantage-server-thread-s-working-stack-about-to-overflow) ## 3201 Incomplete conditional index expression {#3201-incomplete-conditional-index-expression} An error occurred in the Advantage Expression Engine parser. The error was in the conditional index 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. ## 3202 Incorrect parameter count within a function call in conditional index expression {#3202-incorrect-parameter-count-within-a-function-call-in-conditional-index-expression} ***Problem:*** An error occurred in the Advantage Expression Engine parser. A function in the conditional index expression contained too few or too many parameters. ***Solution:*** Review the function calls within the conditional index expression to correct the number of parameters within the function call in error. ## 3203 Missing string delimiter in conditional index expression {#3203-missing-string-delimiter-in-conditional-index-expression} ***Problem:*** An error occurred in the Advantage Expression Engine parser. A string in the conditional index expression is missing a delimiter. ***Solution:*** Add a string delimiter (″) to the string that is missing the delimiter within the conditional index expression. ## 3204 Literal value too long in conditional index expression {#3204-literal-value-too-long-in-conditional-index-expression} ***Problem***: An error occurred in the Advantage Expression Engine parser. A literal value in the conditional index expression is longer than 32K. ***Solution***: Use literal values less than 32K in length within the conditional index expression. ## 3205 Unsupported data type value in conditional index expression {#3205-unsupported-data-type-value-in-conditional-index-expression} ***Problem:*** An error occurred in the Advantage Expression Engine parser. A value in the conditional index expression is not a supported data type. ***Solution:*** Contact Advantage Technical Support if this error occurs. ## 3206 Unsupported operator found in conditional index expression {#3206-unsupported-operator-found-in-conditional-index-expression} ***Problem:*** An error occurred in the Advantage Expression Engine parser. The conditional index expression contains an unsupported operator. ***Solution:*** Verify operators in the expression are valid client operators that are supported by the Advantage Expression Engine. ## 3207 Unsupported function found in conditional index expression {#3207-unsupported-function-found-in-conditional-index-expression} ***Problem:*** An error occurred in the Advantage Expression Engine parser. The conditional index 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. ## 3208 Invalid delimiter in function parameter in conditional index expression {#3208-invalid-delimiter-in-function-parameter-in-conditional-index-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 are valid. ## 3209 Unsupported data type in function parameter in conditional index expression {#3209-unsupported-data-type-in-function-parameter-in-conditional-index-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. ## 3210 Unknown alias name used with field name in conditional index expression {#3210-unknown-alias-name-used-with-field-name-in-conditional-index-expression} ***Problem:*** An error occurred in the Advantage Expression Engine parser. A field name within the conditional index 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. ## 3211 Unknown identifier found in conditional index expression {#3211-unknown-identifier-found-in-conditional-index-expression} ***Problem:*** An error occurred in the Advantage Expression Engine parser. An identifier within the conditional index expression is unknown to the parser. ***Solution:*** This error is usually caused by the use of memory variables within the conditional index 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. ## 3214 Advantage Expression Engine memory allocation failed {#3214-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. ## 3215 Invalid field type found in conditional index expression {#3215-invalid-field-type-found-in-conditional-index-expression} ***Problem:*** An error occurred in the Advantage Expression Engine parser. The conditional index expression contained an invalid field type. ***Solution:*** This error is most likely due to the use of a memo field within the conditional index expression. Memo fields are not supported by the Advantage Expression Engine parser. ## 3216 Advantage Expression Engine operator stack overflow {#3216-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 conditional index expression containing an unusually high number of operators. Contact Advantage Technical Support. ## 3217 Number of conditional index expression parameters exceed the capability of the parser {#3217-number-of-conditional-index-expression-parameters-exceed-the-capability-of-the-parser} ***Problem:*** An error occurred in the Advantage Expression Engine parser. The conditional index expression contained too many parameters for the parser to handle. ***Solution:*** Contact Advantage Technical Support. ## 3218 Mismatched number of parentheses in the conditional index expression {#3218-mismatched-number-of-parentheses-in-the-conditional-index-expression} ***Problem:*** An error occurred in the Advantage Expression Engine parser. The conditional index expression contains a mismatched number of parentheses. ***Solution:*** Verify the parentheses are matched and are in the correct position. ## 3219 Parser working stack is about to overflow {#3219-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 conditional index expression. Contact Advantage Technical Support. ## 3222 Advantage server thread's working stack about to overflow {#3222-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. *[PO]: Purchase Order *[AZA]: local folder *[(PO]: Purchase Order *[RQ]: Requisition *[(RQ]: Requisition *[RfQ]: Request for Quotation *[(RfQ]: Request for Quotation *[SO]: Service Order *[(SO]: Service Order *[SQ]: Service Requisition *[(SQ]: Service Requisition *[SRfQ]: Service Request for Quotation *[OoB]: Open on Board *[(OoB]: Open on Board *[ART]: Average Running Time (operation hours per day) *[MC]: Master Contract *[ADS]: Advantage Database Server (database engine used in previous versions of the ZeeBORN software) *[.replic]: file extension for replication files (aka data transfer files)