topic Re: DynamicCollectionProcessor query not finding collectiions in Alfresco Archive

DynamicCollectionProcessor query not finding collectiions

schipmolder — Tue, 14 Aug 2012 22:27:40 GMT

Hi,I've been trying to figure this one for a while now, but can't figure out why this isn't working.I'm basically using a default community server with alfresco 4.0.d and web quick start and the DynamicCollectionProcessor of web quick start just never seems to find any dynamic collections to conside

Re: DynamicCollectionProcessor query not finding collectiions

schipmolder — Thu, 16 Aug 2012 22:01:09 GMT

Ok, I finally found that the searchService only seems to find objects with types from the contentmodel, but not when it's type is from the website model.

To test this I've setup a number of searches and all only return the objects from the content model.


ResultSet rs = searchService.query(storeRef, SearchService.LANGUAGE_LUCENE, "TYPE:\"{http://www.alfresco.org/model/website/1.0}webassetCollection\"");
log.debug("{http://www.alfresco.org/model/website/1.0}webassetCollection -> " + rs.length());

rs = searchService.query(storeRef, SearchService.LANGUAGE_LUCENE, "TYPE:\"{http://www.alfresco.org/model/website/1.0}article\"");
log.debug("{http://www.alfresco.org/model/website/1.0}article -> " + rs.length());
                        
rs = searchService.query(storeRef, SearchService.LANGUAGE_LUCENE, "TYPE:\"{http://www.alfresco.org/model/content/1.0}folder\"");
log.debug("{http://www.alfresco.org/model/content/1.0}folder -> " + rs.length());

rs = searchService.query(storeRef, SearchService.LANGUAGE_LUCENE, "@cm\\:name:\"collections\"");
log.debug("@cm\\:name:\"collections\" -> " + rs.length());

rs = searchService.query(storeRef, SearchService.LANGUAGE_LUCENE, "ID:workspace\\://SpacesStore/e59a0792-f436-46a4-b42a-a46f235dcc31"); // A website article node
log.debug("ID:workspace\\://SpacesStore/e59a0792-f436-46a4-b42a-a46f235dcc31 -> " + rs.length());
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

With output:


 2012-08-16 22:57:00,018  DEBUG [org_alfresco_module_wcmquickstart.jobs.DynamicCollectionProcessor] [DefaultScheduler_Worker-3] {http://www.alfresco.org/model/website/1.0}webassetCollection -> 0
 2012-08-16 22:57:00,029  DEBUG [org_alfresco_module_wcmquickstart.jobs.DynamicCollectionProcessor] [DefaultScheduler_Worker-3] {http://www.alfresco.org/model/website/1.0}article -> 0
 2012-08-16 22:57:00,047  DEBUG [org_alfresco_module_wcmquickstart.jobs.DynamicCollectionProcessor] [DefaultScheduler_Worker-3] {http://www.alfresco.org/model/content/1.0}folder -> 66
 2012-08-16 22:57:00,058  DEBUG [org_alfresco_module_wcmquickstart.jobs.DynamicCollectionProcessor] [DefaultScheduler_Worker-3] @cm\:name:"collections" -> 0
 2012-08-16 22:57:00,062  DEBUG [org_alfresco_module_wcmquickstart.jobs.DynamicCollectionProcessor] [DefaultScheduler_Worker-3] ID:workspace\://SpacesStore/e59a0792-f436-46a4-b42a-a46f235dcc31 -> 0
 2012-08-16 22:57:00,115  DEBUG [org_alfresco_module_wcmquickstart.jobs.DynamicCollectionProcessor] [DefaultScheduler_Worker-3] {http://www.alfresco.org/model/content/1.0}content -> 131
‍‍‍‍‍‍‍‍

To illustrate, when I run the query TYPE:"{http://www.alfresco.org/model/content/1.0}content" in the node browser I get 512 results, but the search service only sees 131, all with a type from the content model.

Can anyone think of a reason why this would happen?
Bear in mind, the website model is defined in the same module and all the rest seems to work ok…

Re: DynamicCollectionProcessor query not finding collectiions

schipmolder — Sat, 18 Aug 2012 11:25:40 GMT

Ok, I finally managed to fix this and thought I'd put my solution here in case others have the same issue.

I started off with installing a new alfresco server to see if I'd have the same issue there, but that all worked normally and the collections were all found.
I then noticed that on both servers only the scheduled jobs had the issue of not seeing any website objects, but the normal webscripts seemed to be unaffected.

As the jobs all run as the AuthenticationUtil.SYSTEM_USER_NAME user I figured this could also be a weird permission thing where the user running the job just doesn't have access to the site root.
It turned out that one of my colleagues had changed the admin user's password (he had also changed this in the was wepapp so that could still communicate with the alfresco backend) so I figured it could have something to do with that.

Long story short, when I changed AuthenticationUtil.SYSTEM_USER_NAME to "admin" suddenly all came back to life!


        AuthenticationUtil.runAs(new RunAsWork<Object>()
        {
            @Override
            public Object doWork() throws Exception
            {
                transactionService.getRetryingTransactionHelper().doInTransaction(
                        new RetryingTransactionCallback<Object>()
                {
                    @Override
                    public Object execute() throws Throwable
                    {
                       …
                       …
                    }   
                });
                return null;
            }
        }, AuthenticationUtil.SYSTEM_USER_NAME);
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I have absolutely no idea why the System (= AuthenticationUtil.SYSTEM_USER_NAME) user wouldn't have access to the site's root whereas admin does but it works.
If anyone has any ideas why this happens then please let me know, but I'm just happy it works again.