Error: No more data available to read

[cal_binhtri]

Hi everyone,

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.

[Dave Watts]

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

[cal_binhtri]

Thanks the response Dave.

Our host provider was able to help identify the crux of the issue. As they had explained:

• We have seen this happen when the datasource timeout and interval is set too high. By default, the timeout is 20min and the interval is 7min. The datasources we saw, that had problems, were going through a proxy and the login timeout was 300 seconds. The interval had to be less than that to work. I just set your datasource to use a timeout of 3min and interval of 1min. That should keep the connection open and not timeout the read.

This seemed to have resolved the issue.