OBE-30000 ~ OBE-49999

OBE-30002: SYS_CONNECT_BY_PATH function is not allowed here

• OceanBase error code: 5768

• SQLSTATE: HY000

• Cause: The SYS_CONNECT_BY_PATH function is called outside the SELECT list and ORDER BY clause.

• Solution: Remove calls to the SYS_CONNECT_BY_PATH function outside the SELECT list and ORDER BY clause.

OBE-30003: illegal parameter in SYS_CONNECT_BY_PATH function

• OceanBase error code: 5769

• SQLSTATE: HY000

• Cause: The SYS_CONNECT_BY_PATH function contains an illegal parameter.

OBE-30003: illegal parameter in SYS_CONNECT_BY_PATH function

• OceanBase error code: 5927

• SQLSTATE: HY000

• Cause: The SYS_CONNECT_BY_PATH function contains an illegal parameter.

OBE-30004: A column value contained the string that the SYS_CONNECT_BY_PATH function was to use to separate column values

• OceanBase error code: 5770

• SQLSTATE: HY000

• Cause: A column value contains the string that the SYS_CONNECT_BY_PATH function uses to separate column values.

• Solution: Specify another separator for the SYS_CONNECT_BY_PATH function, ensuring this separator is not present in any column value, and then retry the operation.

OBE-30005: missing or invalid WAIT interval

• OceanBase error code: 5495
• SQLSTATE: HY000
• Cause: The specified wait time parameter is invalid or missing when using the MySQL WAIT command.
• Solution: Check the syntax of the WAIT command used and ensure the wait time parameter is correct.

OBE-30006: resource busy; acquire with WAIT timeout expired

• OceanBase error code: 6003

• SQLSTATE: HY000

• Error cause: The requested resource is busy.

• Solution: Retry the operation later.

OBE-30007: CONNECT BY ROOT operator is not supported in the START WITH or in the CONNECT BY condition

• OceanBase error code: 5771

• SQLSTATE: HY000

• Error cause: Attempt to use the CONNECT BY ROOT operator in a START WITH or CONNECT BY condition.

• Solution: Remove the CONNECT BY ROOT operator from the START WITH or CONNECT BY condition.

OBE-30009: Not enough memory for CONNECT BY operation

• OceanBase error code: 5926

• SQLSTATE: HY000

• Error cause: On new engines, an error is reported when the recursion depth is too deep, with a limit of 2 to the power of 30. On older engines, an error is also reported if the number of all nodes and their child nodes along the path from the root node to the current node exceeds a fixed value (2 to the power of 30). This value is currently set fixedly and generally will not be exceeded.

• Solution: No solution has been found yet. Increasing memory size does not resolve this issue. The only solution is to reduce the recursion depth or decrease the data volume.

OBE-30055: NULL snapshot expression not allowed here

• OceanBase error code: 4786

• SQLSTATE: HY000

• Error cause: Using a NULL snapshot expression is not allowed here.

• Solution: Check the syntax and validity of the expressions in the flashback query statement to ensure it points to a specific historical snapshot that exists within the retention period.

OBE-30076: invalid extract field for extract source

• OceanBase error code: 5686

• SQLSTATE: HY000

• Error cause: The data extraction source does not contain the specified extraction field.

OBE-30078: partition bound must be TIME/TIMESTAMP WITH TIME ZONE literals

• OceanBase error code: 5349

• SQLSTATE: HY000

• Cause: The TIME or TIMESTAMP column does not have a TIME ZONE specification.

• Solution: Use the TIME or TIMESTAMP format with TIME ZONE.

OBE-30084: invalid data type for datetime primary with time zone modifier

• OceanBase error code: 5950

• SQLSTATE: HY000

• Cause: When a time zone modifier is specified, the datetime parameter must be a value of the TIME, TIME WITH TIME ZONE, TIMESTAMP, or TIME STAMP WITH TIME ZONE data type.

OBE-30088: datetime/interval precision is out of range

• OceanBase error code: 5605

• SQLSTATE: HY000

• Cause: The specified datetime/interval precision is not between 0 and 9.

• Solution: Ensure that the datetime/interval precision uses a value between 0 and 9.

OBE-30175: invalid type given for an argument

• OceanBase error code: 5351

• SQLSTATE: HY000

• Cause: The parameter list contains parameters of invalid types.

• Solution: Use the correct data types for the parameters.

OBE-30186: '\\' must be followed by four hexidecimal characters or another '\\'

• OceanBase error code: 5938

• SQLSTATE: HY000

• Cause: In the parameter of the SQL function UNISTR, to include a backslash (\\) in the string itself, append four hexadecimal characters or another backslash after it.

• Solution: Correct the string format.

OBE-30205: invalid Character set

• OceanBase error code: 5969

• SQLSTATE: HY000

• Cause: The specified character set is invalid.

• Solution: Check whether the character set ID is valid.

OBE-30481: GROUPING function only supported with GROUP BY CUBE or ROLLUP

• OceanBase error code: 5501
• SQLSTATE: 42000
• Cause: The GROUPING function is supported only when the GROUP BY CUBE or ROLLUP statement is used.
• Solution: When using the GROUPING function, ensure that the GROUP BY CUBE or ROLLUP statement is used.

OBE-30482: DISTINCT not allowed here

• OceanBase error code: 5798

• SQLSTATE: HY000

• Cause: The DISTINCT option is not allowed for this function.

OBE-30485: missing ORDER BY expression in the window specification

• OceanBase error code: 5300

• SQLSTATE: HY000

