Skip to main content
Known Participant
March 3, 2009
Question

Cached Queries Causing Null Pointer Errors

  • March 3, 2009
  • 1 reply
  • 427 views
I have a Windows 2003 server with CF 8.01 with the 8.01 cumulative hotfix installed. We've been running off the server in a production environment for several months without issue. Yesterday application we run annually went live for this year. This is the first time this particular application has run on CF8 in a production environment. After maybe an hour or so any CFQUERY that had the CACHEDWITHIN parameter set (even if it was set to 0) started generating null pointer exceptions. This wasn't restricted to just the new application. ALL pages running on our CF8 server that had cached queries were getting this error. I restarted the CF8 service, everything was fine for another hour or so, then the same thing happened again.

Some quick searching turned up kb402583 which speaks of corrupt table errors and was apparently patched. But taking this as a possibly related, I went and removed all the cachedwithin parameters from all CFQUERY tags in the new application that went live yesterday. I restarted the CF service and it's been running smooth since.

Does ColdFusion 8.01 still have a problem with cached queries? It would appear so. Is there a bug report or a kb article or something with more information on this? Has anyone else experienced this? Thanks.
    This topic has been closed for replies.

    1 reply

    Participant
    July 3, 2009

    I am having the same problem in CF 8 and I've applied the cummulative hot fix. I just set Maximum number of cached queries to zero to see if that solves the problem.