We just recently migrated from ColdFusion 2011 to 2018. Pages on the site frequently encounter the following error:
Error Executing Database Query.[Macromedia][Oracle JDBC Driver]No more data available to read.
This is usually generated when a page is initally loaded or access after having been idle for an indeterminate time frame. This error was never an issue with our CF 2011 installation.
We are using an Oracle backend datasource which is situated in another physcial location from our CF servers. This setup is new to us but I cannot imagine it be the cause of the error.
I see that this error has been posted in the past by it was never fully resolved/explained.
Any advice/suggestion would be greatly appreciated.
Are you saying that having the database in a separate location is new, as well as your CF upgrade? Because that certainly sounds like a viable cause for your problem. And in general, it's not a good idea.
Dave Watts, Eidolon LLC
Thanks the response Dave.
Our host provider was able to help identify the crux of the issue. As they had explained: