Re: OMC Databases lost with windows update
Posted: 13 Oct 2017 10:27
Just more on this. The only fix Ive found so far is to un-install the windows update. For Win7 32 bit it is KB4041681 . See Different designations on other Operating systems.
Unfortunately this is a pretty big security update.
In win7 I un-installed the update and did a Hide in the updates before it reinstalled. My system is very up to date . I dont hold back updates an hence this problem hit me not long after it was released by MS.
I have tried changing the default DB folder (as suggested) using Options>Parameters but this did not help.
Ive uninstalled the MS update again for now and Hidden it. This could be a problem in Win10 going by the way they have changed the way updates are controlled on that OS. Every time I uninstall the update OMC works again fine.
I beleive the problem has something to do with the OBDC data sources as I see differences in the User DSN Tab on a working system and a non working system. The way the OMC programe starts asking for database.xls files instead of database.omc files is pretty suspicious. Also the way it ends up in a dialog window resembling closely the OBDC config windows found in the control panel is telling.
The first thing that happens prior to this is a error where OMC is unable to open a registry Key. I tend to think theres a fix for all this with a registry edit but Ive no idea where to start.
Sorry for the long post. Ive spent hours on this for 2 nights in a row now so if someone else can benefit or take this further then great.
Here are the error windows in the order in which they appear. Here is the info from the MS Update website. Interestingly I did install the KB4038803 update refered to here and had no issue with OMC.
Also note the reference to MS JETDatabase engine having changes.
KB4041681 Win7
Improvements and fixes
This security update includes improvements and fixes that were a part of update KB4038803 (released September 19, 2017) and resolves the following issues:
• Addressed issue with docking and undocking Internet Explorer windows.
• Addressed issue with form submissions in Internet Explorer.
• Addressed issue with URL encoding in Internet Explorer.
• Addressed issue that prevents an element from receiving focus in Internet Explorer.
• Addressed issue with the rendering of a graphics element in Internet Explorer.
• Addressed issue where USBHUB.SYS randomly causes memory corruption that results in random system crashes that are extremely difficult to diagnose.
• Security updates to Microsoft Windows Search Component, Windows kernel-mode drivers, Microsoft Graphics Component, Internet Explorer, Windows kernel, Windows Wireless Networking, Microsoft JET Database Engine, and the Windows SMB Server.
For more information about the resolved security vulnerabilities, please refer to the Security Update Guide.
Known issues in this update
Symptom Workaround
After installing KB4041681, package users may see an error dialog that indicates that an application exception has occurred when closing some applications. This can affect applications that use mshtml.dll to load web content. The failure only occurs when a process is already shutting down and will not impact application functionality.
Regards DTMFTONES
Unfortunately this is a pretty big security update.
In win7 I un-installed the update and did a Hide in the updates before it reinstalled. My system is very up to date . I dont hold back updates an hence this problem hit me not long after it was released by MS.
I have tried changing the default DB folder (as suggested) using Options>Parameters but this did not help.
Ive uninstalled the MS update again for now and Hidden it. This could be a problem in Win10 going by the way they have changed the way updates are controlled on that OS. Every time I uninstall the update OMC works again fine.
I beleive the problem has something to do with the OBDC data sources as I see differences in the User DSN Tab on a working system and a non working system. The way the OMC programe starts asking for database.xls files instead of database.omc files is pretty suspicious. Also the way it ends up in a dialog window resembling closely the OBDC config windows found in the control panel is telling.
The first thing that happens prior to this is a error where OMC is unable to open a registry Key. I tend to think theres a fix for all this with a registry edit but Ive no idea where to start.
Sorry for the long post. Ive spent hours on this for 2 nights in a row now so if someone else can benefit or take this further then great.
Here are the error windows in the order in which they appear. Here is the info from the MS Update website. Interestingly I did install the KB4038803 update refered to here and had no issue with OMC.
Also note the reference to MS JETDatabase engine having changes.
KB4041681 Win7
Improvements and fixes
This security update includes improvements and fixes that were a part of update KB4038803 (released September 19, 2017) and resolves the following issues:
• Addressed issue with docking and undocking Internet Explorer windows.
• Addressed issue with form submissions in Internet Explorer.
• Addressed issue with URL encoding in Internet Explorer.
• Addressed issue that prevents an element from receiving focus in Internet Explorer.
• Addressed issue with the rendering of a graphics element in Internet Explorer.
• Addressed issue where USBHUB.SYS randomly causes memory corruption that results in random system crashes that are extremely difficult to diagnose.
• Security updates to Microsoft Windows Search Component, Windows kernel-mode drivers, Microsoft Graphics Component, Internet Explorer, Windows kernel, Windows Wireless Networking, Microsoft JET Database Engine, and the Windows SMB Server.
For more information about the resolved security vulnerabilities, please refer to the Security Update Guide.
Known issues in this update
Symptom Workaround
After installing KB4041681, package users may see an error dialog that indicates that an application exception has occurred when closing some applications. This can affect applications that use mshtml.dll to load web content. The failure only occurs when a process is already shutting down and will not impact application functionality.
Regards DTMFTONES