No more data available to read

[JeffPTampa]

Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]No more data
available to read.

We get the above error "randomly" -- I cannot replicate, but it occurs often
enough that our users are starting to report it now too. We have applied all CF
MX 6 updates ("updater"), etc. (we are windows 2003, CF MX 6.1+, SQL Server
2000)

I assume that would mean we have the latest DB drivers too if we have applied
the latest MX updater. After looking at our sql server log, it does not appear
we are violating our # of license connections either.

Has anyone been able to figure this one out? Any help would be geratly
appreciated.

I have read all the various threads online and still am at a loss as to how to
fix this. Everything worked great before we upgraded to CF MX (figures).

Thanks again in advance.

[shoalwater]

I've not seen this before. Can you give some examples of code that generates this error?

[shoalwater]

Sounds like it's possibly a driver issue. I'd try updating them separately, as
I don't think CF updates include new drivers, since overwriting old drivers
could cause people some real problems.
[url]http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:30422[/url]

[RCRATHORE]

I guess it is a known issue with Macromedia drivers (that is pre 3.4). Try using version 3.4 from [url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=1a3c2ad0[/url])

[amac0001]

I also get the same error message. It comes and goes randomly, and refreshing the page corrects it. However, I have not been able to figure out what causes it.

[sdupre]

The 3.2 drivers that shipped with 6.1 Gold definitely had this problem but the
behavior could happen with many different causes (ex: text field queries - but
not every time, etc).

The 6.1 Updater should have given you 3.3 build 31 or 48 and taken care of
this problem.

Some other possibilities:

1) The older drivers sometimes threw this error in MS SQL Server when you had
pooling enabled (but not restricted to a specific pool size - ie - unlimited)
and your SQL Server was connection limited to say 10.

On the 11th connection, this error would be thrown.

2) Another possibility is a firewall is taking out the SQL Server connection
after some idle time (some firewalls do this by default at the 5 minute mark).
CF grabs a connection out of the pool that's bad, tries to use it and the
driver throws this error. Next time, you'll get a good connection from the
pool (probably) which is why the refresh works.

Is it any one of these 2 things?

If you're still seeing the problem with the 3.4 drivers from the link:
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=1a3c2ad0[/url]

I'd like to talk to you and get an example.

Stephen Dupre
Macromedia QA

[gatsrulz]

I keep getting the error No more data available to read. I just recently ran cf patches on my system, but it still occurs. Am not sure why? Please help

[JanM]

Hello
Where is a solution for the JDBC Error: "no more data available to read" when
connecting from CF6.1(incl. Updater) to MS SQL Server 2000 SP4?
The technote
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=1a3c2ad0[/url] should
fix this problem:
51266 - No more data available to read error when maximum connections are
reached
But replacing the DataDirect JDBC drivers version 3.3 with the recomended
version 3.4 did not help.

So what can be done?
Jan

[JanM]

Hello Macromedia
Is there a solution, a new driver or what can we do now?

[sdupre]

Can you put the entire error stack here and email them to me?

Stephen Dupre
Macromedia QA

[JanM]

With try/catch I only get the errors provided:
Type: Database
Message: Error Executing Database Query.
Detail: [Macromedia][SQLServer JDBC Driver]No more data available to read.
SQLState: 08006

How can be a stack trace produced?

Thanks
Jan

[sdupre]

Does this happen every time?

[JanM]

Yes it happens on every request.
In the meantime we changed back to JDBC-ODBC Bridge.
We heard from Microsoft, that there is a pending Service-Request on that issue
because SP4 of SQL Server is acting different than SP3.
I can't find more info about the error in the log files.
If we can help, tell us what to do.

[Ike23]

I am having the same problem with a blog that uses CF 6.1, SQL Server 2000 and
RSS feeds. It only happens sometimes though but it is a problem. Here's the
entire stack trace:

Type=Database



--------------------------------------------------------------------------------

Message=Error Executing Database Query.



--------------------------------------------------------------------------------

Detail=[Macromedia][SQLServer JDBC Driver]No more data available to read.

struct

DataSource
mikeblog

Detail
[Macromedia][SQLServer JDBC Driver]No more data available to read.

ErrorCode
HY000

Message
Error Executing Database Query.

NativeErrorCode
0

RootCause
struct

ErrorCode
0

Message
[Macromedia][SQLServer JDBC Driver]No more data available to read.

SQLState
HY000

