Search from Sitecore returns no results
I'm running into a fairly similar issue that I've seen posted before but I was unable to find any resolution to it. In short, I have 2 Azure VMs: VM1 is CES, VM2 is sitecore/coveo api. When I search @uri (or anything else) in the admin tool on VM1, I get expected results. Searching on VM2, either through the page editor or published page created from Coveo template yields no results for any queries.
The CES diagnostic console logs my queries from sitecore as follows:
Query (@fisz32xdisplayedz32xinz32xsearchz32xresults14744=="1") performed by sitecore\myuser [Sitecore Security Provider for myMachine-myInstance ]. 0 results in 0.016 seconds.
In the admin tool, my permissions on all three indices look like this: [x] Index security permissions and specify additional security permissions to index
sitecore\myuser || Sitecore Security Provider for myMachine-myInstance
It definitely looks like my queries are at least hitting the index but I can't figure out what I'm missing as far as configuration. Any help would be greatly appreciated.
There is probably a configuration issue with the security provider. You can try to rebuild the index security cache manually. See http://onlinehelp.coveo.com/en/ces/7.0/Administrator/refreshingsecuritycaches.htm. Then check the CES logs to see if there is an error.
Let me know how it goes
When doing queries in the CES Admin Tool Index Browser, the queries are executed as your Active Directory account, not by your Sitecore user account. That might explain the difference in the number of results.
Is the Diagnostic Page green for the "Security Provider" test? I think that the Security Provider inside CES cannnot access the Sitecore instance in order to expand and resolve the securities.
Normally, you shouldn't have to set additional security permissions to index on your CES sources.
In the CES Index Browser, can you check the "Permissions" tab of the "Details" section of a result you think "sitecore\myuser" should have access. Check the effective combined permissions to see if the user is allowed or denied on the document.