Re: CFQUERY immediately throws blank CF error and HTTP 500 code when more than 50 records will be returned (CF6)
Not sure.. we don't handle much of the system software/hardware on the box. Do you know what that may affect or how to check when it was updated? Has anyone updated the java version by any chance Russ Michaels www.michaels.me.uk On 9 Jul 2013 23:11, Chris Johnson ejohn...@directalliance.com wrote: ~| 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:356161 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFQUERY immediately throws blank CF error and HTTP 500 code when more than 50 records will be returned (CF6)
Do any other CF requests work on that server? Sounds like a web connector issue perhaps. Byron Mann Lead Engineer Architect HostMySite.com On Jul 9, 2013 6:11 PM, Chris Johnson ejohn...@directalliance.com wrote: Really odd issue we've been having.. We have a scheduled task that hits another database server to get a full list of employees. It then runs through the user accounts for this specific app and adds or updates accounts as needed. We weren't aware that it had been broken, so we don't know exactly what change on the server side could have done it (virtual instance). If the query looks like: select TOP 5 somecolumn from employees - the query runs If the query looks like: select somecolumn from employees - a blank CF error (no message or details) is thrown immediately without trying to run the query I've upped the TOP 5 to about ~50 and around that and above, it either throws the immediate CF error or attempts to run and then brings down ColdFusion. On one of our other CF boxes with less memory (4gb vs 512mb), the query runs and returns the 18,000 rows within seconds. Looking at Task Manager, I don't see any spikes in memory or CPU when the page is ran. The error is thrown immediately, almost like the server just refused to bother. It seems like ColdFusion is either trying to allocate resources and not liking the info it gets or is somehow otherwise sizing up what will be needed for the call. I can't think of any other reason why it wouldn't run and time out like other queries. The CF error returned is blank and thrown immediately. We've created a new DSN using the fully qualified domain name, IP address, and even changed the query to a stored proc that should have resulted in less overhead on CF and nothing seems to help. If we don't specify a TOP XX number or specify one that's too large (50+), we get this strange result. Otherwise it runs or at least attempts to run just fine. Being that we're using an long outdated version of CF, it's been hard to find support specific to this issue and I need to try to throw our server folks a bone as these issues tend to become IT hot potato games (not the server, it's CF... not CF, it's the database, etc.). Anyone experience a similar issue? I've created tons of queries in the last 10 years, crashed tons of CF instances, and written tons of bad SQL, but this issue is so odd that I've never encountered it in the wild. In the CF Admin settings, the CF version on the trouble server is showing as 6,1,0,83762. ~| 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:356162 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFQUERY immediately throws blank CF error and HTTP 500 code when more than 50 records will be returned (CF6)
you should ask whoever manages the server, as updating to new java versions can have bizzare results like this where everything seems to work except one random thing. you can also see the java version being used on the info page in cfadmin. you should also try rebuilding your conenctors, as they sometimes get corrupted. The easy way to do this is to use the Coldfusion Web config tool to disable then re-enable CF, which will create a new connector. the other issue could be the number of connections, how busy is the server? when you do these tests is it always re-producible without fail ? it could also be your DSN settings, can you tell me what you have them set to currently, the advanced settings mainly. On Wed, Jul 10, 2013 at 5:45 PM, Chris Johnson ejohn...@directalliance.comwrote: Not sure.. we don't handle much of the system software/hardware on the box. Do you know what that may affect or how to check when it was updated? Has anyone updated the java version by any chance Russ Michaels www.michaels.me.uk On 9 Jul 2013 23:11, Chris Johnson ejohn...@directalliance.com wrote: ~| 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:356163 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFQUERY immediately throws blank CF error and HTTP 500 code when more than 50 records will be returned (CF6)
Really odd issue we've been having.. We have a scheduled task that hits another database server to get a full list of employees. It then runs through the user accounts for this specific app and adds or updates accounts as needed. We weren't aware that it had been broken, so we don't know exactly what change on the server side could have done it (virtual instance). If the query looks like: select TOP 5 somecolumn from employees - the query runs If the query looks like: select somecolumn from employees - a blank CF error (no message or details) is thrown immediately without trying to run the query I've upped the TOP 5 to about ~50 and around that and above, it either throws the immediate CF error or attempts to run and then brings down ColdFusion. On one of our other CF boxes with less memory (4gb vs 512mb), the query runs and returns the 18,000 rows within seconds. Looking at Task Manager, I don't see any spikes in memory or CPU when the page is ran. The error is thrown immediately, almost like the server just refused to bother. It seems like ColdFusion is either trying to allocate resources and not liking the info it gets or is somehow otherwise sizing up what will be needed for the call. I can't think of any other reason why it wouldn't run and time out like other queries. The CF error returned is blank and thrown immediately. We've created a new DSN using the fully qualified domain name, IP address, and even changed the query to a stored proc that should have resulted in less overhead on CF and nothing seems to help. If we don't specify a TOP XX number or specify one that's too large (50+), we get this strange result. Otherwise it runs or at least attempts to run just fine. Being that we're using an long outdated version of CF, it's been hard to find support specific to this issue and I need to try to throw our server folks a bone as these issues tend to become IT hot potato games (not the server, it's CF... not CF, it's the database, etc.). Anyone experience a similar issue? I've created tons of queries in the last 10 years, crashed tons of CF instances, and written tons of bad SQL, but this issue is so odd that I've never encountered it in the wild. In the CF Admin settings, the CF version on the trouble server is showing as 6,1,0,83762. ~| 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:356143 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFQUERY immediately throws blank CF error and HTTP 500 code when more than 50 records will be returned (CF6)
Has anyone updated the java version by any chance Russ Michaels www.michaels.me.uk On 9 Jul 2013 23:11, Chris Johnson ejohn...@directalliance.com wrote: Really odd issue we've been having.. We have a scheduled task that hits another database server to get a full list of employees. It then runs through the user accounts for this specific app and adds or updates accounts as needed. We weren't aware that it had been broken, so we don't know exactly what change on the server side could have done it (virtual instance). If the query looks like: select TOP 5 somecolumn from employees - the query runs If the query looks like: select somecolumn from employees - a blank CF error (no message or details) is thrown immediately without trying to run the query I've upped the TOP 5 to about ~50 and around that and above, it either throws the immediate CF error or attempts to run and then brings down ColdFusion. On one of our other CF boxes with less memory (4gb vs 512mb), the query runs and returns the 18,000 rows within seconds. Looking at Task Manager, I don't see any spikes in memory or CPU when the page is ran. The error is thrown immediately, almost like the server just refused to bother. It seems like ColdFusion is either trying to allocate resources and not liking the info it gets or is somehow otherwise sizing up what will be needed for the call. I can't think of any other reason why it wouldn't run and time out like other queries. The CF error returned is blank and thrown immediately. We've created a new DSN using the fully qualified domain name, IP address, and even changed the query to a stored proc that should have resulted in less overhead on CF and nothing seems to help. If we don't specify a TOP XX number or specify one that's too large (50+), we get this strange result. Otherwise it runs or at least attempts to run just fine. Being that we're using an long outdated version of CF, it's been hard to find support specific to this issue and I need to try to throw our server folks a bone as these issues tend to become IT hot potato games (not the server, it's CF... not CF, it's the database, etc.). Anyone experience a similar issue? I've created tons of queries in the last 10 years, crashed tons of CF instances, and written tons of bad SQL, but this issue is so odd that I've never encountered it in the wild. In the CF Admin settings, the CF version on the trouble server is showing as 6,1,0,83762. ~| 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:356144 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
