OBE-00000 to OBE-00999

OBE-00000: PX DOP downgrade from %ld to %ld

• Error code in OceanBase Database: 5780

• SQLSTATE: HY000

• Cause: The error code indicates a normal exit.

OBE-00000: parallel_max_servers downgrade due to insufficent cpu resource from %ld to %ld. deprecated

• Error code in OceanBase Database: 5781

• SQLSTATE: HY000

• Cause: The error code indicates a normal exit.

  Note

  The error code is no longer used in the current version.

OBE-00001: unique constraint \'%s\' for key \'%.*s\' violated

• Error code in OceanBase Database: 5024

• SQLSTATE: 23000

• Cause: An UPDATE or INSERT statement is attempting to insert a duplicate key.

• Solution: Remove the UNIQUE constraint or do not insert this key.

OBE-00001: unique constraint (%.*s) violated

• Error code in OceanBase Database: 5595

• SQLSTATE: 23000

• Cause: An UPDATE or INSERT statement is attempting to insert a duplicate key.

• Solution: Remove the UNIQUE constraint or do not insert this key.

OBE-00001: unique constraint violated, column '%.*s' with value '%.*s' in %s

• Error code in OceanBase Database: 5334

• SQLSTATE: HY000

• Cause: An UPDATE or INSERT statement is attempting to insert a duplicate key.

• Solution: Remove the UNIQUE constraint or do not insert this key.

OBE-00001: unique constraint (%.*s) violated

• Error code in OceanBase Database: 5562

• SQLSTATE: HY000

• Cause: An UPDATE or INSERT statement is attempting to insert a duplicate key.

• Solution: Remove the UNIQUE constraint or do not insert this key.

OBE-00036: maximum number of recursive SQL levels (%ld) exceeded

• Error code in OceanBase Database: 9697

• SQLSTATE: HY000

• Cause: You are attempting to go more than the specified number of recursive SQL levels.

• Solution: Remove the recursive SQL or the recursive trigger.

OBE-00051: timeout occurred while waiting for a resource

• Error code in OceanBase Database: 5848

• SQLSTATE: HY000

• Cause: The error is usually caused by dead instances.

• Solution: Check whether dead or unrecovered instances exist. If yes, recover the instances.

OBE-00054: resource busy and acquire with NOWAIT specified or timeout expired

• Error code in OceanBase Database: 6006

• SQLSTATE: HY000

• Cause: The resource is busy.

• Solution: Try again or increase the timeout period.

OBE-00185: invalid argument for %s call

• Error code in OceanBase Database: 5488
• SQLSTATE: HY000
• Cause: The %s call contains an invalid argument.

OBE-00060: deadlock detected while waiting for resource

• Error code in OceanBase Database: 4101

• SQLSTATE: HY000

• Cause: A deadlock is detected while waiting for resources.

• Solution: View the Trace file and the involved transactions and resources. Try again if necessary.

OBE-00060: internal error code, arguments: -6005, Try lock row conflict

• Error code in OceanBase Database: 6005
• SQLSTATE: HY000
• Cause: The update operation failed to add a lock. This error is returned to the upper layer, and the system retries the operation.
• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

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

• Error code in OceanBase Database: 4012
• SQLSTATE: HY000
• Cause: The execution timed out.
• Solution:
  • Reduce the amount of time required through performance tuning.
  • Extend the timeout period.
  • Contact OceanBase Technical Support for troubleshooting.

OBE-00060: internal error code, arguments: -4013, No memory or reach tenant memory limit

• Error code in OceanBase Database: 4013
• SQLSTATE: HY000
• Cause: Memory allocation failed.
  • The physical memory is exhausted.
  • The memory allocated at a time is greater than 4 GB.
  • The memory usage of the context, tenant, and OBServer node reaches the upper limit.
• Solution: Contact OceanBase Technical Support for troubleshooting.

OBE-00060: internal error code, arguments: -4016, Internal error

• Error code in OceanBase Database: 4016
• SQLSTATE: HY000
• Cause: This is an internal error code.
• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

OBE-00060: internal error code, arguments: -4377, fatal internal error

• Error code in OceanBase Database: 4377
• SQLSTATE: HY000
• Cause: OceanBase Database encountered an unexpected internal error, such as a program execution failure.
• Solution: Contact OceanBase Technical Support for troubleshooting.

OBE-00060: internal error code, arguments: -5065, Query execution was interrupted

• Error code in OceanBase Database: 5065
• SQLSTATE: HY000
• Cause: The query was terminated.
• Solution: Contact the system administrator or database administrator for troubleshooting.

OBE-00060: internal error code, arguments: -6220, SQL sequence illegal

• Error code in OceanBase Database: 6220
• SQLSTATE: HY000
• Cause: The sequence of SQL statements is invalid.
• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

OBE-00224: object '%.*s' must be of type function or array to be used this way

• Error code in OceanBase Database: 9765

• SQLSTATE: HY000

• Cause: The object '%.*s' must be a function or an array.

