Skip to main content
brahms_x01
Known Participant
September 12, 2018
Question

CF 11 Update 15 - CF ODBC server no more starts

  • September 12, 2018
  • 10 replies
  • 10844 views

After installing the latest update hotfix 15 (see ColdFusion 11 Update 15 ) on our coldfusion 11 server (Win 2008 R2 with latest patches and latest java jdk) the CF server restarts (access to CF admin is working) but the CF ODBC service does no more start. After un-installing the update it works again. Any idea how to fix this? Is this a known issue?

This topic has been closed for replies.

10 replies

March 19, 2019

Why is this STILL an issue in Update 18?!?!?

February 13, 2019

FYI this issue happens with the new CF11 HF16 update again.  I had to copy msvcr71.dll back over again from another backup.  The HF16 installer does not backup this file before removing it so it will not be in the hf-11-00016 folder.  So you will need to back it up before updating, get it from another backup, or get it from another server not updated yet.

Inspiring
February 13, 2019

This is also happening on CF 2016 Update 8, FYI.

(I've had other issues installing CF2016 Update 8 as well. Going through CF Admin looks like it works, but ALL data sources ended up broken.  Doing it manually as a member of the administrators group via CMD throws an error about not having write permissions or the ability to start/stop services.  I've verified I explicitly have the proper permissions, of course. And I've tried a regular CMD prompt and an elevated one. The only thing that go it to work was running it via the local administrator account directly, which is against our normal practice.)

Participant
February 28, 2019

This is also happening for ColdFusion11 update 17.  Copying the file ' msvcr71.dll '  into location mentioned above resolved issue. This is with Windows 2012 R2 Server.

Restarted Server and ColdFusion ODBC service restarted too.

ColdFusion installer hashfile same as above - see Brentil

Had none of the above issue in Windows 10, btw

September 21, 2018

We're having the same issue on two different servers.  Both Windows 2008 R2 running CF11 HF14 updated to HF15.  I followed the same process I've always followed.  Stopped all services, used a copy of the installer downloaded from the Adobe Support page, java -jar installer.jar, and installed into our CF folder.  Afterwards the ColdFusion 11 ODBC Server service fails to start.  The log output of what was going on was absolutely useless.  Nothing in the normal cfusion\logs about the service failing and also nothing in the cfusion\db\slserver54\logging folder either.  The Windows Event Logs about this were also useless stating it exceeded the 30000 millisecond start time when it fails immediately.

A timeout was reached (30000 milliseconds) while waiting for the ColdFusion 11 ODBC Server service to connect.

The ColdFusion 11 ODBC Server service failed to start due to the following error:

The service did not respond to the start or control request in a timely fashion.

I had tried running it from the command line and found the same MSVCR71.dll is missing error as well and was coming here to post about it but luckily found this thread.  I also used a merge/compare tool against this folder and the backup and I see several other exe/dll files were updated the only file removed was the MSVCR71.dll but there's a new vcruntime140.dll in the folder too.  So I fired up Process Monitor and watched that folder and that does expose the calls to MSVCR71.dll failing.  I copied the DLL back over from a backup and as others have found it now starts.  However during the startup sequence nothing at all calls vcruntime140.dll though.  Maybe something else was compiled against it in this folder but it clearly wasn't swsoc.exe.  This feels like a "it worked on my development machine, ship it" issue and it wasn't tested on other platforms.

I also just did a SHA1 hash against what I had downloaded them versus downloading the update again right now and they're identical.

Charlie Arehart
Community Expert
Community Expert
September 21, 2018

Brentil, thanks for your confirmation of things.

BTW, the discussion of the checksums was more about the CF11 installer (not the updates being applied), in case there may be a difference to explain who does and does not have the problems that some are seeing, even on Windows Server editions.

And FWIW, I offered the MD5 hash rather than a SHA-1 hash simply because on some Adobe pages, that's what they have used, such as Adobe - ColdFusion Support Center : More Downloads . But those are not for CF installers, per se, but "related installers". Again, Adobe no longer offers the CF11 or 2016 installers publicly. I'm also not aware of any public listing that remains with the checksums of the various CF installers that have existed.

Again, I shared the md5 hash of the CF11 Windows 64-bit installer I used (and how to obtain that hash), just so others with the problem could do the same, as we might find that people with the problem used some particular installer (of the variants that existed over the years). I discuss this more in a follow-up blog post I did yesterday based on all this:

https://www.carehart.org/blog/client/index.cfm/2018/9/20/how_to_get_checksum_on_windows 

/Charlie (troubleshooter, carehart. org)
September 21, 2018

If you have PowerShell v4 or newer you can also use this method to get MD5 hashes.  I ran it against the installer I had from when we had installed CF11 years ago.  I also ran the SHA1 of it to compare against what brahms_x01 had done above and our hashes match theirs for that version.

Get-FileHash -Algorithm MD5 .\ColdFusion_11_WWEJ_win64_20150721.exe

Algorithm       Hash                                                                   Path

---------       ----                                                                   ----

MD5             5187DB89496BE4CD97B4503E31D6487E

Get-FileHash .\ColdFusion_11_WWEJ_win64_20150721.exe

Algorithm       Hash                                                                   Path

---------       ----                                                                   ----

SHA1            B76771D30DF094EEF5E16AE17B8621FF8D65DB92

I was running the SHA1 against the jar file because that's the default Get-FileHash does unless specified and as validation I didn't have a corrupt patch I had previously downloaded.

Charlie Arehart
Community Expert
Community Expert
September 18, 2018

**UPDATE **

Agh, after I posted this comment and my next, I realized that this thread has been talking about CF11, not CF2018. So sorry. I will try to check out the same and report similar details about an attempt with CF11. So sorry for the confusion.

Let me share a few things, to help the OP and others having this problem with CF2018 update 1.

First, FWIW, I just applied the update (on a test machine where I had the ODBC services running), and it worked. The ODBC service could be restarted both before and after the update. So this is not a universal problem affecting those using CF2018 and the ODBC services.

Second, to perhaps help those having problems, I confirmed first that my update worked with no errors (per the update log in the HF-updates, as discussed in my blog post referred to above).

Then, since eccentricDBA​ has discussed his observations about CF11 and the msvcr*.dll file, I will share in another reply here what I see about that in my CF2018 setup, after the update, in case it may help anyone.

But I wanted to state first (above) that the update DID work and did not cause failure of the ODBC services for me. (FWIW, I am on Windows 10.)

More about those msvcr*.dll files in a moment.

/Charlie (troubleshooter, carehart. org)
Charlie Arehart
Community Expert
Community Expert
September 18, 2018

OK, so extending my last comment, and about the msvcr*.dll files, here is what I can report on my machine (where CF2018 update 1 worked and the ODBC services have no problem starting). Perhaps this will help those for whom it is NOT starting. (But again, be sure to check first that there are NO errors in your hf-updates update log, as discussed in my aforementioned blog post.)


1) So first, I can report that on my working machine, there is a msvcr120.dll in the \coldfusion2018\cfusion\bin and \coldfusion2018\jre\bin (and one the cfusion\jetty\jre\bin, but I think it has nothing to do with this discussion, per se).

