How can we help you today?
Error: 'There should be no queued results'
8 CommentsSorted by Oldest First
Hans Bergsten
said
about 14 years ago
[This reply is migrated from our old forums.]
Re: Error: 'There should be no queued results'
Re: Error: 'There should be no queued results'
Hi Jon,
Please upgrade to the latest 7.1.x release (7.1.3) and let us know if that solves the problem. We fixed a problem that may be related to this in 7.1.2.
Best Regards,
Hans
[This reply is migrated from our old forums. The original author name has been removed]
Re: Error: 'There should be no queued results'
Re: Error: 'There should be no queued results'
Regrettably I tried it with 7.1.3 before making that post, and the error occurred. Sorry I should have been more specific about the sub-version.
Hans Bergsten
said
about 14 years ago
[This reply is migrated from our old forums.]
Re: Error: 'There should be no queued results'
Re: Error: 'There should be no queued results'
Hi Jon,
I cannot reproduce this error with a simple test procedure, using MS SQL Server 2005 (09.00.2047) and jTDS 1.2.5. The procedure I use looks like this:
CREATE PROCEDURE [dbo].[test_error]
@mode CHAR(1)
AS
IF @mode NOT IN ('A', 'B', 'C')
BEGIN
RAISERROR('Illegal value "%s" passed for @mode.', 16, -1, @mode)
RETURN 50000
END
When I execute it I get:
[@CALL - 0 row(s), 0.000 secs] [Error Code: 50000, SQL State: S1000] Illegal value "D" passed for @mode
You mention that you have to stop the procedure. Maybe that is what's causing this rather than the procedure raising an error?
Please see if you can reproduce the problem with my test procedure. If not, please see if you can reproduce it with a long running SELECT that you stop.
Best Regards,
Hans
[This reply is migrated from our old forums. The original author name has been removed]
Re: Error: 'There should be no queued results'
Re: Error: 'There should be no queued results'
Thanks - I confirm that I don't get the debug error with that test.
I was 'Stop'ping the query *after* the debug error had occurred (the SQL Editor remains unresponsive after the debug error, if the query is not Stopped) so that cannot have been the cause.
I'll see if I can come up with a test query that reliably reproduces the debug error.
[This reply is migrated from our old forums. The original author name has been removed]
Re: Error: 'There should be no queued results'
Re: Error: 'There should be no queued results'
I'm seeing this error again with a query that has not been STOPped.
10:54:26 [ERROR Thread-112 C.?] Internal error while executing: use xxx set implicit_transac...
java.lang.IllegalStateException: There should be no queued results.
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:579)
at net.sourceforge.jtds.jdbc.JtdsStatement.cacheResults(JtdsStatement.java:632)
at net.sourceforge.jtds.jdbc.JtdsResultSet.next(JtdsResultSet.java:582)
at net.sourceforge.jtds.jdbc.JtdsResultSet.close(JtdsResultSet.java:474)
at com.onseven.dbvis.H.B.Y.closeResultSet(Z:3518)
at com.onseven.dbvis.H.B.J.execute(Z:575)
at com.onseven.dbvis.H.B.N.execute(Z:1798)
at com.onseven.dbvis.H.B.Y.?(Z:591)
at com.onseven.dbvis.H.B.Y.run(Z:1655)
at com.onseven.dbvis.H.B.C.?(Z:2318)
at com.onseven.dbvis.H.B.C.?(Z:2185)
at com.onseven.dbvis.H.B.C.execute(Z:1511)
at com.onseven.dbvis.H.B.Y.?(Z:591)
at com.onseven.dbvis.H.B.K.?(Z:1013)
at se.pureit.swing.A.O$2.run(Z:1192)
at java.lang.Thread.run(Unknown Source)
Hans Bergsten
said
almost 13 years ago
[This reply is migrated from our old forums.]
Re: Error: 'There should be no queued results'
Re: Error: 'There should be no queued results'
Hi Jon,
So this is with just a SELECT statement, not via a stored procedure? Are you using the latest jTDS driver? As far as I can tell, the cause for this is within the driver itself. Have you checked the jTDS forums for an answer?
Best Regards,
Hans
[This reply is migrated from our old forums. The original author name has been removed]
Re: Error: 'There should be no queued results'
Re: Error: 'There should be no queued results'
We're still getting these errors from time to time, when a stored proc stops with an error - the latest:
13:06:57 [ERROR Thread-148 C.?] Internal error while executing: begin tran declare @Flags int ...
java.lang.IllegalStateException: There should be no queued results.
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:579)
at net.sourceforge.jtds.jdbc.JtdsStatement.cacheResults(JtdsStatement.java:632)
at net.sourceforge.jtds.jdbc.JtdsResultSet.next(JtdsResultSet.java:582)
at net.sourceforge.jtds.jdbc.JtdsResultSet.close(JtdsResultSet.java:474)
at com.onseven.dbvis.H.B.Y.closeResultSet(Z:3518)
at com.onseven.dbvis.H.B.J.execute(Z:575)
at com.onseven.dbvis.H.B.N.execute(Z:1798)
at com.onseven.dbvis.H.B.Y.?(Z:591)
at com.onseven.dbvis.H.B.Y.run(Z:1655)
at com.onseven.dbvis.H.B.C.?(Z:2318)
at com.onseven.dbvis.H.B.C.?(Z:2185)
at com.onseven.dbvis.H.B.C.execute(Z:1511)
at com.onseven.dbvis.H.B.Y.?(Z:591)
at com.onseven.dbvis.H.B.K.?(Z:1013)
at se.pureit.swing.A.O$2.run(Z:1192)
at java.lang.Thread.run(Unknown Source)
Hans Bergsten
said
almost 12 years ago
[This reply is migrated from our old forums.]
Re: Error: 'There should be no queued results'
Re: Error: 'There should be no queued results'
Hi Jon,
Sorry to hear that.
Which DbVisualizer version are you using now? Is auto-commit enabled or disabled when you see this? Have you ran any other SQL statements in the same SQL Commander before running the procedure?
Best Regards,
Hans
anonymous