UE when updating workstations

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

UE when updating workstations

Post by wjstarck » Wed Dec 09, 2015 8:52 am

I am getting the following unhandled exception when I update workstations. Seems it started around 15.4.6

Thanks,

+++++++++++++++++++++++++++++
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
Ionic.Zip.BadReadException: Could not read block - no data! (position 0x00000000)
at Ionic.Zip.SharedUtilities._ReadFourBytes(Stream s, String message)
at Ionic.Zip.ZipFile.ReadIntoInstance(ZipFile zf)
at Ionic.Zip.ZipFile.Read(Byte[] buffer, TextWriter statusMessageWriter, Encoding encoding)
at OpenDental.PrefL.CheckProgramVersion(Boolean isSilent)
at OpenDental.FormOpenDental.PrefsStartup(Boolean isSilentUpdate)
at OpenDental.FormOpenDental.FormOpenDental_Load(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.6.127.1 built by: NETFXREL3STAGE
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
OpenDental
Assembly Version: 15.4.6.0
Win32 Version: 15.4.6.0
CodeBase: file:///C:/Program%20Files%20(x86)/Open%20Dental/OpenDental.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.6.93.0 built by: NETFXREL2STAGE
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
CodeBase
Assembly Version: 15.4.1.0
Win32 Version: 15.4.1.0
CodeBase: file:///C:/Program%20Files%20(x86)/Open%20Dental/CodeBase.DLL
----------------------------------------
OpenDentBusiness
Assembly Version: 15.4.6.0
Win32 Version: 15.4.6.0
CodeBase: file:///C:/Program%20Files%20(x86)/Open%20Dental/OpenDentBusiness.DLL
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
NHunspell
Assembly Version: 0.9.6.0
Win32 Version: 0.9.6.0
CodeBase: file:///C:/Program%20Files%20(x86)/Open%20Dental/NHunspell.DLL
----------------------------------------
SparksToothChart
Assembly Version: 4.7.1.0
Win32 Version: 4.7.1.0
CodeBase: file:///C:/Program%20Files%20(x86)/Open%20Dental/SparksToothChart.DLL
----------------------------------------
Microsoft.DirectX.Direct3D
Assembly Version: 1.0.2902.0
Win32 Version: 9.05.132.0000
CodeBase: file:///C:/Program%20Files%20(x86)/Open%20Dental/Microsoft.DirectX.Direct3D.DLL
----------------------------------------
xImageDeviceManager
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/Open%20Dental/xImageDeviceManager.DLL
----------------------------------------
SigPlusNET
Assembly Version: 1.1.4050.24928
Win32 Version:
CodeBase: file:///C:/Program%20Files%20(x86)/Open%20Dental/SigPlusNET.DLL
----------------------------------------
msvcm90
Assembly Version: 9.0.30729.9158
Win32 Version: 9.00.30729.9158
CodeBase: file:///C:/WINDOWS/WinSxS/x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.9158_none_5091b51ebcb97cdc/msvcm90.dll
----------------------------------------
System.Web.Services
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Web.Services/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll
----------------------------------------
OpenDental.XmlSerializers
Assembly Version: 15.4.6.0
Win32 Version: 15.4.6.0
CodeBase: file:///C:/Program%20Files%20(x86)/Open%20Dental/OpenDental.XmlSerializers.DLL
----------------------------------------
AxInterop.AcroPDFLib
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/Open%20Dental/AxInterop.AcroPDFLib.DLL
----------------------------------------
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.6.127.1 built by: NETFXREL3STAGE
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
CDT
Assembly Version: 15.4.1.0
Win32 Version: 15.4.1.0
CodeBase: file:///C:/Program%20Files%20(x86)/Open%20Dental/CDT.DLL
----------------------------------------
MySql.Data
Assembly Version: 6.2.4.0
Win32 Version: 6.2.4.0
CodeBase: file:///C:/Program%20Files%20(x86)/Open%20Dental/MySql.Data.DLL
----------------------------------------
System.Transactions
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
Oracle.DataAccess
Assembly Version: 2.112.3.0
Win32 Version: 2.112.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/Open%20Dental/Oracle.DataAccess.DLL
----------------------------------------
System.EnterpriseServices
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
System.Numerics
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
----------------------------------------
System.Web
Assembly Version: 4.0.0.0
Win32 Version: 4.6.114.0 built by: NETFXREL3STAGE
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Web/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
Anesthesia15.4
Assembly Version: 15.4.5814.36645
Win32 Version: 15.4.5814.36645
CodeBase: file:///C:/Program%20Files%20(x86)/Open%20Dental/Anesthesia.dll
----------------------------------------
Ionic.Zip
Assembly Version: 1.9.1.4
Win32 Version: 1.9.1.4
CodeBase: file:///C:/Program%20Files%20(x86)/Open%20Dental/Ionic.Zip.DLL
----------------------------------------
System.ServiceProcess
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceProcess/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: UE when updating workstations

Post by jsalmon » Wed Dec 09, 2015 8:59 am

Strange, it's acting like you don't have the correct Update Files in the database or in your AtoZ share. I recommend doing a "Recopy" found in the Update Setup window from your server:
http://www.opendental.com/manual/update.html
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Re: UE when updating workstations

Post by wjstarck » Wed Dec 09, 2015 9:02 am

OK will try that with next OD update and let you know
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Re: UE when updating workstations

Post by wjstarck » Wed Dec 09, 2015 9:06 am

That's weird. When I go to the Server and click 'Recopy' in Updates > Setup I get the same error.
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: UE when updating workstations

Post by jsalmon » Wed Dec 09, 2015 9:21 am

I'll have someone look into this in more depth.
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

User avatar
dgraffeo
Posts: 147
Joined: Wed Sep 24, 2014 3:19 pm

Re: UE when updating workstations

Post by dgraffeo » Wed Dec 09, 2015 10:27 am

Was there any message attached to this error? I'm expecting something like: "Failed inserting update files into the database. Please call us or have your IT admin increase the max_allowed_packet to 40MB in the my.ini file."
"To understand what recursion is, you must first understand recursion."

David Graffeo
Open Dental Software
http://www.opendental.com

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Re: UE when updating workstations

Post by wjstarck » Wed Dec 09, 2015 10:38 am

Here's my.ini right now:

[mysqld]
basedir="C:/Program Files (x86)/MySQL/MySQL Server 5.5/"
datadir="C:/mysql/data/"
default-storage-engine=MyISAM
max_allowed_packet=40M

and here's the error log (this is after running DB mainenance tool):

151209 12:46:30 [Note] Plugin 'FEDERATED' is disabled.
151209 12:46:30 InnoDB: The InnoDB memory heap is disabled
151209 12:46:30 InnoDB: Mutexes and rw_locks use Windows interlocked functions
151209 12:46:30 InnoDB: Compressed tables use zlib 1.2.3
151209 12:46:30 InnoDB: Initializing buffer pool, size = 128.0M
151209 12:46:30 InnoDB: Completed initialization of buffer pool
151209 12:46:30 InnoDB: highest supported file format is Barracuda.
151209 12:46:30 InnoDB: Waiting for the background threads to start
151209 12:46:31 InnoDB: 1.1.8 started; log sequence number 1595675
151209 12:46:31 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
151209 12:46:31 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
151209 12:46:31 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
151209 12:46:31 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
151209 12:46:31 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
151209 12:46:31 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
151209 12:46:31 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
151209 12:46:31 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
151209 12:46:31 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
151209 12:46:31 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
151209 12:46:31 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
151209 12:46:31 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
151209 12:46:31 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
151209 12:46:31 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
151209 12:46:31 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
151209 12:46:31 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
151209 12:46:31 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
151209 12:46:31 [Note] Event Scheduler: Loaded 0 events
151209 12:46:31 [Note] C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.14' socket: '' port: 3306 MySQL Community Server (GPL)
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

User avatar
dgraffeo
Posts: 147
Joined: Wed Sep 24, 2014 3:19 pm

Re: UE when updating workstations

Post by dgraffeo » Wed Dec 09, 2015 10:58 am

After looking into it we discovered that if we attempt to get the UpdateFiles from the database which was introduced in version 15.4.6 and they weren't inserted for whatever reason (maybe you had cleaned out the directory prior or for some reason it's zipping the files of an empty directory?) this error will occur. We're going to improve our error reporting and how the recopy works so hopefully you can Recopy, then on updating lower version workstations to the more current version the error will no longer occur. If it does it'll at least tell you what the issue is instead of giving the UE.
"To understand what recursion is, you must first understand recursion."

David Graffeo
Open Dental Software
http://www.opendental.com

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Re: UE when updating workstations

Post by wjstarck » Wed Dec 09, 2015 11:02 am

OK thanks. Not a showstopper because I can always update manually if I have to. But thanks for checking into that for me. FYI the error messages are apparently a bug in MySQL https://bugs.mysql.com/bug.php?id=54467
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: UE when updating workstations

Post by jsalmon » Wed Dec 09, 2015 11:03 am

To get your office (workstations) on the correct version you will have to run the Setup.exe on each machine (or wait for our bug fix to get released which I don't recommend).
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

User avatar
dgraffeo
Posts: 147
Joined: Wed Sep 24, 2014 3:19 pm

Re: UE when updating workstations

Post by dgraffeo » Wed Dec 09, 2015 1:04 pm

This issue has been fixed and will be available in version 15.3.36 and later. We don't know how you have a blank entry in your database, but at least now it will allow you to Recopy which will hopefully solve it.
"To understand what recursion is, you must first understand recursion."

David Graffeo
Open Dental Software
http://www.opendental.com

Post Reply