How to debug solr exceptions/warnings for Alfresco (Part 3)

Some good to know stuff having followed debugging which I thought I’d share.

First of all, to find out the node ref of a node id do the following SQL:

  SELECT CONCAT(store.protocol,'://',store.identifier,'/',node.uuid), node.id, node.audit_creator, node.audit_created, node.audit_modifier, node.audit_modified,
       node.audit_accessed
  FROM alf_node node
  LEFT JOIN alf_store as store ON store.id=store_id
  WHERE node.id in ('4777883', '4777625');

Next just use the node browser or Alfresco Share to find your node and its info.

If you are having problem with a node and want to exclude it from the index, have a look at http://docs.alfresco.com/4.2/concepts/admin-indexes.html. There it is described how to exclude a node from the Solr index. Or just disable content indexing, or metadata indexing.

Just apply the aspect and set the properties accordingly on a node and it will be indexed according to the rules described on the page. In my case I had to deactivate content indexing for some failing nodes due to corrupt content (but correct metadata).

function disableContentIndexingFor(nodeRef) {
  var node = search.findNode(nodeRef);

  node.properties["cm:isContentIndexed"] = false;  //Disable content index on the node
  node.properties["cm:isIndexed"] = true; //Allow metadata index on the node

  node.save();
}

disableContentIndexingFor("workspace://SpacesStore/cafebabe-cafe-babe-cafe-babecafebabe");

How to debug solr exceptions/warnings for Alfresco (Part 1)
How to debug solr exceptions/warnings for Alfresco (Part 2)

This entry was posted in Uncategorized. Bookmark the permalink.

14 Responses to How to debug solr exceptions/warnings for Alfresco (Part 3)

  1. This is a very good weblog. Keep up all the function. I too love to weblog. This really is wonderful every person sharing opinions

  2. Really appreciate you sharing this post. Really Cool.

  3. I see that you simply are making use of WordPress on your blog, wordpress could be the best.~ a-~*

  4. pretty beneficial material, overall I feel this is worthy of a bookmark, thanks

  5. fake rolex says:

    This is getting a bit more subjective, but I much prefer the Zune Marketplace.

  6. This genuinely answered my challenge, thank you!

  7. Thanks for sharing, this is a fantastic article.Thanks Again. Really Great.

  8. Tattoo says:

    Im obliged for the article.Much thanks again. Keep writing.

  9. Thank you for every other great post. The place else may just anyone get that type of info in such a perfect way of writing? I ave a presentation next week, and I am at the look for such info.

  10. Very good blog article.Really thank you! Awesome.

  11. Tattoo says:

    You ave an extremely good layout for your blog i want it to use on my internet site also.

  12. This was to protect them from ghosts and demons. Peace,

  13. sex is pretty hot topic at the moment. I was just talking to my brother about the exact same issue the other day.

  14. EKDV-640 says:

    I really liked your post.Much thanks again. Really Great.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>