Just migrating from coldfusion11 to Coldfusion2021 and it looks like queryofquery doesn’t work anymore!!!
Here is the error returned :
| Message | [empty string] |
| StackTrace | java.lang.NullPointerException at coldfusion.sql.imq.rttSelectExprSpec.validateOrderBy(rttSelectExprSpec.java:608) at coldfusion.sql.imq.rttSelectStmt.validate(rttSelectStmt.java:86) at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:550) at coldfusion.sql.imq.jdbcStatement.execute(jdbcStatement.java:143) at coldfusion.sql.Executive.executeQuery(Executive.java:1595) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:430) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821) at cfLoadcamp2ecfm184386686.runPage(D:sites web123mailings.comv11SG_V3includesLoadcamp.cfm:13) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5201) at cfcatalogue2ecfm1102540526.runPage(D:sites web123mailings.comv11SG_V3catalogue.cfm:5) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:228) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:373) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:462) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1723) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) |
| S |
Newbie
1 posts
Yep, it’s not that it’s broken “in CF2021”, but rather that it became broken as of update 2 (released in September, when it also was broken in CF2018 update 12). And sadly, the update in December only addressed log4j and did not address this or any other bugs introduced in that update 2 (or 12).
But here’s good news: you can get the hotfix directly. No need to ask Adobe. It’s offered as a jar in the bug report about the issue:
https://tracker.adobe.com/#/view/cf-4212383
The jar is offered on the right (or at the bottom, if viewed on mobile). And comments from Adobe there talk briefly about how to apply the fix. I also have a blog post on the topic of applying such “special hotfixes”:
https://coldfusion.adobe.com/2019/11/how-to-implement-a-special-cf-hotfix/
We can hope that an upcoming update 4 (and 14) will apply that and all other outstanding fixes to any bugs introduced in update 2 (and 12, and still others found and fixed since then). No word from Adobe on the timing of that. They never announce that in advance: could be this week, next week, or the next month.
I should add that I realize that tracker ticket doesn’t refer to the specific error you list, but there is another ticket that does. My understanding is that that jar offered in that other ticket (one each for CF2021 or 2018) does address both bug reports and still others related to query of queries bugs from the Sept updates.
Please do check it out (and my blog post) and let us know if things get resolved.
Could you please share the query-of-query that fails?
I believe we had the same issue and Adobe has a hotfix that will remedy the problem. We’re on CF 2018 but I believe both 2018 and 2021 have the same problem. The error we were getting was an ‘Index X out of bounds for length X’ error, however many others have posted having issues with QofQ. Email support@coldfusionsupport.zendesk.com
You must be logged in to post a comment.
23 Nov
10AM Pacific
Online
