SQL++ Error Codes

  • reference
    +
    The following table lists all of the SQL++ error codes, their error message, and some tips to resolve them.

    1xx Codes (shell)

    These errors are related to the shell.

    ICode Error Message Description

    10x

    Connection Errors

    100

    CONNECTION_REFUSED [string]

    Connection refused.

    101

    UNSUPPORTED_PROTOCOL [string]

    Unsupported protocol scheme.

    102

    NO_SUCH_HOST [string]

    No such host.

    103

    NO_HOST_IN_URL [string]

    No host in request URL.

    104

    UNKNOWN_PORT_TCP [string]

    Unknown port.

    105

    NO_ROUTE_TO_HOST [string]

    No route to host.

    106

    UNREACHABLE_NETWORK [string]

    Network is unreachable.

    107

    NO_CONNECTION [string]

    Not connected to any cluster.

    Use \\CONNECT command.

    108

    DRIVER_OPEN [string]

    Driver open.

    109

    INVALID_URL [string]

    Invalid input URL.

    11x

    Read/Write/Update file errors

    116

    READ_FILE [string]

    Error during file read.

    117

    WRITE_FILE [string]

    Error during file write.

    118

    FILE_OPEN [string]

    Unable to open file.

    119

    FILE_CLOSE [string]

    Unable to close file.

    12x

    Authentication Errors

    121

    INVALID_PASSWORD [string]

    Invalid password.

    122

    INVALID_USERNAME [string]

    Invalid username.

    123

    MISSING_CREDENTIAL [string]

    Username missing in -credentials/-c option.

    124

    INVALID_CREDENTIAL [string]

    Invalid format for credentials.

    Separate username and password by a :.

    13x

    Command Errors

    136

    NO_SUCH_COMMAND [string]

    Command does not exist.

    137

    NO_SUCH_PARAM [string]

    Parameter does not exist.

    138

    TOO_MANY_ARGS [string]

    Too many input arguments to command.

    139

    TOO_FEW_ARGS [string]

    Too few input arguments to command.

    140

    STACK_EMPTY [string]

    Stack empty.

    141

    NO_SUCH_ALIAS [string]

    Alias does not exist.

    142

    BATCH_MODE [string]

    Error when running in batch mode. Incorrect input value

    143

    STRING_WRITE [string]

    Cannot write to string buffer.

    17x

    Generic Errors

    170

    OPERATION_TIMEOUT [string]

    Operation timed out.

    Check query service URL.

    171

    ROWS_SCAN [string]

    Error in scanning a row.

    172

    JSON_MARSHAL [string]

    Error in marshalling the JSON data.

    173

    JSON_UNMARSHAL [string]

    Error in unmarshalling the JSON data.

    174

    DRIVER_QUERY [string]

    Error in the query driver.

    175

    WRITER_OUTPUT [string]

    Error with I/O Writer.

    176

    UNBALANCED_PAREN [string]

    Unbalanced parenthesis in the input.

    177

    ROWS_CLOSE [string]

    Error in closing the row.

    178

    CMD_LINE_ARG [string]

    Place input argument URL at the end, after input flags.

    179

    INVALID_INPUT_ARGUMENTS [string]

    Input Argument format is invalid.

    19x

    Untracked Errors

    199

    UNKNOWN_ERROR [string]

    Unknown error.

    1xxx Codes (service)

    These errors are related to the service.

    ICode Error Message Description

    1000

    service.io.readonly [message]

    Service I/O is readonly.

    1010

    Unsupported http method: [method]

    Unsupported HTTP method.

    1020

    [value] [feature] not yet implemented

    That value or feature is not yet implemented.

    1030

    Unknown [feature] value: [value]

    Unknown feature value.

    1040

    Error processing [feature]

    Error processing that feature.

    For example, the Query Service REST API returns this error if you specify request parameters as form data and include an unescaped semicolon (;) in a statement.

    1050

    No [feature] value

    Missing value for that feature.

    1060

    Multiple values for [feature]

    Multiple values for that feature.

    1065

    Unrecognized parameter in request: [parameter]

    Unrecognized parameter in that request.

    1070

    [feature] has to be of type [expected]

    Type mismatch.

    Another type was expected.

    1080

    Timeout [setting] exceeded

    Timeout was exceeded.

    1100

    Invalid JSON in results

    Invalid JSON in results.

    1110

    forbidden character (\\ or \") in client_context_id

    Forbidden character (\ or ") in client_context_id.

    Remove the \ or " in client_context_id.

    1120

    Unsupported media type: [type]

    Unsupported media type.

    1130

    Request [id] is not a http request

    Request is not an HTTP request.

    1140

    Array [vec] should be of length 2

    Array should be of length 2.

    1150

    Bad sequence number [seq]. Expected an unsigned 64-bit integer.

    Bad sequence number.

    Use an unsigned 64-bit integer.

    1150

    Bad UUID [uuid]. Expected a string.

    Bad UUID.

    Use a string value.

    1160

    Failed to decode nil value.

    Failed to decode nil value.

    1170

    Unsupported method [method]

    Unsupported HTTP method.

    2xxx Codes (admin)

    These codes are related to the admin.

    ICode Error Message Description

    2130

    [Internal Caller message]

    Admin endpoint error.

    2140

    server is not ssl enabled

    Server is not SSL enabled.

    2150

    Not a proper creds JSON array of user/pass structures:

    Invalid username or password.

    2160

    Completed requests qualifier already set: [InternalCaller]

    Completed requests qualifier is already set.

    2170

    Completed requests qualifier can only be deployed once: [InternalCaller]

    Completed requests qualifier can only be deployed once.

    2180

    Completed requests qualifier unknown: [CondString]

    Completed requests has an invalid argument.

    2190

    Completed requests qualifier can only be deployed once: [InternalCaller]

    Completed requests qualifier can only be deployed once.

    2200

    Completed requests qualifier unknown: [CondString]

    Completed requests has an invalid argument.

    2210

    [port string]

    Bad service port.

    3xxx Codes (parse)

    These codes are related to parsing.

    ICode Error Message Description

    3000

    parse.syntax_error

    Parse syntax error.

    4xxx Codes (plan)

    These error are related to the query plan.

    ICode Error Message Description

    4000

    plan_error

    Plan error.

    4010

    [alias] term must have a name or alias

    Term must have a name or alias.

    4020

    Duplicate [termType] alias [alias]

    Duplicate alias.

    4025

    Unknown [termType] for alias [keyFor]

    Unknown for alias.

    4030

    FROM in correlated subquery must have USE KEYS clause: FROM [keyspace]

    FROM in correlated subquery must have USE KEYS clause.

    4040

    No such prepared statement: [name]

    No such prepared statement.

    4050

    Unrecognizable prepared statement

    Unrecognizable prepared statement.

    4060

    Unable to add name: [msg]

    Unable to add prepared name.

    4070

    Unable to decode prepared statement

    Unable to decode prepared statement.

    4080

    Encoded plan parameter does not match encoded plan of [name]

    Encoded plan parameter does not match this encoded plan.

    4090

    Prepared name in encoded plan parameter is not [name]

    Prepared name in encoded plan parameter is mismatched.

    41xx

    4100

    No index available for join term [alias]

    No index available for this JOIN term.

    4110

    [alias] term should not have USE KEYS

    This should not have USE KEYS.

    42xx

    4210

    Expression must be a group key or aggregate: [expr]

    This expression must be a group key or aggregate.

    43xx

    4300

    The index [idx] already exists.

    The index already exists.

    4310

    META() in query with multiple FROM terms requires an argument.

    META() in query with multiple FROM terms requires an argument.

    4320

    DESC option in the index keys is not supported by indexer.

    DESC option in the index keys is not supported by indexer.

    4321

    Plan error: [msg]

    Plan internal error.

    5000 & 9999 Codes (errors)

    These are general errors.

    ICode Error Message Description

    5000

    Internal Error

    Internal error.

    9999

    not_implemented

    The feature is not implemented in this edition.

    (For example, you attempted to use an Enterprise Edition-only feature in Couchbase Server Community Edition.)

    5xxx Codes (exec)

    These codes are related to the execution.

    ICode Error Message Description

    5001

    execution.panic

    Execution panic.

    5002

    execution.internal_error

    Internal error during execution.

    5003

    Execution parameter error

    Cannot have both USING clause and request parameters.

    5010

    execution.evaluation_error

    Evaluation error.

    5015

    execution.explain_error

    Explain error.

    5020

    execution.group_update_error

    Group update error.

    5030

    execution.invalid_value_error

    Invalid value.

    5035

    Out of range evaluating [termType]

    Out of range.

    5040

    execution.duplicate_final_group

    Duplicate final group.

    5050

    No INSERT key for [value]

    No INSERT key.

    5060

    No INSERT value for [value]

    No INSERT value.

    5070

    Cannot INSERT non-string key [key] of type [type]

    Cannot INSERT non-string key of the type used.

    5072

    No UPSERT key for [value]

    No UPSERT key for value used.

    5075

    No UPSERT value for [value]

    No UPSERT value.

    5078

    Cannot UPSERT non-string key [value] of type [type]

    Cannot UPSERT non-string key of the type used.

    5080

    DELETE alias [alias] not found in item.

    DELETE alias not found in item.

    5090

    DELETE alias [alias] has no metadata in item.

    DELETE alias has no metadata in item.

    51xx

    5100

    UPDATE alias [alias] not found in item.

    UPDATE alias not found in item.

    5110

    UPDATE alias [alias] has no metadata in item.

    UPDATE alias has no metadata in item.

    5120

    Missing UPDATE clone.

    Missing UPDATE clone.

    5180

    Invalid UNNEST position of type [type]

    Invalid UNNEST position.

    5190

    execution.scan_vector_too_many_scanned_vectors

    Too many scanned vectors.

    The scan_vector parameter should not be used for queries accessing more than one keyspace. Use scan_vectors instead.

    52xx

    5200

    Unable to find a value for key [key]

    Unable to find a value for the given key.

    5210

    Unable to find user [user]

    User not found.

    5220

    Role [role] requires a keyspace.

    Role requires a keyspace.

    5230

    Role [role] does not take a keyspace.

    Role does not take a keyspace.

    5240

    Keyspace [keyspace] is not valid.

    Keyspace is not valid.

    5250

    Role [role] is not valid.

    Role is not valid.

    5260

    User [user] already has role [role]

    User already has this role.

    5270

    User [user] did not have role [role]

    User did not have this role.

    5280

    User [user] has no roles. Connecting with this user may not be possible.

    User has no roles and may not be possible to connect with.

    55xx

    5500

    Request has exceeded memory quota

    The query request exceeded the set Query Memory Quota.

    You can set a memory quota with the Couchbase Server UI, the REST API, or the CLI. For more information, see Configure Queries.

    • To set a memory quota with the UI, see Query Settings in the General settings for Couchbase Server.

    • To set a memory quota with the REST API, see the cluster-level queryMemoryQuota setting.

    • To set a memory quota with the CLI, see setting-query in the CLI Reference.

    10xxx Codes (ds_auth)

    These errors are related to the Datastore authentication.

    ICode Error Message Description

    10000

    Unable to authorize user.

    Unable to authorize user.

    11xxx Codes (ds_sys)

    These errors are related to the Datastore system.

    ICode Error Message Description

    11000

    datastore.system.generic_error

    System Datastore error.

    11001

    Datastore : namespace not found [msg]

    System Datastore: Namespace not found.

    11002

    Keyspace not found [msg]

    System Datastore: Keyspace not found.

    11003

    System datastore : Not implemented [msg]

    System Datastore: Not implemented.

    11004

    System datastore : Not supported [msg]

    System Datastore: Not supported.

    11005

    System datastore : Index not found [msg]

    System Datastore: Index not found.

    11006

    System datastore : This index cannot be dropped [msg]

    System Datastore: This index cannot be dropped.

    11007

    System datastore : Statement not found [msg]

    System Datastore: Statement not found.

    11008

    System datastore : [op] on [keyspace] failed

    System Datastore: Remote warning.

    11009

    System datastore : unable to retrieve user roles from server

    System Datastore: Unable to retrieve user roles from server.

    11010

    System datastore : unable to update user information in server

    System Datastore: Unable to update user information in server.

    11011

    One or more documents were excluded from the [keyspace] bucket because of insufficient user permissions.

    One or more documents were excluded from the bucket because of insufficient user permissions.

    11012

    System datastore : key [key] is not of the correct format for keyspace [keyspace]

    System datastore: A key is not of the correct format for the keyspace.

    12xxx Codes (ds_cb)

    These errors are related to the Couchbase Datastore.

    ICode Error Message Description

    12000

    Cannot connect [msg]

    Cannot connect.

    12001

    Cannot parse url [msg]

    Cannot parse URL.

    12002

    Namespace not found [msg]

    Namespace not found.

    12003

    Keyspace not found [msg]

    Keyspace not found.

    12004

    Primary Index not found [msg]

    Primary index not found.

    12005

    Indexer not implemented [msg]

    Indexer not implemented

    12006

    Failed to get keyspace count [msg]

    Failed to get Keyspace count.

    12007

    No keys to fetch [msg]

    No keys to fetch.

    12008

    Error performing bulk get operation [msg]

    Error performing bulk GET operation.

    12009

    DML Error, possible causes include CAS mismatch or concurrent modification [msg]

    DML error.

    CAS mismatch or concurrent modification.

    12010

    No keys to insert [msg]

    No keys to insert.

    12011

    datastore.couchbase.delete_failed

    Couchbase Datastore delete failed.

    12012

    Failed to load indexes [msg]

    Failed to load indexes.

    12013

    This bucket type is not supported [msg]

    This keyspace type is not supported.

    12014

    datastore.couchbase.index_state_error

    Invalid datastore index state.

    12015

    datastore.couchbase.index_scan_timeout

    Index scan timed out.

    12016

    Index Not Found

    Index not found.

    12017

    Error getting random entry from keyspace [msg]

    Error getting random entry from Keyspace.

    12018

    Unable to initialize authorization system as required

    Unable to initialize authorization system as required.

    13xxx Codes (ds_view)

    These errors are related to the Datastore view.

    ICode Error Message Description

    13000

    Failed to create view [msg]

    Failed to create view.

    13001

    View Index not found [msg]

    View Index not found.

    13002

    [not used]

    13003

    View index exists [msg]

    View index already exists.

    13004

    Views not allowed for WITH keyword [msg]

    Views not allowed with keyword WITH.

    13005

    View indexes not supported [msg]

    View indexes not supported.

    13006

    Failed to drop index [msg]

    Failed to drop index.

    13007

    Failed to access view [msg]

    Failed to access view.

    13008

    Failed to load indexes for keyspace [msg]

    Failed to load indexes for keyspace.

    13009

    Unable to store the view definition.

    Unable to store the view definition.

    Not all index target expressions are supported. Check whether the JavaScript of the view definition is valid. The map function has been output to query_log.

    13010

    No user supplied for query.

    No user supplied for the query.

    13011

    Invalid username/password.

    Invalid username or password.

    13012

    Error retrieving cluster [msg]

    Error retrieving cluster.

    13013

    Unable to retrieve roles from server.

    Unable to retrieve roles from server.

    13014

    datastore.couchbase.insufficient_credentials

    Datastore: Insufficient credentials

    14xxx Codes (ds_gsi)

    These errors are related to the Datastore Global Secondary Index.

    ICode Error Message Description

    14000

    Unacceptable size for index scan: [size]

    Unacceptable size for index scan.

    15xxx Codes (ds_file)

    These errors are related to the Datastore files.

    ICode Error Message Description

    15000

    Error in file datastore [msg]

    Error in file datastore.

    15001

    Namespace not found [msg]

    Namespace not found.

    15002

    Keyspace not found [msg]

    Keyspace not found.

    15003

    Duplicate Namespace [msg]

    Duplicate Namespace.

    Rename one of the Namespaces.

    15004

    Duplicate Keyspace [msg]

    Duplicate Keyspace.

    Rename one of the Keyspaces.

    15005

    No keys to insert [msg]

    No keys to insert.

    15006

    Key Exists [msg]

    Key exists.

    15007

    DML Error [msg]

    DML error.

    15008

    Keyspace path must be a directory [msg]

    Keyspace path must be a directory.

    15009

    Index not found [msg]

    Index not found.

    15010

    Operation not supported [msg]

    Operation not supported.

    15011

    Primary Index cannot be dropped [msg]

    Primary index cannot be dropped.

    16xxx Codes (ds_other)

    These error are related to other Datastore aspects.

    ICode Error Message Description

    16000

    datastore.other.datastore_generic_error

    Error in Datastore.

    16001

    datastore.other.namespace_not_found

    Datastore Namespace not found.

    16002

    datastore.other.keyspace_not_found

    Datastore Keyspace not found.

    16003

    datastore.other.not_implemented

    Not implemented.

    16004

    datastore.other.idx_not_found

    Datastore Index not found.

    16005

    Index Cannot be dropped [msg]

    Index cannot be dropped.

    16006

    Not supported for this datastore [msg]

    Not supported for this Datastore.

    16007

    Key not found [msg]

    Key not found.

    16020

    Inferencer not found [msg]

    Inferencer not found.