Does anyone else have to keep uninstalling and reinstalling Update 12 (CF2021) after Windows updates are applied?

You mean Windows update REMOVES a CF update? Very very weird. I have had problems with U12 though, still working w Adobe on that. Something bad happens to the MSSQL package, and all queries fail (we're all MSSQL). It says they timed out, but it happens immediately, and log shows it's actually a Java class loader error. I had a remote session with Adobe devs, captured a lot of logs it doesn't normally generate, sent them a bunch of stuff, but I haven't heard anything since then. It looked then like after the right jar loaded, something was causing an older version of an Adobe common jar to get loaded, but they weren't sure why at that time. I'm out for the next two weeks, so this is going to be stuck on my end until I'm back.

No - Windows Update seems to bork CF - and the only fix we have found is to uninstall and reinstall Update 12

@Sid Wing Nice to meet you! Adobe told me there were 4 customers with this problem, and thousands who don't have it, but they appeared to be taking it seriously. I don't wish anyone bad news, but I was "glad" to hear that it's not just us, which would have sucked even worse. I'm not in a position to recommend this as a "real" "solution", but I think you can revert just the MSSQL package to the prior version, 05 I think, and that'll fix it. No idea what crappy consequence that would have, but appeared to work on a basic level.

That's a thought - and yes - good to know that I am not alone

We use MSSQL but aren't having this issue. You mention a specific MSSQL package... what version are you using and is it actually called that?

That's what we are using as well

@hemi345 Interesting, that's the version that doesn't work for me, and I think for @Sid Wing.

Yeah - that's when it become "apparent"

FYI, I just reverted the MSSQL package to the 05 version on a server that was broken this way, and it appears to have fixed the problem. The server overall is at update 12, and no other packages say they have updates available. This is a dev server, doesn't get tons of use, and doesn't see anything like a comprehensive subset of all the scenarios the app supports, but it's face up so far.

@Dave Merrill yes, I've restarted the server a few times for MS patches since then.

All (MSSQL, that's all we have) queries throw an error. Verifying the datasource in admin says it timed out, but a) it says that immediately (not a timeout), and b) the logs show it's a Java class loader error. All app queries fail too. I ran into this thread, also relevant: https://community.adobe.com/t5/coldfusion-discussions/cf21u12-sql-dsn-stopped-working-[…]connection-verification-failed-for-data-source/m-p/14312403

Did you get this MSSQL package from Adobe? I don't see that as an option. But we're also running Standard edition, so maybe that's why.

Just an FYI - That threads answer did NOT work for us... Still have to keep uninstalling and reinstalling CFU12 after every reboot of a CF2021 server

@Sid Wing Ugh. Just to be clear, I rolled back the MSSQL package myself in the package manager, you don't need anything from Adobe. Not in that system right now, but my memory is that you can click on individual packages to see info about them, including a dropdown of the available versions. I chose the 05 version, restarted CF and that worked. If that doesn't work for you, it'd be good for us all if you'd share your situation with them, as another different data point. I'd suggest reaching out to @priyank_adobe here. He's who I started dealing with, and he can connect you with deeper devs if that's necessary. FWIW, he hasn't been responding to me since my last remote session with the developers. Disappointing, but I'm actually on vacation anyway, so.

Yeah rolling back to 05 SQL didn't work for us either

A long shot, but you might verify that DNS is configured correctly on all machines involved. I had a wierd issue a few years ago where our SQL server would appear down to a handful of systems (our Nagios montior and web servers) but I could connect from my desktop just fine using mng studio. We found one of the DNS server IPs was mistyped or no longer valid (I can't remember).

@hemi345 - DNS was the first thing we triple checked

"well there's yer problem". Oh that other type of cluster. gotcha.

@Sid Wing How did you make out with this? Rolling back to the 05 version of the MSSQL package is still not working for you? Did you talk to Adobe about it, specifically @priyank_adobe? I'm back from vacation, and my company would like me to actually fix this, not just work on it 🙂

Hi Dave

Priyank - I have the same issue as well

@priyank_adobe Is there any way to know in advance whether the version 05 rollback strategy will work? I don't want to apply U12 in production, have all queries break, then discover that the fix what worked in dev for us doesn't work there.