Verity in coldfusion sucks, to put it very plainly. I don't know whether this is justthe Verity implementation included with CF, or whether this is Verity on the whole. If anyone knows a good alternative to Verity then please please please let me know.
I have stopped planning ANY solutions that use Verity, or any of the CF Java controls such as CF Grid in my projects...because they just don't work reliably. Try limiting the fields output by your CFQUERY with a MaxRows function and see if it works. Slowly increase this MaxRows and see at what point it crashes... I got this error myself, and would really like to know if the above works for you as well :) -Gel -----Original Message----- From: Mark Leder [mailto:mel@;markleder.com] Sent: Sunday, October 20, 2002 2:16 AM To: CF-Talk Subject: CFIndex for Verity quit working Hi everyone, My client has an MS Access 2002 db which is periodically uploaded to the ISP server (Win XP-CF 5) and a CFIndex Action="refresh" run on it. This process has been used successfully for several months now. The db when we started was about 4.5mb in size, now it's grown to about 11mb. The client does a compact and repair prior to uploading each time. The db only contains one table and one form, the table has an autoindex numbering for each record (no duplicates), and three other corresponding fields for each record (all memo fields). The problem is, the CF index has quit working on this database. I have not changed a single line of code. The CFQUERY prior to the CFINDEX used to retrieve the db records works normally. The CFIndex hangs, and the Access db goes into a locked condition (db.lbd). This whole process used to take about 1 minute for an indexing routine, now it won't work at all. I've had the ISP reboot the server but that doesn't help either. I've tried deleting and recreating the collection, which works, but it doesn't solve the problem. Below is the dbrefresh.cfm code for your review. Any ideas on how to resolve? HELP!!! I'm really stuck. Is there a file size limit that Verity won't work with if it exceeds that limit? (such as it working with a 9mb file size, but not an 11mb file size). BTW: You're probably wondering, the client insists on working on the Access db on his client machine, then uploading to the server - he refuses to go to SQL 2000 if it means not being able to keep a copy at his office. It's his life's work. <!---Query the database for each of the faq to get the various db table fields--> <cfquery name="indexdb" datasource=#REQUEST.dsn2#> SELECT ask_ID, publication, keywords, abstract FROM oscar2002 </cfquery> <!---Index the contents of the query object using CFINDEX---> <CFINDEX ACTION="REFRESH" COLLECTION="citations" KEY="ask_ID" TYPE="CUSTOM" TITLE="publication" QUERY="indexdb" BODY="publication, keywords, abstract" CUSTOM1="publication" CUSTOM2="keywords" LANGUAGE="English"> Thanks, Mark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
