Sagewire Logo

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)



Programming | Sports | Autos

copyright 2006
Valid XHTML 1.0 Transitional