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.

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

Not yet implemented.

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.

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.

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.