Query worked so far, today not

[fabernate]

Hi

this query

"SELECT t.cmisbjectId FROM cmis:document as d join lynx:documentable as t on d.cmisbjectId = t.cmisbjectId "

has always worked, now not……

this the exception:


Exception in thread "main" org.apache.chemistry.opencmis.commons.exceptions.CmisRuntimeException: 07160061 Request failed 401 /solr/alfresco/cmis?q=SELECT+t.cmis%3AobjectId+FROM+cmis%3Adocument+as+d+join+lynx%3Adocumentable+as+t+on+d.cmis%3AobjectId+%3D+t.cmis%3AobjectId+&wt=json&fl=DBID%2Cscore&rows=100&df=TEXT&start=0&locale=it_IT&fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON
   at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.convertStatusCode(AbstractAtomPubService.java:452)
   at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.post(AbstractAtomPubService.java:570)
   at org.apache.chemistry.opencmis.client.bindings.spi.atompub.DiscoveryServiceImpl.query(DiscoveryServiceImpl.java:142)
   at org.apache.chemistry.opencmis.client.runtime.SessionImpl$3.fetchPage(SessionImpl.java:557)
   at org.apache.chemistry.opencmis.client.runtime.util.AbstractIterator.getCurrentPage(AbstractIterator.java:132)
   at org.apache.chemistry.opencmis.client.runtime.util.CollectionIterator.hasNext(CollectionIterator.java:48)

the only thing I changed is the JDK version, from 1.6 to 1.7 because I changed the pc and moved the project

[fabernate]

OK

it works

I have not understood why I should set to AUTO when loaded…. but it works anyway

Thank you

[jpotts]

The reason you change it from FULL to AUTO after the server comes up is that you normally do not want to do a full re-index of your entire content repository every time you restart your application server.

Glad you got it working.

Jeff

[hihei]

Hi Jeff, can you explain step by step the procedure?? I have the same problem of Fabernate…

[jpotts]

1. Shutdown Tomcat.
2. Edit $TOMCAT_HOME/shared/classes/alfresco-global.properties.
3. Search for index.subsystem.name=
4. If it is set to solr, comment it out.
5. Add a new line for lucene as follows:
index.subsystem.name=lucene
6. The entire repo will need to be reindexed by Lucene. For even moderate sized repositories, this can take a significant amount of time. To make the reindex happen, you must specify:
index.recovery.mode=FULL
7. Save alfresco-global.properties
8. Start Tomcat.
9. Edit $TOMCAT_HOME/shared/classes/alfresco-global.properties again.
10. Change index.recovery.mode=FULL to index.recovery.mode=AUTO
11. Save alfresco-global.properties

Jeff