• Solution: Check the object type and adjust it as needed.

OBE-00600: arbitration service does not exist

• Error code in OceanBase Database: 4747

• SQLSTATE: HY000

• Cause: The arbitration service endpoint is not configured for the cluster.

• Solution: OceanBase clusters do not support arbitration if the arbitration service endpoint is not configured. Set the arbitration service endpoint for the cluster by using OceanBase Cloud Platform (OCP) or the SQL statement alter system add arbitration service‘$svr_ip:$svr_port’;.

OBE-00600: arbitration service already exist

• Error code in OceanBase Database: 4748

• SQLSTATE: HY000

• Cause: The cluster already has a valid arbitration service endpoint.

• Solution: Configure only one arbitration service endpoint for the cluster.

OBE-00600: wait degration finished timeout

• Error code in OceanBase Database: 4751

• SQLSTATE: HY000

• Cause: Waiting for tenant degradation timed out during a Stop Server operation.

• Solution: Execute the Stop Server command again until it succeeds.

OBE-00600: unknown SET option '%s'

• Error code in OceanBase Database: 4764
• SQLSTATE: HY000
• Cause: An unknown option is specified in the SET command.
• Solution: Make sure that the options specified in the SET command are free of spelling or syntax errors.

OBE-00600: Cannot create a JSON value from a string

• Error code in OceanBase Database: 5415

• SQLSTATE: 22032

• Cause: This is an internal error code.

• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

OBE-00600: Invalid JSON character data provided to function

• Error code in OceanBase Database: 5416

• SQLSTATE: 22032

• Cause: This is an internal error code.

• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

OBE-00600: Invalid data type for JSON data in argument %u to function %s; a JSON string or JSON type is required

• Error code in OceanBase Database: 5417

• SQLSTATE: 22032

• Cause: This is an internal error code.

• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

OBE-00600: Cannot CAST value to JSON

• Error code in OceanBase Database: 5418

• SQLSTATE: 22032

• Cause: This is an internal error code.

• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

OBE-00600: A path expression must be encoded in the utf8 character set

• Error code in OceanBase Database: 5419

• SQLSTATE: 22032

• Cause: This is an internal error code.

• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

OBE-00600: In this situation, path expressions may not contain the * and ** tokens

• Error code in OceanBase Database: 5420

• SQLSTATE: 22032

• Cause: This is an internal error code.

• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

OBE-00600: The JSON value is too big to be stored in a JSON column

• Error code in OceanBase Database: 5421

• SQLSTATE: 22032

• Cause: This is an internal error code.

• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

OBE-00600: JSON column '%.*s' cannot be used in key specification

• Error code in OceanBase Database: 5423

• SQLSTATE: 22032

• Cause: This is an internal error code.

• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

OBE-00600: The path expression is not allowed in this context

• Error code in OceanBase Database: 5424

• SQLSTATE: 22032

• Cause: This is an internal error code.

• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

OBE-00600: The oneOrAll argument may take these values: \'one\' or \'all\'

• Error code in OceanBase Database: 5425

• SQLSTATE: 22032

• Cause: This is an internal error code.

• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

OBE-00600: Out of range JSON value for CAST

• Error code in OceanBase Database: 5426

• SQLSTATE: 22032

• Cause: This is an internal error code.

• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

OBE-00600: Invalid JSON value for CAST

• Error code in OceanBase Database: 5427

• SQLSTATE: 22032

• Cause: This is an internal error code.

• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

OBE-00600: The JSON document exceeds the maximum depth

• Error code in OceanBase Database: 5428

• SQLSTATE: 22032

• Cause: This is an internal error code.

• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

OBE-00600: Invalid default value for \'%.*s\'

• Error code in OceanBase Database: 5430

• SQLSTATE: 22032

• Cause: This is an internal error code.

• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

OBE-00600: A path expression is not a path to a cell in an array

• Error code in OceanBase Database: 5431

• SQLSTATE: 22032

• Cause: This is an internal error code.

• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

OBE-40600: JSON_EQUAL used outside predicate

• Error code in OceanBase Database: 5448
• SQLSTATE: 42000
• Cause: JSON_EQUAL is used outside the predicate.
• Solution: Use JSON_EQUAL in the predicate. For example, embed it in a CASE expression.

OBE-00600: auto increment service busy

• Error code in OceanBase Database: 5794

• SQLSTATE: HY000

• Cause: This is an internal error code.

• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

OBE-00600: rowid type mismatch, expect %.*s, got %.*s"

• Error code in OceanBase Database: 5870

• SQLSTATE: HY000

• Cause: This is an internal error code.

• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

OBE-00600: rowid num mismatch, expect %ld, actual %ld

• Error code in OceanBase Database: 5871

• SQLSTATE: HY000

• Cause: This is an internal error code.

• Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

OBE-00600: internal error code, arguments: -7124, partitions are already balanced, %s

• Error code in OceanBase Database: 7124

• SQLSTATE: HY000

• Cause: You are attempting to perform partition balancing on a partition that is already in the balanced state.

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

