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
The worst error is:
"unspecified error occured at line "
I always have a laugh at that one ;-)
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.
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.
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.
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...
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 :)
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
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.
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.
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?
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