Highlighted

Error: No more data available to read

New Here ,
Jan 28, 2020

Copy link to clipboard

Copied

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.

 

TOPICS
Database access

Views

410

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Error: No more data available to read

New Here ,
Jan 28, 2020

Copy link to clipboard

Copied

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.

 

TOPICS
Database access

Views

411

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jan 28, 2020 0
Adobe Community Professional ,
Jan 30, 2020

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jan 30, 2020 0
New Here ,
Jan 30, 2020

Copy link to clipboard

Copied

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.

 

 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jan 30, 2020 0