• Error code in OceanBase Database: 7201
• SQLSTATE: HY000
• Cause: The binary geometry function has given two different SRIDs: %u and %u, which should be the same. The geometry values passed as arguments to the spatial function must have the same SRID value.

OBE-00600: Calling geometry function with unsupported types of arguments. Calling geometry function %s with unsupported types of arguments

• Error code in OceanBase Database: 7202
• SQLSTATE: HY000
• Cause: An unsupported argument type is used for calling the geometry function %s.

OBE-00600: Unknown GIS error occurred in function. Unknown GIS error occurred in function %s

• Error code in OceanBase Database: 7203
• SQLSTATE: HY000
• Cause: An unknown GIS error occurred in function %s.

OBE-00600: Unknown exception caught in GIS function. Unknown exception caught in GIS function %s

• Error code in OceanBase Database: 7204
• SQLSTATE: HY000
• Cause: An unknown exception occurred in the GIS function %s.

OBE-00600: Invalid GIS data provided to function. Invalid GIS data provided to function %s

• Error code in OceanBase Database: 7205
• SQLSTATE: 22023
• Cause: The GIS data provided to function %s is invalid. The spatial function is called with an input parameter that is not recognized as a valid geometry value.

OBE-00600: The geometry has no data in function. The geometry has no data in function %s

• Error code in OceanBase Database: 7206
• SQLSTATE: HY000
• Cause: The geometry has no data in function %s.

OBE-00600: Unable to calculate centroid because geometry is empty in function. Unable to calculate centroid because geometry is empty in function %s

• Error code in OceanBase Database: 7207
• SQLSTATE: HY000
• Cause: The centroid cannot be calculated because the geometry in function %s is empty.

OBE-00600: Geometry overlay calculation error: geometry data is invalid in function. Geometry overlay calculation error: geometry data is invalid in function %s

• Error code in OceanBase Database: 7208
• SQLSTATE: HY000
• Cause: An error occurred in the geometry overlay calculation. The geometry data in the function %s is invalid.

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

• Error code in OceanBase Database: 7209
• SQLSTATE: HY000
• Cause: An error occurred in the geometry turn calculation. The geometry data in the function %s is invalid.

OBE-00600: Analysis procedures of intersection points interrupted unexpectedly in function. Analysis procedures of intersection points interrupted unexpectedly in function %s

• Error code in OceanBase Database: 7210
• SQLSTATE: HY000
• Cause: The intersection point analysis procedure was interrupted unexpectedly in function %s.

OBE-00600: Unknown exception thrown in function. Unknown exception thrown in function %s

• Error code in OceanBase Database: 7211
• SQLSTATE: HY000
• Cause: An unknown exception was thrown in function %s.

OBE-00600: Geometry byte string must be little endian

• Error code in OceanBase Database: 7212
• SQLSTATE: HY000
• Cause: The geometry byte string must be a little-endian value.

OBE-00600: Do not support online operation on table with GIS index

• Error code in OceanBase Database: 7213
• SQLSTATE: HY000
• Cause: Online operations on tables with GIS indexes are not supported.

OBE-00600: Inconsistent intersection points. Inconsistent intersection points

• Error code in OceanBase Database: 7214
• SQLSTATE: HY000
• Cause: The intersection points are inconsistent.

OBE-00600: Parameter exceeds the maximum number of points in a geometryin function. Parameter %s exceeds the maximum number of points in a geometry (%lu) in function %s

• Error code in OceanBase Database: 7215
• SQLSTATE: HY000
• Cause: The parameter %s has exceeded the maximum number of points for geometry %lu in function %s.

OBE-00600: value is a geometry of unexpected type.%.64s value is a geometry of unexpected type %.64s in %.64s

• Error code in OceanBase Database: 7216
• SQLSTATE: 22S01
• Cause: The value %s is a geometry of unexpected type %s in %s.

OBE-00600: Can't parse the spatial reference system definition of SRID. Can't parse the spatial reference system definition of SRID %u

• Error code in OceanBase Database: 7217
• SQLSTATE: SR002
• Cause: The spatial reference system definition for SRID %u cannot be parsed.

OBE-00600: The spatial reference system definition for SRID does not specify the mandatory (EPSG) projection parameter. The spatial reference system definition for SRID %u does not specify the mandatory %s (EPSG %u) projection parameter

• Error code in OceanBase Database: 7218
• SQLSTATE: SR003
• Cause: The spatial reference system definition for SRID %u did not specify the mandatory %s (EPSG %u) projection parameter.

OBE-00600: There's no spatial reference system with SRID. There's no spatial reference system with SRID %u

• Error code in OceanBase Database: 7219
• SQLSTATE: 01000
• Cause: The spatial reference system for SRID %u is not defined.

OBE-00600: Function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in SRID %u, which is not Cartesian. Function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in SRID %u, which is not Cartesian

• Error code in OceanBase Database: 7220
• SQLSTATE: 22S00
• Cause: Function %s is only defined for Cartesian spatial reference systems, but one of its parameters is in SRID %u, which is not a Cartesian spatial reference system.

