topic Re: Search not finding aspect after I make updates. NodeService.hasAspect is finding it... after updating search results in Alfresco Archive

Search not finding aspect after I make updates. NodeService.hasAspect is finding it... after updating search results

josh_barrett — Tue, 23 Apr 2013 14:14:42 GMT

I am trying to write an action that creates thumbnails in the background. This action: -executes a query to see what needs to be thumbnailed-if no results exits-iterates through the result adding thumbnails and adds a marker aspect to the node-Sleeps for 10 seconds-and executes query again.I tested

Re: Search not finding aspect after I make updates. NodeService.hasAspect is finding it... after updating search results

afaust — Thu, 25 Apr 2013 17:53:57 GMT

Hello,

what is the "ADPSearchService"? This does not appear to be a standard Alfresco search service / component. This means that unless the code of that class is available, I couldn't venture a guess if I wanted to…

Regards
Axel

Re: Search not finding aspect after I make updates. NodeService.hasAspect is finding it... after updating search results

josh_barrett — Mon, 29 Apr 2013 12:30:33 GMT

Hi Axel,

That class is just a helper Service class for searching. It uses the Alfresco SearchService under the covers.

package com.adp.alfresco.service

import org.alfresco.service.cmr.repository.NodeRef
import org.alfresco.service.cmr.repository.NodeService
import org.alfresco.service.cmr.repository.Path
import org.alfresco.service.cmr.repository.StoreRef
import org.alfresco.service.cmr.search.ResultSet
import org.alfresco.service.cmr.search.SearchParameters
import org.alfresco.service.cmr.search.SearchService
import org.alfresco.service.namespace.NamespaceService
import org.apache.commons.logging.Log
import org.apache.commons.logging.LogFactory

import java.text.SimpleDateFormat

class ADPSearchService {
    private SearchService searchService
    private NodeService nodeService
    private NamespaceService namespaceService
    public static final SimpleDateFormat luceneSDF = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.sssZ")
    private static Log logger = LogFactory.getLog(ADPSearchService.class)

    public List<NodeRef> getNodeRefs(String query){
        logger.debug("Getting nodes using query: " + query)
        SearchParameters sp = createBasicLuceneSearchParameter(query)
        return getNodeRefs(sp)
    }

    public List<NodeRef> getNodeRefs(SearchParameters sp){
        ResultSet results = null
        try{
            results = searchService.query(sp)
            List<NodeRef>nodeRefs = results.getNodeRefs()
            logger.debug("Search "+sp.getQuery()+" returned "+nodeRefs.size())
            return nodeRefs
        }
        catch (Exception e) {
            logger.error("ERROR SEARCHING - "+sp.getQuery()+" - "+e.getMessage(),e)
        }
        finally{
            if(results != null)
            {
                results.close()
            }
        }
        return new ArrayList<NodeRef>()
    }

    public SearchParameters createBasicLuceneSearchParameter(String query){
        SearchParameters sp = new SearchParameters()
        sp.addStore(StoreRef.STORE_REF_WORKSPACE_SPACESSTORE)
        sp.setLanguage(SearchService.LANGUAGE_LUCENE)
        sp.setQuery(query)
        return sp
    }

    public void setSearchService(SearchService searchService) {
        this.searchService = searchService
    }

    public void setNodeService(NodeService nodeService) {
        this.nodeService = nodeService
    }

    public void setNamespaceService(NamespaceService namespaceService) {
        this.namespaceService = namespaceService
    }

    public List<NodeRef> getNodeRefs(String query, int limit) {
        SearchParameters sp = createBasicLuceneSearchParameter(query)
        sp.setLimit(limit)
        return getNodeRefs(sp)
    }
}

Thanks,

Josh

Re: Search not finding aspect after I make updates. NodeService.hasAspect is finding it... after updating search results

afaust — Tue, 30 Apr 2013 15:52:53 GMT

Hello,
are you using embedded Lucene or SOLR? Is SOLR actively tracking changes? Have you tried your query in the Node Browser?

Apart from the looping and usage of Thread.sleep instead of a cron-/regular-scheduled job, the code doesn't look like it is the immediate cause of your problem.

Regards
Axel

Re: Search not finding aspect after I make updates. NodeService.hasAspect is finding it... after updating search results

josh_barrett — Wed, 01 May 2013 01:04:50 GMT

What I found is the transaction doesn't commit until the process stops. That seems to be why Solr is not finding the changes.

What I need to figure out is how to continue this process while forcing the transaction to commit so the DB updates and Solr can index the changes. Have you written code with partial commits or multiple transactions nested in a long running process?

Thanks,

Josh

Re: Search not finding aspect after I make updates. NodeService.hasAspect is finding it... after updating search results

afaust — Tue, 07 May 2013 22:46:31 GMT

Hello,

in terms of Alfresco transactions there is no such things as partial commits. You have to seperate your process in individual transactions, i.e. one per iteration. The simplest way to do this is using RetryingTransactionHelper.doInTransaction(RetryingTransactionCallback, boolean, boolean) where the RetryingTransactionCallback encapsulates your single-iteration logic, forcing a new transaction by passing true as the last boolean parameter (which is "requiresNew").

Regards
Axel

Re: Search not finding aspect after I make updates. NodeService.hasAspect is finding it... after updating search results

josh_barrett — Wed, 08 May 2013 18:09:34 GMT

Thank you for your help Axel!

-Josh