I can confirm also that the 120 version of the file was "created" when I installed CF2018 in July, so it's not new as of this update.

2) Next, I see that as part of the update, the update log shows that as part of the backup process, a msvcr80.dll was copied from D:\ColdFusion2018\cfusion\db\slserver54\bin to the update's backup folder:

D:\ColdFusion2018\cfusion\hf-updates\hf-2018-00001-311402\backup\db\slserver54\bin\msvcr80.dll (and also to the backup\slserver54\admin folder)

And then that file was DELETED from the D:\ColdFusion2018\cfusion\db\slserver54\bin  (and \admin) folder.

2a) I ALSO see that it says a msvcr71.dll was DELETED as well from the D:\ColdFusion2018\cfusion\db\lserver54\bin folder, though no backup was made to the backup folder, which is interesting. (Ah, I see now that in the OTHER log in hf-updates, hotfix_filelist.log, it does NOT mention that the file was deleted. I guess the other log was saying that the update would TRY to delete it if it was there. But it did say "deleted".)

(I wanted to attach here the two logs from my hf-updates folder for update 1, in case those who have it failing could compare theirs to mine. I am not seeing how to attach files--and have never needed to before, I guess. Any one know if it's possible?)

3) I can confirm as well that there is now NO msvcr*.dll file of any name left in that D:\ColdFusion2018\cfusion\db\slserver54\bin (or \admin) folder.  But again there IS still that 120 version of the file now in the cfusion\bin and jre\bin above.

4) I see also in the log that it mentions implementing a new file of a similar name (vcruntime140.dll) also in the D:\ColdFusion2018\cfusion\db\slserver54\bin and \admin folders. I can see that that file DID already exist in my CF2018 \cfusion\bin and \jre\bin folders (among other places).

So I hope that breakdown may help someone, who is finding things "not working".