OBE-00600: Function is only defined for Cartesian spatial reference systems, but one of its arguments is in SRID, which has not been defined. Function %s is only defined for Cartesian spatial reference systems, but one of its arguments is in SRID %u, which has not been defined

• Error code in OceanBase Database: 7221
• SQLSTATE: SR001
• Cause: Function %s is only defined for Cartesian spatial reference systems, but one of its parameters is in SRID %u, which has not been defined.

OBE-00600: There's no spatial reference system with SRID. There's no spatial reference system with SRID %u

• Error code in OceanBase Database: 7222
• SQLSTATE: SR001
• Cause: The spatial reference system for SRID %u is not defined.

OBE-00600: There's no spatial reference system with SRID. The axis order is unknown. There's no spatial reference system with SRID %u. The axis order is unknown

• Error code in OceanBase Database: 7223
• SQLSTATE: 01000
• Cause: The spatial reference system for SRID %u is not defined. The axis order is unknown.

OBE-00600: It has not been implemented for geographic spatial reference systems. %.192s(%.80s) has not been implemented for geographic spatial reference systems

• Error code in OceanBase Database: 7224
• SQLSTATE: 22S00
• Cause: %s(%s) has not been implemented for geospatial reference systems.

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

• Error code in OceanBase Database: 7225
• SQLSTATE: HY000
• Cause: The SRID of the geometry does not match the SRID of column '%s'. The SRID of the geometry is %lu, while the SRID of the column is %lu.
• Solution: Change the SRID of the geometry or the SRID attribute of the column.

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

• Error code in OceanBase Database: 7226
• SQLSTATE: HY000
• Cause: The SRID specification of column '%s' cannot be modified because the column has a spatial index.
• Solution: You need to drop the spatial index before modifying the SRID specification.

OBE-00600: The spatial index on column will not be used by the query optimizer since the column does not have an SRID attribute. The spatial index on 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

• Error code in OceanBase Database: 7227
• SQLSTATE: HY000
• Cause: The query optimizer will not use the spatial index on column '%s' because the column does not have an SRID attribute.
• Solution: You can add an SRID attribute to the column.

OBE-00600: Function is only defined for SRID 0 and SRID 4326. Function %.192s is only defined for SRID 0 and SRID 4326

• Error code in OceanBase Database: 7228
• SQLSTATE: 22S00
• Cause: Function %s is only defined for SRID 0 and SRID 4326.

OBE-00600: It has not been implemented for Cartesian spatial reference systems. %.192s(%.80s) has not been implemented for Cartesian spatial reference systems

• Error code in OceanBase Database: 7229
• SQLSTATE: 22S00
• Cause: %s(%s) has not been implemented for Cartesian spatial reference systems.

OBE-00600: It has not been implemented for projected spatial reference systems. %.192s(%.80s) has not been implemented for projected spatial reference systems

• Error code in OceanBase Database: 7230
• SQLSTATE: 22S00
• Cause: %s(%s) has not been implemented for projected spatial reference systems.

OBE-00600: Missing mandatory attribute. Missing mandatory attribute %s

• Error code in OceanBase Database: 7231
• SQLSTATE: SR006
• Cause: The mandatory attribute %s is missing.

OBE-00600: Multiple definitions of attribute. Multiple definitions of attribute %s

• Error code in OceanBase Database: 7232
• SQLSTATE: SR006
• Cause: Attribute %s has multiple definitions.

OBE-00600: The spatial reference system name can't be an empty string or start or end with whitespace

• Error code in OceanBase Database: 7233
• SQLSTATE: SR006
• Cause: The spatial reference system name cannot be an empty string, or start or end with a space.

OBE-00600: The organization name can't be an empty string or start or end with whitespace

• Error code in OceanBase Database: 7234
• SQLSTATE: SR006
• Cause: The organization name cannot be an empty string, or start or end with a space.

OBE-00600: There is already a spatial reference system with SRID. There is already a spatial reference system with SRID %u

• Error code in OceanBase Database: 7235
• SQLSTATE: SR004
• Cause: The spatial reference system of SRID %u already exists.

OBE-00600: There is already a spatial reference system with SRID. There is already a spatial reference system with SRID %u

• Error code in OceanBase Database: 7236
• SQLSTATE: 01S00
• Cause: The spatial reference system of SRID %u already exists.

OBE-00600: SRID 0 is not modifiable

• Error code in OceanBase Database: 7237
• SQLSTATE: SR000
• Cause: SRID 0 cannot be modified.

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

• Error code in OceanBase Database: 7238
• SQLSTATE: 01S01
• Cause: The SRID range [%u, %u] is reserved for system use. During the upgrade process, SRSs in this range may be added, modified, or deleted without warning.

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

• Error code in OceanBase Database: 7239
• SQLSTATE: SR005
• Cause: SRID %u cannot be modified because at least one column depends on it.

OBE-00600: Invalid character in attribute. Invalid character in attribute %s

