42 JZN-00000 to JZN-00499

JZN-00000: Normal, successful completion

Cause: The operation completed successfully.

Action: No action required.

JZN-00001: End of input

Cause: Processing has reached the end of available input.

Action: No action required.

JZN-00002: Invalid argument

Cause: The input argument was not a buffer, file, or stream.

Action: This is a programming error by the caller of the JavaScript Object Notation (JSON) facility. Contact Oracle Support Services.

JZN-00003: Input not specified

Cause: A parse or decode operation was requested without specifying input.

Action: Specify a buffer, file, or stream as input before attempting to parse or decode the input.

JZN-00004: Cannot open input file

Cause: The requested input file could not be found, or was not readable.

Action: Ensure that the file exists and that read permission is available.

JZN-00005: Syntax error

Cause: The JavaScript Object Notation (JSON) parser encountered syntactically invalid JSON.

Action: Correct the JSON input document.

JZN-00006: Invalid escape sequence

Cause: The JavaScript Object Notation (JSON) parser encountered an invalid sequence of characters following a backslash character.

Action: Correct the JSON input and remove or correct the invalid escape sequence.

JZN-00007: Object member key is not unique

Cause: The JavaScript Object Notation (JSON) parser detected a duplicate member key.

Action: Correct the JSON input and remove the duplicate key.

JZN-00008: Parse already in progress

Cause: An attempt was made to begin parsing an input while a parsing operation was already in progress.

Action: Close the previous parsing operation before beginning a new one.

JZN-00009: Unsupported encoding

Cause: The requested character encoding was not supported by JavaScript Object Notation (JSON).

Action: Convert the input to Unicode.

JZN-00010: Invalid byte sequence in character data

Cause: The parser encountered a sequence of bytes that were invalid for the specified character set.

Action: Correct the input source or ensure that the character encoding is correctly specified.

JZN-00011: Error reading input

Cause: An I/O error was encountered while reading input for parsing or decoding.

Action: None

JZN-00012: Premature end of input

Cause: The parser or decoder encountered the end of the input source while still expecting more data.

Action: None

JZN-00013: Stack overflow

Cause: The internal depth limit on the JavaScript Object Notation (JSON) hierarchy of containers (which may be objects, arrays, or both) was exceeded during a Document Object Model (DOM) read or write operation.

Action: None

JZN-00014: Stack underflow

Cause: An event sequence to render the JavaScript Object Notation (JSON) included a closing event for an unknown object or array.

Action: The input source is bad, likely due to a programming error.

JZN-00015: Name too long

Cause: The JavaScript Object Notation (JSON) parser encountered a member key name that exceeded the internal maximum.

Action: Parse the input without duplicate key checks.

JZN-00016: Serializer stream error

Cause: An I/O error was encountered while writing to the output stream.

Action: None

JZN-00017: Serializer buffer error

Cause: The data overflowed the fixed-size output buffer.

Action: Specify a larger output buffer consistent with the input supplied.

JZN-00018: Input to serializer is too large

Cause: The data overflowed the fixed-size output buffer.

Action: Specify a larger output buffer consistent with the input supplied.

JZN-00019: Cannot print without array wrapper

Cause: The result of the JavaScript Object Notation (JSON) expression could not be rendered without an array wrapper.

Action: If the expression results in a sequence of multiple results, the array wrapper option is required.

JZN-00020: Empty result

Cause: The path expression resulted in a null result.

Action: None

JZN-00021: Value to be printed was not scalar

Cause: An operation requested a scalar value, but the selected value was an object, array, or sequence and could not be returned.

Action: None

JZN-00022: Extra data after end of input

Cause: Additional data bytes were encountered after the expected end of input.

Action: None

JZN-00023: Length does not match data

Cause: The binary decoder encountered a data length that exceeded or did not match the actual data value.

Action: The input is corrupt.

JZN-00024: Unrecognized data type or code

Cause: The binary decoder encountered an unrecognized operation code.

Action: The input is corrupt.

JZN-00025: Invalid binary data

Cause: The binary decoder encountered invalid or inconsistent data while reading the input.

Action: The input is corrupt.

JZN-00026: Too many levels of nesting

Cause: The internal depth limit on the JavaScript Object Notation (JSON) hierarchy of containers (which may be objects, arrays, or both) was exceeded.

Action: None

