N1QL Error Codes
- reference
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 |
|
|
|
Connection refused. |
|
|
Unsupported protocol scheme. |
|
|
No such host. |
|
|
No host in request URL. |
|
|
Unknown port. |
|
|
No route to host. |
|
|
Network is unreachable. |
|
|
Not connected to any cluster. Use |
|
|
Driver open. |
|
|
Invalid input URL. |
11x |
Read/Write/Update file errors |
|
|
|
Error during file read. |
|
|
Error during file write. |
|
|
Unable to open file. |
|
|
Unable to close file. |
12x |
Authentication Errors |
|
|
|
Invalid password. |
|
|
Invalid username. |
|
|
Username missing in -credentials/-c option. |
|
|
Invalid format for credentials. Separate username and password by a |
13x |
Command Errors |
|
|
|
Command does not exist. |
|
|
Parameter does not exist. |
|
|
Too many input arguments to command. |
|
|
Too few input arguments to command. |
|
|
Stack empty. |
|
|
Alias does not exist. |
|
|
Error when running in batch mode. Incorrect input value |
|
|
Cannot write to string buffer. |
17x |
Generic Errors |
|
|
|
Operation timed out. Check query service URL. |
|
|
Error in scanning a row. |
|
|
Error in marshalling the JSON data. |
|
|
Error in unmarshalling the JSON data. |
|
|
Error in the query driver. |
|
|
Error with I/O Writer. |
|
|
Unbalanced parenthesis in the input. |
|
|
Error in closing the row. |
|
|
Place input argument URL at the end, after input flags. |
|
|
Input Argument format is invalid. |
19x |
Untracked Errors |
|
|
|
Unknown error. |
1xxx Codes (service)
These errors are related to the service.
ICode | Error Message | Description |
---|---|---|
|
|
Service I/O is readonly. |
|
|
Unsupported HTTP method. |
|
|
That value or feature is not yet implemented. |
|
|
Unknown feature value. |
|
|
Error processing that feature. |
|
|
Missing value for that feature. |
|
|
Multiple values for that feature. |
|
|
Unrecognized parameter in that request. |
|
|
Type mismatch. Another type was expected. |
|
|
Timeout was exceeded. |
|
|
Invalid JSON in results. |
|
|
Forbidden character (\ or ") in Remove the \ or " in |
|
|
Unsupported media type. |
|
|
Request is not an HTTP request. |
|
|
Array should be of length 2. |
|
|
Bad sequence number. Use an unsigned 64-bit integer. |
|
|
Bad UUID. Use a string value. |
|
|
Failed to decode nil value. |
|
|
Unsupported HTTP method. |
2xxx Codes (admin)
These codes are related to the admin.
ICode | Error Message | Description |
---|---|---|
|
|
Admin endpoint error. |
|
|
Server is not SSL enabled. |
|
|
Invalid username or password. |
|
|
Completed requests qualifier is already set. |
|
|
Completed requests qualifier can only be deployed once. |
|
|
Completed requests has an invalid argument. |
|
|
Completed requests qualifier can only be deployed once. |
|
|
Completed requests has an invalid argument. |
|
[port string] |
Bad service port. |
3xxx Codes (parse)
These codes are related to parsing.
ICode | Error Message | Description |
---|---|---|
|
|
Parse syntax error. |
4xxx Codes (plan)
These error are related to the query plan.
ICode | Error Message | Description |
---|---|---|
|
|
Plan error. |
|
|
Term must have a name or alias. |
|
|
Duplicate alias. |
|
|
Unknown for alias. |
|
|
FROM in correlated subquery must have USE KEYS clause. |
|
|
No such prepared statement. |
|
|
Unrecognizable prepared statement. |
|
|
Unable to add prepared name. |
|
|
Unable to decode prepared statement. |
|
|
Encoded plan parameter does not match this encoded plan. |
|
|
Prepared name in encoded plan parameter is mismatched. |
41xx |
||
|
|
No index available for this JOIN term. |
|
|
This should not have USE KEYS. |
42xx |
||
|
|
This expression must be a group key or aggregate. |
43xx |
||
|
|
The index already exists. |
|
|
META() in query with multiple FROM terms requires an argument. |
|
|
DESC option in the index keys is not supported by indexer. |
|
|
Plan internal error. |
5000 & 9999 Codes (errors)
These are general errors.
ICode | Error Message | Description |
---|---|---|
|
|
Internal Error. |
|
|
Not yet implemented. |
5xxx Codes (exec)
These codes are related to the execution.
ICode | Error Message | Description |
---|---|---|
|
|
Execution panic. |
|
|
Internal error during execution. |
|
|
Cannot have both USING clause and request parameters. |
|
|
Evaluation error. |
|
|
Explain error. |
|
|
Group update error. |
|
|
Invalid value. |
|
|
Out of range. |
|
|
Duplicate final group. |
|
|
No INSERT key. |
|
|
No INSERT value. |
|
|
Cannot INSERT non-string key of the type used. |
|
|
No UPSERT key for value used. |
|
|
No UPSERT value. |
|
|
Cannot UPSERT non-string key of the type used. |
|
|
DELETE alias not found in item. |
|
|
DELETE alias has no metadata in item. |
51xx |
||
|
|
UPDATE alias not found in item. |
|
|
UPDATE alias has no metadata in item. |
|
|
Missing UPDATE clone. |
|
|
Invalid UNNEST position. |
|
|
Too many scanned vectors. The |
52xx |
||
|
|
Unable to find a value for the given key. |
|
|
User not found. |
|
|
Role requires a keyspace. |
|
|
Role does not take a keyspace. |
|
|
Keyspace is not valid. |
|
|
Role is not valid. |
|
|
User already has this role. |
|
|
User did not have this role. |
|
|
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 |
---|---|---|
|
|
Unable to authorize user. |
11xxx Codes (ds_sys)
These errors are related to the Datastore system.
ICode | Error Message | Description |
---|---|---|
|
|
System Datastore error. |
|
|
System Datastore: Namespace not found. |
|
|
System Datastore: Keyspace not found. |
|
|
System Datastore: Not implemented. |
|
|
System Datastore: Not supported. |
|
|
System Datastore: Index not found. |
|
|
System Datastore: This index cannot be dropped. |
|
|
System Datastore: Statement not found. |
|
|
System Datastore: Remote warning. |
|
|
System Datastore: Unable to retrieve user roles from server. |
|
|
System Datastore: Unable to update user information in server. |
|
|
One or more documents were excluded from the bucket because of insufficient user permissions. |
|
|
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 |
---|---|---|
|
|
Cannot connect. |
|
|
Cannot parse URL. |
|
|
Namespace not found. |
|
|
Keyspace not found. |
|
|
Primary index not found. |
|
|
Indexer not implemented |
|
|
Failed to get Keyspace count. |
|
|
No keys to fetch. |
|
|
Error performing bulk GET operation. |
|
|
DML error. CAS mismatch or concurrent modification. |
|
|
No keys to insert. |
|
|
Couchbase Datastore delete failed. |
|
|
Failed to load indexes. |
|
|
This keyspace type is not supported. |
|
|
Invalid datastore index state. |
|
|
Index scan timed out. |
|
|
Index not found. |
|
|
Error getting random entry from Keyspace. |
|
|
Unable to initialize authorization system as required. |
13xxx Codes (ds_view)
These errors are related to the Datastore view.
ICode | Error Message | Description |
---|---|---|
|
|
Failed to create view. |
|
|
View Index not found. |
|
[not used] |
|
|
|
View index already exists. |
|
|
Views not allowed with keyword WITH. |
|
|
View indexes not supported. |
|
|
Failed to drop index. |
|
|
Failed to access view. |
|
|
Failed to load indexes for keyspace. |
|
|
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 |
|
|
No user supplied for the query. |
|
|
Invalid username or password. |
|
|
Error retrieving cluster. |
|
|
Unable to retrieve roles from server. |
|
|
Datastore: Insufficient credentials |
14xxx Codes (ds_gsi)
These errors are related to the Datastore Global Secondary Index.
ICode | Error Message | Description |
---|---|---|
|
|
Unacceptable size for index scan. |
15xxx Codes (ds_file)
These errors are related to the Datastore files.
ICode | Error Message | Description |
---|---|---|
|
|
Error in file datastore. |
|
|
Namespace not found. |
|
|
Keyspace not found. |
|
|
Duplicate Namespace. Rename one of the Namespaces. |
|
|
Duplicate Keyspace. Rename one of the Keyspaces. |
|
|
No keys to insert. |
|
|
Key exists. |
|
|
DML error. |
|
|
Keyspace path must be a directory. |
|
|
Index not found. |
|
|
Operation not supported. |
|
|
Primary index cannot be dropped. |
16xxx Codes (ds_other)
These error are related to other Datastore aspects.
ICode | Error Message | Description |
---|---|---|
|
|
Error in Datastore. |
|
|
Datastore Namespace not found. |
|
|
Datastore Keyspace not found. |
|
|
Not implemented. |
|
|
Datastore Index not found. |
|
|
Index cannot be dropped. |
|
|
Not supported for this Datastore. |
|
|
Key not found. |
|
|
Inferencer not found. |