Codes 4xxx

Advantage Error Guide

Contents

• 4000 General Advantage Expression Engine evaluator error code. Refer to associated specific Error Code for more information.
• 4004 Advantage Expression Engine evaluator stack overflow
• 4009 Unsupported data type in evaluated index key expression
• 4012 Invalid date evaluated in index key expression
• 4013 Invalid Julian date evaluated in index key expression
• 4017 Number of index key expression parameters exceed the capability of the evaluator
• 4019 Evaluator working stack is about to overflow
• 4020 Division by zero in index key expression
• 4025 Unknown collation
• 4104 Advantage Expression Engine evaluator stack overflow
• 4109 Unsupported data type in evaluated record filter expression
• 4112 Invalid date evaluated in record filter expression
• 4113 Invalid Julian date evaluated in record filter expression
• 4117 Number of record filter expression parameters exceed the capability of the evaluator
• 4119 Evaluator working stack is about to overflow
• 4120 Division by zero in record filter expression
• 4124 String Collation Error
• 4204 Advantage Expression Engine evaluator stack overflow
• 4209 Unsupported data type in evaluated conditional index expression
• 4212 Invalid date evaluated in conditional index expression
• 4213 Invalid Julian date evaluated in the conditional index expression
• 4217 Number of conditional index expression parameters exceed the capability of the evaluator
• 4219 Evaluator working stack is about to overflow
• 4220 Division by zero in conditional index expression
• 4304 Advantage Expression Engine evaluator stack overflow
• 4309 Unsupported data type in evaluated index while expression
• 4312 Invalid date evaluated in index while expression
• 4313 Invalid Julian date evaluated in index while expression
• 4317 Number of index while expression parameters exceed the capability of the evaluator
• 4319 Evaluator working stack is about to overflow
• 4320 Division by zero in index while expression

4000 General Advantage Expression Engine evaluator error code. Refer to associated specific Error Code for more information.

4004 Advantage Expression Engine evaluator stack overflow

Problem: An error occurred in the Advantage Expression Engine evaluator. The result of the parsed index key expression is too long to fit on the internal evaluator stack.

Solution: 4004 errors are typically caused by modifying a table's structure without deleting and re-building the index. 4004 errors are also caused by variable length index keys being created, often as a result of using a TRIM function in the index expression without using a PAD function.

Problem: A string literal specified in the Advantage Optimized Filter expression is too long.

Solution: 4004 error can be caused by a string literal value that is longer than 4KB. Such expression cannot be evaluated by the Advantage expression engine.

4009 Unsupported data type in evaluated index key expression

Problem: An error occurred in the Advantage Expression Engine evaluator. The data type of the result of the evaluated expression was not a supported type.

Solution: Contact Advantage Technical Support.

4012 Invalid date evaluated in index key expression

Problem: An error occurred in the Advantage Expression Engine evaluator. The expression contains an invalid date value. The invalid date will be replaced by an empty date.

Solution: Verify the date values are correct.

4013 Invalid Julian date evaluated in index key expression

Problem: An error occurred in the Advantage Expression Engine evaluator. The expression contains an invalid Julian date value. The invalid date will be replaced by an empty date.

Solution: Verify the date values are correct.

4017 Number of index key expression parameters exceed the capability of the evaluator

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

Solution: Contact Advantage Technical Support.

4019 Evaluator working stack is about to overflow

Problem: An error occurred in the Advantage Expression Engine evaluator. The evaluator working stack was about to overflow. This error is due to an extraordinarily large index key expression.

Solution: Contact Advantage Technical Support.

4020 Division by zero in index key expression

Problem: An error occurred in the Advantage Expression Engine evaluator. A division or modulus operation contained a division by zero.

Solution: Verify the divisor will not result in a zero.

4025 Unknown collation

Problem: Collation language specified in a call to the collate function was unknown.

Solution: Verify the language specified is supported. See collate function definition.

4104 Advantage Expression Engine evaluator stack overflow

Problem: An error occurred in the Advantage Expression Engine evaluator. The result of the parsed record filter expression is too long to fit on the internal evaluator stack.

Solution: Verify that the expression result does not exceed 4196 bytes. If you are using a CONTAINS() (full text search) condition, verify that the search condition does not exceed 4196 characters.

4109 Unsupported data type in evaluated record filter expression