• Cause: The ORDER BY expression is missing for the window function or aggregation group.

OBE-30487: ORDER BY not allowed here

• OceanBase error code: 5797

• SQLSTATE: HY000

• Cause: The ORDER BY expression cannot be used with the DISTINCT function and the RATIO_TO_REPORT function.

OBE-30488: argument should be a function of expressions in PARTITION BY

• OceanBase error code: 5347

• SQLSTATE: HY000

• Cause: The parameter of a window function must be a constant for the partition.

OBE-30493: The percentile value should be a number between 0 and 1

• OceanBase error code: 5861

• SQLSTATE: HY000

• Cause: The percentile value specified for the PERCENTILE_CONT or PERCENTILE_DISC function is not within the valid range.

• Solution: Specify a value within the [0,1] range.

OBE-30494: The argument [%s] of WIDTH_BUCKET function is NULL or invalid

• OceanBase error code: 5925

• SQLSTATE: HY000

• Cause: The parameter [%s] of the WIDTH_BUCKET function is NULL or invalid.

OBE-30495: The argument should be of numeric or date/datetime type

• OceanBase error code: 5862

• SQLSTATE: HY000

• Cause: The parameter must be of a numeric type or a date/time type.

OBE-30496: Argument should be a constant

• OceanBase error code: 5852

• SQLSTATE: HY000

• Cause: The parameter must be a constant.

OBE-30497: Argument should be a constant or a function of expressions in GROUP BY

• OceanBase error code: 11010

• SQLSTATE: HY000

• Cause: The delimiter for the LISTAGG aggregate function can only be a constant or an expression in the GROUP BY clause.

• Solution: Check whether the delimiter for the LISTAGG aggregate function is correct.

OBE-30508: client logon triggers cannot have BEFORE type

• OceanBase error code: 9804

• SQLSTATE: HY000

• Cause: Client login triggers cannot be of the BEFORE type.

• Solution: Review and modify the trigger definition to ensure it does not use the BEFORE type. LOGON triggers can only be of the AFTER type.

OBE-30509: client logoff triggers cannot have AFTER type

• OceanBase error code: 9805

• SQLSTATE: HY000

• Cause: Client logout triggers cannot be of the AFTER type.

• Solution: Review and modify the trigger definition to ensure it does not use the AFTER type. LOGOFF triggers can only be of the BEFORE type.

OBE-30510: system triggers cannot be defined on the schema of SYS user

• OceanBase error code: 9802

• SQLSTATE: HY000

• Cause: System triggers cannot be defined on the schema of the SYS user.

• Solution: This error is a mandatory security safeguard, not an ordinary obstacle that can be bypassed.

OBE-30553: The function is not deterministic

• OceanBase error code: 5996

• SQLSTATE: HY000

• Error cause: The function that defines the index is non-deterministic.