StackTrace
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]No more data
available to read. at
macromedia.jdbc.base.BaseExceptions.createExceptio n(Unknown Source) at
macromedia.jdbc.base.BaseExceptions.getException(U nknown Source) at
macromedia.jdbc.sqlserver.tds.TDSRPCRequest.submit Request(Unknown Source) at
macromedia.jdbc.sqlserver.tds.TDSRPCNonCursorExecu teRequest.submitExecute(Unknow
n Source) at macromedia.jdbc.sqlserver.tds.TDSRPCExecuteRequest .execute(Unknown
Source) at macromedia.jdbc.sqlserver.SQLServerImplStatement.e xecute(Unknown
Source) at macromedia.jdbc.base.BaseStatement.commonExecute(U nknown Source) at
macromedia.jdbc.base.BaseStatement.executeInternal (Unknown Source) at
macromedia.jdbc.base.BasePreparedStatement.execute (Unknown Source) at
macromedia.jdbc.base.BasePreparedStatementPoolable .execute(Unknown Source) at
coldfusion.server.j2ee.sql.JRunPreparedStatement.e xecute(JRunPreparedStatement.j
ava:87) at coldfusion.sql.Executive.executeQuery(Executive.ja va:979) at
coldfusion.sql.Executive.executeQuery(Executive.ja va:886) at
coldfusion.sql.SqlImpl.execute(SqlImpl.java:229) at
coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.j ava:447) at
cfblog2ecfc2044626593$funcGETENTRIES.runFunction(\ mikesblog\client\org\camden\bl
og\blog.cfc:679) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java :338) at
coldfusion.filter.SilentFilter.invoke(SilentFilter .java:44) at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invo ke(UDFMethod.java:286) at
coldfusion.runtime.UDFMethod$ArgumentCollectionFil ter.invoke(UDFMethod.java:250)
at coldfusion.filter.FunctionAccessFilter.invoke(Func tionAccessFilter.java:53)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMet hod.java:203) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java :165) at
coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage. java:1768) at
cfblog2ecfc2044626593$funcGENERATERSS.runFunction( \mikesblog\client\org\camden\b
log\blog.cfc:362) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java :338) at
coldfusion.filter.SilentFilter.invoke(SilentFilter .java:44) at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invo ke(UDFMethod.java:286) at
coldfusion.runtime.UDFMethod$ArgumentCollectionFil ter.invoke(UDFMethod.java:250)
at coldfusion.filter.FunctionAccessFilter.invoke(Func tionAccessFilter.java:53)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMet hod.java:203) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java :359) at
coldfusion.runtime.TemplateProxy.invoke(TemplatePr oxy.java:196) at
coldfusion.runtime.TemplateProxy.invoke(TemplatePr oxy.java:139) at
coldfusion.runtime.CfJspPage._invoke(CfJspPage.jav a:1582) at
cfrss2ecfm1665696840.runPage(\mikesblog\client\rss .cfm:37) at
coldfusion.runtime.CfJspPage.invoke(CfJspPage.java :147) at
coldfusion.tagext.lang.IncludeTag.doStartTag(Inclu deTag.java:357) at
coldfusion.filter.CfincludeFilter.invoke(Cfinclude Filter.java:62) at
coldfusion.filter.ApplicationFilter.invoke(Applica tionFilter.java:107) at
coldfusion.filter.PathFilter.invoke(PathFilter.jav a:80) at
coldfusion.filter.ExceptionFilter.invoke(Exception Filter.java:47) at
coldfusion.filter.ClientScopePersistenceFilter.inv oke(ClientScopePersistenceFilt
er.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilt er.java:35) at
coldfusion.filter.GlobalsFilter.invoke(GlobalsFilt er.java:43) at
coldfusion.filter.DatasourceFilter.invoke(Datasour ceFilter.java:22) at
coldfusion.CfmServlet.service(CfmServlet.java:105) at
jrun.servlet.ServletInvoker.invoke(ServletInvoker. java:91) at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvok erChain.java:42) at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequ estDispatcher.java:252) at
jrun.servlet.ServletEngineService.dispatch(Servlet EngineService.java:527) at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable( JRunProxyService.java:192) at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invok eRunnable(ThreadPool.java:348)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRu nnable(ThreadPool.java:451)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeR unnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java :66)

TagContext
array

1
struct

COLUMN
0

ID
CFQUERY

LINE
679

RAW_TRACE
at
cfblog2ecfc2044626593$funcGETENTRIES.runFunction(\ mikesblog\client\org\camden\bl
og\blog.cfc:679)

TEMPLATE
\client\org\camden\blog\blog.cfc

TYPE
CFML



2
struct

COLUMN
0

ID
CF_UDFMETHOD

LINE
362

RAW_TRACE
at
cfblog2ecfc2044626593$funcGENERATERSS.runFunction( \mikesblog\client\org\camden\b
log\blog.cfc:362)

TEMPLATE
\mikesblog\client\org\camden\blog\blog.cfc