JZN-00027: Internal error

Cause: An internal error occurred in the code.

Action: Contact Oracle Support Services.

JZN-00028: Out of memory

Cause: The operating system ran out of memory.

Action: Increase the memory available to the program.

JZN-00029: Data member too large

Cause: A data value in a Document Object Model (DOM) was too large to be encoded in binary form.

Action: None

JZN-00030: NULL pointer for required context

Cause: A NULL pointer was detected as an internal error condition.

Action: This is a programming error by the caller of the JavaScript Object Notation (JSON) facility. Contact Oracle Support Services.

JZN-00031: Invalid path expression

Cause: The JavaScript Object Notation (JSON) path expression could not be successfully parsed.

Action: Correct the invalid syntax.

JZN-00032: Invalid array position in path expression

Cause: The specified array position was invalid.

Action: Array positions must be non-negative integers.

JZN-00033: Invalid order of array indexes

Cause: In a comma-delimited set of array indexes, the array indexes were in descending order.

Action: Correct the array indexes so that they appear in ascending order.

JZN-00034: Field name too long

Cause: The field name exceeded 256 bytes.

Action: Select a shorter name for the field.

JZN-00035: Total field names too long

Cause: The total length of all field names exceeded the 65536 byte limit.

Action: None

JZN-00036: Array position out of bounds

Cause: An attempt was made to access an element outside of the array bounds.

Action: None

JZN-00037: Invalid number

Cause: The string could not be interpreted as a numeric value.

Action: None

JZN-00038: Invalid date/time

Cause: The string could not be interpreted as a date or date/time.

Action: The data/time string must be in accordance with ISO-8601.

JZN-00039: Size overflow for JSON set encoding

Cause: The total size of the JavaScript Object Notation (JSON) objects exceeded the maximum allowed for JSON set-oriented storage.

Action: None

JZN-00040: Invalid specification

Cause: The Query-By-Example (QBE) specification was invalid.

Action: Correct the specification.

JZN-00041: JSON Patch operation could not be completed

Cause: The JavaScript Object Notation (JSON) Patch operation encountered an infeasible operation and could not be completed.

Action: None

JZN-00042: Modification not allowed on read-only object

Cause: Read-only JavaScript Object Notation (JSON) objects could not be modified by Document Object Model (DOM) operations.

Action: This is a programming error. Correct the error by copying the DOM to a read/write DOM and then executing the modification.

JZN-00043: Feature not implemented

Cause: This feature was not implemented yet.

Action: None

JZN-00044: Type conversion failed

Cause: A type conversion requested for JavaScript Object Notation (JSON) Path output could not be performed.

Action: None

JZN-00045: Invalid sequence of events

Cause: The JavaScript Object Notation (JSON) serializer encountered an incorrect event sequence and could not serialize the result.

Action: This is a programming error by the caller of the JSON facility. Contact Oracle Support Services.

JZN-00046: Requested key does not exist

Cause: An attempt was made to read a key from a Document Object Model (DOM) object node, but the key was not present in the DOM object node.

Action: This is a programming error.

JZN-00047: Cyclic reference to DOM node is not allowed

Cause: A Document Object Model (DOM) node could not be inserted below one of its own descendant nodes.

Action: This is a programming error.

JZN-00048: Multiple references to DOM node are not allowed

Cause: A Document Object Model (DOM) node could not be inserted because it is already present in the document node tree.

Action: This is a programming error.

JZN-00049: Input to JSON parser is empty

Cause: The input provided to the JSON parser was empty.

Action: This is an internal error message not visible to user.

JZN-00050: Character set conversion failed

Cause: The string could not be converted to or from UTF-8.

Action: This is an internal error message not visible to user.

JZN-00051: Invalid regular expression

Cause: The string supplied to 'eq_regex' or 'like_regex' could not be interpreted as a regular expression.

Action: Correct the expression.

JZN-00052: no cached value found for this column

Cause: Internal code signals that a call to get a JSON_TABLE column value found no pre-generated value in the cache.

Action: Call the generation function to get and cache the value.

JZN-00053: target of DOM operation must be an object node

Cause: A DOM operation that requires an object node was given an array or scalar node as the target.

Action: Correct the code to use an operation appropriate to the node type.

JZN-00054: target of DOM operation must be an array node

Cause: A DOM operation that requires an array node was given an object or scalar node as the target.