Problem: An error occurred in the Advantage Expression Engine evaluator. The data type of the result of the evaluated expression was not a supported type.

Solution: Contact Advantage Technical Support.

4112 Invalid date evaluated in record filter expression

Problem: An error occurred in the Advantage Expression Engine evaluator. The expression contains an invalid date value. The invalid date will be replaced by an empty date.

Solution: Verify the date values are correct.

4113 Invalid Julian date evaluated in record filter expression

Problem: An error occurred in the Advantage Expression Engine evaluator. The expression contains an invalid Julian date value. The invalid date will be replaced by an empty date.

Solution: Verify the date values are correct.

4117 Number of record filter expression parameters exceed the capability of the evaluator

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

Solution: Contact Advantage Technical Support.

4119 Evaluator working stack is about to overflow

Problem: An error occurred in the Advantage Expression Engine evaluator. The evaluator working stack was about to overflow. This error is due to an extraordinarily large record filter expression.

Solution: Contact Advantage Technical Support.

4120 Division by zero in record filter expression

Problem: An error occurred in the Advantage Expression Engine evaluator. A division or modulus operation contained a division by zero.

Solution: Verify the divisor will not result in a zero.

4124 String Collation Error

Problem: Result of an expression was a string with an undetermined collation.

Solution: Coerce the result to a specific collation using the collate function.

4204 Advantage Expression Engine evaluator stack overflow

Problem: An error occurred in the Advantage Expression Engine evaluator. The result of the parsed conditional index expression is too long to fit on the internal evaluator stack.

Solution: Contact Advantage Technical Support.

4209 Unsupported data type in evaluated conditional index expression

Problem: An error occurred in the Advantage Expression Engine evaluator. The data type of the result of the evaluated expression was not a supported type.

Solution: Contact Advantage Technical Support.

4212 Invalid date evaluated in conditional index expression

Problem: An error occurred in the Advantage Expression Engine evaluator. The expression contains an invalid date value. The invalid date will be replaced by an empty date.

Solution: Verify the date values are correct.

4213 Invalid Julian date evaluated in the conditional index expression

Problem: An error occurred in the Advantage Expression Engine evaluator. The expression contains an invalid Julian date value. The invalid date will be replaced by an empty date.

Solution: Verify the date values are correct.

4217 Number of conditional index expression parameters exceed the capability of the evaluator

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

Solution: Contact Advantage Technical Support.

4219 Evaluator working stack is about to overflow

Problem: An error occurred in the Advantage Expression Engine evaluator. The evaluator working stack was about to overflow. This error is due to an extraordinarily large conditional index expression.

Solution: Contact Advantage Technical Support.

4220 Division by zero in conditional index expression

Problem: An error occurred in the Advantage Expression Engine evaluator. A division or modulus operation contained a division by zero.

Solution: Verify the divisor will not result in a zero.

4304 Advantage Expression Engine evaluator stack overflow

Problem: An error occurred in the Advantage Expression Engine evaluator. The result of the parsed index while expression is too long to fit on the internal evaluator stack.

Solution: Contact Advantage Technical Support.

4309 Unsupported data type in evaluated index while expression

Problem: An error occurred in the Advantage Expression Engine evaluator. The data type of the result of the evaluated expression was not a supported type.

Solution: Contact Advantage Technical Support.

4312 Invalid date evaluated in index while expression

Problem: An error occurred in the Advantage Expression Engine evaluator. The expression contains an invalid date value. The invalid date will be replaced by an empty date.

Solution: Verify the date values are correct.

4313 Invalid Julian date evaluated in index while expression

Problem: An error occurred in the Advantage Expression Engine evaluator. The expression contains an invalid Julian date value. The invalid date will be replaced by an empty date.

Solution: Verify the date values are correct.

4317 Number of index while expression parameters exceed the capability of the evaluator

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

Solution: Contact Advantage Technical Support.

4319 Evaluator working stack is about to overflow

Problem: An error occurred in the Advantage Expression Engine evaluator. The evaluator working stack was about to overflow. This error is due to an extraordinarily large index while expression.

Solution: Contact Advantage Technical Support.

4320 Division by zero in index while expression

Problem: An error occurred in the Advantage Expression Engine evaluator. A division or modulus operation contained a division by zero.

Solution: Verify the divisor will not result in a zero.