Claremont, Timothy wrote: > > 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)
Are you using cfqueryparam? If so, probably this results from cached query execution plans. There might be a database specific command to flush them. > 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 net stop "name of service" net start "name of service" Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:207258 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
