Now THAT Is an Error Message

I just got this error message:

17 >= 17

I'm not kidding. That was the message. When I find out more, I'll post the details.

Edited 2 Minutes Later: I turned on Robust Exception Info, and the error went away, so it must have been a fluke... but still - it was pretty funny.

Edited 1 Minute Later: It's back now. This time I see more information. It is happening inside a query. Here is part of the stack trace:

java.lang.ArrayIndexOutOfBoundsException: 17 >= 17
at java.util.Vector.elementAt(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.getColumn(Unknown Source)

Last Edit: I think I figured it out. The query in question was a select * from foo where id = X, where X used a query param. The use of queryparam caused CF to store the ... I think "prepared statement" is the right word. The table in question was modified though. I went to the CF Admin, selected the DSN, and set the Max Pooled Statements to 0, which fixed the problem. Although normally you wouldn't do that on a production server.

Archived Comments

Comment 1 by Peter J. Farrell posted on 4/14/2005 at 12:23 AM

The worst error is:
"unspecified error occured at line "

I always have a laugh at that one ;-)

Comment 2 by Joe Rinehart posted on 4/14/2005 at 12:36 AM

I liked the "_0123456789neverusethisasavariablenameinyourcode" (or something similar) that CF5 (I think, maybe 4.5) and previous versions would give under the right conditions.

Also, there was one about a jedi master (Ray?) in the CF5.0 admin somewhere.

Comment 3 by Ray Camden posted on 4/14/2005 at 1:35 AM

jedimasterwhoppersupreme. Yep, that was me. I was trying to sort a struct by two keys. It was rather silly of me. I could have converted the data to a query and just did QofQ.

Comment 4 by dave ross posted on 4/14/2005 at 5:29 AM

yeah this issue has reared it's ugly head for me before. It happens when you change a db schema (e.g. add a field) and are using wildcard operators in SQL coupled with cfqueryparam. One quick way to get rid of the error is to add a space to the end of the sql string.

This is one bug I sometimes appreciate, because it reminds me to NOT use wildcards in my SQL...even though I still do, it's just less often.

Comment 5 by Daniel Short posted on 4/14/2005 at 6:01 AM

During my "I can't get Application.cfc to extend Application.cfc" debacle, I tried adding a <cfapplication> tag to my Application.cfc. I got 5 >=1... Like I didn't already know that...

Comment 6 by Giampaolo Bellavite posted on 4/14/2005 at 12:14 PM

Often I get this error live changing a view or a table in SQL Server. Never thought it was the cfqueryparam or the pooled statements setting. Great tip, thank you :)

Comment 7 by Daniel Roberts posted on 4/14/2005 at 6:39 PM

The [Unknown Exception] error was driving me crazy for a while, then I had the bright idea to search Macromedia's site for known issues and found a Hotfix...woohoo

Comment 8 by chris posted on 4/14/2005 at 6:49 PM

I was getting a 4096 error for awhile. Anyone ever had that come up? It went away, but I would really like to know what was causing it.

Comment 9 by ben nadel posted on 4/16/2005 at 8:00 PM

I get that 17 >= 17 error all the time. I find what works for me every single time is go into CFAdmin and turn of "Maintain connection" on the data source. I usually get this error after i alter the datatable. Its like the system caches the db connection and structure or something. I don't really know about this stuff, but in the development server i tend to leave that turned off all the time and i never get that issue at all.

Comment 10 by J Ditty posted on 12/14/2005 at 11:42 PM

With Robust error reporting off I think I've got an even better one.

" Error Occurred While Processing Request: 9 "

With robust error reporting on I'm still just as baffled:

java.lang.ArrayIndexOutOfBoundsException: 9

I'm trying to use the administrator API, setting a MySQL datasource. It craps out everytime I try to set the password. I can't find any info on this, kind of looks like a bug / driver JDBC issue?

Comment 11 by Brent Gravelle posted on 10/17/2006 at 11:40 PM

I keep getting these oracle errors that are causing our server to hang, we're running CFMX7 connecting to an Oracle 10g database. Thinking of fidling with the MAX POOLED STATEMENTS, TIMEOUT, INTERVAL settings, but I'm not sure if that will do anything. If anyone can give me some advice it would be greatly appreciated!!

Errors like:
"Error Executing Database Query.[Macromedia][Oracle JDBC Driver][Oracle]ORA-01407: cannot update (""XXX"".""X_FORM_DOCS"".""X_TITLE"") to NULL

AND

"Error Executing Database Query.[Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character