Kate, some code which we use to reindex our collections:
<!--- Delete the collection before beginning --->
<cftry>
<CFCOLLECTION Action="DELETE" Collection="cfa_metadata_categories">
<CFCOLLECTION Action="DELETE" Collection="cfa_metadata_keywords">
<cfcatch>
<FONT color="RED">Unable to delete the collection. They may not be
present.</font>
</cfcatch>
</cftry>
<!--- Create the new indexes --->
<cftry>
<cfa_metadataindexall datasource="#request.globals.dsn#">
<cfcatch>
<FONT color="RED">Unable to create the collections. This is
BAD.</font>
</cfcatch>
</cftry>
This is pretty much what you were doing by running 'metadataindexall'
anyway, with an initial delete of the collection.
Maybe this helps, maybe not.
Jared Clinton
Software Engineer
Maxi Multimedia
NEC Australia.
> -----Original Message-----
> From: Kate De Jong [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 3 May 2001 9:34
> To: Spectra-Talk
> Subject: RE: metadataindexall error
>
>
> Thanks for the suggestion, Michiel.
>
> Even though the tags on lines 113/114 were not <cfindex
> action="purge">, I
> commented them out and ran the metadataindexall tag.
>
> Everything works again. But I don't know why this method of
> reindexing our
> objects suddenly stopped working on only one of our three
> test servers. I
> also don't know why commenting out the two lines fixed it.
> And I also don't
> know a better way to accomplish reindexing.
>
> So if anyone has insight into this, I'd appreciate it.
>
> -Kate
> -----Original Message-----
> From: Kate De Jong
> Sent: Wednesday, May 02, 2001 4:17 PM
> To: Spectra-Talk
> Subject: RE: metadataindexall error
>
>
> Hmm...
>
> Lines 113/114 in my metadataindexall customtag are:
>
> <CFINDEX ACTION="DELETE" COLLECTION="cfa_metadata_keywords"
> KEY="objectID"
> type="custom" query="reaperQuery">
> <CFINDEX ACTION="DELETE" COLLECTION="cfa_metadata_categories"
> KEY="objectID"
> type="custom" query="reaperQuery">
>
> Not <cfindex action="purge">
>
> The reason we started using metadataindexall consistently is
> because our
> collections where growing hugely unmanageable and the server
> ran more & more
> slowly when trying to assign keywords or search on keywords.
> (I think that
> was the reasoning, I'd have to verify this.)
>
> What's the better way to do this?
>
> -Kate
>
> -----Original Message-----
> From: Michiel Boland [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 02, 2001 3:47 PM
> To: Spectra-Talk
> Subject: Re: metadataindexall error
>
>
> > We have been running the metadataindexall tag on a
> scheduled basis since
> > september with no trouble.
> >
> > Suddenly on our test server we cannot index all objects.
> When we try, we
> get
> > this error:
> >
> > ****************
> >
> > Error Diagnostic Information
> > Error occurred in tag CFINDEX
> >
> > Internal Error: Key Delete, Type=File, VdkCollectionSubmit failed
> > Error Code: -14
> >
> > The error occurred while processing an element with a
> general identifier
> of
> > (CFINDEX), occupying document position (113:1) to (113:109) in the
> template
> > file D:\PROGRAM
> >
> FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\TIER0\METADATA\CFA_MET
> ADATAINDEXALL.
> > CFM.
>
> You need to take out the <CFINDEX ACTION="PURGE"> line (line 113). It
> doesn't do anything useful (apart from confusing a lot of people.)
>
> Anyway cfa_metadataindexall is meant to be run only once. Why are you
> scheduling this?
>
> --
> Michiel Boland <[EMAIL PROTECTED]>
> Digital Valley Internet Professionals
> Plantsoen 17, Wageningen, The Netherlands
> Phone: +31 317 465555, Fax: +31 317 460276
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