• Error code in OceanBase Database: 7240
• SQLSTATE: SR006
• Cause: Attribute %s has invalid characters.

OBE-00600: Attribute is too long. Attribute %s is too long. The maximum length is %u characters

• Error code in OceanBase Database: 7241
• SQLSTATE: SR006
• Cause: Attribute %s cannot exceed the maximum length of %u characters.

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

• Error code in OceanBase Database: 7242
• SQLSTATE: 22S00
• Cause: Function %s is only defined for geographic spatial reference systems, but one of its parameters is in SRID %u, which is not a geographic spatial reference system.

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

• Error code in OceanBase Database: 7243
• SQLSTATE: 22023
• Cause: Function %s has encountered a polygon that is too large.

OBE-00600: Spatial indexes can't be primary or unique indexes

• Error code in OceanBase Database: 7244
• SQLSTATE: HY000
• Cause: A spatial index cannot be a primary or unique index.

OBE-00600: The index type is not supported for spatial indexes. The index type %.20s is not supported for spatial indexes

• Error code in OceanBase Database: 7245
• SQLSTATE: HY000
• Cause: The index type %s is not supported for spatial indexes.

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].

• Error code in OceanBase Database: 7246
• SQLSTATE: 22S02
• Cause: A parameter of function %s contains a geometry with longitude %f, which is out of range. It must be within (%f, %f].

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].

• Error code in OceanBase Database: 7247
• SQLSTATE: 22S03
• Cause: A parameter of function %s contains a geometry with latitude %f, which is out of range. It must be within [%f, %f].

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

• Error code in OceanBase Database: 7248
• SQLSTATE: SR002
• Cause: The spatial reference system definition for SRID %u has specified invalid axes %s and %s. One axis must be NORTH or SOUTH, and the other must be EAST or WEST.

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

• Error code in OceanBase Database: 7249
• SQLSTATE: SR002
• Cause: The spatial reference system definition for SRID %u has specified invalid axes %s and %s. One axis must be NORTH or SOUTH, and the other must be EAST or WEST.

OBE-00600: The inverse flattening must be larger than 1.0, or 0.0 if the ellipsoid is a sphere

• Error code in OceanBase Database: 7250
• SQLSTATE: SR002
• Cause: The inverse flattening must be greater than 1.0, or 0.0 if the ellipsoid is a sphere.

OBE-00600: The angular unit conversion factor must be a positive number

• Error code in OceanBase Database: 7251
• SQLSTATE: SR002
• Cause: The angular unit conversion factor must be a positive number.

OBE-00600: The prime meridian must be within (*180, 180] degrees, specified in the SRS angular unit

• Error code in OceanBase Database: 7252
• SQLSTATE: SR002
• Cause: The prime meridian must be within (*180, 180] degrees, specified in the SRS angular unit.

OBE-00600: Transformation from SRID is not supported. Transformation from SRID %u is not supported

• Error code in OceanBase Database: 7253
• SQLSTATE: 22S00
• Cause: Transformation from SRID %u is not supported.

OBE-00600: Transformation to SRID is not supported. Transformation to SRID %u is not supported

• Error code in OceanBase Database: 7254
• SQLSTATE: 22S00
• Cause: Transformation to SRID %u is not supported.

OBE-00600: Transformation from SRID %u is not supported. The spatial reference system has no TOWGS84 clause

• Error code in OceanBase Database: 7255
• SQLSTATE: 22S00
• Cause: Transformation from SRID %u is not supported. The spatial reference system does not have a TOWGS84 clause.

OBE-00600: Transformation to SRID %u is not supported. The spatial reference system has no TOWGS84 clause

• Error code in OceanBase Database: 7256
• SQLSTATE: 22S00
• Cause: Transformation to SRID %u is not supported. The spatial reference system does not have a TOWGS84 clause.

OBE-00600: Cannot create a functional index on a function that returns a JSON or GEOMETRY value

• Error code in OceanBase Database: 7257
• SQLSTATE: 42000
• Cause: You cannot create a function-based index on a function that returns a JSON or GEOMETRY value.

OBE-00600: Spatial functional index is not supported

• Error code in OceanBase Database: 7258
• SQLSTATE: HY000
• Cause: Spatial functional indexes are not supported.

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'

• Error code in OceanBase Database: 7259
• SQLSTATE: SU001
• Cause: The geometry passed to function %s is in SRID 0. It cannot be converted to %s because its length unit is not specified.

OBE-00600: Invalid cast. Invalid cast from %s to %s

• Error code in OceanBase Database: 7260
• SQLSTATE: 22S01
• Cause: Conversion from %s to %s is invalid.

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

• Error code in OceanBase Database: 7261
• SQLSTATE: 22S04
• Cause: Conversion from %s to %s is invalid. A polygon ring is in the wrong direction.

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

• Error code in OceanBase Database: 7262
• SQLSTATE: 22S05
• Cause: A parameter of function %s contains geometries with different SRIDs: %u and %u. All geometries must have the same SRID.