TYPE
CFML



3
struct

COLUMN
0

ID
CF_TEMPLATEPROXY

LINE
37

RAW_TRACE
at cfrss2ecfm1665696840.runPage(\mikesblog\client\rss .cfm:37)

TEMPLATE
\mikesblog\client\rss.cfm

TYPE
CFML





Type
java.sql.SQLException



SQLState
HY000

Sql
select top 15 tblblogentries.id, tblblogentries.title, tblblogentries.alias,
tblblogentries.posted, tblblogentries.username , tblblogentries.body,
tblblogentries.morebody from tblblogentries where 1=1 and blog = (param 1)
order by tblblogentries.posted desc

StackTrace
coldfusion.tagext.sql.QueryTag$DatabaseQueryExcept ion: Error Executing
Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.j ava:495)
at
cfblog2ecfc2044626593$funcGETENTRIES.runFunction(\ mikesblog\client\org\camden\bl
og\blog.cfc:679) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java :338) at
coldfusion.filter.SilentFilter.invoke(SilentFilter .java:44) at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invo ke(UDFMethod.java:286) at
coldfusion.runtime.UDFMethod$ArgumentCollectionFil ter.invoke(UDFMethod.java:250)
at coldfusion.filter.FunctionAccessFilter.invoke(Func tionAccessFilter.java:53)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMet hod.java:203) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java :165) at
coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage. java:1768) at
cfblog2ecfc2044626593$funcGENERATERSS.runFunction( \mikesblog\client\org\camden\b
log\blog.cfc:362) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java :338) at
coldfusion.filter.SilentFilter.invoke(SilentFilter .java:44) at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invo ke(UDFMethod.java:286) at
coldfusion.runtime.UDFMethod$ArgumentCollectionFil ter.invoke(UDFMethod.java:250)
at coldfusion.filter.FunctionAccessFilter.invoke(Func tionAccessFilter.java:53)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMet hod.java:203) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java :359) at
coldfusion.runtime.TemplateProxy.invoke(TemplatePr oxy.java:196) at
coldfusion.runtime.TemplateProxy.invoke(TemplatePr oxy.java:139) at
coldfusion.runtime.CfJspPage._invoke(CfJspPage.jav a:1582) at
cfrss2ecfm1665696840.runPage(\mikesblog\client\rss .cfm:37) at
coldfusion.runtime.CfJspPage.invoke(CfJspPage.java :147) at
coldfusion.tagext.lang.IncludeTag.doStartTag(Inclu deTag.java:357) at
coldfusion.filter.CfincludeFilter.invoke(Cfinclude Filter.java:62) at
coldfusion.filter.ApplicationFilter.invoke(Applica tionFilter.java:107) at
coldfusion.filter.PathFilter.invoke(PathFilter.jav a:80) at
coldfusion.filter.ExceptionFilter.invoke(Exception Filter.java:47) at
coldfusion.filter.ClientScopePersistenceFilter.inv oke(ClientScopePersistenceFilt
er.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilt er.java:35) at
coldfusion.filter.GlobalsFilter.invoke(GlobalsFilt er.java:43) at
coldfusion.filter.DatasourceFilter.invoke(Datasour ceFilter.java:22) at
coldfusion.CfmServlet.service(CfmServlet.java:105) at
jrun.servlet.ServletInvoker.invoke(ServletInvoker. java:91) at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvok erChain.java:42) at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequ estDispatcher.java:252) at
jrun.servlet.ServletEngineService.dispatch(Servlet EngineService.java:527) at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable( JRunProxyService.java:192) at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invok eRunnable(ThreadPool.java:348)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRu nnable(ThreadPool.java:451)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeR unnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java :66)

TagContext
array

1
struct

COLUMN
0

ID
CFQUERY

LINE
679

RAW_TRACE
at
cfblog2ecfc2044626593$funcGETENTRIES.runFunction(\ mikesblog\client\org\camden\bl
og\blog.cfc:679)

TEMPLATE
\mikesblog\client\org\camden\blog\blog.cfc

TYPE
CFML



2
struct

COLUMN
0

ID
CF_UDFMETHOD

LINE
362

RAW_TRACE
at cfblog2ecfc2044626593$funcGENERATERSS.runFunction(
\mikesblog\client\org\camden\blog\blog.cfc:362)

TEMPLATE
\mikesblog\client\org\camden\blog\blog.cfc

TYPE
CFML



3
struct

COLUMN
0

ID
CF_TEMPLATEPROXY

LINE
37

RAW_TRACE
at cfrss2ecfm1665696840.runPage(\mikesblog\client\rss .cfm:37)

TEMPLATE
\mikesblog\client\rss.cfm