I wonder if those having troubles might find that they somehow do NOT have that 120 version in the cfusion\bin or jre\bin folders. (If not, perhaps that was a problem during the install--or perhaps there were slightly different installer versions that led to slightly different results. That has happened before. I sure hope that's not the case this time. Then we have to know "which" version of the installer people ran.)


Hope we get to the bottom of things.

PS When it comes to searching for files by name, you can certainly rely on the Windows search (pokey) or your favorite editor's "find files" feature, but I strongly recommend that those on Windows (which this thread is about) consider the great free tool Ultrasearch. It can search find files by name across your entire drive in seconds (and of course it can be told to look starting in just a given folder). And if you're ever looking for files by CONTENT, I recommend instead File Locator Lite. (Yes, I know there are many others which fans could recommend. See my CF411.com/filefind category to see if I already have yours listed, for people to consider.)

/Charlie (troubleshooter, carehart. org)
Community Expert
February 15, 2019

Dear Dave,

we are working mostly with MariaDB but also have some MS access databases in use due to customer restrictions. We have bought the license of a product supporting ODBC connections. Now it is no more working, but I do not assume that we will get our money back...

Manuela


I would look for the native JDBC-JET driver that's around somewhere. It used to be included in earlier versions of CF, and I suspect it's still around somewhere. Also, you might look at the msvcr71.dll mention above - that might fix your problem directly.

I'm not saying that this isn't Adobe's fault, of course, but I am saying you might be able to find a workaround before they provide a solution.

Dave Watts, Eidolon LLC

Dave Watts, Eidolon LLC
eccentricDBA
Inspiring
September 18, 2018

Having the same issue with the update running on windows server 2012 r2.  When I run the executable defined in the service (E:\ColdFusion11\cfusion\db\slserver54\bin\swstrtr.exe "ColdFusion 11 ODBC Server" ) I get an error with the title swsoc.exe - System Error and body "The program can't start because MSVCR71.dll is missing from your computer.  Try reinstall the program to fix this problem."

Community Expert
September 18, 2018

That DLL is part of the Microsoft Visual C++ Runtime. You can download this runtime, install it, and try again.

Dave Watts, Fig Leaf Software

Dave Watts, Eidolon LLC
eccentricDBA
Inspiring
September 18, 2018

I'm showing that MSVCR71.dll is part of the Visual C++ .NET 2003 runtime?  Is this an error on adobe's part linking the wrong dll?  I'm showing 2005 - 2017 installed on my server and In the ColdFusion11\cfusion\bin directory I see mfc100.dll and msvcr100.dll.  I verified my test system is configured the same way but has update 14 instead of update 15 and runs correctly. When I run the command from the cmd prompt.

Sandip_halder
Community Manager
Community Manager
September 13, 2018

brahms_x01.. Do you see any errors in ColdFusion-error.log? Also, can you start ColdFusion from the command prompt and check if you see any error related to ODBC?

brahms_x01
Known Participant
September 13, 2018

The Coldfusion-error.log has the following suspicious entries during the update:

INFORMATION: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.

and

SQLException while attempting to connect: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused..

As main database server we are using MariaDB. Also some MS Access datasources are in use (I know that MS Access is not the optimal solution but there is still a need for it).

Sandip_halder
Community Manager
Community Manager
September 13, 2018

Did you get a chance to start ColdFusion service from command prompt and see if there are any ODBC entries?

Charlie Arehart
Community Expert
Community Expert
September 13, 2018

brahms_x01 can you let us know if my first reply to you helped or not?

/Charlie (troubleshooter, carehart. org)
Inspiring
September 13, 2018

I went through the upgrade process once again, this time making sure to stop all CF services on the server.  i also paid close attention to make sure there were no errors shown during the upgrade process.  At the end, the ODBC Server service will not start.  Does anyone have any suggestions?

Inspiring
September 12, 2018

I have encountered the same issue.  I am running on Windows 2012 R2.

After I applied the update the service would not start and I could not find any useful error messages.  The application returns a service unavailable message.  Luckily I applied this update on a test server, as we usually do with newly released updates.

Community Expert
September 12, 2018

With previous versions at least, there are installers for the ODBC services right in the CF directory. I don't have CF in front of me today, but you can generally uninstall and/or reinstall these services (ODBC Server, ODBC Agent) from a command line with admin permissions.

That said, you should try to avoid using ODBC if possible.

Dave Watts, Fig Leaf Software

Dave Watts, Eidolon LLC
Charlie Arehart
Community Expert
Community Expert
September 12, 2018

I would bet the problem is  not some issue with the update but with a problem on your end in the implementation of the update.

I suspect that somehow the 2 cf odbc services did not stop. But it could be other things.

Try running the update again, but first stopping those (and the cf add-on service, if you see it).

I have more on this here:

How to solve common problems with applying ColdFusion updates (in 10 and above) - Charlie Arehart's ColdFusion Troublesh…

/Charlie (troubleshooter, carehart. org)
brahms_x01
Known Participant
September 13, 2018

Dear Charlie,

thank you for your answer. All services have been stopped and restarted except the ODBC service did not start again.

There were no errors in the update logfile, it says

Installation: Successful.

1271 Successes

0 Warnings

0 NonFatalErrors

0 FatalErrors

Action Notes:

None

I will give the installation another try the next days and stop the Add-On service and the ODBC service before the installation as recommended.