ERROR 174 : Unspecified error

SQL++
1

Hello,
Using the cbq utility to perform N1QL selects, I am getting weird errors from the server, and the last line of the response, in these cases is:
ERROR 174 : Unspecified error.
Any idea what this is?
Thanks!

2

Post the complete statement with error.
Also try with REST API and check. It might be coming from cbq shell. There might be control or unexpected input.

3

Ah yes, good idea, I’ll use the REST API, it’ll provide more details. Thanks!

4

Hi @Hawkeye

Could you post your input query ? I can take a look to see why you see the unspecified error.

Thanks
Isha

5

This is the query I ran from cbq command line and got Unspecified error.

opt/couchbase/bin/cbq -u username -p password -s ‘SELECT id FROM bucket WHERE doc_type = “PREF” AND id >= “530000000” and id < " 540000000" EXCEPT SELECT id FROM bucket WHERE doc_type = “PR” AND id >= “530000000” and id < " 540000000"’ -o results_output.json

ERROR 174 : Unspecified error.

6

Can you check if you are using single quotes ? It seems to work for me.