N1ql Query on Couchbase console vs dotnet

Query 1 works on both couchbase query window and in dotnet application
However, Query 2 does not work on dotnet application. Any idea why?

Query 1
var request = QueryRequest.Create(“SELECT META().id AS key, TOOBJECT(hc) as value FROM mybucket as hc WHERE type=‘Profile’;”);

Query 2
var request = QueryRequest.Create("SELECT META().id AS key, TOOBJECT(hc) as value FROM mybucket as hc ");

Query 2 requires primary index on mybucket because there is no where clause

Sorry, there was a primary index existing on mybucket already. Still not pulling the results. However, on the Couchbase Console it runs perfect.

If this is with the .NET client 2.4.7, you might try a downgrade to 2.4.6 if it’s easy to do so. I don’t think it’d be related, but there is a known issue with single-node-clusters in 2.4.7. The release notes have details.

If there isn’t any difference, then can you give us an indication of what it’s failing with? Perhaps increase the log level too in order to get more info.