Action: Correct the code to use an operation appropriate to the node type.

JZN-00055: target of DOM operation is not scalar

Cause: A DOM operation that requires a scalar node was given an object object or array node as the target.

Action: Correct the code to use an operation appropriate to the node type.

JZN-00056: numeric overflow

Cause: A string representaion of a number was too large to be converted to an Oracle number.

Action: Use a smaller number or do not convert to Oracle number format.

JZN-00057: cannot convert BOOLEAN value to number

Cause: An attempt was made to convert a BOOLEAN value that was selected by a JavaScript Object Notation (JSON path) expression to a number with a number() or numberOnly() function.

Action: Remove the number()/numberOnly() function from the JSON path expression.

JZN-00058: JavaScript Object Notation (JSON) value is scalar

Cause: A scalar JavaScript Object Notation value was encountered where a non-scalar value (JSON object or JSON array) was expected.

Action: Check the JSON data or SQL or JSON operation.

JZN-00059: invalid scalar data type

Cause: The input scalar data type could not be processed by the JSON operator.

Action: Cast or convert the scalar value to a data type supported by the JSON operator.

JZN-00060: The specified node is a freed node.

Cause: The input node to a Document Object Model (DOM) operation was previously freed and could be used again.

Action: Ensure that your program is not using stale pointer references.

JZN-00061: operation not allowed

Cause: The Document Object Model (DOM) operation was not allowed. Operations that remove, unlink, rename, replace, or move DOM nodes were not allowed.

Action: Avoid disallowed operations and duplicated field names.

JZN-00070: comma not preceded or followed by field or item

Cause: An unexpected or superfluous comma was encountered while parsing an object or array.

Action: This is an error in the JavaScript Object Notation (JSON) input.

JZN-00071: missing comma in object or array

Cause: A comma was expected between members of an object, or between items in an array.

Action: This is an error in the JavaScript Object Notation (JSON) input.

JZN-00072: object member is missing value

Cause: An object member name and colon was not followed by a member value.

Action: This is an error in the JavaScript Object Notation (JSON) input.

JZN-00073: missing colon in member:value pair

Cause: An object member name was not followed by a colon.

Action: This is an error in the JavaScript Object Notation (JSON) input.

JZN-00074: member name not enclosed in double quotation marks

Cause: An object member name was not enclosed in double quotation marks, and either contained or started with a character that was not allowed.

Action: This is an error in the JavaScript Object Notation (JSON) input.

JZN-00075: string value not enclosed in double quotation marks

Cause: A string value was not enclosed in double quotation marks.

Action: This is an error in the JavaScript Object Notation (JSON) input.

JZN-00076: number could not be parsed

Cause: A JavaScript Object Notation (JSON) number was encountered that

Action: This is an error in the JSON input.

JZN-00077: invalid ASCII control character

Cause: An invalid byte value was read from the JavaScript Object Notation (JSON) input. ASCII control characters are not allowed in JSON text.

Action: This is an error in the JSON input.

JZN-00078: Invalid JSON keyword '~s'

Cause: A literal value was encountered that could not be interpreted as a JSON literal. Allowed JSON literals are 'true', 'false', and 'null'.

Action: This is an error in the JSON input.

JZN-00079: missing quotation mark at end of string

Cause: A member name or string value beginning with a quotation mark did not have a closing quotation mark.

Action: This is an error in the JavaScript Object Notation (JSON) input.

JZN-00081: invalid hexadecimal string

Cause: A string was encountered that could not be interpreted as a hexadecimal representation of a binary value.

Action: Ensure that the the string contains only valid hexadecimal characters (0-9,a-f,A-F) and that it contains an even number of characters (2 characters per byte of the binary value).

JZN-00082: unexpected JSON syntax character '~s'

Cause: An unexpected or superfluous syntactic character was encountered while parsing an object or array.

Action: This is an error in the JavaScript Object Notation (JSON) input.

JZN-00083: unclosed array

Cause: An array was not closed with a ']'.

Action: This is an error in the JavaScript Object Notation (JSON) input.

JZN-00084: unclosed object

Cause: An object was not closed with a '}'.

Action: This is an error in the JavaScript Object Notation (JSON) input.

JZN-00085: JSON unintelligible

Cause: A JSON contained invalid or unexpected characters and could not be interpreted.