OBE-00600: Longitude is out of range in function. Longitude %f is out of range in function %.192s. It must be within (%f, %f].

• Error code in OceanBase Database: 7263
• SQLSTATE: 22S02
• Cause: Longitude %f is out of the range of function %s. It must be within (%f, %f].

OBE-00600: Latitude is out of range in function. Latitude %f is out of range in function %.192s. It must be within [%f, %f].

• Error code in OceanBase Database: 7264
• SQLSTATE: 22S03
• Cause: Latitude %f is out of the range of function %s. It must be within [%f, %f].

OBE-00600: Memory allocation error. Memory allocation error: %*.256s in function %s

• Error code in OceanBase Database: 7265
• SQLSTATE: HY000
• Cause: A memory allocation error occurred for %s in function %s.

OBE-00600: Domain error. Domain error: %*.256s in function %s

• Error code in OceanBase Database: 7266
• SQLSTATE: HY000
• Cause: A domain error occurred for %s in function %s.

OBE-00600: Length error. Length error: %*.256s in function %s

• Error code in OceanBase Database: 7267
• SQLSTATE: HY000
• Cause: A length error occurred for %s in function %s.

OBE-00600: Invalid argument error. Invalid argument error: %*.256s in function %s

• Error code in OceanBase Database: 7268
• SQLSTATE: HY000
• Cause: %s in function %s is an invalid argument.

OBE-00600: Out of range error. Out of range error: %*.256s in function %s

• Error code in OceanBase Database: 7269
• SQLSTATE: HY000
• Cause: An out-of-range error occurred for %s in function %s.

OBE-00600: Overflow error. Overflow error: %*.256s in function %s

• Error code in OceanBase Database: 7270
• SQLSTATE: HY000
• Cause: An overflow error occurred for %s in function %s.

OBE-00600: Range error. Range error: %*.256s in function %s

• Error code in OceanBase Database: 7271
• SQLSTATE: HY000
• Cause: A range error occurred for %s in function %s.

OBE-00600: Underflow error. Underflow error: %*.256s in function %s

• Error code in OceanBase Database: 7272
• SQLSTATE: HY000
• Cause: An underflow error occurred for %s in function %s.

OBE-00600: Logic error. Logic error: %*.256s in function %s

• Error code in OceanBase Database: 7273
• SQLSTATE: HY000
• Cause: A logic error occurred for %s in function %s.

OBE-00600: Runtime error. Runtime error: %*.256s in function %s

• Error code in OceanBase Database: 7274
• SQLSTATE: HY000
• Cause: A runtime error occurred for %s in function %s.

OBE-00600: Unknown exception: %*.384s in function %s

• Error code in OceanBase Database: 7275
• SQLSTATE: HY000
• Cause: An unknown exception occurred for %s in function %s.

OBE-00600: Cannot get geometry object from data you send to the GEOMETRY field

• Error code in OceanBase Database: 7276
• SQLSTATE: 22003
• Cause: The geometry object cannot be obtained from the data that you send to the GEOMETRY field.

OBE-00600: Incorrect usage of srid, srid column attribute only support in geometry

• Error code in OceanBase Database: 7277
• SQLSTATE: HY000
• Cause: The SRID is not used correctly. SRID column attributes are supported only in geometries.

OBE-00600: Incorrect usage of spatial/fulltext/hash index and explicit index order

• Error code in OceanBase Database: 7278
• SQLSTATE: HY000
• Cause: The spatial, full-text, or hash index or the explicit index order is used incorrectly.

OBE-00600: All parts of a SPATIAL index must be NOT NULL

• Error code in OceanBase Database: 7280
• SQLSTATE: 42000
• Cause: All parts of a spatial index must be NOT NULL.

OBE-00600: The index type is not supported for spatial indexes. The index type %s is not supported for spatial indexes

• Error code in OceanBase Database: 7281
• SQLSTATE: HY000
• Cause: The index type %s is not supported for spatial indexes.

OBE-00600: There's no unit of measure. There's no unit of measure named '%s'

• Error code in OceanBase Database: 7282
• SQLSTATE: SU001
• Cause: The measuring unit named %s does not exist.

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

• Error code in OceanBase Database: 7283
• SQLSTATE: 22023
• Cause: String %s is not a valid key-value pair in function %s.

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

• Error code in OceanBase Database: 7284
• SQLSTATE: 22023
• Cause: The radius provided to function %s is invalid. The radius must be greater than zero.

OBE-00600: Spatial reference system is empty

• Error code in OceanBase Database: 7285
• SQLSTATE: SR001
• Cause: The spatial reference system for SRID %u is not defined.

OBE-00600: Invalid option key in function. Invalid option key '%.192s' in function %.192s

• Error code in OceanBase Database: 7286
• SQLSTATE: 22023
• Cause: Option key %s in function %s is invalid.

OBE-00600: Invalid value for option in function. Invalid value '%.192s' for option '%.192s' in function '%.192s'

