tracker issue : CF-4204300

select a category, or use search below
(searches all categories and all time range)
Title:

Random JDBC No More Data Available To Read.

| View in Tracker

Status/Resolution/Reason: To Track//PRNeedInfo

Reporter/Name(from Bugbase): Michael G. / ()

Created: 05/12/2019

Components: Database, Oracle

Versions: 2018

Failure Type: Data Loss

Found In Build/Fixed In Build: 5.1.4 (Build 0001) /

Priority/Frequency: Normal / Very few users will encounter

Locale/System: English / Win 2016

Vote Count: 0

Problem Description: We currently have a setup where we were using Coldfusion 2010 enterprise connecting to an Oracle 8i database. We have moved to Coldusion 2018 enterprise using the the same Oracle 8i database with the standard Oracle drivers that come with 2018.

We are randomly getting the JDBC No More Data Available To Read a couple of times a day on our VPS server. 

Steps to Reproduce: We have no way to reproduce this. It happens randomly and I am not sure where to go.

Actual Result: The result is we are getting the error instead of our query returning data.

Expected Result:

 HTTP_CONNECTION:close
HTTP_CONTENT-LENGTH:504
HTTP_CONTENT-TYPE:application/x-www-form-urlencoded
HTTP_ACCEPT-ENCODING:gzip,deflate
HTTP_AUTHORIZATION:Basic cXVzZXI6ZXJ1dEZAIXJQcml6ZUA=
HTTP_HOST:184.175.83.104
HTTP_USER-AGENT:ColdFusion
HTTP_TOMCATAUTHTYPE00000000552A0000:Basic
HTTP_TOMCATAUTHPASSWORD00000000552A0000:
HTTP_TOMCATREMOTEUSER00000000552A0000:
HTTP_TOMCATCGIHTTPURL00000000552A0000:/cfc/shopify.cfc?method=remoteGetDiscount
HTTP_XSITE-NAME:DEFAULT WEB SITE
HTTP_XCLUSTER-NAME:
   
   Location: 184.175.102.253
   Browser: ColdFusion
   Date/Time: {ts '2019-05-11 07:19:39'}
   Page:
   Content: Error Executing Database Query. [Macromedia][Oracle JDBC Driver]No more data available to read. <br>The error occurred on line 686. /cfc/shopify.cfc method=remoteGetDiscount

Attachments:

Comments:

Hi Michael, Please provide us more detail about the query and data that you are getting back from your database server. You can get the query details from this method: /cfc/shopify.cfc?method=remoteGetDiscount -Nimit
Comment by Nimit S.
30862 | June 03, 2019 11:55:54 AM GMT