N1QL Error Codes

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.