• Error code in OceanBase Database: 7287
• SQLSTATE: 22023
• Cause: Value %s for option %s in function %s is invalid.

OBE-00600: Unknown WKB type. Unknown WKB type(%d)! Full WKB type number was (%d)

• Error code in OceanBase Database: 7288
• SQLSTATE: 22S01
• Cause: The value %s is a geometry of unexpected type %s in %s.

OBE-00600: A FTS index may only contain a text type column.

• Error code in OceanBase Database: 7289

• SQLSTATE: 42000

• Cause: A full-text search (FTS) index can contain only columns of text types.

• Solution: Make sure that the columns in the FTS index to be created are of text types, such as VARCHAR, TEXT, and CHAR.

OBE-00600: Incorrect usage of %s

• Error code in OceanBase Database: 9751
• SQLSTATE: HY000
• Cause: It is used incorrectly.
• Solution: Make sure that it is used correctly.

OBE-00603: Prepare statement checksum error

• Error code in OceanBase Database: 5777

• SQLSTATE: HY000

• Cause: The server session is unrecoverable.

• Solution: Log in to OceanBase Database again so that the system automatically creates a server session. For more information, see the session trace file.

OBE-00739: FORALL INSERT/UPDATE/DELETE not support on remote tables

• Error code in OceanBase Database: 9752
• SQLSTATE: HY000
• Cause: You cannot execute the FORALL INSERT, UPDATE, or DELETE statement on a remote table.
• Solution: Do not execute the FORALL INSERT, UPDATE, or DELETE statement on remote tables.

OBE-00900: invalid SQL statement

• Error code in OceanBase Database: 5001

• SQLSTATE: 42000

• Cause: An error exists in the SQL statement.

• Solution: For the correct SQL statements, see SQL Reference (Oracle Mode) of the corresponding OceanBase Database version.

OBE-00900: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use

• Error code in OceanBase Database: 5006

• SQLSTATE: 42000

• Cause: An error exists in the SQL statement.

• Solution: For the correct SQL statements, see SQL Reference (Oracle Mode) of the corresponding OceanBase Database version.

OBE-00902: invalid datatype

• Error code in OceanBase Database: 5874

• SQLSTATE: HY000

• Cause: The data type is invalid.

OBE-00903: invalid table name

• Error code in OceanBase Database: 5163

• SQLSTATE: 42000

• Cause: The table name is invalid.

OBE-00904: invalid identifier '%.*s'

• Error code in OceanBase Database: 5164

• SQLSTATE: 42000

• Cause: The string contains an invalid identifier.

OBE-00904: invalid identifier '%.*s'in '%.*s'

• Error code in OceanBase Database: 5217

• SQLSTATE: 42S22

• Cause: The string contains an invalid identifier.

OBE-00904: ' %.*s': invalid identifier

• Error code in OceanBase Database: 5211

• SQLSTATE: 42000

• Cause: The string contains an invalid identifier.

OBE-00905: missing keyword

• Error code in OceanBase Database: 5096

• SQLSTATE: HY000

• Cause: A keyword is missing from the SQL statement.

OBE-00909: invalid number of arguments in the call to native function '%.*s'

• Error code in OceanBase Database: 5054

• SQLSTATE: 42000

• Cause: The number of arguments is invalid.

OBE-00910: specified length too long for column '%s' (max = %d byte)

• Error code in OceanBase Database: 5198

• SQLSTATE: 42000

• Cause: The specified string length is greater than the length supported by the data type. Specifically, the specified string length exceeds 2000 for the CHAR and RAW data types and 4000 for other data types.

• Solution: Reduce the string length, or switch to another data type that supports a longer string length, such as VARCHAR2, LONG CHAR, or LONG RAW.

OBE-00913: too many values

• Error code in OceanBase Database: 5613

• SQLSTATE: HY000

• Cause: Too many values exist.

OBE-00917: missing comma

• Error code in OceanBase Database: 7403
• SQLSTATE: 42000
• Cause: Necessary commas (,) are missing from an INSERT statement or from a list of columns or values in the ((C,D),(E,F), ...) format.
• Solution: Check the SQL statement to make sure that required commas (,) are present and correctly used.

OBE-00918: column '%.*s' in %.*%s ambiguously defined

• Error code in OceanBase Database: 5207

• SQLSTATE: 23000

• Cause: The column definition is ambiguous.

OBE-00925: missing INTO keyword

• Error code in OceanBase Database: 9712

• SQLSTATE: HY000

• Cause: An INSERT statement lacks the keyword INTO.

• Solution: Insert the keyword INTO where required and then retry the statement.

OBE-00926: missing VALUES keyword

• Error code in OceanBase Database: 5574

• SQLSTATE: HY000

• Cause: The VALUES keyword is missing.

OBE-00931: missing identifier

• Error code in OceanBase Database: 5963

• SQLSTATE: HY000

• Cause: The identifier is missing.

OBE-00932: inconsistent datatypes: left_type=%s right_type=%s

• Error code in OceanBase Database: 5083

• SQLSTATE: 22000

