Page 1 of 2

OMC Databases lost with windows update

Posted: 12 Oct 2017 19:36
by dtmftones
I have systematiclly lost my customer databases under OMC after windows update. It appears to be due to update monthly rollup KB4041681 under Windows 7. One machine lost access to the databases and showed several errors on trying to open the databases. I had 2 versions of OMC (version 9 and version 10) on one machine and both versions of OMC suffered this problem after windows updates. So I installed a newer recent version of OMC 21 and it has the same issues. The database.omc file does not seem to be found but rather its looking for database.xls .
On an older backup laptop everything was working ok until it started to update windows . The machines are both Win7 and had the KB4041681 update in common. After un-installing the microsoft update on both machines I found that OMC seems to function ok again on all versions.
error1.jpg
Looking in the OBDC sources setup while the KB4041681 update was installed revealed that OMC was missing as a source.

I dont know if there is a work around for this and precisely what was broken but it has been a frustrating and scary time trying to work out what happened to OMC because it was not discovered until a few days after the update from microsoft.

Any comments or suggestions are appreciated.

Tony

Re: OMC Databases lost with windows update

Posted: 13 Oct 2017 04:30
by Julien_fr
Hello,

Same thing here.
I try many things (install other versions of odbc manager, other version of Excel... but no effects).


(Sorry for my bad english writing, i try to not use Google translate ;)

Re: OMC Databases lost with windows update

Posted: 13 Oct 2017 04:50
by alexeik
win 10 the same...

its seems KB4041676

Re: OMC Databases lost with windows update

Posted: 13 Oct 2017 04:55
by Maulwurf
Same here. We got an info from ALE.
Workaround:

Windows 10 Version 1511 for 32-bit and x64-based Systems, KB4041689
Windows 10 Version 1607 for 32-bit and x64-based Systems, KB4041691
Windows 10 Version 1703 for 32-bitand 64-bit Systems, KB4041676
Windows 10 for 32-bit and x64-based Systems, KB4042895
Windows 7 for x64-based Systems Service Pack 1, KB4041681
Windows 7 for x64-based Systems Service Pack 1, KB4041678

Re: OMC Databases lost with windows update

Posted: 13 Oct 2017 05:34
by alexeik
whats the workaround? deinstall??

Re: OMC Databases lost with windows update

Posted: 13 Oct 2017 06:53
by alex
dtmftones wrote: 12 Oct 2017 19:36
Any comments or suggestions are appreciated.
Hmm. Interesting. Never noticed it both with Windows 7 and Windows 10 Pro (x86).
Have you tried to change default DB folder to another drive/another folder in Options/Parameters? I always keep DBs on another drive - it's just more convenient for files archiving.

Re: OMC Databases lost with windows update

Posted: 13 Oct 2017 07:23
by alexeik
the updates were released yesterday... maybe you windows isn´t up to date?

Re: OMC Databases lost with windows update

Posted: 13 Oct 2017 07:26
by alexeik
deinstall worked, but win 10 will install it again immediately. I´m trying to manage manual update Installation with local group policies. maybe it will prevent the installation

Re: OMC Databases lost with windows update

Posted: 13 Oct 2017 07:56
by alex
Yes , shutdown was pending.
After restart of the PC OMC is broken.

Re: OMC Databases lost with windows update

Posted: 13 Oct 2017 08:10
by alexeik
colleague told me, that Alcatel is working on a new omc to solve this problem...