TYPE

[JonJonJonJonJon]

I am also getting the JDBC error "No more data available to read". I'm on CF
7.0.1 and I have the latest Data Direct 3.5 drivers from the Macromedia website
and I am going against an Oracle 10gR2 database. I don't get the errors
against Oracle 9iR2. I get the error in rare circumstances, but consistently
for a given query that errors. For example, the following causes the error

SELECT ApplicationDesc FROM OurSchema.OurTable WHERE ApplicationID =
<cfqueryparam cfsqltype="cf_sql_char" value="OurAppID" > AND ApplicationActive
= -1

but not in the following similar queries:

SELECT ApplicationDesc FROM OurSchema.OurTable WHERE ApplicationID =
'OurAppID' AND ApplicationActive = -1

SELECT ApplicationDesc FROM OurSchema.OurTable WHERE ApplicationID =
<cfqueryparam cfsqltype="cf_sql_char" value="OurAppID" > AND ApplicationActive
!= -1

The stack trace that results from the first query is below. Let me know if I
can provide any more info.

Thanks,
Jon


SQLSTATE 08006

java.sql.SQLException: [Macromedia][Oracle JDBC Driver]No more data available
to read.
at macromedia.jdbc.base.BaseExceptions.createExceptio n(Unknown Source)
at macromedia.jdbc.base.BaseExceptions.getException(U nknown Source)
at macromedia.jdbc.base.BaseExceptions.getException(U nknown Source)
at macromedia.jdbc.oracle.net8.OracleNet8NSPTDAPacket .sendRequest(Unknown
Source)
at macromedia.jdbc.oracle.OracleImplStatement.execute (Unknown Source)
at macromedia.jdbc.base.BaseStatement.commonExecute(U nknown Source)
at macromedia.jdbc.base.BaseStatement.executeInternal (Unknown Source)
at macromedia.jdbc.base.BasePreparedStatement.execute (Unknown Source)
at macromedia.jdbc.base.BasePreparedStatementPoolable .execute(Unknown Source)
at
coldfusion.server.j2ee.sql.JRunPreparedStatement.e xecute(JRunPreparedStatement.j
ava:87)
at coldfusion.sql.Executive.executeQuery(Executive.ja va:722)
at coldfusion.sql.Executive.executeQuery(Executive.ja va:652)
at coldfusion.sql.Executive.executeQuery(Executive.ja va:613)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.j ava:499)
at cf10g2ecfm1954807696.runPage(C:\MBMWeb\test\10g\10 g.cfm:22)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java :152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Inclu deTag.java:349)
at coldfusion.filter.CfincludeFilter.invoke(Cfinclude Filter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(Applica tionFilter.java:210)
at coldfusion.filter.RequestMonitorFilter.invoke(Requ estMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.jav a:86)
at coldfusion.filter.LicenseFilter.invoke(LicenseFilt er.java:27)
at coldfusion.filter.ExceptionFilter.invoke(Exception Filter.java:69)
at coldfusion.filter.BrowserDebugFilter.invoke(Browse rDebugFilter.java:52)
at
coldfusion.filter.ClientScopePersistenceFilter.inv oke(ClientScopePersistenceFilt
er.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilt er.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilt er.java:38)
at coldfusion.filter.DatasourceFilter.invoke(Datasour ceFilter.java:22)
at
coldfusion.filter.RequestThrottleFilter.invoke(Req uestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at coldfusion.bootstrap.BootstrapServlet.service(Boot strapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker. java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvok erChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequ estDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(Servlet EngineService.java:541)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable( JRunProxyService.java:204)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invok eRunnable(ThreadPool.java:318)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRu nnable(ThreadPool.java:426)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeR unnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java :66)

[sdupre]

JonJonJonJonJon,

Your issue with Oracle is different and I've repro'd this and sent it to
DataDirect.

Bug 61367. Certain prepared statements fail.

anM: Try the 3.5 drivers. I'm sure SP4 isn't supported on the older 3.3
drivers (though I'm not sure this is the cause of the "no more data..." errors.

Stephen Dupre
Macromedia QA

[Ike23]

I updated my drivers and it seems to have fixed the "no more data available to
read" error. But now I'm seeing an error I've never run accross before. It
doesn't happen every time I load a certain page but it does happen enough to
cause a problem. Is this another known issue with the new drivers?

[Macromedia][SQLServer JDBC Driver]Connection reset by peer: socket write error

[JanM]

We installed now CF7.0.1 with all the related Hotfixes on Win2003 Server.
The error ist still the same.
A connection to our providers SQL Server 2000SP3 is possible.
Can anybody try to connect to SQL Server 2000SP4 with CF 7.0.1?