With some help from Dhemke, on the MM ColdFusion forums, this has been
solved.
For some reason, if I created the collections in the default directory
(D:\CFUSION\Verity\Collections) all of the files in the collection would be
created O.K. and everything would look like it was right. But the
collections themselves would not open for a cfindex tag. They were useless.
The solution was
1.) create a new directory at C:\verity.
2.) delete all of the old collections in
D:\CFUSION\Verity\Collections.
3.) make a new set of collections using the new path c:\verity.
The collections all index, purge, etc... just fine now.
This issue was especially odd, because there was plenty of available space
on either drive, on either production server. Permission were opened up, the
registry was pointing to the correct path. I tried deleting and re-creating
the collections, going into the directory and physically deleting the files,
even re-installing CF. All to no avail. Verity would even work on the
development server--it just wouldn't work on either production server.
So, now that it's been fixed, I'd like to offer up this summary as a way of
saying thanks to Dave Wilson and (again) to Dhemke.
Jeff Polaski
Webmaster
Research & Graduate Studies
University California, Irvine
-----Original Message-----
From: Jeffrey Polaski [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 21, 2001 12:17 PM
To: CF-Talk
Subject: Help! Verity Error: "Collection failed to open" and
"VdkCollectio nSubmit failed Error Code: -23"
I need help with Verity. This has become a big issue and I'm at wits end...
Any help will be appreciated.
The problem is that Verity won't work. I can't index collections on either
of our two production servers, however, Verity works fine on our (one)
development server. As far as I can tell, it's running the exact same
version of CF. I get the same errors on both servers. It seems to be a
permissions error, but I've opened up the permissions as far as I can on the
CFUSION directory and the directories being indexed (and everything below
them).
I've done everything I can think of. I've opened up the permissions as wide
as I can, I've purged/deleted/recreated all of the collections. I've gone in
and physically deleted all of the files in the collection. I've even
re-installed CF. Is there some secret directory somewhere that I need to
give permissions to so Verity will work?
Also, I get the same "Collection failed to open" error for collections that
are copied over from another server and then mapped, so there is no way to
actually use Verity on our production CF servers.
All of the servers are exactly the same, except for serial number:
Server Information
Server Product ColdFusion Server
Version 4, 5, 1, SP2
Edition Professional
Serial Number CF45PNT-xxxxxxxxxx
Operating System Windows NT
OS Version 4.0, Service Pack 6
OS Build Number 1381
Depending on how I run Verity, I get one of the following error messages:
1.) From CF Administrator, if I try to optimize a collection:
"Error occurred in tag CFINDEX
Collection failed to open: grad_collection"
2.) If I run the following code:
<CFQUERY NAME="all_mktable_ncds" DATASOURCE="all_marketable_ncds">
SELECT ncd_UC_case_no, ncd_dept, ncd_school, ncd_title,
ncd_ncd
FROM mktable_ncds_only
</CFQUERY>
<cfindex action="PURGE" collection="mktable_ncds_index">
<CFINDEX COLLECTION="MKTABLE_NCDS_INDEX"
ACTION="UPDATE"
TYPE="CUSTOM"
TITLE="ncd_title"
KEY="ncd_UC_case_no"
BODY="ncd_UC_case_no, ncd_dept, ncd_school, ncd_title,
ncd_ncd"
QUERY="all_mktable_ncds">
I get:
"Error occurred in tag CFINDEX
Internal Error: Key Insert, Type=File, VdkCollectionSubmit failed
Error Code: -23"
Again, any help would be most appreciated.
Jeff Polaski
Webmaster
Research & Graduate Studies
University California, Irvine
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