• Cause: The data types are inconsistent.

OBE-00932: inconsistent datatypes, inconsistent datatypes: expected %s got %s

• Error code in OceanBase Database: 7402
• SQLSTATE: 22000
• Cause: An incompatible data type is used in the SQL query.
• Solution: Check the SQL query to find the incompatible data type and use the CAST or CONVERT function to convert the incompatible data type to a compatible one.

OBE-00933: SQL command not properly ended

• Error code in OceanBase Database: 5607

• SQLSTATE: HY000

• Cause: The SQL statement is not properly ended.

OBE-00934: group function is not allowed here

• Error code in OceanBase Database: 5694

• SQLSTATE: HY000

• Cause: The group function is not supported.

OBE-00937: not a single-group group function

• Error code in OceanBase Database: 5853

• SQLSTATE: HY000

• Cause: A non-single-group group function is used.

OBE-00938: not enough arguments for function

• Error code in OceanBase Database: 5774

• SQLSTATE: HY000

• Cause: Arguments of the function are insufficient.

OBE-00939: too many arguments for function

• Error code in OceanBase Database: 5683

• SQLSTATE: HY000

• Cause: The function contains excessive arguments.

OBE-00942: table or view \'%s.%s\'does not exist

• Error code in OceanBase Database: 5019

• SQLSTATE: 42S02

• Cause: The table or view does not exist. In OceanBase Database V2.2.70 and later, role privileges are added. If the current role does not have the SELECT privilege on some tables or views, this error is returned.

• Solution: Check the spelling of the SQL statement. In particular, check the privileges of the current role in OceanBase Database V2.2.70 and later.

OBE-00942: table or view '%.*s' does not exist

• Error code in OceanBase Database: 5201

• SQLSTATE: 42S02

• Cause: The table or view does not exist. In OceanBase Database V2.2.70 and later, role privileges are added. If the current role does not have the SELECT privilege on some tables or views, this error is returned.

• Solution: Check the spelling of the SQL statement. In particular, check the privileges of the current role in OceanBase Database V2.2.70 and later.

OBE-00947: not enough values

• Error code in OceanBase Database: 5614

• SQLSTATE: HY000

• Cause: Values are not enough.

OBE-00955: name is already used by an existing object

• Error code in OceanBase Database: 5331 and 5834

• SQLSTATE: HY000

• Cause: The name is already used by an existing object.

OBE-00957: duplicate column name

• Error code in OceanBase Database: 4228

• SQLSTATE: 42000

• Cause: The column to be created already exists.

OBE-00959: tablespace '%.*s' does not exist

• Error code in OceanBase Database: 4354

• SQLSTATE: HY000

• Cause: The tablespace does not exist.

OBE-00964: table name not in FROM list

• Error code in OceanBase Database: 5490
• SQLSTATE: 42000
• Cause: The table name is not in the FROM list.
• Solution: Make sure that the name entered is a correct table name and is in the FROM list.

OBE-00969: missing ON keyword

• Error code in OceanBase Database: 5370

• SQLSTATE: HY000

• Cause: The ON keyword is missing.

OBE-00972: identifier \'%.*s\' is too long

• Error code in OceanBase Database: 5179

• SQLSTATE: 42000

• Cause: The specified identifier exceeds the maximum length.

• Solution: Reduce the number of bytes of the specified identifier to less than the maximum length.

OBE-00976: Specified pseudo column or operator not allowed here

• Error code in OceanBase Database: 5763

• SQLSTATE: HY000

• Cause: The LEVEL, PRIOR, ROWNUM, CONNECT_BY_ROOT, CONNECT_BY_ISLEAF, and CONNECT_BY_ISCYCLE keyword are not allowed at the current location.

• Solution: Delete the LEVEL, PRIOR, ROWNUM, CONNECT_BY_ROOT, CONNECT_BY_ISLEAF, and CONNECT_BY_ISCYCLE keyword.

OBE-00979: not a GROUP BY expression

• Error code in OceanBase Database: 5218

• SQLSTATE: 42000

• Cause: The expression is not a GROUP BY expression.

OBE-00980: synonym translation is no longer valid

• Error code in OceanBase Database: 5330

• SQLSTATE: HY000

• Cause: The synonym is not converted into a valid target object. The possible causes are as follows:

  • The target mode does not exist.

  • The target object does not exist.

  • The synonym specifies an incorrect database link.

  • The synonym specifies a target object for versioning but does not perform versioning.

• Solution: Modify the definition of the synonym so that the synonym points to a valid object.

OBE-00984: column not allowed here

• Error code in OceanBase Database: 5942

• SQLSTATE: HY000

• Cause: This column cannot be inserted here.

OBE-00988: missing or invalid password(s)

• Error code in OceanBase Database: 5887

• SQLSTATE: HY000

• Cause: The password is incorrect.

OBE-00998: must name this expression with a column alias

• Error code in OceanBase Database: 5872

• SQLSTATE: HY000

• Cause: The expression must be named with a column alias.