I'm still gathering info/details, but it appears ColdFusion update 12 (or 11?) may have introduced a regression. After applying the update we are getting "Element GENERATEDKEY is undefined in QRYRESULT" errors. This is ColdFusion 2021 on Windows with MSSQL. Known issue? Anyone else hit this?

That sounds different than the other bugs I've seen mentioned in here, but the context of Windows and MSSQL having issues with update 12 has been a common theme that I've seen in other posts.

Thanks. If you can point me to other posts I'd like to check those out as well.

If you do a search in this channel for MSSQL you should be able to find the threads pretty quickly

Yeah. @Sid Wing and I are the only people I know of who have spoken up as having run into issues with U12 messing up SQL Server queries, and that issue IS different. What we've seen is that applying U12 causes all SQL Server queries to fail. The msg says it timed out, but it comes back immediately, before any possible timeout, and the logs show a low level java error. Adobe has a set of steps to fix that problem, which Sid and I (and maybe others I'm not aware of) are testing; initial results look good. Your problem seems very different, and is one I haven't seen. Have you verified that it's actually due to a cf 2021 change in CF's behavior, not a problem in your code? For instance, I'm not certain that query.generatedKy is populated for all types of queries (select, insert, update, delete, stored proc...). If you're pretty sure that it's a 2018 bug please bring it to the attention of @Mark Takata (Adobe) and @priyank_adobe, with as specific and repeatable steps to repro it as possible.

Yeah, 99% sure this is a bug. This code has been running fine for years. We will create steps to repro.

Hi Phil, once you get a reproducible code samples, email me at takata@adobe.com and I’ll get it to the right folks to figure out what’s up

Re this:

If you're pretty sure that it's a 2018 bug

Should read

If you're pretty sure that it's a 2021 bug

Which anyone who cares probably already figured out...

I also had to rollback CF 2021 U12 due to MSSQL issues as well.

@Rodney What issue(s) were you seeing?

CF couldn't find the MSSQL driver after applying the update.

Weird. You just applied U12, then got that error? Did you tell @Mark Takata (Adobe) and @priyank_adobe about it? If not you should

I got the instructions over to Rodney regarding the DSN/MSSQL thing. I have engineering looking to see if the other issue is related to the "wrong driver loaded" issue as well.

@Mark Takata (Adobe) , you should have receive code/steps to repro for the “GENERATEDKEY” error from @Marc Funaro

Hi Phil, I reviewed it and sent it to engineering & support to check whether it is a new issue or related to the "wrong driver". Marc should be getting an email soon hopefully, possibly asking for some logs to check.

@Mark Takata (Adobe) Thanks! Please have engineering & support copy me on those emails.

Sure thing Phil, I just emailed them and requested that. You were listed as a CC on the originals I sent over.

@Mark Takata (Adobe) Any update? (@Marc Funaro and I have yet to hear from engineering & support.)

Hey, sorry Phil, I dropped the ball here. Engineering feels this is a different, unique issue. Would you mind sending the original + additional email directly to cfsup@adobe.com so we can get a unique bug into JIRA and try to figure out a solution potentially.