Reporting for Solr indexing and problems

[macti]

Hello,

We have an issue where nodes can be found by an admin, but other non-admin users can't find them. We found out that just by editing the properties of the node will fix the issue, so we assume that Solr is re-indexing the node and fix any issues.

Problem is: we would like to see if we have nodes with bad indexing data on them (especially for the ACL part). Alfresco support replied to have a look at this wiki page, but I have two questions about it:

1) How do you find the nodeid? For example, I have tried the NODEREPORT report with nodeid=10, it works, but I don't know which node this is. I have tried a nodeid like 01a8b7ba-ff7c-42a6-8933-f1c863938a85 or workspace://SpacesStore/01a8b7ba-ff7c-42a6-8933-f1c863938a85, and the report is throwing up exceptions.

2) Any way to get the state for any indexing nodes? We would like to build a report that will get the state of indexing, especially ACLs, so that we can found out errors and fix it if needed.

Alfresco Enterprise 4.0.2.9 with Solr.

[xarope]

can't answer the rest of your question, but for the nodeid, I'd suspect something like:

select an.id from alf_node an where an.uuid ='01a8b7ba-ff7c-42a6-8933-f1c863938a85'‍

as for NODEREPORT, using https://<host>:8443/solr/admin/cores?action=NODEREPORT&wt=xml&nodeid=<nodeid> failed for me, I had to use dbid= instead of nodeid=, not sure what's going on here?