Re: weird issue in browser with cf8 and long execution times
Yes, Ravi is correct. If CF is not connected to your webserver, the CFML will not run at all, and data will not be inserted. Are you doing some kind of cfheader/cfcontent, or javascript relocate somewhere? I'm thinking if your code does something like this: 1. get the XML 2. parse through it 3. do your cfcontent, or serve up another page that results in the blank file 4. loop through your data and insert into DB 1 and 2 is why it takes a while to have that dialog box to save index.cfm come up. 3 is what makes that dialog box come up 4 keeps on going because the request has been made. You've confirmed this in MySQL. It's like a user going to long_running_page.cfm, and then not waiting for the page to load and navigate to any_other_page.cfm. long_running_page.cfm is still executing on the server, even though the user is totally unaware of it (most users anyway). If it was the web connector, then the cfm file would never execute, and just get served up like ordinary html, by either displaying the unparsed cfml, or asking the file to be saved. [STS] Ravi Gehlot wrote: It is weird that it asks you to save the index.cfm file. The only time I had that problem was when IIS was not configured to open CFM files. Same had happened with Apache. But since you are saying that the process are running on the background with data being inserted into the database it makes me think that this is not a problem of adding CFM to IIS/Apache Index Directory. Ravi. On Sun, Apr 13, 2008 at 7:30 AM, Rick Faircloth [EMAIL PROTECTED] wrote: I remember getting that error when trying to complete a long-running cfftp request. It's been awhile, and I'm not sure what actually solved the issue, but I did look back at the file and remember adding cfsetting requesttimeout=6 to the code at the top of the page. Perhaps setting a high requesttimeout will help. If I think of something else, I'll pass it on to you. Rick -Original Message- From: Randy Johnson [mailto:[EMAIL PROTECTED] Sent: Sunday, April 13, 2008 12:15 AM To: CF-Talk Subject: weird issue in browser with cf8 and long execution times Hello, I am running CF8 Standard. I am running a page that takes a few minutes to run. After a certain amount of time a gray box will popup and ask me to save the index.cfm file or open it. When I open it or save it the file is always blank. When this happens it looks like the page is done executing in the browser but if you look in the task manager you see that JRUN is still using the CPU. I have also confirmed that the page is still running by doing a refresh in Navicat which shows that more rows are being added to the database table. The page is reading an XML file, parsing it and then looping over to insert data into the database. Has anyone seen this before or know what I need to do to stop it from happening? Thanks! Randy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303267 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: weird issue in browser with cf8 and long execution times
I actually had this same thing happen with a long running PHP script. That being said it seems to be a browser issue because the PHP page was on a different machine. I will have to do some testing in a different browser and see what happens. Right now I am using the latest version of Firefox 2.x -Randy On Mon, Apr 14, 2008 at 3:10 AM, rex [EMAIL PROTECTED] wrote: Yes, Ravi is correct. If CF is not connected to your webserver, the CFML will not run at all, and data will not be inserted. Are you doing some kind of cfheader/cfcontent, or javascript relocate somewhere? I'm thinking if your code does something like this: 1. get the XML 2. parse through it 3. do your cfcontent, or serve up another page that results in the blank file 4. loop through your data and insert into DB 1 and 2 is why it takes a while to have that dialog box to save index.cfm come up. 3 is what makes that dialog box come up 4 keeps on going because the request has been made. You've confirmed this in MySQL. It's like a user going to long_running_page.cfm, and then not waiting for the page to load and navigate to any_other_page.cfm. long_running_page.cfm is still executing on the server, even though the user is totally unaware of it (most users anyway). If it was the web connector, then the cfm file would never execute, and just get served up like ordinary html, by either displaying the unparsed cfml, or asking the file to be saved. [STS] Ravi Gehlot wrote: It is weird that it asks you to save the index.cfm file. The only time I had that problem was when IIS was not configured to open CFM files. Same had happened with Apache. But since you are saying that the process are running on the background with data being inserted into the database it makes me think that this is not a problem of adding CFM to IIS/Apache Index Directory. Ravi. On Sun, Apr 13, 2008 at 7:30 AM, Rick Faircloth [EMAIL PROTECTED] wrote: I remember getting that error when trying to complete a long-running cfftp request. It's been awhile, and I'm not sure what actually solved the issue, but I did look back at the file and remember adding cfsetting requesttimeout=6 to the code at the top of the page. Perhaps setting a high requesttimeout will help. If I think of something else, I'll pass it on to you. Rick -Original Message- From: Randy Johnson [mailto:[EMAIL PROTECTED] Sent: Sunday, April 13, 2008 12:15 AM To: CF-Talk Subject: weird issue in browser with cf8 and long execution times Hello, I am running CF8 Standard. I am running a page that takes a few minutes to run. After a certain amount of time a gray box will popup and ask me to save the index.cfm file or open it. When I open it or save it the file is always blank. When this happens it looks like the page is done executing in the browser but if you look in the task manager you see that JRUN is still using the CPU. I have also confirmed that the page is still running by doing a refresh in Navicat which shows that more rows are being added to the database table. The page is reading an XML file, parsing it and then looping over to insert data into the database. Has anyone seen this before or know what I need to do to stop it from happening? Thanks! Randy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303331 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: weird issue in browser with cf8 and long execution times
I remember getting that error when trying to complete a long-running cfftp request. It's been awhile, and I'm not sure what actually solved the issue, but I did look back at the file and remember adding cfsetting requesttimeout=6 to the code at the top of the page. Perhaps setting a high requesttimeout will help. If I think of something else, I'll pass it on to you. Rick -Original Message- From: Randy Johnson [mailto:[EMAIL PROTECTED] Sent: Sunday, April 13, 2008 12:15 AM To: CF-Talk Subject: weird issue in browser with cf8 and long execution times Hello, I am running CF8 Standard. I am running a page that takes a few minutes to run. After a certain amount of time a gray box will popup and ask me to save the index.cfm file or open it. When I open it or save it the file is always blank. When this happens it looks like the page is done executing in the browser but if you look in the task manager you see that JRUN is still using the CPU. I have also confirmed that the page is still running by doing a refresh in Navicat which shows that more rows are being added to the database table. The page is reading an XML file, parsing it and then looping over to insert data into the database. Has anyone seen this before or know what I need to do to stop it from happening? Thanks! Randy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303250 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: weird issue in browser with cf8 and long execution times
It is weird that it asks you to save the index.cfm file. The only time I had that problem was when IIS was not configured to open CFM files. Same had happened with Apache. But since you are saying that the process are running on the background with data being inserted into the database it makes me think that this is not a problem of adding CFM to IIS/Apache Index Directory. Ravi. On Sun, Apr 13, 2008 at 7:30 AM, Rick Faircloth [EMAIL PROTECTED] wrote: I remember getting that error when trying to complete a long-running cfftp request. It's been awhile, and I'm not sure what actually solved the issue, but I did look back at the file and remember adding cfsetting requesttimeout=6 to the code at the top of the page. Perhaps setting a high requesttimeout will help. If I think of something else, I'll pass it on to you. Rick -Original Message- From: Randy Johnson [mailto:[EMAIL PROTECTED] Sent: Sunday, April 13, 2008 12:15 AM To: CF-Talk Subject: weird issue in browser with cf8 and long execution times Hello, I am running CF8 Standard. I am running a page that takes a few minutes to run. After a certain amount of time a gray box will popup and ask me to save the index.cfm file or open it. When I open it or save it the file is always blank. When this happens it looks like the page is done executing in the browser but if you look in the task manager you see that JRUN is still using the CPU. I have also confirmed that the page is still running by doing a refresh in Navicat which shows that more rows are being added to the database table. The page is reading an XML file, parsing it and then looping over to insert data into the database. Has anyone seen this before or know what I need to do to stop it from happening? Thanks! Randy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303252 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: weird issue in browser with cf8 and long execution times
Hi Randy, I would try re-mapping your IIS or web server settings using the CF Web Server Configuration Tool. -Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303259 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
weird issue in browser with cf8 and long execution times
Hello, I am running CF8 Standard. I am running a page that takes a few minutes to run. After a certain amount of time a gray box will popup and ask me to save the index.cfm file or open it. When I open it or save it the file is always blank. When this happens it looks like the page is done executing in the browser but if you look in the task manager you see that JRUN is still using the CPU. I have also confirmed that the page is still running by doing a refresh in Navicat which shows that more rows are being added to the database table. The page is reading an XML file, parsing it and then looping over to insert data into the database. Has anyone seen this before or know what I need to do to stop it from happening? Thanks! Randy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303244 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
