I have had a problem recently which results in a "base tables have changed" error message.
This stems from a batch file that I run each night that copies a bunch of database files from an application on another server to my webserver. The dilemma is that every once in a while, as the error message implies, the base tables have chnaged due to improvements in the original database application. So, even though I am copying all of the database tables each night, the system still complains and throws the error message. Strangely though, if I STOP and RESTART the ColdFusion service, the problem immediately goes away and the website operates as usual. So, my question is two-fold. The first is, does this make any sense to anyone? (I am not actively caching the queries BTW) The second is, what commands can I place at the end of my nightly batch file that will stop and restart the coldfusion service in hopes that this will eliminate the error???? CF6.1 on Win2k3 Thanks Tim ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207253 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