• Solution: If the function is deterministic, mark it as deterministic. If it is non-deterministic (depending on package state, database state, current time, or anything other than the function's input), do not create the index. The value returned by a deterministic function should not change even when the function is rewritten or recompiled.

OBE-30562: SAMPLE percentage must be in the range [0.000001,100)

• OceanBase error code: 5730

• SQLSTATE: HY000

• Error cause: The SAMPLE percentage must be in the range [0.000001, 100).

OBE-30563: outer join operator (+) is not allowed here

• OceanBase error code: 5626

• SQLSTATE: HY000

• Error cause: Attempt to use the + operator in the select_list, CONNECT BY clause, START WITH clause, or ORDER BY clause.

• Solution: Do not use the operator in the select_list, CONNECT BY clause, START WITH clause, or ORDER BY clause.

OBE-30625: method dispatch on NULL SELF argument is disallowed

• OceanBase error code: 5847

• SQLSTATE: HY000

• Error cause: A MEMBER method of a certain type is called with a NULL SELF parameter.

• Solution: Change the method call type to pass a valid SELF parameter.

OBE-30665: invalid NOT NULL constraint specified on a DEFAULT ON NULL column

• OceanBase error code: 5949

• SQLSTATE: HY000

• Error cause: The NOT NULL constraint is incorrectly specified on a DEFAULT ON NULL column.

• Solution: If a NOT NULL constraint is specified on a DEFAULT ON NULL column, it must be enabled and cannot be deferred.

OBE-30669: table can have only one identity column

• OceanBase error code: 5909

• SQLSTATE: HY000

• Error cause: Attempt to specify multiple identity columns for a table.

• Solution: Specify only one identity column for each table.

OBE-30670: invalid NOT NULL constraint specified on an identity column

• OceanBase error code: 5910

• SQLSTATE: HY000

• Cause: The NOT NULL constraint is incorrectly specified on an identity column.

• Solution: If a NOT NULL constraint is specified on an identity column, it must be enabled and cannot be deferred.

OBE-30671: cannot modify NOT NULL constraint on an identity column

• OceanBase error code: 5911

• SQLSTATE: HY000

• Cause: The NOT NULL constraint on an identity column cannot be modified.

• Solution: Do not modify the NOT NULL constraint on an identity column.

OBE-30672: cannot drop NOT NULL constraint on an identity column

• OceanBase error code: 5912

• SQLSTATE: HY000

• Cause: The NOT NULL constraint on an identity column cannot be dropped.

• Solution: Do not drop the NOT NULL constraint on an identity column. The only way to remove a constraint is to use ALTER TABLE MODIFY with DROP IDENTITY to drop the column's identity attribute.

OBE-30673: column to be modified is not an identity column

• OceanBase error code: 5913

• SQLSTATE: HY000

• Cause: You are trying to modify the identity attribute of a non-identity column.

• Solution: Modify the identity attribute of an identity column.

OBE-30674: identity column cannot have a default value

• OceanBase error code: 5914

• SQLSTATE: HY000

• Cause: You are trying to add a default value to an identity column.

• Solution: You cannot assign a default value to an identity column.

OBE-30675: identity column must be a numeric type

• OceanBase error code: 5915

• SQLSTATE: HY000

• Cause: You attempted to create or change the value of an identity column to a nonnumeric data type.

• Solution: Do not assign nonnumeric data types to identity columns.

OBE-30678: too many open connections

• OceanBase error code: 9792

• SQLSTATE: HY000

• Cause: The maximum number of concurrent connections was exceeded when establishing an external TCP connection using the UTL_TCP system package.

• Solution: Ensure that the number of concurrent connections does not exceed the maximum number of concurrent connections.

OBE-30926: unable to get a stable set of rows in the source tables

• OceanBase error code: 30926

• SQLSTATE: HY000

• Cause: A stable set of rows could not be obtained due to heavy DML activity or a non-deterministic WHERE clause.

• Solution: Remove the non-deterministic WHERE clause and reissue the DML statement.

OBE-30929: ORDER SIBLINGS BY clause not allowed here

• OceanBase error code: 5325

• SQLSTATE: HY000

• Cause: A query with the specified ORDER SIBLINGS BY clause does not contain a CONNECT BY clause.

• Solution: Remove the ORDER SIBLINGS BY clause or add a CONNECT BY clause to the query.

OBE-30929: ORDER SIBLINGS BY clause not allowed here

• OceanBase error code: 5451
• SQLSTATE: 42000
• Cause: The ORDER SIBLINGS BY clause was specified in a query without a CONNECT BY clause.
• Solution: Remove the ORDER SIBLINGS BY clause or add a CONNECT BY clause.

OBE-30929: ORDER SIBLINGS BY clause not allowed here

• OceanBase error code: 5772

• SQLSTATE: HY000

• Cause: A query that specifies the ORDER SIBLINGS BY clause does not contain a CONNECT BY clause.

• Solution: Remove the ORDER SIBLINGS BY clause or add a CONNECT BY clause to the query.

OBE-30930: NOCYCLE keyword is required with CONNECT_BY_ISCYCLE pseudo column

• OceanBase error code: 5773

• SQLSTATE: HY000

• Cause: The CONNECT_BY_ISCYCLE pseudo column is specified in the query, but the query does not contain the NOCYCLE keyword.

• Solution: Remove CONNECT_BY_ISCYCLE or add the NOCYCLE keyword.

OBE-30980: Invalid Input

• OceanBase error code: 5462
• SQLSTATE: 42000
• Cause: Type conversion failed; invalid input.
• Solution: Enter data of the correct type.

OBE-31003: Parent %.*s already contains child entry %.*s

• OceanBase error code: 7433

• SQLSTATE: 42000

• Cause: An attempt was made to insert a duplicate child entry into the XDB hierarchical parser.

• Solution: Insert a unique name into the container.

OBE-31011: XML parsing failed

• OceanBase error code: 9549

• SQLSTATE: HY000

• Cause: The XML parser returned an error while attempting to parse the document.

• Solution: Check whether the document to be parsed is valid.

OBE-31012: Given XPATH expression not supported

• OceanBase error code: 7409
• SQLSTATE: 42000
• Cause: The XPath expression is not supported.
• Solution: Check whether the used XPath expression is correct and whether the database version supports using this XPath expression.

OBE-31013: invalid xpath expression

• OceanBase error code: 7404
• SQLSTATE: 42000
• Cause: The XPath expression format is incorrect or invalid when using the XPath expression.
• Solution: Check the XPath expression and verify whether the XML data is correct.

OBE-31056: The document being inserted does not conform to specified child name

• OceanBase error code: 7429

• SQLSTATE: 42000

• Cause: The inserted XML element does not conform to the registered XML schema identified by the URL.

• Solution: Insert an element that conforms to the specified XML schema.

OBE-31067: XML nodes must be updated with valid nodes and of the same type

• OceanBase error code: 7418
• SQLSTATE: 42000
• Cause: An invalid node or node type was used to update an XML node.
• Solution: Check whether the type of the node to be updated is correct and ensure that the node types match.

OBE-31181: PL/SQL DOM handle accesses node that is no longer available

• OceanBase error code: 9841
• SQLSTATE: HY000
• Cause: The node accessed by the PL/SQL DOM handle is no longer available.
• Solution: Ensure that the DOM document and its nodes are still valid and not released before accessing them.

OBE-31188: The specified printing option is invalid

• OceanBase error code: 7407
• SQLSTATE: 42000
• Cause: The specified printing option is invalid.
• Solution: Check whether the printing option is correct.

OBE-31195: XML node '' (type=%s) does not support this operation

• OceanBase error code: 7430

• SQLSTATE: 42000

• Cause: The given node type does not support this operation. For example, adding a child node to an attribute node or passing a document node as a child node is not supported.

• Solution: Perform the operation using a valid node type.

OBE-31600: invalid input value %.*s for parameter %.*s in function %.*s

• OceanBase error code: 9504

• SQLSTATE: HY000

• Cause: The input parameter value is NULL or an invalid value.

• Solution: Correct the input value and retry the call.

OBE-31603: object '%.*s' of type %.*s not found in schema '%.*s'

• OceanBase error code: 9503

• SQLSTATE: HY000

• Cause: The specified object cannot be found in the database.

• Solution: Correct the object configuration and retry the call.

OBE-32021: parameter value longer than %d characters

• OceanBase error code: 5939

• SQLSTATE: HY000

• Cause: You attempt to change a parameter value, but the number of characters in the value exceeds the maximum allowed. For a list parameter, one of the values in the list exceeds the maximum allowed.

• Solution: Reduce the length of the parameter value and retry the command. For the DISPATCHERS parameter, use a listener alias to shorten the value.

OBE-32031: illegal reference of a query name in WITH clause

• OceanBase error code: 5737

• SQLSTATE: HY000

• Cause: Forward or recursive references to query names are not allowed in the WITH clause.

• Solution: Correct the query statement and retry.

OBE-32033: unsupported column aliasing

• OceanBase error code: 5738

• SQLSTATE: HY000

• Error cause: Column aliases are not supported in the WITH clause.

• Solution: Specify aliases in the subquery definition and try again.

OBE-32034: unsupported use of WITH clause

• OceanBase error code: 5739

• SQLSTATE: HY000

• Error cause: The usage of this WITH clause is not supported for the following reasons:

  • Nesting WITH clauses within WITH clauses is not supported.

  • For a set query, you cannot specify a WITH clause for a branch.

• Solution: Modify the query and try again.

OBE-32038: number of WITH clause column names does not match number of elements in select list

• OceanBase error code: 5740

• SQLSTATE: HY000

• Error cause: A column alias or list of names was specified for the query name in the WITH clause, but the number of elements in the list does not match the number of elements in the Select-list that defines the query.

• Solution: Update the column alias list or the Select-list to ensure they have the same number of elements.

OBE-32039: recursive WITH clause must have column alias list

• OceanBase error code: 5741

• SQLSTATE: HY000

• Error cause: A recursive WITH clause refers to itself but no column alias list is specified for it.

• Solution: Add a column alias list for the query name in the WITH clause.

OBE-32040: recursive WITH clause must use a UNION ALL operation

• OceanBase error code: 5742

• SQLSTATE: HY000

• Error cause: A recursive WITH clause refers to itself but the UNION ALL operation is not used in its defining query.

• Solution: Rewrite the recursive WITH clause query to use the UNION ALL operation.

OBE-32041: UNION ALL operation in recursive WITH clause must have only two branches

• OceanBase error code: 5743

• SQLSTATE: HY000

• Error message: The WITH clause query recursively references itself, but uses a UNION ALL operation with more than two branches. This operation is not currently supported.

• Solution: Rewrite the recursive WITH clause query to use only two branches in the UNION ALL operation.

OBE-32042: recursive WITH clause must reference itself directly in one of the UNION ALL branches

• OceanBase error code: 5744

• SQLSTATE: HY000

• Error message: The WITH clause query indirectly references itself (recursively), for example, through subqueries or views.

• Solution: Rewrite the recursive WITH clause query to directly reference itself in the FROM clause of one of the UNION ALL branches.

OBE-32043: recursive WITH clause needs an initialization branch

• OceanBase error code: 5745

• SQLSTATE: HY000

• Error message: The WITH clause query recursively references itself, but in the UNION ALL operation, there is only a reference to itself, lacking an initialization branch that does not reference itself.

• Solution: Rewrite the recursive WITH clause query to add an initialization branch that does not reference itself in the UNION ALL operation.

OBE-32044: cycle detected while executing recursive WITH query

• OceanBase error code: 5746

• SQLSTATE: HY000

• Error message: The recursive WITH clause query generates a cycle, and the system stops the query to avoid an infinite loop.

• Solution: Rewrite the recursive WITH query to stop the recursion or use the CYCLE clause.

OBE-32045: maximum level of recursion reached while executing recursive WITH query

• OceanBase error code: 5747

• SQLSTATE: HY000

• Error message: The recursive WITH query reaches the specified maximum recursion level and stops.

• Solution: Increase the maximum recursion level or use the CYCLE clause.

OBE-32046: sequence column name for SEARCH clause must not be part of the column alias list

• OceanBase error code: 5748

• SQLSTATE: HY000

• Cause: The SEARCH clause of a recursive WITH query specifies a sequence column, but this sequence column is already listed in the column alias list for the query name in the WITH clause.

• Solution: Specify a different name for the sequence column in the SEARCH clause, or remove that name from the column alias list.

OBE-32047: cycle mark value and non-cycle mark value must be one byte character string values

• OceanBase error code: 5749

• SQLSTATE: HY000

• Cause: The cycle mark or non-cycle mark value specified in the CYCLE clause of a recursive WITH query is not a one-byte string value.

• Solution: Specify a one-byte string for the cycle mark or non-cycle mark value in the CYCLE clause of the recursive WITH query.

OBE-32048: cycle mark column name for CYCLE clause must not be part of the column alias list

• OceanBase error code: 5750

• SQLSTATE: HY000

• Cause: The CYCLE clause of a recursive WITH query specifies a cycle mark column, but this column already exists in the column alias list for the query name in the WITH clause.

• Solution: Specify a different name for the cycle mark column in the CYCLE clause, or remove that name from the column alias list.

OBE-32049: duplicate name found in column alias list for WITH clause

• OceanBase error code: 5751

• SQLSTATE: HY000

• Cause: A name in the column alias list for an element of a WITH clause appears multiple times in the list.

• Solution: Remove duplicate names from the column alias list.

OBE-32480: SEARCH and CYCLE clauses can only be specified for recursive WITH clause elements

• OceanBase error code: 5752

• SQLSTATE: HY000

• Cause: A SEARCH or CYCLE clause was specified for a non-recursive element of a WITH clause.

• Solution: Remove the SEARCH or CYCLE clause, or add recursion to the WITH clause element.

OBE-32481: The cycle value for the CYCLE clause must be different from the non-cycle values.

• OceanBase error code: 5753

• SQLSTATE: HY000

• Cause: A CYCLE clause is specified for a recursive WITH query, but the cycle value is the same as a non-cycle value or the DEFAULT value.

• Solution: Change the cycle value or a non-cycle value so that they are no longer identical.

OBE-32482: The sequence column for the SEARCH clause must be different from the cycle mark column for the CYCLE clause.

• OceanBase error code: 5754

• SQLSTATE: HY000

• Cause: Both the SEARCH and CYCLE clauses are specified for a recursive WITH query, but the sequence column in the SEARCH clause matches the cycle mark column in the CYCLE clause.

• Solution: Change the sequence column or the cycle mark column so that they are no longer identical.

OBE-32483: duplicate name found in sort specification list for SEARCH clause of WITH clause

• OceanBase error code: 5755

• SQLSTATE: HY000

• Cause: A SEARCH clause is specified for a recursive query, but the sort specification list in the recursive query contains duplicate names.

• Solution: Remove duplicate names from the sort specification list.

OBE-32484: duplicate name found in cycle column list for CYCLE clause of WITH clause

• OceanBase error code: 5756

• SQLSTATE: HY000

• Cause: A CYCLE clause is specified for a recursive query, but the cycle column list in the CYCLE clause contains duplicate names.

• Solution: Remove duplicate names from the cycle column list in the CYCLE clause.

OBE-32485: An element in the cycle column list of the CYCLE clause must appear in the column alias list of the WITH clause element.

• OceanBase error code: 5757

• SQLSTATE: HY000

• Cause: The elements in the cycle column list of the CYCLE clause specified for a recursive WITH query are not included in the column alias list of the WITH clause element.

• Solution: Modify the cycle column list to use only names contained in the column alias list of the WITH clause element.

OBE-32486: unsupported operation in recursive branch of recursive WITH clause

• OceanBase error code: 5758

• SQLSTATE: HY000

• Cause: The recursive component of a UNION ALL operation within elements of a recursive WITH clause uses an unsupported operation. The GROUP BY, DISTINCT, MODEL, grouping sets, CONNECY BY, window functions, HAVING, and aggregate functions are not allowed in the recursive branches of a UNION ALL operation.

• Solution: Rewrite the query to ensure it does not contain unsupported operations.

OBE-32487: unsupported join in recursive WITH query

• OceanBase error code: 5759

• SQLSTATE: HY000

• Cause: The recursive component of an element in a recursive WITH clause contains an unsupported join operation:

  • It contains a LEFT OUTER join where the right side is a recursive query name.

  • It contains a RIGHT OUTER join where the left side is a recursive query name.

  • It contains a FULL OUTER join that involves a recursive query name.

• Solution: Rewrite the query to ensure it does not contain unsupported join operations.

OBE-32488: WITH clause element did not have a column alias list

• OceanBase error code: 5760

• SQLSTATE: HY000

• Cause: A WITH clause element uses either the SEARCH or CYCLE clause, or both, but does not specify a list of column aliases for its query name.

• Solution: Add a list of column aliases for the query name in the WITH clause.

OBE-32489: element in sort specification list of SEARCH clause did not appear in the column alias list of the WITH clause element

--

• OceanBase error code: 5761

• SQLSTATE: HY000

• Cause: An element in the sort specification list specified for a SEARCH clause in a recursive WITH query is not included in the column alias list of the corresponding WITH clause element.

• Solution: Modify the sort specification list to use only names from the column alias list of the WITH clause element.

OBE-32490: recursive query name referenced more than once in recursive branch of recursive WITH clause element

• OceanBase error code: 5762

• SQLSTATE: HY000

• Error message: A recursive component of a UNION ALL in a recursive WITH clause element referenced the recursive query name multiple times. In the recursive branches of a recursive WITH clause element, the recursive query name can only be referenced once.

• Solution: Rewrite the query to ensure that the recursive query name is referenced only once in the recursive branches of the recursive WITH clause element.

OBE-32575: Explicit column default is not supported for modifying views

• OceanBase error code: 5511
• SQLSTATE: 42000
• Error message: The DEFAULT keyword is used to modify a view.
• Solution: Use implicit default values to omit column value pairs.

OBE-32595: DDL statement cannot be audited with BY SESSION specified

• OceanBase error code: 4364

• SQLSTATE: HY000

• Error message: You attempt to audit a DDL statement with the specified BY SESSION clause. DDL statements can only be audited by using BY ACCESS.

• Solution: Use BY ACCESS to audit the DDL statement.

OBE-32792: prebuilt table managed column cannot be an identity column

• OceanBase error code: 5916

• SQLSTATE: HY000

• Error message: You attempt to create an instance view on a prebuilt table with an identity column.

• Solution: Remove the identity attribute or remove the identity column from the instance view definition.

OBE-32793: cannot alter a system-generated sequence

• OceanBase error code: 5917

• SQLSTATE: HY000

• Error message: You attempt to alter a system-generated sequence.

• Solution: System-generated sequences (such as those created for identity columns) cannot be altered.

OBE-32794: cannot drop a system-generated sequence

• OceanBase error code: 5918

• SQLSTATE: HY000

• Cause: You attempted to drop a system-generated sequence.

• Solution: System-generated sequences, such as those created for identity columns, cannot be dropped.

OBE-32795: cannot insert into a generated always identity column

• OceanBase error code: 5919

• SQLSTATE: HY000

• Cause: You are trying to insert a value into an identity column created with the GENERATED ALWAYS keyword.

• Solution: You cannot directly insert a value into an identity column generated by the GENERATED ALWAYS keyword. Instead, the value must be provided by the associated sequence generator.

OBE-32796: cannot update a generated always identity column

• OceanBase error code: 5920

• SQLSTATE: HY000

• Cause: You are trying to update an identity column created with the GENERATED ALWAYS keyword.

• Solution: You cannot directly update an identity column generated by the GENERATED ALWAYS keyword.

OBE-32797: identity column sequence mismatch in ALTER TABLE EXCHANGE PARTITION

• OceanBase error code: 5921

• SQLSTATE: HY000

• Cause: The sequences of the identity columns for the two tables specified in the EXCHANGE clause do not increase or decrease by the same amount.

• Solution: Ensure that the identity columns with INCREMENT BY have sequences with the same sign.

OBE-32798: cannot rename a system-generated sequence

• OceanBase error code: 5922

• SQLSTATE: HY000

• Cause: You are trying to rename a system-generated sequence.

• Solution: System-generated sequences (such as those created for identity columns) cannot be renamed.

OBE-38101: Invalid column in the INSERT VALUES Clause:'%.*s'.'%.*s'

• OceanBase error code: 5803

• SQLSTATE: HY000

• Cause: The INSERT VALUES clause references an invalid table column.

OBE-38104: Columns referenced in the ON Clause cannot be updated:'%.*s'.'%.*s'

• OceanBase error code: 38104

• SQLSTATE: HY000

• Cause: The LHS in the UPDATE SET clause contains columns referenced in the ON clause.

OBE-38778: Restore point %s already exists

• OceanBase error codes: 6259, 6261

• SQLSTATE: HY000

• Cause: The restore point name specified in the CREATE RESTORE POINT command already exists. Restore point names must be unique.

• Solution: Use another name or delete the existing restore point with the same name.

OBE-38779: cannot create restore point - too many restore points

• OceanBase error code: 6263

• SQLSTATE: HY000

• Cause: The maximum number of restore points has already been created.

• Solution: Delete some existing restore points and then try the operation again.

OBE-38780: Restore point %s does not exists

• OceanBase error codes: 6260, 6262

• SQLSTATE: HY000

• Cause: The restore point name specified in the statement does not exist.

• Solution: Query the restore point table to find the restore point.

OBE-38900: miss mandatory column %.*s of error log table

• OceanBase error code: 5385

• SQLSTATE: HY000

• Cause: A required column in the error log table does not exist.

• Solution: Add the named column to the error log table.

OBE-39956: duplicate setting for PL/SQL compiler parameter %.*s

• OceanBase error code: 5964

• SQLSTATE: HY000

• Cause: The PL/SQL compiler parameter has been set multiple times.

• Solution: Remove duplicate PL/SQL compiler settings.

OBE-39962: invalid parameter for PLSQL_CCFLAGS

• OceanBase error code: 5940

• SQLSTATE: HY000

• Cause: The value of the PLSQL_CCFLAGS parameter is invalid.

• Solution: Specify a valid value for the PLSQL_CCFLAGS parameter.

OBE-40441: JSON syntax error

• OceanBase error code: 5411
• SQLSTATE: 22032
• Cause: The provided JavaScript Object Notation (JSON) data syntax is invalid and cannot be parsed.
• Solution: Check the input JSON data and provide JSON data with correct syntax.

OBE-40441: JSON syntax error

• OceanBase error code: 5412
• SQLSTATE: 22032
• Cause: The provided JavaScript Object Notation (JSON) data syntax is invalid and cannot be parsed.
• Solution: Check the input JSON data and provide JSON data with correct syntax.

OBE-40441: JSON syntax error

• OceanBase error code: 5447
• SQLSTATE: 42000
• Error message: The provided JavaScript Object Notation (JSON) data is invalid and cannot be parsed.
• Solution: Provide JSON data with correct syntax.

OBE-40441: This version doesn't yet support 'references in JSON Schema

• OceanBase error code: 6284

• SQLSTATE: 42000

• Error message: References are not supported in the current version of JSON mode.

• Solution: Modify the design of the JSON schema to avoid using references.

OBE-40442: JSON path expression syntax error ('INT')

• OceanBase error code: 5414
• SQLSTATE: 22032
• Error message: The provided JavaScript Object Notation (JSON) path expression is invalid and cannot be parsed.
• Solution: Provide a valid JSON path expression.

OBE-40442: JSON path expression syntax error ('INT').JSON path expression syntax error ('%s')

• OceanBase error code: 5442
• SQLSTATE: 42000
• Error message: The provided JavaScript Object Notation (JSON) path expression is invalid and cannot be parsed.
• Solution: Provide a valid JSON path expression.

OBE-40444: JSON processing error

• OceanBase error code: 5514
• SQLSTATE: 42000
• Error cause: JSON processing error.

OBE-40449: invalid data type for return value

• OceanBase error code: 5443
• SQLSTATE: 42000
• Error cause: The data type provided for the return value is invalid or unsupported.
• Solution: Provide a supported return value.

OBE-40450: invalid '%s' clause

• OceanBase error code: 5460
• SQLSTATE: 42000
• Error cause: The "%s" statement is invalid.
• Solution: Provide a valid "%s" statement.

OBE-40451: invalid default value provided

• OceanBase error code: 5486
• SQLSTATE: 42000
• Error cause: The provided default value is invalid.

OBE-40452: default value not matching type defined in RETURNING clause

• OceanBase error code: 5474
• SQLSTATE: 42000
• Cause: The default value does not match the type defined in the RETURNING statement.
• Solution: Ensure the default value and the type specified in the RETURNING clause are compatible.

OBE-40454: path expression not a literal

• OceanBase error code: 5487
• SQLSTATE: 42000
• Cause: The path expression is not a literal.

OBE-40455: default value not a literal

• OceanBase error code: 5446
• SQLSTATE: 42000
• Cause: The provided default value is not a literal (constant).
• Solution: Provide a constant default value.

OBE-40456: JSON_VALUE evaluated to non*scalar value

• OceanBase error code: 5444
• SQLSTATE: 42000
• Cause: The provided JavaScript Object Notation (JSON) path expression selects a non-scalar value.
• Solution: Correct the JSON path expression or use JSON_QUERY.

OBE-40459: output value too large (actual: %d, maximum: %d)

• OceanBase error code: 5473
• SQLSTATE: 42000
• Error cause: The result generated by the provided JavaScript Object Notation (JSON) operator exceeds the maximum length specified in the RETURN clause.
• Solution: Increase the minimum and maximum data types in the RETURNING clause, or use CLOB/BLOB in the RETURNING clause.

OBE-40462: No value was found by '%.192s' on the specified path

• OceanBase error code: 5432
• SQLSTATE: 22035
• Error cause: The provided JavaScript Object Notation (JSON) path expression did not select a value.
• Solution: Correct the JSON path expression.

OBE-40462: JSON_VALUE evaluated to no value

• OceanBase error code: 5445
• SQLSTATE: 42000
• Error cause: The provided JavaScript Object Notation (JSON) path expression did not select a value.
• Solution: Correct the JSON path expression.

OBE-40470: More than one value was found by '%.192s' on the specified path

• OceanBase error code: 5433
• SQLSTATE: 22034
• Error cause: The provided JavaScript Object Notation (JSON) path expression selected multiple values.
• Solution: Correct the JSON path expression or use JSON_QUERY.

OBE-40473: duplicate key names in JSON object

• OceanBase error code: 5453
• SQLSTATE: 42000
• Error message: The provided JavaScript Object Notation (JSON) data has duplicate key names in an object.
• Solution: Provide JSON data with unique key names in each JSON object.

OBE-40476: JSON key too long

• OceanBase error code: 5422
• SQLSTATE: 22032
• Error message: The provided JavaScript Object Notation (JSON) data has a key that exceeds the maximum length.
• Solution: Provide JSON data with shorter key names.

OBE-40480: result cannot be returned without array wrapper

• OceanBase error code: 5449
• SQLSTATE: 42000
• Error message: Results cannot be returned without an array wrapper.

OBE-40481: ASCII or PRETTY not supported for non*textual return data type

• OceanBase error code: 5469
• SQLSTATE: 42000
• Error message: Attempting to print or escape non-ASCII characters for non-text output in JavaScript Object Notation (JSON) operations.
• Solution: Change the return data type to VARCHAR2 or CLOB, or remove the PRETTY or ASCII serialization option.

OBE-40484: invalid data type for '%s' column

• OceanBase error code: 5459
• SQLSTATE: 42000
• Error message: The data type of column "%s" is invalid.
• Solution: Please enter correct information for column "%s".

OBE-40487: invalid usage of keyword EXISTS

• OceanBase error code: 5480
• SQLSTATE: 42000
• Error message: An invalid keyword is used, causing a syntax error in the expression.

OBE-40491: invalid input data type for JSON_TABLE

• OceanBase error code: 5481
• SQLSTATE: 42000
• Error message: The data type entered for JSON_TABLE is invalid.

OBE-40560: JSON_TABLE nested path expressions not disjunct

• OceanBase error code: 5483
• SQLSTATE: 42000
• Error message: Path expressions under the same level in JSON_TABLE cannot be duplicate.

OBE-40565: JSON path expression did not select a value

• OceanBase error code: 5468
• SQLSTATE: 42000
• Error message: The JavaScript Object Notation (JSON) path expression does not select a value.
• Solution: Correct the JSON path expression.

OBE-40566: JSON path expression selected a value of different data type

• OceanBase error code: 5467
• SQLSTATE: 42000
• Cause: A JavaScript Object Notation (JSON) path expression selects a value of a data type that is different from the requested data type.
• Solution: Use another "get*method" to retrieve the value selected by the JSON path expression.

OBE-40569: Unimplemented JSON feature

• OceanBase error code: 5479
• SQLSTATE: 42000
• Cause: An attempt was made to use an unimplemented JavaScript Object Notation (JSON) feature.
• Solution: Ensure the expression exists.

OBE-40570: JSON conversion failed

• OceanBase error code: 5476
• SQLSTATE: 42000
• Cause: JSON conversion failed.
• Solution: Check the type definition or the selected JSON value.

OBE-40571: JSON key name not found.", "JSON key name not found

• OceanBase error code: 5485
• SQLSTATE: 42000
• Cause: The key does not exist in the JSON data.

OBE-40573: Invalid use of PL/SQL JSON object type

• OceanBase error code: 5470
• SQLSTATE: 42000
• Cause: Attempted to use a PL/SQL JavaScript Object Notation (JSON) object type in an invalid context.
• Solution: Use PL/SQL JSON object types only within PL/SQL.

OBE-40576: Invalid use of bind variable in SQL/JSON path

• OceanBase error code: 5484
• SQLSTATE: 42000
• Error cause: The use of bound variables in the SQL/JSON path is invalid.

OBE-40587: invalid JSON type

• OceanBase error code: 5441
• SQLSTATE: 42000
• Error cause: Invalid JSON type, illegal JSON text.

OBE-40595: Name input to JSON generation function cannot be null

• OceanBase error code: 5429
• SQLSTATE: 22032
• Error cause: The name input for the JavaScript Object Notation (JSON) generation function is empty.
• Solution: Ensure the input has a valid value.

OBE-40597: JSON path expression syntax error ('%.*s')

• OceanBase error code: 5454
• SQLSTATE: 42000
• Error cause: Syntax error in the JSON path expression ("%.*s").

OBE-40600: JSON_EQUAL used outside predicate

• OceanBase error code: 5448
• SQLSTATE: 42000
• Error cause: JSON_EQUAL is used outside a predicate.
• Solution: Use JSON_EQUAL inside a predicate, for example, by embedding it in a CASE expression.

OBE-40629: Patch specification is not valid JSON

• OceanBase error code: 5450
• SQLSTATE: 42000
• Cause: The patch specification is not valid JSON.
• Solution: Ensure the patch specification is represented as valid JSON.

OBE-40654: Input to JSON generation function has unsupported data type

• OceanBase error code: 7420

• SQLSTATE: HY000

• Cause: An input parameter to a JSON generation function has an unsupported data type.

• Solution: Enter a valid data type or use a conversion function to convert the input parameter to a supported data type.

OBE-40654: Input to JSON generation function has unsupported data type

• OceanBase error code: 7431

• SQLSTATE: HY000

• Cause: An input parameter to a JSON generation function has an unsupported data type.

• Solution: Use the correct input or a conversion function to convert the input to a supported data type.

OBE-40656: Variable in JSON path expression has no value in PASSING clause

• OceanBase error code: 5456
• SQLSTATE: 42000
• Cause: The variable in the JSON path expression has no value in the PASSING statement.
• Solution: Add the variable to the outer PASSING clause and ensure the name matches.

OBE-40664: cannot add additional IS jSON check constraint

• OceanBase error code: 5464
• SQLSTATE: 42000
• Cause: An attempt was made to add an IS JSON check constraint to a column that already has an IS JSON check constraint.
• Solution: Check the addition of the IS JSON constraint.

• OceanBase error code: 5522
• SQLSTATE: 22000
• Cause: An invalid identifier is used in the path expression of the JSON_TABLE function.
• Solution: Strictly check and correct the syntax of the PATH clause in the JSON_TABLE function, paying special attention to the writing conventions at the beginning of the path, key name references, and array indices.

OBE-40688: date or time stamp string value does not conform to ISO 8601 format

• OceanBase error code: 5472
• SQLSTATE: 42000
• Cause: A date or timestamp string value does not conform to the ISO 8601 format.
• Solution: Provide a correct date or timestamp string value that conforms to the ISO 8601 format for conversion.

OBE-40750: Patch specification is not valid JSON

• OceanBase error code: 5452
• SQLSTATE: 42000
• Cause: The specified sort condition includes LOB columns, such as CLOB, BLOB, or JSON.
• Solution: Ensure that the data type of the sort column is not a large object, such as CLOB, BLOB, or JSON.

OBE-40779: Truncation is not supported with data type in RETURNING clause

• OceanBase error code: 5478
• SQLSTATE: 42000
• Cause: The data type in the RETURNING statement does not support truncation.

OBE-40783: invalid binary JSON data\nstring

• OceanBase error code: 5413
• SQLSTATE: 22032
• Cause: The provided binary JavaScript Object Notation (JSON) data is invalid.
• Solution: Provide valid binary JSON data.

OBE-40796: invalid comparison operation involving JSON type value

• OceanBase error code: 5461
• SQLSTATE: 42000
• Cause: An attempt was made to compare a value of the JavaScript Object Notation (JSON) type.
• Solution: Add a JSON-to-primitive conversion function to compare a JSON value with a scalar value. Use JSON_EQUAL to compare two JSON values.

OBE-40799: cannot convert Boolean value to number

• OceanBase error code: 5475
• SQLSTATE: 42000
• Cause: An attempt was made to convert a Boolean value selected by a JavaScript Object Notation (JSON path) expression with the number() or numberOnly() function into a number.
• Solution: Remove the number() or numberOnly() function from the JSON path expression.

OBE-40833: empty input to JSON operator

• OceanBase error code: 5463
• SQLSTATE: 42000
• Cause: An empty input (for example, an empty CLOB) was provided to a JSON operator that requires a non-empty input.
• Solution: Check and correct the input.

OBE-40876: invalid JSON schema document

• OceanBase error code: 6285

• SQLSTATE: 22032

• Cause: The JSON schema is invalid.

• Solution: Use the JSON schema specifications correctly.

OBE-42399: cannot perform a DML operation on a read-only view

• OceanBase error code: 5723

• SQLSTATE: HY000

• Cause: You attempted to insert, delete, or update rows in a read-only view. Performing DML operations on such views is explicitly prohibited.

• Solution: Perform the required DML operations on the base table of the view, or use the ALTER VIEW ... READ WRITE command to make the view operable.