Applicability
This topic applies only to OceanBase Database in Oracle mode.
OBE-00000: PX DOP downgrade from %ld to %ld
OceanBase Database error code: 5780
SQLSTATE: HY000
Cause: Normal exit.
OBE-00000: parallel_max_servers downgrade due to insufficient CPU resource from %ld to %ld. deprecated
OceanBase Database error code: 5781
SQLSTATE: HY000
Cause: Normal exit.
Note
This error code is no longer used in the current version.
OBE-00001: unique constraint \'%s\' for key \'%.*s\' violated
OceanBase Database error code: 5024
SQLSTATE: 23000
Cause: The
UPDATEorINSERTstatement attempts to insert a duplicate key.Solution: Remove the
UNIQUEconstraint or do not insert the key.
Related issues:
OBE-00001: unique constraint (%.*s) violated
OceanBase Database error code: 5595
SQLSTATE: 23000
Cause: The
UPDATEorINSERTstatement attempts to insert a duplicate key.Solution: Remove the
UNIQUEconstraint or do not insert the key.
OBE-00001: unique constraint violated, column '%.*s' with value '%.*s' in %s
OceanBase Database error code: 5334
SQLSTATE: HY000
Cause: The
UPDATEorINSERTstatement attempts to insert a duplicate key.Solution: Remove the
UNIQUEconstraint or do not insert the key.
OBE-00001: unique constraint (%.*s) violated
OceanBase Database error code: 5562
SQLSTATE: HY000
Cause: The
UPDATEorINSERTstatement attempts to insert a duplicate key.Solution: Remove the
UNIQUEconstraint or do not insert the key.
OBE-00036: maximum number of recursive SQL levels (%ld) exceeded
OceanBase Database error code: 9697
SQLSTATE: HY000
Cause: The specified number of recursive SQL levels is exceeded.
Solution: Remove the recursive SQL or the recursive trigger.
Note
This error code was introduced in OceanBase Database V4.0.0.
OBE-00051: timeout occurred while waiting for a resource
OceanBase Database error code: 5848
SQLSTATE: HY000
Cause: This error is usually caused by a dead instance.
Solution: Check whether there are dead or unrecovered instances. If so, recover them.
OBE-00054: resource busy and acquire with NOWAIT specified or timeout expired
OceanBase Database error code: 6006
SQLSTATE: HY000
Cause: The resource is busy.
Solution: Retry or increase the timeout.
OBE-00060: invalid argument for %s call
- OceanBase Database error code: 5488
- SQLSTATE: HY000
- Cause: The parameters for the %s call are invalid.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00060: deadlock detected while waiting for resource
OceanBase Database error code: 4101
SQLSTATE: HY000
Cause: A deadlock is detected while waiting for a resource.
Solution: View the trace file and check the transactions and resources involved. If necessary, retry.
OBE-00060: internal error code, arguments: -6005, Try lock row conflict
- OceanBase Database error code: 6005
- SQLSTATE: HY000
- Cause: The lock acquisition for the update operation fails. Return this error code to the upper layer and retry.
- Solution: Internal error code. Contact Technical Support for assistance.
Note
This error code cannot be captured by the PL exception handling mechanism in the current version.
OBE-00060: internal error code, arguments: -4012, Timeout, query has reached the maximum query timeout: %ld(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again
- OceanBase Database error code: 4012
- SQLSTATE: HY000
- Cause: The query times out.
- Solution:
- Optimize the performance to reduce the query time.
- Set a larger timeout.
- Contact Technical Support for assistance.
Note
This error code cannot be captured by the PL exception handling mechanism in the current version.
OBE-00060: internal error code, arguments: -4013, No memory or reach tenant memory limit
- OceanBase Database error code: 4013
- SQLSTATE: HY000
- Cause: The memory allocation fails.
- The physical memory is exhausted.
- The memory allocated in a single operation exceeds 4 GB.
- The memory usage of the CTX, tenant, or server reaches the upper limit.
- Solution: Contact Technical Support for assistance.
Note
This error code cannot be captured by the PL exception handling mechanism in the current version.
OBE-00060: internal error code, arguments: -4016, Internal error
- OceanBase Database error code: 4016
- SQLSTATE: HY000
- Cause: Internal error code.
- Solution: Internal error code. Contact Technical Support for assistance.
Note
This error code cannot be captured by the PL exception handling mechanism in the current version.
OBE-00060: internal error code, arguments: -4377, fatal internal error
- OceanBase error code: 4377
- SQLSTATE: HY000
- Cause: An unexpected internal error occurred in OceanBase Database. This might be caused by an exception during program execution.
- Solution: Contact OceanBase Technical Support for assistance.
Note
This error code is not captured by the PL exception handling mechanism in the current version.
OBE-00060: Migrate tx data not continues
OceanBase error code: 4408
SQLSTATE: HY000
Cause: The source transaction data table was recycled, and the destination copy found that the transaction data table was not continuous, failed to report an error, and retried.
Solution: Generally, after retrying, it can be successful. If it fails continuously, please contact OceanBase Technical Support for assistance.
Note
For V4.3.5, this error code was introduced in V4.3.5 BP2.
OBE-00060: internal error code, arguments: -5065, Query execution was interrupted
- OceanBase error code: 5065
- SQLSTATE: HY000
- Cause: The query was terminated.
- Solution: Contact the system administrator or database administrator.
Note
This error code is not captured by the PL exception handling mechanism in the current version.
OBE-00060: internal error code, arguments: -6220, SQL sequence illegal
- OceanBase error code: 6220
- SQLSTATE: HY000
- Cause: The SQL statement sequence is invalid.
- Solution: This is an internal error code. Please contact OceanBase Technical Support for assistance.
Note
This error code is not captured by the PL exception handling mechanism in the current version.
OBE-00224: object '%.*s' must be of type function or array to be used this way
OceanBase error code: 9765
SQLSTATE: HY000
Cause: The object '%.*s' must be of type function or array to be used this way.
Solution: Check the type of the object and adjust it as needed.
Note
This error code was introduced in V4.3.0.
OBE-00431: bulk SQL attributes must use a single index
OceanBase error code: 9838
SQLSTATE: HY000
Cause: Bulk SQL attributes must use a single index.
Solution: The core solution is to ensure that when referencing attributes of a bulk collection, the collection contains only one index variable.
Note
This error code was introduced in V4.4.2.
OBE-00437: FORALL bulk index cannot be used in INTO clause
OceanBase error code: 9836
SQLSTATE: HY000
Cause: The
FORALLbulk index cannot be used in theINTOclause.Solution: The core solution is to correctly separate the logic of data retrieval and data modification and use valid bulk operation syntax.
Note
This error code was introduced in V4.4.2.
OBE-00440: FORALL bulk IN-bind variables cannot be used here
OceanBase error code: 9837
SQLSTATE: HY000
Cause: The
FORALLbulk input bind variables cannot be used here.Solution: Avoid directly referencing the collection element variables that need to be processed by
FORALLin theUSINGclause. Instead, inline the values directly into the dynamic SQL string or use a valid binding method.
Note
This error code was introduced in V4.4.2.
OBE-00600: internal error code, arguments: -4410, ls not in learner list
OceanBase error code: 4410
SQLSTATE: HY000
Cause: During the process of selecting the source for migration or rebuild, the log stream replica on the destination is not in the learner list. This might be because the log stream replica on the destination has been deleted.
Solution: Wait for the corresponding task to automatically retry and resolve the issue.
Note
For V4.4.x, this error code was introduced in V4.4.1.
OBE-00600: arbitration service does not exist
OceanBase error code: 4747
SQLSTATE: HY000
Cause: The arbitration service address has not been configured for the cluster.
Solution: You cannot perform arbitration-related operations without configuring the arbitration service address. You can add the arbitration service address to the cluster by using OCP or executing the
alter system add arbitration service‘$svr_ip:$svr_port’;statement.
OBE-00600: arbitration service already exist
OceanBase error code: 4748
SQLSTATE: HY000
Cause: The cluster already has a valid arbitration service address.
Solution: A cluster does not support configuring multiple arbitration services at the same time.
EOBE-00600: wait degration finished timeout
OceanBase error code: 4751
SQLSTATE: HY000
Cause: The tenant downgrade failed during the Stop Server operation.
Solution: Retry the Stop Server command until it succeeds.
OBE-00600: unknown SET option '%s'
- OceanBase error code: 4764
- SQLSTATE: HY000
- Cause: An unknown SET option was specified when setting the parameter.
- Solution: Check whether the option specified in the SET statement is correct and ensure that there are no spelling or syntax errors.
Note
This error code was introduced in V4.2.0.
OBE-00600: Cannot create a JSON value from a string
OceanBase error code: 5415
SQLSTATE: 22032
Cause: Internal error code.
Solution: Internal error code. Please contact OceanBase Technical Support for assistance.
OBE-00600: Invalid JSON character data provided to function
OceanBase Database error code: 5416
SQLSTATE: 22032
Cause: Internal error code.
Solution: Internal error code. Contact OceanBase Technical Support for assistance.
OBE-00600: Invalid data type for JSON data in argument %u to function %s; a JSON string or JSON type is required
OceanBase Database error code: 5417
SQLSTATE: 22032
Cause: Internal error code.
Solution: Internal error code. Contact OceanBase Technical Support for assistance.
OBE-00600: Cannot CAST value to JSON
OceanBase Database error code: 5418
SQLSTATE: 22032
Cause: Internal error code.
Solution: Internal error code. Contact OceanBase Technical Support for assistance.
OBE-00600: A path expression must be encoded in the utf8 character set
OceanBase Database error code: 5419
SQLSTATE: 22032
Cause: Internal error code.
Solution: Internal error code. Contact OceanBase Technical Support for assistance.
OBE-00600: In this situation, path expressions may not contain the * and ** tokens
OceanBase Database error code: 5420
SQLSTATE: 22032
Cause: Internal error code.
Solution: Internal error code. Contact OceanBase Technical Support for assistance.
OBE-00600: The JSON value is too big to be stored in a JSON column
OceanBase Database error code: 5421
SQLSTATE: 22032
Cause: Internal error code.
Solution: Internal error code. Contact OceanBase Technical Support for assistance.
OBE-00600: JSON column '%.*s' cannot be used in key specification
OceanBase Database error code: 5423
SQLSTATE: 22032
Cause: Internal error code.
Solution: Internal error code. Contact OceanBase Technical Support for assistance.
OBE-00600: The path expression is not allowed in this context
OceanBase Database error code: 5424
SQLSTATE: 22032
Cause: Internal error code.
Solution: Internal error code. Contact OceanBase Technical Support for assistance.
OBE-00600: The oneOrAll argument may take these values: \'one\' or \'all\'
OceanBase Database error code: 5425
SQLSTATE: 22032
Cause: Internal error code.
Solution: Internal error code. Contact OceanBase Technical Support for assistance.
OBE-00600: Out of range JSON value for CAST
OceanBase Database error code: 5426
SQLSTATE: 22032
Cause: Internal error code.
Solution: Internal error code. Contact OceanBase Technical Support for assistance.
OBE-00600: Invalid JSON value for CAST
OceanBase Database error code: 5427
SQLSTATE: 22032
Cause: Internal error code.
Solution: Internal error code. Contact OceanBase Technical Support for assistance.
OBE-00600: The JSON document exceeds the maximum depth
OceanBase Database error code: 5428
SQLSTATE: 22032
Cause: Internal error code.
Solution: Internal error code. Contact OceanBase Technical Support for assistance.
OBE-00600: Invalid default value for \'%.*s\'
OceanBase Database error code: 5430
SQLSTATE: 22032
Cause: Internal error code.
Solution: Internal error code. Contact OceanBase Technical Support for assistance.
OBE-00600: A path expression is not a path to a cell in an array
OceanBase Database error code: 5431
SQLSTATE: 22032
Cause: Internal error code.
Solution: Internal error code. Contact OceanBase Technical Support for assistance.
OBE-40600: JSON_EQUAL used outside predicate
- OceanBase Database error code: 5448
- SQLSTATE: 42000
- Cause: JSON_EQUAL is used outside a predicate.
- Solution: Use JSON_EQUAL inside a predicate, such as in a CASE expression.
Note
This error code was introduced in V4.1.0.
OBE-00600: auto increment service busy
OceanBase Database error code: 5794
SQLSTATE: HY000
Cause: Internal error code.
Solution: Internal error code. Contact OceanBase Technical Support for assistance.
OBE-00600: rowid type mismatch, expect %.*s, got %.*s"
OceanBase Database error code: 5870
SQLSTATE: HY000
Cause: Internal error code.
Solution: Internal error code. Contact OceanBase Technical Support for assistance.
OBE-00600: rowid num mismatch, expect %ld, actual %ld
OceanBase Database error code: 5871
SQLSTATE: HY000
Cause: Internal error code.
Solution: Internal error code. Contact OceanBase Technical Support for assistance.
OBE-00600: internal error code, arguments: -7124, partitions are already balanced, %s
OceanBase Database error code: 7124
SQLSTATE: HY000
Cause: The partitions are already balanced when you attempt to execute a partition balancing operation.
Note
- This error code was introduced in V4.3.2 of the V4.3.x series.
- This error code was introduced in V4.2.4 of the V4.2.x series.
OBE-00600: Binary geometry function given two geometries of different srids.Binary geometry function %s given two geometries of different srids: %u and %u, which should have been identical
- OceanBase Database error code: 7201
- SQLSTATE: HY000
- Cause: The binary geometry function is given two geometries of different SRIDs: %u and %u, which should have been identical. The geometry values passed as parameters to spatial functions must have the same SRID value.
Note
This error code was introduced in V4.1.0.
OBE-00600: Calling geometry function with unsupported types of arguments.Calling geometry function %s with unsupported types of arguments
- OceanBase error code: 7202
- SQLSTATE: HY000
- Cause: The geometry function %s is called with unsupported types of arguments.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Unknown GIS error occurred in function.Unknown GIS error occurred in function %s
- OceanBase error code: 7203
- SQLSTATE: HY000
- Cause: An unknown GIS error occurred in the function %s.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Unknown exception caught in GIS function.Unknown exception caught in GIS function %s
- OceanBase error code: 7204
- SQLSTATE: HY000
- Cause: An unknown exception is caught in the GIS function %s.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Invalid GIS data provided to function.Invalid GIS data provided to function %s
- OceanBase error code: 7205
- SQLSTATE: 22023
- Cause: Invalid GIS data is provided to the function %s. The function %s is called with parameters that are not recognized as valid geometry values.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: The geometry has no data in function.The geometry has no data in function %s
- OceanBase error code: 7206
- SQLSTATE: HY000
- Cause: The geometry has no data in the function %s.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Unable to calculate centroid because geometry is empty in function.Unable to calculate centroid because geometry is empty in function %s
- OceanBase error code: 7207
- SQLSTATE: HY000
- Cause: The centroid cannot be calculated because the geometry is empty in the function %s.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Geometry overlay calculation error: geometry data is invalid in function.Geometry overlay calculation error: geometry data is invalid in function %s
- OceanBase error code: 7208
- SQLSTATE: HY000
- Cause: The geometry overlay calculation error occurs because the geometry data is invalid in the function %s.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Geometry turn info calculation error: geometry data is invalid in function.Geometry turn info calculation error: geometry data is invalid in function %s
- OceanBase error code: 7209
- SQLSTATE: HY000
- Cause: The geometry turn info calculation error occurs because the geometry data is invalid in the function %s.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Analysis procedures of intersection points interrupted unexpectedly in function.Analysis procedures of intersection points interrupted unexpectedly in function %s
- OceanBase error code: 7210
- SQLSTATE: HY000
- Cause: The analysis procedures of intersection points are interrupted unexpectedly in the function %s.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Unknown exception thrown in function.Unknown exception thrown in function %s
- OceanBase error code: 7211
- SQLSTATE: HY000
- Cause: An unknown exception is thrown in the function %s.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Geometry byte string must be little endian
- OceanBase error code: 7212
- SQLSTATE: HY000
- Cause: The geometry byte string must be little endian.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Do not support online operation on table with GIS index
- OceanBase error code: 7213
- SQLSTATE: HY000
- Cause: Online operation is not supported on a table with a GIS index.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Inconsistent intersection points.Inconsistent intersection points
- OceanBase error code: 7214
- SQLSTATE: HY000
- Cause: Inconsistent intersection points.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: The parameter exceeds the maximum number of points in a geometry in the function. Parameter %s exceeds the maximum number of points in a geometry (%lu) in the function %s
- OceanBase error code: 7215
- SQLSTATE: HY000
- Cause: The parameter %s exceeds the maximum number of points in the geometry (%lu) in the function %s.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: The value is a geometry of an unexpected type. %.64s value is a geometry of an unexpected type %.64s in %.64s
- OceanBase error code: 7216
- SQLSTATE: 22S01
- Cause: The %s value is a geometry of an unexpected type %s in %s.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: Cannot parse the spatial reference system definition of the SRID. Cannot parse the spatial reference system definition of the SRID %u
- OceanBase error code: 7217
- SQLSTATE: SR002
- Cause: The spatial reference system definition of the SRID %u cannot be parsed.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: The spatial reference system definition for the SRID does not specify the mandatory (EPSG) projection parameter. The spatial reference system definition for the SRID %u does not specify the mandatory %s (EPSG %u) projection parameter
- OceanBase error code: 7218
- SQLSTATE: SR003
- Cause: The spatial reference system definition for the SRID %u does not specify the mandatory %s (EPSG %u) projection parameter.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: There is no spatial reference system with the SRID. There is no spatial reference system with the SRID %u
- OceanBase error code: 7219
- SQLSTATE: 01000
- Cause: There is no spatial reference system with the SRID %u.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: The function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in the SRID %u, which is not a Cartesian spatial reference system. The function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in the SRID %u, which is not a Cartesian spatial reference system
- OceanBase error code: 7220
- SQLSTATE: 22S00
- Cause: The function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in the SRID %u, which is not a Cartesian spatial reference system.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: The function is only defined for Cartesian spatial reference systems, but one of its arguments is in the SRID, which has not been defined. The function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in the SRID %u, which has not been defined
- OceanBase error code: 7221
- SQLSTATE: SR001
- Cause: The function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in the SRID %u, which has not been defined.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: There is no spatial reference system with the SRID. There is no spatial reference system with the SRID %u
- OceanBase error code: 7222
- SQLSTATE: SR001
- Cause: There is no spatial reference system with the SRID %u.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: There is no spatial reference system with the SRID. The axis order is unknown. There is no spatial reference system with the SRID %u. The axis order is unknown
- OceanBase error code: 7223
- SQLSTATE: 01000
- Cause: There is no spatial reference system with the SRID %u. The axis order is unknown.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: It has not been implemented for geographic spatial reference systems. %.192s(%.80s) has not been implemented for geographic spatial reference systems
- OceanBase error code: 7224
- SQLSTATE: 22S00
- Cause: %s(%s) has not been implemented for geographic spatial reference systems.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: The SRID of the geometry does not match the SRID of the column. The SRID of the geometry is %lu, but the SRID of the column is %lu. Consider changing the SRID of the geometry or the SRID property of the column
- OceanBase error code: 7225
- SQLSTATE: HY000
- Cause: The SRID of the geometry does not match the SRID of the column '%s'. The SRID of the geometry is %lu, but the SRID of the column is %lu. Consider changing the SRID of the geometry or the SRID property of the column.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: The SRID specification on the column cannot be changed because there is a spatial index on the column. The SRID specification on the column '%.64s' cannot be changed because there is a spatial index on the column. Please remove the spatial index before altering the SRID specification
- OceanBase error code: 7226
- SQLSTATE: HY000
- Cause: The SRID specification on the column '%s' cannot be changed because there is a spatial index on the column. Please remove the spatial index before altering the SRID specification.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: The spatial index on the column will not be used by the query optimizer since the column does not have an SRID attribute. The spatial index on the column '%.64s' will not be used by the query optimizer since the column does not have an SRID attribute. Consider adding an SRID attribute to the column
- OceanBase error code: 7227
- SQLSTATE: HY000
- Cause: The spatial index on the column '%s' will not be used by the query optimizer since the column does not have an SRID attribute. Consider adding an SRID attribute to the column.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: The function is only defined for SRID 0 and SRID 4326. The function %.192s is only defined for SRID 0 and SRID 4326
- OceanBase error code: 7228
- SQLSTATE: 22S00
- Cause: The function %s is only defined for SRID 0 and SRID 4326.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: It has not been implemented for Cartesian spatial reference systems. %.192s(%.80s) has not been implemented for Cartesian spatial reference systems
- OceanBase error code: 7229
- SQLSTATE: 22S00
- Cause: %.192s(%.80s) has not been implemented for Cartesian spatial reference systems.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: It has not been implemented for projected spatial reference systems. %.192s(%.80s) has not been implemented for projected spatial reference systems
- OceanBase error code: 7230
- SQLSTATE: 22S00
- Cause: %.192s(%.80s) has not been implemented for projected spatial reference systems.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: Missing mandatory attribute. Missing mandatory attribute %s
- OceanBase error code: 7231
- SQLSTATE: SR006
- Cause: Missing mandatory attribute %s.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: Multiple definitions of attribute. Multiple definitions of attribute %s
- OceanBase error code: 7232
- SQLSTATE: SR006
- Cause: Multiple definitions of attribute %s.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: The spatial reference system name can't be an empty string or start or end with whitespace
- OceanBase error code: 7233
- SQLSTATE: SR006
- Cause: The spatial reference system name can't be an empty string or start or end with whitespace.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: The organization name can't be an empty string or start or end with whitespace
- OceanBase error code: 7234
- SQLSTATE: SR006
- Cause: The organization name can't be an empty string or start or end with whitespace.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: There is already a spatial reference system with SRID. There is already a spatial reference system with SRID %u
- OceanBase error code: 7235
- SQLSTATE: SR004
- Cause: A spatial reference system with SRID %u already exists.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: There is already a spatial reference system with SRID. There is already a spatial reference system with SRID %u
- OceanBase error code: 7236
- SQLSTATE: 01S00
- Cause: A spatial reference system with SRID %u already exists.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: SRID 0 is not modifiable
- OceanBase error code: 7237
- SQLSTATE: SR000
- Cause: SRID 0 cannot be modified.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: The SRID range has been reserved for system use. SRSs in this range may be added, modified, or removed without warning during upgrade. The SRID range [%u, %u] has been reserved for system use. SRSs in this range may be added, modified, or removed without warning during upgrade
- OceanBase error code: 7238
- SQLSTATE: 01S01
- Cause: The SRID range [%u, %u] has been reserved for system use. During upgrade, SRSs in this range may be added, modified, or removed without warning.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: Can't modify SRID. There is at least one column depending on it. Can't modify SRID %u. There is at least one column depending on it
- OceanBase error code: 7239
- SQLSTATE: SR005
- Cause: SRID %u cannot be modified because at least one column depends on it.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: Invalid character in attribute. Invalid character in attribute %s
- OceanBase error code: 7240
- SQLSTATE: SR006
- Cause: The character in attribute %s is invalid.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: Attribute is too long. Attribute %s is too long. The maximum length is %u characters
- OceanBase error code: 7241
- SQLSTATE: SR006
- Cause: The length of attribute %s exceeds the maximum of %u characters.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: Function is only defined for geographic spatial reference systems, but one of its arguments is in SRID, which is not geographic. Function %s is only defined for geographic spatial reference systems, but one of its arguments is in SRID %u, which is not geographic
- OceanBase error code: 7242
- SQLSTATE: 22S00
- Cause: The function %s is defined only for geographic spatial reference systems, but one of its arguments is in SRID %u, which is not geographic.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: Function encountered a polygon that was too large. Polygons must cover less than half the planet. Function %s encountered a polygon that was too large. Polygons must cover less than half the planet
- OceanBase error code: 7243
- SQLSTATE: 22023
- Cause: The function %s encountered a polygon that is too large.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: Spatial indexes can't be primary or unique indexes
- OceanBase error code: 7244
- SQLSTATE: HY000
- Cause: A spatial index cannot be a primary or unique index.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: The index type is not supported for spatial indexes. The index type %.20s is not supported for spatial indexes
- OceanBase error code: 7245
- SQLSTATE: HY000
- Cause: The index type %s is not supported for spatial indexes.
Note
This error code was introduced in OceanBase Database V4.1.0.
OBE-00600: A parameter of function contains a geometry with longitude, which is out of range.A parameter of function %.192s contains a geometry with longitude %f, which is out of range. It must be within (%f, %f]
- OceanBase error code: 7246
- SQLSTATE: 22S02
- Cause: The parameter of the function %s contains a geometry with longitude %f, which is out of range. It must be within (%f, %f].
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: A parameter of function contains a geometry with latitude, which is out of range.A parameter of function %.192s contains a geometry with latitude %f, which is out of range. It must be within [%f, %f]
- OceanBase error code: 7247
- SQLSTATE: 22S03
- Cause: The parameter of the function %s contains a geometry with latitude %f, which is out of range. It must be within [%f, %f].
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: The spatial reference system definition for SRID specifies invalid geographic axes. One axis must be NORTH or SOUTH and the other must be EAST or WEST.he spatial reference system definition for SRID %u specifies invalid geographic axes '%.20s' and '%.20s'. One axis must be NORTH or SOUTH and the other must be EAST or WEST
- OceanBase error code: 7248
- SQLSTATE: SR002
- Cause: The spatial reference system definition for SRID %u specifies invalid geographic axes "%.20s" and "%.20s". One axis must be NORTH or SOUTH, and the other must be EAST or WEST.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: The spatial reference system definition for SRID specifies invalid geographic axes. One axis must be NORTH or SOUTH and the other must be EAST or WEST.he spatial reference system definition for SRID %u specifies invalid geographic axes '%.20s' and '%.20s'. One axis must be NORTH or SOUTH and the other must be EAST or WEST
- OceanBase error code: 7249
- SQLSTATE: SR002
- Cause: The spatial reference system definition for SRID %u specifies invalid geographic axes "%.20s" and "%.20s". One axis must be NORTH or SOUTH, and the other must be EAST or WEST.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: The inverse flattening must be larger than 1.0, or 0.0 if the ellipsoid is a sphere
- OceanBase error code: 7250
- SQLSTATE: SR002
- Cause: The inverse flattening must be greater than 1.0. If the ellipsoid is a sphere, the inverse flattening must be 0.0.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: The angular unit conversion factor must be a positive number
- OceanBase error code: 7251
- SQLSTATE: SR002
- Cause: The angular unit conversion factor must be a positive number.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: The prime meridian must be within (*180, 180] degrees, specified in the SRS angular unit
- OceanBase error code: 7252
- SQLSTATE: SR002
- Cause: The prime meridian must be within (*180, 180] degrees, specified in the SRS angular unit.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Transformation from SRID is not supported.Transformation from SRID %u is not supported
- OceanBase error code: 7253
- SQLSTATE: 22S00
- Cause: Transformation from SRID %u is not supported.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Transformation to SRID is not supported.Transformation to SRID %u is not supported
- OceanBase error code: 7254
- SQLSTATE: 22S00
- Cause: Transformation to SRID %u is not supported.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Transformation from SRID %u is not supported. The spatial reference system has no TOWGS84 clause
- OceanBase error code: 7255
- SQLSTATE: 22S00
- Cause: Transformation from SRID %u is not supported. The spatial reference system has no TOWGS84 clause.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Transformation to SRID %u is not supported. The spatial reference system has no TOWGS84 clause
- OceanBase error code: 7256
- SQLSTATE: 22S00
- Cause: The transformation to SRID %u is not supported. The spatial reference system has no TOWGS84 clause.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Cannot create a functional index on a function that returns a JSON or GEOMETRY value
- OceanBase error code: 7257
- SQLSTATE: 42000
- Cause: A functional index cannot be created on a function that returns a JSON or GEOMETRY value.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Spatial functional index is not supported
- OceanBase error code: 7258
- SQLSTATE: HY000
- Cause: Spatial functional indexes are not supported.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: The geometry passed to function is in SRID 0, which doesn't specify a length unit. Can't convert. The geometry passed to function %s is in SRID 0, which doesn't specify a length unit. Can't convert to '%s'
- OceanBase error code: 7259
- SQLSTATE: SU001
- Cause: The geometry passed to function %s is in SRID 0, which does not specify a length unit. The geometry cannot be converted to '%s'.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Invalid cast. Invalid cast from %s to %s
- OceanBase error code: 7260
- SQLSTATE: 22S01
- Cause: The conversion from %s to %s is invalid.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Invalid cast. A polygon ring is in the wrong direction. Invalid cast from %s to %s. A polygon ring is in the wrong direction
- OceanBase error code: 7261
- SQLSTATE: 22S04
- Cause: The conversion from %s to %s is invalid. The direction of a polygon ring is incorrect.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Arguments to function contains geometries with different SRIDs. All geometries must have the same SRID. Arguments to function %s contains geometries with different SRIDs: %u and %u. All geometries must have the same SRID
- OceanBase error code: 7262
- SQLSTATE: 22S05
- Cause: The function %s contains geometries %u and %u with different SRIDs. All geometries must have the same SRID.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Longitude is out of range in function. Longitude %f is out of range in function %.192s. It must be within (%f, %f]
- OceanBase error code: 7263
- SQLSTATE: 22S02
- Cause: The longitude %f is out of range in function %s. It must be within (%f, %f].
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Latitude is out of range in function. Latitude %f is out of range in function %.192s. It must be within [%f, %f]
- OceanBase error code: 7264
- SQLSTATE: 22S03
- Cause: The latitude %f is out of range in function %s. It must be within [%f, %f].
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Memory allocation error. Memory allocation error: %*.256s in function %s
- OceanBase error code: 7265
- SQLSTATE: HY000
- Cause: A memory allocation error occurs in function %s: %s.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Domain error. Domain error: %*.256s in function %s
- OceanBase error code: 7266
- SQLSTATE: HY000
- Cause: A domain error occurs in function %s: %s.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Length error. Length error: %*.256s in function %s
- OceanBase error code: 7267
- SQLSTATE: HY000
- Cause: A length error occurs in function %s: %s.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Invalid argument error. Invalid argument error: %*.256s in function %s
- OceanBase Database error code: 7268
- SQLSTATE: HY000
- Cause: An invalid argument error occurred in the %s function: %s.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Out of range error. Out of range error: %*.256s in function %s
- OceanBase Database error code: 7269
- SQLSTATE: HY000
- Cause: An out-of-range error occurred in the %s function: %s.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Overflow error. Overflow error: %*.256s in function %s
- OceanBase Database error code: 7270
- SQLSTATE: HY000
- Cause: An overflow error occurred in the %s function: %s.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Range error. Range error: %*.256s in function %s
- OceanBase Database error code: 7271
- SQLSTATE: HY000
- Cause: A range error occurred in the %s function: %s.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Underflow error. Underflow error: %*.256s in function %s
- OceanBase Database error code: 7272
- SQLSTATE: HY000
- Cause: An underflow error occurred in the %s function: %s.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Logic error. Logic error: %*.256s in function %s
- OceanBase Database error code: 7273
- SQLSTATE: HY000
- Cause: A logic error occurred in the %s function: %s.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Runtime error. Runtime error: %*.256s in function %s
- OceanBase Database error code: 7274
- SQLSTATE: HY000
- Cause: A runtime error occurred in the %s function: %s.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Unknown exception: %*.384s in function %s
- OceanBase Database error code: 7275
- SQLSTATE: HY000
- Cause: An unknown exception occurred in the %s function: %s.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Cannot get geometry object from data you send to the GEOMETRY field
- OceanBase Database error code: 7276
- SQLSTATE: 22003
- Cause: The geometry object cannot be obtained from the data you send to the GEOMETRY field.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Incorrect usage of srid, srid column attribute only support in geometry
- OceanBase Database error code: 7277
- SQLSTATE: HY000
- Cause: The srid is used incorrectly. The srid column attribute is supported only for geometry.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Incorrect usage of spatial/fulltext/hash index and explicit index order
- OceanBase Database error code: 7278
- SQLSTATE: HY000
- Cause: The spatial, full-text, and hash indexes and the explicit index order are used incorrectly.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: All parts of a SPATIAL index must be NOT NULL
- OceanBase Database error code: 7280
- SQLSTATE: 42000
- Cause: All parts of the SPATIAL index must be NOT NULL.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: The index type is not supported for spatial indexes.The index type %s is not supported for spatial indexes
- OceanBase Database error code: 7281
- SQLSTATE: HY000
- Cause: The %s index type is not supported for spatial indexes.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: There's no unit of measure.There's no unit of measure named '%s'
- OceanBase Database error code: 7282
- SQLSTATE: SU001
- Cause: There is no unit of measure named '%s'.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: The string is not a valid key value pair in function. The string '%.192s' is not a valid key %c value pair in function '%.192s'
- OceanBase Database error code: 7283
- SQLSTATE: 22023
- Cause: The string '%s' is not a valid key %c value pair in function '%s'.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Invalid radius provided to function: Radius must be greater than zero. Invalid radius provided to function '%s': Radius(%lf) must be greater than zero
- OceanBase Database error code: 7284
- SQLSTATE: 22023
- Cause: The radius provided to function '%s' is invalid. The radius must be greater than zero.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Spatial reference system is empty
- OceanBase Database error code: 7285
- SQLSTATE: SR001
- Cause: The spatial reference system with SRID %u does not exist.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Invalid option key in function. Invalid option key '%.192s' in function '%.192s'
- OceanBase Database error code: 7286
- SQLSTATE: 22023
- Cause: The option key '%s' in function '%s' is invalid.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Invalid value for option in function. Invalid value '%.192s' for option '%.192s' in function '%.192s'
- OceanBase Database error code: 7287
- SQLSTATE: 22023
- Cause: The value '%s' for option '%s' in function '%s' is invalid.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: Unknown WKB type. Unknown WKB type(%d)! Full WKB type number was (%d)
- OceanBase Database error code: 7288
- SQLSTATE: 22S01
- Cause: The geometry value of type %s is unexpected in %s.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00600: A FTS index may only contain a text type column.
OceanBase Database error code: 7289
SQLSTATE: 42000
Cause: The full-text search (FTS) index can contain only text type columns.
Solution: Make sure that the data type of the column for which you want to create an FTS index is a text type, such as VARCHAR, TEXT, or CHAR.
Note
This error code is introduced in OceanBase Database V4.2.2.
OBE-00600: internal error code, arguments: -9129, object storage io error
- OceanBase Database error code: 9129
- SQLSTATE: HY000
- Cause: The object storage error code. Common causes include object storage connectivity and compatibility issues.
- Solution: Check the connectivity of the object storage. If no connectivity issues are found, contact OceanBase Technical Support.
OBE-00600: tmp file exceeds disk quota
OceanBase Database error code: 9135
SQLSTATE: HY000
Cause: The amount of data written to the disk by the temporary file exceeds the upper limit.
Solution: Check whether the amount of data generated by the SQL statement that caused the current error exceeds the expected value (for example, the maximum amount of data that can be written to the disk by the temporary file is 500 GB). If the amount of data is within the expected value, you can set the
temporary_file_max_disk_sizeparameter to an appropriate value.
Note
This error code is introduced in OceanBase Database V4.3.5 BP1.
OBE-00600: kms destination is not valid
OceanBase Database error code: 9139
SQLSTATE: HY000
Cause: The key address is not specified or the specified key address is invalid when the transparent encryption feature is enabled for the backup tenant and the restore tenant is being restored.
Solution: Specify the correct key address in the restore command or set the
@kms_encrypt_infosession variable to the correct key address before the restore.
Note
This error code is introduced in OceanBase Database V4.3.5 BP2.
OBE-00600: the object is locked by worm
OceanBase Database error code: 9140
SQLSTATE: HY000
Cause: The object in the object storage is in the retention period.
Solution: Check whether the backup or archive path is configured with a retention strategy and whether the
enable_wormparameter is correctly set when the backup or archive path is configured. If theenable_wormparameter is correctly set, contact OceanBase Technical Support.
Note
This error code is introduced in OceanBase Database V4.3.5 BP2.
OBE-00600: the resource has been released
OceanBase Database error code: 9141
SQLSTATE: HY000
Cause: The temporary file macroblock is unexpectedly released during use.
Solution: Contact OceanBase Technical Support.
Note
This error code is introduced in OceanBase Database V4.3.5 BP2.
OBE-00600: the object can not be overwritten with different content
OceanBase error code: 9142
SQLSTATE: HY000
Cause: An object with the same name is written to an object storage service that has a retention policy.
Solution: Contact OceanBase Technical Support for troubleshooting.
Note
This error code was introduced in V4.3.5 BP2 for V4.3.5.
OBE-00600: internal error code, arguments: -9147, can not access backup set file
OceanBase error code: 9147
SQLSTATE: HY000
Cause: During physical restore, the OBServer node cannot access the backup set file in the specified backup media.
Solution: Check the connectivity of the object storage service. If no connectivity issues are found, contact Technical Support for troubleshooting.
Note
This error code was introduced in V4.4.1 for V4.4.x.
OBE-00600: internal error code, arguments: -9148, disk quota is exceeded
OceanBase error code: 9148
SQLSTATE: HY000
Cause: The disk quota is exceeded.
Solution: Clean up files or adjust the disk quota.
Note
This error code was introduced in V4.4.1 for V4.4.x.
OBE-00600: internal error code, arguments: -9149, backup dest is not allowed to set when log_only policy exists
OceanBase error code: 9149
SQLSTATE: HY000
Cause: The
log_onlycleanup policy applies to scenarios where only log archiving is enabled and no data backup is performed. When thelog_onlycleanup policy exists, data backup paths cannot be configured.Solution: First, delete the
log_onlycleanup policy, and then configure the data backup path.
Note
This error code was introduced in V4.4.1 for V4.4.x.
OBE-00600: internal error code, arguments: -9150, log_only policy is not allowed to set when backup dest exists
OceanBase error code: 9150
SQLSTATE: HY000
Cause: The
log_onlycleanup policy applies to scenarios where only log archiving is enabled and no data backup is performed. In scenarios where a data backup path is configured, the cleanup policy cannot be set tolog_only.Solution: If you want to use the
log_onlycleanup policy, you need to delete the configured data backup path first.
Note
This error code was introduced in V4.4.1 for V4.4.x.
OBE-00600: internal error code, arguments: -9151, backup clean can not start, because %s
OceanBase error code: 9151
SQLSTATE: HY000
Cause: Data backup and log archiving cleanup cannot be performed. Possible reasons include that the status of the related tenant is not
NORMAL(for example,CREATINGorRESTORE) or that the related tenant has not been configured with a cleanup policy (for the expiration cleanup scenario).Solution: Check whether the tenant status is normal. For the expiration cleanup scenario, confirm whether the related tenant has been correctly configured with a cleanup policy.
Note
This error code was introduced in V4.4.1 for V4.4.x.
OBE-00600: internal error code, arguments: -9152, backup device may be not mounted, %s did not read any data written by %s
OceanBase error code: 9152
SQLSTATE: HY000
Cause: The backup media is not correctly mounted.
Solution: Mount the backup media correctly and ensure that all OBServer nodes of the tenant initiating the archive/backup/recovery operation can access the same backup media. For more information about how to mount an NFS, see Deploy NFS.
Note
This error code was introduced in V4.4.1 for V4.4.x.
OBE-00600: internal error code, arguments: -9153, backup device is not read and write strongly consistent. %s did not read the latest data written by %s.
OceanBase error code: 9153
SQLSTATE: HY000
Cause: The backup media does not have strong consistency for read and write operations.
Solution: If the backup media is an NFS, mount it according to the specified method as described in Deploy NFS. If the backup media is an object storage service, contact the corresponding service provider.
Note
This error code was introduced in V4.4.1 for V4.4.x.
OBE-00600: Incorrect usage of %s
- OceanBase error code: 9751
- SQLSTATE: HY000
- Cause: The usage is incorrect.
- Solution: Check whether the usage is correct and use it correctly.
Note
This error code was introduced in V4.2.1.
OBE-00600: internal error code, arguments: -11093,OBLogService rpc execute failed
OceanBase error code: 11093
SQLSTATE: HY000
Cause: The RPC call to the log service failed due to insufficient resources or network issues on the target node.
Solution: First, use the trace_id to locate the logs of the target node. Then, resolve the issue by monitoring resources and adjusting parameters.
Note
This error code was introduced in V4.4.0.
OBE-00603: Prepare statement checksum error
OceanBase Database error code: 5777
SQLSTATE: HY000
Cause: The server session is in an unrecoverable state.
Solution: Log in to OceanBase Database again to automatically create a new server session. For more information, see the session tracking file.
OBE-00739: FORALL INSERT/UPDATE/DELETE not supported on remote tables
- OceanBase Database error code: 9752
- SQLSTATE: HY000
- Cause: The FORALL INSERT/UPDATE/DELETE statement is not supported for remote tables.
- Solution: Do not use the FORALL INSERT/UPDATE/DELETE statement for remote tables.
Note
This error code was introduced in V4.2.1.
OBE-00900: Invalid SQL statement
OceanBase Database error code: 5001
SQLSTATE: 42000
Cause: The SQL statement is invalid.
Solution: For the correct SQL statement, see the SQL Reference (Oracle mode) of the corresponding version of OceanBase Database.
OceanBase error code: 5006
SQLSTATE: 42000
Cause: The SQL statement is incorrect.
Solution: For the correct SQL statement, refer to the "SQL Reference (Oracle mode)" of the corresponding OceanBase Database version.
Related case:
- Error OBE-00900 when creating a table group with RANGE or LIST partitions in an Oracle tenant
- PL modules in Oracle mode of OceanBase Database do not support identifiers such as NEW
- An error occurs when a stored procedure is called in an Oracle tenant that does not support the $$PLSQL_UNIT variable
- Differences between unique constraints and regular constraints in OceanBase Database
OBE-00902: invalid datatype
OceanBase error code: 5874
SQLSTATE: HY000
Cause: The data type is invalid.
OBE-00903: invalid table name
OceanBase error code: 5163
SQLSTATE: 42000
Cause: The table name is invalid.
OBE-00904: invalid identifier '%.*s'
OceanBase error code: 5164
SQLSTATE: 42000
Cause: The identifier in the string is invalid.
OBE-00904: invalid identifier '%.*s' in '%.*s'
OceanBase error code: 5217
SQLSTATE: 42S22
Cause: The identifier in the string is invalid.
Related issues:
OBE-00904: '%.*s': invalid identifier
OceanBase error code: 5211
SQLSTATE: 42000
Cause: The identifier in the string is invalid.
Note
This error code is introduced in OceanBase Database V4.0.0.
OBE-00905: missing keyword
OceanBase error code: 5096
SQLSTATE: HY000
Cause: The SQL statement is missing a keyword.
OBE-00909: invalid number of arguments in the call to native function '%.*s'
OceanBase error code: 5054
SQLSTATE: 42000
Cause: The number of parameters is invalid.
OBE-00910: specified length too long for column '%s' (max = %d byte)
OceanBase error code: 5198
SQLSTATE: 42000
Cause: The specified string length exceeds the maximum supported by the data type. For the CHAR and RAW data types, the specified string length exceeds 2,000. For other data types, the specified string length exceeds 4,000.
Solution: Reduce the string length, or switch to a data type that supports a longer string, such as VARCHAR2, LONG CHAR, or LONG RAW.
OBE-00913: too many values
OceanBase error code: 5613
SQLSTATE: HY000
Cause: Too many values are specified.
OBE-00917: missing comma
- OceanBase error code: 7403
- SQLSTATE: 42000
- Cause: A required comma is missing in the INSERT statement or in the column or value list of the form ((C,D),(E,F), ...).
- Solution: Correct the syntax and check the SQL statement for missing commas or incorrect comma usage.
Note
This error code is introduced in OceanBase Database V3.2.4.
OBE-00918: column '%.*s' in %.*%s ambiguously defined
OceanBase error code: 5207
SQLSTATE: 23000
Cause: The column definition is ambiguous.
OBE-00925: missing INTO keyword
OceanBase error code: 9712
SQLSTATE: HY000
Cause: The INTO keyword is missing in the INSERT statement.
Solution: Add the missing INTO keyword and re-execute the statement.
Note
This error code is introduced in OceanBase Database V4.0.0.
OBE-00926: missing VALUES keyword
OceanBase error code: 5574
SQLSTATE: HY000
Cause: The
VALUESkeyword is missing.
OBE-00931: missing identifier
OceanBase error code: 5963
SQLSTATE: HY000
Cause: The identifier is missing.
OBE-00932: inconsistent datatypes: left_type=%s right_type=%s
OceanBase error code: 5083
SQLSTATE: 22000
Cause: The data types are inconsistent.
Related issues:
- An error of inconsistent datatypes is returned when you perform type operations in Oracle mode of OceanBase Database.
- An error of ret_code=-5083 is returned when you update a CLOB column in Oracle mode of OceanBase Database.
- An error of inconsistent datatypes is returned when you perform an order by operation on a CLOB column.
- An error of OBE-00932 is returned when the data types are inconsistent during data insertion.
OBE-00932: inconsistent datatypes, inconsistent datatypes: expected %s got %s
- OceanBase error code: 7402
- SQLSTATE: 22000
- Cause: Incompatible data types are used in the SQL query.
- Solution: Check the SQL query statement, find the inconsistent data types, and use the CAST or CONVERT function to convert the data types to the same type.
Note
This error code is introduced in OceanBase Database V4.2.0.
OBE-00933: SQL command not properly ended
OceanBase error code: 5607
SQLSTATE: HY000
Cause: The SQL command is not properly ended.
OBE-00934: group function is not allowed here
OceanBase error code: 5694
SQLSTATE: HY000
Cause: The
groupfunction is not supported here.
OBE-00937: not a single-group group function
OceanBase error code: 5853
SQLSTATE: HY000
Cause: The
groupfunction is not a single-group function.
OBE-00938: not enough arguments for function
OceanBase error code: 5774
SQLSTATE: HY000
Cause: The function has insufficient parameters.
OBE-00939: too many arguments for function
OceanBase error code: 5683
SQLSTATE: HY000
Cause: The function has too many parameters.
OBE-00942: table or view '%s.%s' does not exist
OceanBase Database error code: 5019
SQLSTATE: 42S02
Cause: The table or view does not exist. For OceanBase Database V2.2.70 and later, if the current role does not have the
SELECTprivilege on some tables or views, this error is also returned.Solution: Check the spelling of your SQL statement. For OceanBase Database V2.2.70 and later, check the privileges of the current role.
Related issues:
OBE-00942: table or view '%.*s' does not exist
OceanBase Database error code: 5201
SQLSTATE: 42S02
Cause: The table or view does not exist. For OceanBase Database V2.2.70 and later, if the current role does not have the
SELECTprivilege on some tables or views, this error is also returned.Solution: Check the spelling of your SQL statement. For OceanBase Database V2.2.70 and later, check the privileges of the current role.
Related issues:
- PL privileges are insufficient, error code OBE-00942
- In Oracle mode, a regular user cannot retrieve the DDL statements of an object by using the dbms_metadata.get_ddl() function, error code OBE-00942
- An error is returned when a stored procedure is called by another user.
- A stored procedure can be executed without the execute privilege.
- In Oracle mode, when an object is recreated, the privileges on the object are lost.
- In Oracle mode, when an object is created by using the create or replace statement, the privileges on the object are lost.
OBE-00947: not enough values
OceanBase Database error code: 5614
SQLSTATE: HY000
Cause: The number of values is insufficient.
OBE-00955: name is already used by an existing object
OceanBase Database error code: 5331, 5834
SQLSTATE: HY000
Cause: The name is already used by an existing object.
Related issues:
OBE-00957: duplicate column name
OceanBase Database error code: 4228
SQLSTATE: 42000
Cause: The column name is duplicated.
OBE-00959: tablespace '%.*s' does not exist
OceanBase Database error code: 4354
SQLSTATE: HY000
Cause: The tablespace does not exist.
OBE-00964: table name not in FROM list
- OceanBase Database error code: 5490
- SQLSTATE: 42000
- Cause: The table name is not in the FROM list.
- Solution: Make sure that the name is a valid table name and is in the FROM list.
Note
This error code is introduced in OceanBase Database V4.1.0.
OBE-00969: missing ON keyword
OceanBase Database error code: 5370
SQLSTATE: HY000
Cause: The
ONkeyword is missing.
OBE-00972: identifier '%.*s' is too
OceanBase Database error code: 5179
SQLSTATE: 42000
Cause: The specified identifier exceeds the limit.
Solution: Set the number of bytes of the specified identifier to a value within the limit.
OBE-00976: Specified pseudo column or operator not allowed here
OceanBase Database error code: 5763
SQLSTATE: HY000
Cause: The
LEVEL,PRIOR,ROWNUM,CONNECT_BY_ROOT,CONNECT_BY_ISLEAF, orCONNECT_BY_ISCYCLEkeyword is not allowed at this position.Solution: Remove the
LEVEL,PRIOR,ROWNUM,CONNECT_BY_ROOT,CONNECT_BY_ISLEAF, orCONNECT_BY_ISCYCLEkeyword.
OBE-00979: not a GROUP BY expression
OceanBase Database error code: 5218
SQLSTATE: 42000
Cause: The expression is not a
GROUP BYexpression.
OBE-00980: synonym translation is no longer valid
OceanBase Database error code: 5330
SQLSTATE: HY000
Cause: The synonym cannot be translated to a valid target object. This may be due to the following reasons:
The target mode does not exist.
The target object does not exist.
The synonym specifies an incorrect database link.
The synonym does not support version control, but specifies a target object that supports version control.
Solution: Modify the synonym definition so that the synonym points to a valid target object.
OBE-00984: column not allowed here
OceanBase Database error code: 5942
SQLSTATE: HY000
Cause: The column cannot be inserted at this position.
OBE-00988: missing or invalid password(s)
OceanBase Database error code: 5887
SQLSTATE: HY000
Cause: The password is invalid.
OBE-00989: Cursor Variable in record, object, or collection is not supported by this release
- OceanBase Database error code: 9811
- SQLSTATE: HY000
- Cause: The current version does not support nested cursor variables in records (record), objects (object), or collections (collection).
- Solution: Avoid using nested cursor structures.
OBE-00998: must name this expression with a column alias
OceanBase Database error code: 5872
SQLSTATE: HY000
Cause: You must specify a column alias for this expression.