Action: This is an error in the JavaScript Object Notation (JSON) input.

JZN-00086: missing next item

Cause: An array or object contained a comma but no subsequent element or member was found.

Action: This is an error in the JavaScript Object Notation (JSON) input.

JZN-00087: unexpected characters

Cause: Unexpected non-whitespace characters were encountered follwing the end of the JSON document.

Action: This is an error in the JavaScript Object Notation (JSON) input.

JZN-00090: Invalid binary JSON (~s)

Cause: The binary JSON image was invalid or corrupt.

Action: If the binary JSON comes from an external source, check the encoder or source for errors.

JZN-00091: Binary JSON encoding ended prematurely

Cause: The binary JSON image was incomplete or corrupt.

Action: If the binary JSON comes from an external source, check the encoder or source for errors.

JZN-00092: JSON too large for binary encoding

Cause: The binary JSON exceeded the maximum supported size.

Action: None

JZN-00201: Unquoted punctuation in step

Cause: A path step contained punctuation characters.

Action: Enclose the step in double quotation marks.

JZN-00202: Escape sequence must be in quotation marks

Cause: A backslash escape sequence was not enclosed in quotation marks.

Action: Enclose the string in double quotation marks.

JZN-00203: Invalid escape sequence

Cause: An escape sequence beginning with a backslash contained invalid characters.

Action: Correct the invalid escape sequence.

JZN-00204: Invalid surrogate pair

Cause: The surrogate pair was invalid. A surrogate pair must consist of a high surrogate followed by a low surrogate.

Action: Correct the invalid surrogate pair.

JZN-00205: Array subscript too long

Cause: A subscript within an array step was too long to be interpreted.

Action: Shorten the array step.

JZN-00206: Array subscript invalid range

Cause: An array range subscript was missing a start or end position.

Action: Correct the start or end position to create a valid range.

JZN-00207: Variable name is invalid

Cause: The variable name was invalid. A variable name must be alphanumeric and cannot start with a number.

Action: Correct the variable name.

JZN-00208: Path must start with a dollar sign ($) character

Cause: A path did not start with a dollar sign ($) character.

Action: Start the path with a dollar sign ($) character.

JZN-00209: Unexpected characters after end of path

Cause: Trailing characters followed the end of the path.

Action: Remove the trailing or corrupted characters.

JZN-00210: Empty array subscript

Cause: An array step was empty.

Action: Specify a subscript, range, or series of entries.

JZN-00211: Invalid array subscript

Cause: The specified array position was invalid.

Action: Array positions must be non-negative integers.

JZN-00212: Array wildcard must be used alone

Cause: The array wildcard (*) character was not specified by itself in an array subscript.

Action: Remove all other parts of the subscript.

JZN-00213: Object key wildcard must be used alone

Cause: The key wildcard (*) character did not appear by itself in a key step.

Action: Remove extraneous characters from the key step.

JZN-00214: Missing square bracket in array step

Cause: An array step had mismatching square bracket ([]) charaters.

Action: Add the missing closing square bracket character.

JZN-00215: Array step contains unexpected characters

Cause: An array step contained invalid characters and could not be interpreted.

Action: Array steps must contain numbers, ranges, or comma-delimited numbers and ranges.

JZN-00216: Unclosed quoted step

Cause: A step beginning with a quotation mark did not have a closing quotation mark.

Action: Add the missing quotation mark.

JZN-00217: Key step contains unexpected characters

Cause: A key step contained invalid characters and could not be interpreted.

Action: Unquoted key steps must be alphanumeric and begin with an alphabetic character. Otherwise, enclose the step in quotation marks.

JZN-00218: Invalid JSON literal

Cause: A JavaScript Object Notation (JSON) literal must be 'true', 'false', or 'null'.

Action: None

JZN-00219: Literal contains unexpected characters

Cause: A JavaScript Object Notation (JSON) literal must be 'true', 'false', or 'null'.

Action: None

JZN-00220: Invalid number

Cause: The value could not be interpreted as a number.

Action: None

JZN-00221: Numeric overflow

Cause: The numeric value could not be converted to binary because of an overflow.

Action: None

JZN-00222: Invalid regular expression

Cause: The expression supplied to 'eq_regex' or 'like_regex' was not a valid regular expression.

Action: Correct the expression.

