Error creating primary index

SQL++
1

Hi,

I’m trying to create a primary index on a bucket and am getting this error:

"Error with unmarshal: invalid character 'R' after object key:value pair\n"

This is my statement:
CREATE PRIMARY INDEX primaryIndex ON default USING GSI;

Thanks

2

Hey @whollycow007,

What happens if you do this instead?:

CREATE PRIMARY INDEX ON `default` USING GSI;

I removed your primaryIndex alias and wrapped the bucket in back-ticks. Usually back-ticks are only required for bucket names that include a hyphen.

Let me know if that makes a difference.

Best,

3

@nraboy, i still get the same thing. any command i run from the CBQ Query DP returns the same result.

4

Also - isnt a primary index necessary before using N1QL?

This getting started guide doesn’t mention it:

http://developer.couchbase.com/documentation/server/4.0/getting-started/index.html

5

@nraboy we solved this:

the error is because of our bucket password not being escaped properly by CBQ Query DP1.1