Couchbase Index - n1ql issue

SQL++
1

When I debug the web API, the below code section is getting failure stattus
var query1 = await TenantBucket.QueryAsync(queryRequest);

Exception: Indexer In Warmup State. Please retry the request later. from hostname:9101 - cause: Indexer In Warmup State. Please retry the request later. from hostname:9101

I tried to drop & create the same index again. This time I’m getting other error message "User does not have credentials to access privilege cluster.bucket[preludesys].n1ql.index!drop. Add role Query Manage Index [preludesys] to allow the query to run."
Please help me out to completely resolve this issue

2

In 5.0, you need query manager role to create/drop the index.
See: https://developer.couchbase.com/documentation/server/current/security/concepts-rba-for-apps.html

3

Keshav,
Thank you for your immediate reply. The user is having Query Manage Role already. Do I need to specify that anywhere in the query?

4

actual role name is: Query Manage Index