N1QL Error Codes

      +
      The following table lists all of the N1QL 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 Query Settings and Parameters.

      • 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 queryMemoryQuota in Query Settings and Parameters.

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