JZN-00223: Unsupported operator

Cause: The 'not_in' operator was specified in an expression.

Action: Use a logical not surrounding an 'in' expression instead.

JZN-00224: Unexpected characters in comparison operator

Cause: Unexpected characters were present in the expression.

Action: Remove the unexpected characters from the expression.

JZN-00225: Comparison with expression must involve a path

Cause: A comparison operation with an expression did not involve a path.

Action: None

JZN-00226: Not operator must be followed by parenthetical expression

Cause: The expression after a not operator was not enclosed in parentheses.

Action: Enclose the expression in parentheses.

JZN-00227: Comparison must be against 'true' or 'false'

Cause: The comparison was not against a JavaScript Object Notation (JSON) 'true' or 'false' literal.

Action: None

JZN-00228: Question mark must be followed by parenthetical expression

Cause: A question mark introduced a filter that was enclosed in parentheses.

Action: Enclose the filter condition in parentheses.

JZN-00229: Missing parenthesis in parenthetical expression

Cause: A parenthetical expression was missing a closing parenthesis.

Action: Append a closing parenthesis to close the expression.

JZN-00230: Unexpected characters in expression

Cause: Unexpected characters were present in the expression.

Action: Remove the unexpected characters from the expression.

JZN-00231: Unquoted Unicode character

Cause: A Unicode character appeared outside of quotation marks.

Action: Surround the path step or value with quotation marks.

JZN-00232: Expected a '.' following step

Cause: After a path step, a '.' separator was expected.

Action: None

JZN-00233: Invalid character at start of step

Cause: The next path step started with an invalid character.

Action: None

JZN-00234: Invalid '@' outside of predicate

Cause: An '@' character appeared in the path outside of a predicate clause.

Action: None

JZN-00235: Invalid '$' inside of predicate

Cause: A '$' appeared in the path inside of a predicate clause.

Action: None

JZN-00236: missing or invalid function or operator

Cause: A predicate expression was missing an operator or specified a function that was not valid.

Action: None

JZN-00237: invalid comparison of two path expressions

Cause: A predicate expression contained a path expression on both the left and right sides of the operator.

Action: None

JZN-00238: path expression has more than one predicate

Cause: A path expression had more than one predicate expression at the top level. At most, one predicate expression is allowed at the top level.

Action: None

JZN-00239: predicate expression before final path step

Cause: A path expression contained a predicate expression prior to the final step in the path. If an expression has a predicate at the top level, it must be the final step in the path.

Action: None

JZN-00240: invalid characters in array range subscript

Cause: The specified array range contained invalid characters. Array ranges are specified using the keyword 'to' between the start and end of the range.

Action: Array positions must be non-negative integers.

JZN-00241: invalid function at the end of path

Cause: The specified function is not valid.

Action: None

JZN-00242: parentheses nested too deeply

Cause: A path expression contained too many levels of nested parentheses.

Action: None

JZN-00243: type incompatibility for comparison

Cause: The domain of a type comparison cannot be determined because the types are incompatible and cannot be converted.

Action: Add a type casting function to the comparison expression.

JZN-00244: wrong argument data type for function call

Cause: The argument to a function call does not have the correct data type and cannot be converted to the correct data type.

Action: Use an argument of an allowed data type.

JZN-00245: can not convert literal to the required data type

Cause: The JSON literal value cannot be converted to the data type required by the operation or comparison.

Action: Use a literal value within the domain of the datatype.

JZN-00246: expression types used by in/not_in sequence must be uniform

Cause: The values used for an in or not_in sequence must be of a uniform data type.

Action: Do not mix JSON literals or bind variables of different data types in the sequence given to an in or not_in clause.

JZN-00247: Array subscript or range out of order

Cause: An array subscript appeared in a comma-separated list after a higher subscript or range.

Action: Reverse the order of the list items and ensure that ranges do not overlap.

JZN-00248: Character not escaped

Cause: A character appeared in a quoted path step or literal string without being escaped as required.

Action: Escape the character with a backslash sequence. Control characters, including whitespace characters such as the horizontal tab (\t), the carriage return (\r), and the newline (\n) must be escaped. Other control characters can be escaped with Unicode \uXXXX sequences.

JZN-00249: Unquoted empty step not allowed

Cause: A zero length step appeared in a path without being enclosed in quotes. The sequence '..' implies a descendant that may not be an immediate child of the previous step.

