March 29, 2022
queryofquery not working with coldfusion2021
Comments
(4)
March 29, 2022
queryofquery not working with coldfusion2021
(4)

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
4 Comments
2022-03-30 19:26:17
2022-03-30 19:26:17

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.

Like
(1)
(1)
>
Charlie Arehart
's comment
2022-03-30 19:42:07
2022-03-30 19:42:07
>
Charlie Arehart
's comment

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.

Like
2022-03-30 18:41:37
2022-03-30 18:41:37

Could you please share the query-of-query that fails?

Like
2022-03-30 12:36:25
2022-03-30 12:36:25

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

Like
Add Comment