CFSEARCH error: status code -1706
9 Message(s) by 2 Author(s) originally posted in cfml discussion
| From: julio5 |
Date: Wednesday, June 27, 2007
|
CF7.0.2 update level hf702-65114.jar (Standalone
server on
Windows 2003)
Type: SearchEngine
Message: There was a problem executing the CFSEARCH
tag with the following
collections.
Detail: Collection (status
code ): MyCollectionName (-1706)
Since re-creating a set of about 12 collections in a different
folder (same
drive), I have been getting the above
error the first time CFSEARCH is invoked
following an update of *any* collection (not necessarily the one mentioned in
the error. Re-indexing or re-creating the
named collection does *not* fix the
problem: CFSEARCH will continue to fail - so it's not corruption. Re-starting
the
ColdFusion Search Service however does fix it... until the next time one or more
collections are updated.
I am now auto-restarting the ColdFusion Search Service using CFEXECUTE after each
update but this isn't ideal, and in fact just now it seems to have had no
effect: the tag has errored again apparently in spite of the restart after the
update.
I have searched for Verity status code 1706 but can find nothing. Can anyone
shed any light?
| From: game_on |
Date: Friday, July 06, 2007
|
Hi Julio. I'm having the same problem. Did you ever find a solution?
| From: julio5 |
Date: Friday, July 06, 2007
|
Hi game_on
Still no idea what the cause is. The CFSEARCH Service auto-restart immediately
after the update usually prevents the problem, but not always. So to work
around that I have added an
exception handler which restarts the
service , waits
a couple of seconds for the service to be ready and then re-runs the search.
Means somebody gets a slow search every now and then but at least I do not have
to keep monitoring it.
'd prefer to know what the cause is. Hopfully upgrading to CF8 will
sort it
out.
| From: game_on |
Date: Friday, July 06, 2007
|
Hi Julio. I have been getting the errors sent to by modile to keep on top of it.
Not very relaxing. I hope that it'll be sorted in cf8.
Is the script for restarting the search service something that you'd be
prepared to share?
game_on
| From: julio5 |
Date: Friday, July 06, 2007
|
Sure:
1) Create a batch
file (using
Notepad but save file as "restartCFsearch.bat")
to restart the Windows service and make sure the ColdFusion service account has
execute
permissions for it (if it's running as local
system then it'll have)
NET STOP "Cold Fusion MX 7 Search Server"
NET START "Cold Fusion MX 7 Search Server"
2) Optionally create a
function which executes the batch file (or you could
just put the CFEXECUTE directly in the exception handler, but creating a
function will make it more re-usable):
<CFFUNCTION name="restartCFSearchService" returntype="void" access="public"
output="false">
<CFEXECUTE name="[path to your batch file, eg: D:\batch\restartCFsearch.bat]"
timeout="30"></CFEXECUTE>
</CFFUNCTION>
3) Wrap your CFSEARCH tag/function in a try/catch and test for the error:
<CFTRY>
<cfsearch... >
<CFCATCH type="SearchEngine">
<CFIF findNoCase("There was a problem executing the CFSEARCH
tag",cfcatch.message)>
<CFSET restartCFSearchService()>
<CFSET sleep(3000)><!--- wait 3 seconds for the service to come back up --->
<cfsearch...><!--- re-issue search --->
<CFELSE>
<CFRETHROW>
</CFIF>
</CFCATCH>
</CFTRY>
To pause before re-issuing the search I'm using
http://www.cflib.org/udf.cfm/sleep
Hope that helps.
| From: game_on |
Date: Friday, July 06, 2007
|
Wow - thanks so much!!!
game_on
| From: julio5 |
Date: Wednesday, August 22, 2007
|
Just for the record, the problem appears to have gone away after upgrading to CF8.
| From: julio5 |
Date: Sunday, August 26, 2007
|
Might've spoken too soon. Looks like we have had 2 incidents since the CF8 upgrade. Guess the exception handling code will have to stay in place.
| From: julio5 |
Date: Friday, October 26, 2007
|
This is definitely still happening in CF8.
Next Message: CFCHART (Pie)