Open Dental Forum

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>

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

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

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

I'll have someone look into this in more depth.

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."

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)

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.

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

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).

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.