topic lucene search doesn't return correct results in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/lucene-search-doesn-t-return-correct-results/m-p/165626#M119296 <HTML><HEAD></HEAD><BODY><SPAN>Alfresco 1.4.0 / MS SQLServer</SPAN><BR /><BR /><SPAN>I have done a full repository export from Alfresco 1.4.0 using Oracle db.</SPAN><BR /><BR /><SPAN>I then imported only the following files into a brand new 1.4.0 installation using MS SQLServer.</SPAN><BR /><SPAN>Files imported:</SPAN><BR /><UL>export_systeminfo.xml<BR />export_system.acp<BR />export_versions.acp<BR />export_spaces.acp</UL><SPAN>I am having a problem with Lucene queries.</SPAN><BR /><BR /><SPAN>I am checking the queries logging in as the admin user and by using the node browser.</SPAN><BR /><BR /><SPAN>A query that works ok in the original system (i.e. lists all spaces contained in a given space) does not work in the new installation…</SPAN><BR /><BR /><SPAN>I think that lucene indexes are not being regenerated correctly but am not sure where to look to check that.</SPAN><BR /><BR /><SPAN>I have forced regeneration of indexes at startup by setting index.recovery.mode=FULL and I can see the message on the console saying that indexes are being regenerated.</SPAN><BR /><BR /><SPAN>What else should I try?</SPAN></BODY></HTML> Wed, 11 Jun 2008 21:02:31 GMT sal 2008-06-11T21:02:31Z lucene search doesn't return correct results https://connect.hyland.com/t5/alfresco-archive/lucene-search-doesn-t-return-correct-results/m-p/165626#M119296 Alfresco 1.4.0 / MS SQLServerI have done a full repository export from Alfresco 1.4.0 using Oracle db.I then imported only the following files into a brand new 1.4.0 installation using MS SQLServer.Files imported:export_systeminfo.xmlexport_system.acpexport_versions.acpexport_spaces.acpI am having a Wed, 11 Jun 2008 21:02:31 GMT https://connect.hyland.com/t5/alfresco-archive/lucene-search-doesn-t-return-correct-results/m-p/165626#M119296 sal 2008-06-11T21:02:31Z Re: lucene search doesn't return correct results https://connect.hyland.com/t5/alfresco-archive/lucene-search-doesn-t-return-correct-results/m-p/165627#M119297 <HTML><HEAD></HEAD><BODY><SPAN>It's probably not the answer you're after, but I would suggest investigating the possibility of upgrading to a more recent release of Alfresco.&nbsp; Alfresco 1.4 is almost 2 years old now!&nbsp;&nbsp; :shock: </SPAN><BR /><BR /><SPAN>Cheers,</SPAN><BR /><SPAN>Peter</SPAN></BODY></HTML> Sun, 15 Jun 2008 05:21:13 GMT https://connect.hyland.com/t5/alfresco-archive/lucene-search-doesn-t-return-correct-results/m-p/165627#M119297 pmonks 2008-06-15T05:21:13Z Re: lucene search doesn't return correct results https://connect.hyland.com/t5/alfresco-archive/lucene-search-doesn-t-return-correct-results/m-p/165628#M119298 <HTML><HEAD></HEAD><BODY><SPAN>thanks, upgrade is planned</SPAN><BR /><BR /><SPAN>the problem we are facing right now is the actual impossibility to export and then successfully import the whole repository because of this weird problem</SPAN><BR /><BR /><SPAN>is there any way of forcing a full lucene reindexing other than changing the setting I quoted above?</SPAN><BR /><BR /><SPAN>cheers</SPAN></BODY></HTML> Mon, 16 Jun 2008 08:08:44 GMT https://connect.hyland.com/t5/alfresco-archive/lucene-search-doesn-t-return-correct-results/m-p/165628#M119298 sal 2008-06-16T08:08:44Z