topic Re: Lucene search working on Node Browser but not from scheduled task in Alfresco Archive

Lucene search working on Node Browser but not from scheduled task

cyruspy — Wed, 27 Feb 2013 07:54:25 GMT

Hi!, I'm trying to run a search from a scheduled. Execution of the following query works from Node Browser:+PATH:"/app:company_home/st:sites/*/cm:calendar//*" AND +@ia\:fromDate:[NOW TO MAX]‍‍‍This is part of the scheduled task definition: <property name="queryLanguage"> <

Re: Lucene search working on Node Browser but not from scheduled task

mitpatoliya — Wed, 27 Feb 2013 09:13:36 GMT

What happens if you use this?


   <value>+PATH:"/app:company_home/st:sites//*/cm:calendar//*" +@ia\:fromDate:\$\{luceneDateRange(yesterday, "-P10Y")\}</value>
‍‍‍

Re: Lucene search working on Node Browser but not from scheduled task

cyruspy — Wed, 27 Feb 2013 10:14:00 GMT

Thanks for the quick answer!

It seems to be working:


06:40:00,147 DEBUG [httpclient.wire.content] >> "{"textAttributes":[],"allAttributes":[],"templates":[],"authorities":["GROUP_EVERYONE","ROLE_AUTHENTICATED","root"],"tenants":[""],"query":"+PATH:\"/app:company_home/st:sites//*/cm:calendar//*\" +@ia\\:fromDate:\\$\\{luceneDateRange(yesterday, \"-P10Y\")\\}","locales":["en_US"],"defaultNamespace":"http://www.alfresco.org/model/content/1.0','defaultFTSFieldOperator':'OR','defaultFTSOperator':'OR"}"
06:40:00,148 DEBUG [java.sql.ResultSet] <==    Columns: id, commit_time_ms, acl_count
06:40:00,148 DEBUG [org.mybatis.spring.SqlSessionUtils] Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@71dddd81]
06:40:00,148 DEBUG [java.sql.ResultSet] <==        Row: 262, 1361955760382, 0
06:40:00,148 DEBUG [java.sql.ResultSet] <==        Row: 263, 1361956566137, 0
06:40:00,148 DEBUG [java.sql.ResultSet] <==        Row: 264, 1361956935440, 0
06:40:00,148 DEBUG [java.sql.ResultSet] <==        Row: 265, 1361957947932, 2

‍‍‍‍‍‍‍‍‍‍

Although I only saw one execution with results (job schedule every one minute for testing), maybe it was a coincidense (too much data un debug mode).


06:41:00,006 DEBUG [httpclient.wire.content] >> "{"textAttributes":[],"allAttributes":[],"templates":[],"authorities":["GROUP_EVERYONE","ROLE_AUTHENTICATED","root"],"tenants":[""],"query":"+PATH:\"/app:company_home/st:sites//*/cm:calendar//*\" +@ia\\:fromDate:\\$\\{luceneDateRange(yesterday, \"-P10Y\")\\}","locales":["en_US"],"defaultNamespace":"http://www.alfresco.org/model/content/1.0','defaultFTSFieldOperator':'OR','defaultFTSOperator':'OR"}"
06:41:00,006 DEBUG [org.apache.commons.httpclient.methods.EntityEnclosingMethod] Request body sent
06:41:00,019 DEBUG [httpclient.wire.header] << "HTTP/1.1 200 OK[\r][\n]"
06:41:00,019 DEBUG [httpclient.wire.header] << "HTTP/1.1 200 OK[\r][\n]"
06:41:00,019 DEBUG [httpclient.wire.header] << "Server: Apache-Coyote/1.1[\r][\n]"
06:41:00,019 DEBUG [httpclient.wire.header] << "Content-Type: text/plain;charset=UTF-8[\r][\n]"
06:41:00,019 DEBUG [httpclient.wire.header] << "Content-Length: 103[\r][\n]"
06:41:00,019 DEBUG [httpclient.wire.header] << "Date: Wed, 27 Feb 2013 09:41:00 GMT[\r][\n]"
06:41:00,019 DEBUG [httpclient.wire.header] << "[\r][\n]"
06:41:00,019 DEBUG [httpclient.wire.content] << "{"responseHeader":{"status":0,"QTime":11},"response":{"numFound":0,"start":0,"maxScore":0.0,"docs":[]}}"

‍‍‍‍‍‍‍‍‍‍‍‍‍

I'm trying to implement calendar event reminders as shown here:

https://forums.alfresco.com/es/node/31092

Can you explain me what could be wrong with the original query and why your suggestion seems to work only once?

Re: Lucene search working on Node Browser but not from scheduled task

mitpatoliya — Thu, 28 Feb 2013 07:28:57 GMT

In original query you have not used this $\{luceneDateRange(
also you should not use "AND" and + operator both.
I did not get your next problem also.

Re: Lucene search working on Node Browser but not from scheduled task

cyruspy — Fri, 01 Mar 2013 05:32:20 GMT

Well, I'm not sure, but apparently it's not working. There's too much info in the debug logs, is there any way to get only the output of this job to better troubleshoot this?

I'm not sure the info I see relates to my job.

Re: Lucene search working on Node Browser but not from scheduled task

mitpatoliya — Fri, 01 Mar 2013 07:16:40 GMT

you can increase the time interval.
or there is one more way to do it create script file and put all your logic inside that and call that script in the schedules job.

Re: Lucene search working on Node Browser but not from scheduled task

cyruspy — Sat, 16 Mar 2013 19:16:15 GMT

sorry for the delay, I'm cannot find a way to enable debugging for just this script execution. By putting all the logic there you mean not using scheduled-action-services-context.xml ?

Re: Lucene search working on Node Browser but not from scheduled task

cyruspy — Sat, 16 Mar 2013 21:20:46 GMT

This is what I get now:

<blockcode>
2013-03-16 17:42:00,167 DEBUG [httpclient.wire.content] [DefaultScheduler_Worker-4] >> "{"textAttributes":[],"allAttributes":[],"templates":[],"authorities":["GROUP_EVERYONE","ROLE_AUTHENTICATED","root"],"tenants":[""],"query":"+PATH:\"/app:company_home/st:sites//*/cm:calendar//*\" +@ia\\:fromDate:\\$\\{luceneDateRange(yesterday, \"-P10Y\")\\}","locales":["es_ES"],"defaultNamespace":"http://www.alfresco.org/model/content/1.0','defaultFTSFieldOperator':'OR','defaultFTSOperator':'OR"}"
2013-03-16 17:42:01,655 DEBUG [httpclient.wire.content] [DefaultScheduler_Worker-4] << "{"responseHeader":{"status":0,"QTime":1367},"response":{"numFound":0,"start":0,"maxScore":0.0,"docs":[]}}"
</blockcode>

As I understand, there are no results (events where inserted in the calendar)