Action: Enclose the zero-length step with backquote (`) characters.

JZN-00250: JSON Patch specification must be an array of operations

Cause: The JavaScript Object Notation (JSON) Patch specification was not an array. A JSON Patch specification must be an array, listing an ordered series of operations to be performed.

Action: Refer to the JSON Patch standard.

JZN-00251: JSON Patch operations must be objects

Cause: The JavaScript Object Notation (JSON) Patch specification array contained some non-object members. Each element of the JavaScript Object Notation (JSON) Patch specification array must be an object describing a patch operation to be performed.

Action: Refer to the JSON Patch standard.

JZN-00252: No 'op' code for patch operation

Cause: An object in a JavaScript Object Notation (JSON) Patch specification was missing an 'op' code.

Action: Refer to the JSON Patch standard.

JZN-00253: Invalid path for patch operation

Cause: The 'path' or 'from' clause in a patch operation could not be parsed.

Action: Refer to the JavaScript Object Notation (JSON) Pointer specification.

JZN-00254: Invalid 'op' code for patch operation

Cause: The 'op' code could not be interpreted.

Action: An 'op' code must be a string and must be one of the standard JavaScript Object Notation (JSON) Patch operators.

JZN-00255: Unknown key name in patch operation

Cause: The operation contained a key that is not specified by JavaScript Object Notation (JSON) Patch.

Action: Remove the invalid key.

JZN-00256: Patch operation requires a path

Cause: The target path for an operation was not specified.

Action: Ensure that all operations have a valid target path.

JZN-00257: 'path' or 'from' key must have a string value

Cause: The path specified for a 'path' or 'from' field was not a string.

Action: Ensure that all operations have a valid target path.

JZN-00258: From path not allowed for operation

Cause: The 'from' path was specified for an operation that does not allow it. 'from' is only allowed in the 'move' and 'copy' operations.

Action: Remove the 'from' path.

JZN-00259: 'value' is not allowed for operation

Cause: A 'value' was specified for an operation that does not allow it. A 'value' is not allowed in 'remove', 'move', and 'copy'.

Action: Remove the 'value' field.

JZN-00260: 'from' path is required for operation

Cause: A 'move' or 'copy' operation was missing a 'from' path.

Action: Specify a 'from' path in those operations.

JZN-00261: 'value' is required for operation

Cause: An 'add', 'replace', or 'test' operation was missing a target value.

Action: Specify a 'value' in those operations.

JZN-00262: Cyclic 'move' requested

Cause: The target 'path' specified is a child of the 'from' path.

Action: Correct the paths.

JZN-00300: Conflicting inclusion or exclusion rules

Cause: The including rule for a parent node conflicted with the explicit rule asserted for a child node. The projection specification is invalid.

Action: Remove the child node, or change the child node to match any sibling nodes.

JZN-00301: Projection specification must be an object

Cause: A projection specification was an array or JavaScript Object

Action: Ensure that the specification root is an object node.

JZN-00302: Include or exclude rule could not be interpreted

Cause: The rule did not use 'true', 'false', 1, 0, "include", or "exclude".

Action: Correct the invalid rule.

JZN-00303: NULL or invalid path

Cause: A path was either invalid or NULL.

Action: None

JZN-00304: Keys must be numbers or strings

Cause: An argument to $id was not a number or string.

Action: Do not use null, booleans, objects, or arrays in a $id expression.

JZN-00305: Array of values was empty

Cause: An array of values for $in, $nin, $all, or $id did not any values. The array of values must have at least one value.

Action: Do not pass an empty array to the operators.

JZN-00306: Array must contain only scalar values

Cause: An array of values for $in, $nin, $all, or $id contained object or array members. The array of values must contain only scalar values.

Action: Do not use objects or arrays within an array of values.

JZN-00307: $between must have two values in array

Cause: A minimum and maximum value were not specified for the $between operator. The $between operator must be given an array with a minimum and a maximum value.

Action: Use a null for the minimum or maximum value to indicate that the range is open on one end. The values must be scalars, and at least one of the two values must not be null.

JZN-00308: Spatial operators must be at the outermost level

Cause: The $near, $within, and $intersect operators were not used at the outermost level of the Query-By-Example (QBE).

Action: None

JZN-00309: Spatial operators must specify $geometry

Cause: The $near, $within, and $intersect operators were not given a GeoJSON object as the value of the $geometry key.

Action: None

JZN-00310: $distance parameter is not allowed

Cause: The $distance parameter was used with an operator other than $near. Only the $near operator may include values for $distance and $unit.

Action: None

JZN-00311: $distance parameter must be numeric

Cause: The $distance parameter was specified with a value that was not a JavaScript Object Notation (JSON) number.

Action: None

JZN-00312: $unit parameter must be a string

Cause: The $unit parameter was not a JavaScript Object Notation (JSON) string. The $unit parameter should be a string specifying a unit of measure such as 'mile'. It may not be a number or JSON literal, nor an object or array.

Action: None

JZN-00313: Unknown key found in spatial operator

Cause: The spatial operator contained a key that did not match the expected values. All spatial operators must have a $geometry value, and the $near operator may have $distance and $unit values. Other keys are not allowed.

Action: None

JZN-00314: $distance parameter is required

Cause: The $near operator did not specify a value for $distance.

Action: None

JZN-00315: Empty objects not allowed

Cause: An empty object was found in the filter specification. An empty object is meaningless and not allowed in the filter specification.

Action: None

JZN-00316: Object with at least one field object must follow modifier

Cause: A modifier operator was not followed by an object, or was followed by an object with no fields. Modifiers include $not, datatype casts such as $number, simple conversions such as $upper, and structural operators such as $type.

Action: None

JZN-00317: Target of spatial operation must be an object

Cause: A $near, $within, or $intersect operator was not followed by an object containing the spatial parameters.

Action: None

JZN-00318: Invalid operator within modifier

Cause: A modifier operator (such as $not) was used around a $and, $or, $nor, $id, or another modifier operator. Modifiers may not be used around those operators.

Action: None

JZN-00319: Value of string matching operator must be a string

Cause: The value supplied to the $regex, $hasSubstring, $startsWith, or $like operators was not a JavaScript Object Notation (JSON) string.

Action: None

JZN-00320: Value of comparison operator must be a scalar

Cause: The value supplied to an operator was not a JavaScript Object Notation (JSON) scalar value.

Action: Use only strings, numbers, or JSON literals; do not use an object or array.

JZN-00321: Value of the operator must be a string or number

Cause: The value supplied to $eq, $ne, or $exists was not a JavaScript Object Notation (JSON) string or number.

Action: Use only strings or numbers; do not use an object or array, and do not use the JSON literals 'true', 'false', or 'null'.

JZN-00322: Value of set comparison operator must be an array

Cause: The value supplied to $in, $all, $id, or $between was not an array.

Action: None

JZN-00323: Elements in a conjunction array must be objects

Cause: An element of an array for $and, $or, or $nor was not an object.

Action: None

JZN-00324: $id operator must be at the outermost level

Cause: The $id operator supplying document keys was not used at the outermost level of the Query-By-Example (QBE).

Action: None

JZN-00325: Cannot combine sub-expression with other filters

Cause: A downscoped sub-expression was used in the same scope as a normal filter condition.

Action: None

JZN-00326: Values for $orderby conditions must be integers

Cause: An order by condition did not give an integer value. Objects, arrays, strings, and other literals are not allowed to specify ordering criteria.

Action: Use only positive and negative integer values for the ordering criteria. Use negative values for descending order and positive values for ascending order.

JZN-00327: Query specification must be an object

Cause: The query specification root was an array or scalar. A query specification must be an object.

Action: Ensure that the specification root is an object node.

JZN-00328: Order by specification must be an object or array

Cause: A $orderby specification was not an object or array. It may not be a JavaScript Object Notation (JSON) scalar.

Action: Ensure that the specification root is an object or array node.

JZN-00329: Order by field must specify a path

Cause: A field of a $orderby array must specify a path.

Action: Ensure that all field objects in the array specify a path.

JZN-00330: Order by array contained invalid item

Cause: The items in a $orderby array must be sort field specification objects. The objects must contain only fields for 'path', 'datatype', 'maxLength', and 'order'.

Action: Ensure that all items in the array are valid field specification objects.

JZN-00331: $sqlJson operator must be at the outermost level

Cause: The $sqlJson was not used at the outermost level of the Query-By-Example (QBE).

Action: None

JZN-00332: Value of $sqlJson operator must be an object

Cause: The value supplied to $sqlJson was not an object.

Action: None

JZN-00333: Items in a $sqlJson object must be field paths

Cause: The fields of a $sqlJson operator must all be path strings.

Action: None

JZN-00334: $id operator cannot appear more than once

Cause: The $id operator supplying document keys was used multiple times in the Query-By-Example (QBE).

Action: Consolidate the key values into a single $id operator.

JZN-00335: Parameter '~s' must be a boolean

Cause: The parameter value was not a JSON literal 'true' or 'false'.

Action: Use a JSON boolean value for this parameter.

JZN-00336: Parameters '~1s' and '~2s' conflict

Cause: Two parameters were used together that are either disallowed in combination, or had conflicting values specified.

Action: Remove one of the parameters or change them to have compatible values.

JZN-00337: Logical operator '~1s' must have at least one target

Cause: An array of target values for the logical operator was empty.

Action: Do not use an empty array as target for the logical operator.

JZN-00338: Order by path must not have array steps

Cause: A path used in an order by path expression used an array step. Order by path expressions use lax semantics and must not have explicit array steps.

Action: Remove the array steps from the order by path expression.

JZN-00375: '~s' operator must be at the outermost level

Cause: A disallowed operator was used at a nested level in a Query-By-Example (QBE).

Action: Place the operator at the outer level of the query specification.

JZN-00376: invalid combination of '$textContains' with ~s

Cause: The $textContains operator could not be used with the other operator or query construct.

Action: Use $textContains as the sole operator in the query.

JZN-00381: unclosed quotation mark

Cause: An input column value began with an opening quotation mark but had no closing quotation mark.

Action: Correct the input CSV file.

JZN-00382: unescaped quotation mark

Cause: An unquoted input column value contains a quotation mark.

Action: Correct the input CSV file.

JZN-00383: missing delimiter

Cause: A column value contained a quoted value and another quoted or unquoted value, but had no delimiter separating the values.

Action: Correct the input CSV file.

JZN-00384: unquoted spaces

Cause: A quoted column value had space characters before the opening quotation mark or after the closing quotation mark.

Action: Correct the input CSV file.

JZN-00400: JSON_TRANSFORM operation encountered missing field

Cause: A JSON_TRANSFORM operation did not find a field value where one was expected.

Action: Check the path expressions or change the ON MISSING handler.

JZN-00401: JSON_TRANSFORM operation encountered an existing field

Cause: A JSON_TRANSFORM operation encountered an existing field where none was expected.

Action: Check the path expressions or change the ON EXISTING handler.

JZN-00402: JSON_TRANSFORM operation did not match JSON array

Cause: A JSON_TRANSFORM operation that expected an array did not match an array.

Action: Check the path expression.

JZN-00403: field name existing in JSON_TRANSFORM operation

Cause: A JSON_TRANSFORM operation could not be executed because a field name already existed.

Action: Check the path expression.

JZN-00404: field name missing in JSON_TRANSFORM operation

Cause: A JSON_TRANSFORM operation could not be executed because a field name was missing.

Action: Check the path expression.

JZN-00405: JSON_TRANSFORM cannot remove root value

Cause: An attempt was made to remove the root value of the JSON data.

Action: Change the path expression to not remove the root value.

JZN-00406: JSON_TRANSFORM operation not supported

Cause: An attempt was made to use a JSON_TRANSFORM operation that was not supported.

Action: Remove the operation from the JSON_TRANSFORM statement.

JZN-00407: JSON_TRANSFORM operation cannot select multiple values

Cause: A path expression was used that selected more than one value in an operation where only one value can be modified.

Action: Modify the path expression to only select one value.

JZN-00408: JSON_TRANSFORM operation called with NULL input

Cause: A JSON_TRANSFORM operation was called with an input value that was NULL and the operation had ERROR ON NULL handling specified.

Action: Ensure that the provided value is not NULL or remove the ERROR ON NULL option.

JZN-00409: JSON_TRANSFORM cannot update root value

Cause: An attempt was made to update the root value of the JSON data.

Action: Change the path expression to not update the root value.

JZN-00499: wrong number or types of arguments to function

Cause: A trailing function was passed an incorrect number of arguments, or arguments of the wrong scalar type.

Action: Correct the arguments or argument types in the expression.