Re: ColdFusion hangs or slow when several datasources are not found
Hi Bryan, I will do as you suggested. Thanks a lot! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359164 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion hangs or slow when several datasources are not found
Oh! I am so sorry I misspelled your name. Thanks again for the solution Byron! :) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359165 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Scheduled Tasks Not Attempted
Here's a strange one: ACF 10,0,12,286680 Scheduled Tasks not attempted. I have numerous Scheduled Tasks that run daily in the early AM hours. This AM, it appears that none of them ran. No errors. The Scheduled Task page in the Admin shows two types: Duration Interval Last Run Next Run Sep 17, 2009 - INDEFINITELYDaily 8/19/2014 5:00:00 AM 8/21/2014 5:00:00 AM Feb 18, 2009 - INDEFINITELYDaily 8/19/2014 2:31:00 AM EXPIRED ...where that first one seems to illustrate skipping today and that second one illustrates skipping today and never running again? Despite the fact that it's set to INDEFINITELY. Any ideas on where to start? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359166 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Scheduled Tasks Not Attempted
Do you have logging your scheduled tasks enabled? Might shed some light. Does a CF restart fix the issue? Are these setup as clustered? If so I would check server time-stamps between CF and DB servers to ensure they are correct. Not sure if this would really matter, as I would think CF would just use the DB server timestamp as authoritative in a clustered setup, but probably worth checking. I would recommend removing the task and rescheduling them. I've had to do this before where a task would not run for whatever reason. ~ Byron Mann Lead Engineer and Architect HostMySite ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359167 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Simultaneous threads and maintain database connections
Is there a relationship between CF simultaneous requests and maintained database connections? Does a maintained database connection use one of the threads allocated for simultaneous requests? For example, suppose in Request Tuning I have simultaneous (Template) requests set to 10 and in CF data source settings I have Maintain Connections checked with Timeout set to 20 (minutes). A request completes. The database connection now is inactive and remains so for at least 20 minutes. CF maintains the connection to the database for 20 minutes. Does the maintained database connection also continue to hold on to the thread that was being used by the request that completed for the same 20 minutes? Or do the request thread and the database connection operate independently of each other? Thanks! George ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359168 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Simultaneous threads and maintain database connections
Hi, George! Is there a relationship between CF simultaneous requests and maintained database connections? No, not really. Does a maintained database connection use one of the threads allocated for simultaneous requests? No. Database connections use their own separate thread pool. The basic pooling mechanism is pretty similar, though. For example, suppose in Request Tuning I have simultaneous (Template) requests set to 10 and in CF data source settings I have Maintain Connections checked with Timeout set to 20 (minutes). A request completes. The database connection now is inactive and remains so for at least 20 minutes. CF maintains the connection to the database for 20 minutes. Does the maintained database connection also continue to hold on to the thread that was being used by the request that completed for the same 20 minutes? No. Or do the request thread and the database connection operate independently of each other? Yes, they're completely independent. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359169 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Simultaneous threads and maintain database connections
Hi back, Dave! Or do the request thread and the database connection operate independently of each other? Yes, they're completely independent. Thanks. This is what I always thought but I read something that made me think things might be otherwise. George ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359170 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Excel Problem...
I've got an application running on CF8 that's been successfully generating Excel reports for a good amount of time. Recently, the user upgraded Office (using 2013 now) - and now it no longer functions for them. Pretty simple stuff: cfsetting enablecfoutputonly=Yes cfheader name=Content-Disposition value=inline; filename=report.xls cfcontent type=application/vnd.ms-excelcfoutput !--- table of crap goes here --- ... with cftry and things where needed to catch errors... I don't use Excel on my machine, but the file opens perfectly for me in Open Office Calc - just as it has been for years. For the user though - file is pushed to them as normal, Excel opens - and THEN you get a generic error (Something like Sorry, there's been an error) - which doesn't tell you anything... Kinda at a loss. What am I missing? Is there some security setting inside Excel that's changed from one version to the next that needs tweaking, or what? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359171 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: deleting an image after using cfimage
the file is probably still locked. how long have you waited before trying to delete it ? On Tue, Aug 19, 2014 at 10:57 PM, te...@it-werks.com te...@it-werks.com te...@it-werks.com wrote: Cannot delete an image after using cfimage unless I stop and restart the Coldfusion Application server. Is there a setting I am missing? How can I program it to unlock as soon as it has been re sized or cropped? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359172 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: deleting an image after using cfimage
no, you have to wait until cf has finished with the file, if you are trying to delete immediately afterwards then that is probably why. You should either try adding a delay, or simply add the images to a list and setup a scheduled task that comes and deletes the files in that list later on. On Thu, Aug 21, 2014 at 1:33 AM, te...@it-werks.com te...@it-werks.com te...@it-werks.com wrote: the file is probably still locked. how long have you waited before trying to delete it ? On Tue, Aug 19, 2014 at 10:57 PM, te...@it-werks.com te...@it-werks.com te...@it-werks.com wrote: Cannot delete an image after using cfimage unless I stop and restart the Coldfusion Application server. Is there a setting I am missing? How can I program it to unlock as soon as it has been re sized or cropped? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359173 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm