OBE-30000 to 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 a 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 contained 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 to 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: Attempting 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 total number of nodes and their descendants on 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 fixed and generally should not be exceeded.

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

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 data extraction field.

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

• OceanBase error code: 5349

• SQLSTATE: HY000

• Error cause: A TIME or TIMESTAMP column lacks 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: There is an invalid type of parameter in the parameter list.

• Solution: Use the correct data type for the parameter.

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

• OceanBase error code: 5938

• SQLSTATE: HY000

• Cause: In the parameters of the SQL function UNISTR, to include a backslash (\\) within 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 of 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 numeric or 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 separator for the LISTAGG aggregate function must be a constant or an expression in the GROUP BY clause.

• Solution: Check whether the separator 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 used to define the index is non-deterministic.

• Solution: If the function is deterministic, mark it as such. 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: Attempting 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 some 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: Attempting 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 was not correctly 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 XPath expression used is correct and whether the database version supports the use of this XPath expression.

OBE-31013: invalid xpath expression

• OceanBase error code: 7404
• SQLSTATE: 42000
• Cause: The XPath expression is incorrectly formatted or invalid.
• 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-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: This operation is not supported for the type of the given node. 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 invalid.

• 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 attempted to change a parameter value, but the length of the value exceeds the maximum allowed. For list parameters, 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

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

• Solution: Specify an alias in the subquery definition and retry.

OBE-32034: unsupported use of WITH clause

• OceanBase error code: 5739

• SQLSTATE: HY000

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

  • Nesting WITH clauses within a WITH clause is not supported.

  • For 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

• Cause: A column alias or name list 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

• Cause: A WITH clause query refers to itself (recursive), but no column alias list is specified for it.

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

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

• OceanBase error code: 5742

• SQLSTATE: HY000

• Cause: A WITH clause query refers to itself (recursive), 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

• Cause: A WITH clause query refers to itself (recursive), 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 cause: The WITH clause query indirectly references itself (recursion), for example, through a subquery or view.

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

OBE-32043: recursive WITH clause needs an initialization branch

• OceanBase error code: 5745

• SQLSTATE: HY000

• Error cause: The WITH query clause recursively references itself, but in the UNION ALL, 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 cause: 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 cause: 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

• Error cause: The SEARCH clause of the recursive WITH query specifies the 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.

• 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 of 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-32361: cannot ENABLE ON QUERY COMPUTATION for the materialized view %s.%s

• OceanBase error code: 9783

• SQLSTATE: HY000

• Cause:

  • The materialized view definition does not meet requirements.
  • The object referenced by the materialized view is unavailable.

• Solution: Check the materialized view definition and its dependent objects to ensure they meet the requirements.

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

• OceanBase error code: 5752

• SQLSTATE: HY000

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

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

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

• OceanBase error code: 5753

• SQLSTATE: HY000

• Error description: A CYCLE clause was 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 equal.

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

• OceanBase error code: 5754

• SQLSTATE: HY000

• Error description: A SEARCH and CYCLE clause were 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 equal.

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

• OceanBase error code: 5755

• SQLSTATE: HY000

• Error description: A SEARCH clause was 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

• Error description: A CYCLE clause was 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: element in cycle column list of CYCLE clause must appear in the column alias list of the WITH clause element

• OceanBase error code: 5757

• SQLSTATE: HY000

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

• Solution: Modify the cycle column list to include only names that are part of the column alias list of the WITH clause elements.

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

• OceanBase error code: 5758

• SQLSTATE: HY000

• Error cause: The recursive component of a UNION ALL statement within an element of a recursive WITH clause uses an operation that is currently not supported. The recursive branch of a UNION ALL operation must not use GROUP BY, DISTINCT, MODEL, grouping sets, CONNECY BY, window functions, HAVING, or aggregate functions.

• 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

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

  • A LEFT OUTER join where the right side is the name of a recursive query.

  • A RIGHT OUTER join where the left side is the name of a recursive query.

  • A FULL OUTER join that involves the name of a recursive query.

• 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

• Error cause: A WITH clause element uses either the SEARCH clause, the CYCLE clause, or both, but no column alias list is specified for its query name.

• Solution: Add a column alias list 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: The elements in the sort specification list of the SEARCH clause specified in the recursive WITH query are not included in the list of column aliases for the elements in the WITH clause.

• Solution: Modify the sort specification list to ensure only names from the list of column aliases for the elements in the WITH clause are used.

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

• OceanBase error code: 5762

• SQLSTATE: HY000

• Cause: The recursive components of a UNION ALL in a recursive WITH clause element reference the recursive query name multiple times. In the recursive branch of a recursive WITH clause element, the recursive query name can only be referenced once.

• Solution: Rewrite the query to ensure the recursive branch of the recursive WITH clause element references the recursive query name only once.

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

• OceanBase error code: 5511
• SQLSTATE: 42000
• Cause: 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

• Cause: 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

• Cause: 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

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

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

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 attempt 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 associated sequence generator provides this value.

OBE-32796: cannot update a generated always identity column

• OceanBase error code: 5920

• SQLSTATE: HY000

• Cause: You attempt 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 attempt 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

• Error message: The LHS in the UPDATE SET clause contains a column referenced by the ON clause.

OBE-38778: Restore point %s already exists

• OceanBase error codes: 6259, 6261

• SQLSTATE: HY000

• Error message: 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

• Error message: The maximum number of restore points has 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

• Error message: 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

• Error message: 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 is syntactically 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 is syntactically 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 cause: The provided JavaScript Object Notation (JSON) data syntax 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 cause: Indicates that the current version does not support using references in JSON Schema.

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

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

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

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

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

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 clause.
• 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 maximum and minimum 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: Attempt to print or escape non-ASCII characters for non-text output of JavaScript Object Notation (JSON) data.
• 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: Enter correct information for column "%s".

OBE-40487: invalid usage of keyword EXISTS

• OceanBase error code: 5480
• SQLSTATE: 42000
• Error message: Invalid use of a keyword; 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 within the same level of JSON_TABLE must be disjoint.

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 is valid.

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 specified 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 blocks.

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 of 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 of 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 external 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.

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 in 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 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 type 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: Attempts to convert a boolean value selected by a JavaScript Object Notation (JSONPath) expression with the number() or numberOnly() function into a number.
• Solution: Remove the number() or numberOnly() function from the JSONPath 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 correctly.

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

• OceanBase error code: 5723

• SQLSTATE: HY000

• Cause: Attempts 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 operation on the base table of the view, or use the ALTER VIEW ... READ WRITE command to make the view operable.