Open Dental Forum

Unhandled exception when using letter merge.

Not trying to cirmcumvent proper channels. Talked with Debbie in Tech Support after work today. She got a copy of my database to have someone test the issue. Just thought I would see if anyone on the forum can look at the details below and see if they see any issues I might need to look at.

Just upgraded from 7.1.29 to 7.1.31 over the weekend. I have been using version 7.1.xx for a few weeks and I have been upgrading on a regular basis. No problems with letter merge until today. We use it daily to write our referral letters so I know it was working in 7.1.29. The only other thing that I did over the weekend that I can think may have some effect on Open Dental is I downloaded MySQL administrator and optimized all my database tables. It seemed to make Open Dental run much faster today.

Any Ideas?

Jeff


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

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at OpenDental.FormQuery.MakeReadable(DataTable tableIn, ReportSimpleGrid reportIn)
at OpenDental.FormLetterMerges.CreateDataFile(String fileName, LetterMerge letter)
at OpenDental.FormLetterMerges.butPreview_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at OpenDental.UI.Button.OnClick(EventArgs ea)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.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: 2.0.0.0
Win32 Version: 2.0.50727.3603 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
OpenDental
Assembly Version: 7.1.31.0
Win32 Version: 7.1.31.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/OpenDental.exe
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3614 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
CodeBase
Assembly Version: 7.1.0.0
Win32 Version: 7.1.0.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/CodeBase.DLL
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3082 (QFE.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
OpenDentBusiness
Assembly Version: 7.1.31.0
Win32 Version: 7.1.31.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/OpenDentBusiness.DLL
----------------------------------------
SparksToothChart
Assembly Version: 4.7.1.0
Win32 Version: 4.7.1.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/SparksToothChart.DLL
----------------------------------------
Microsoft.DirectX.Direct3D
Assembly Version: 1.0.2902.0
Win32 Version: 9.05.132.0000
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.DirectX.Direct3D/1.0.2902.0__31bf3856ad364e35/Microsoft.DirectX.Direct3D.dll
----------------------------------------
xImageDeviceManager
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/xImageDeviceManager.DLL
----------------------------------------
SigPlusNET
Assembly Version: 1.0.2245.36238
Win32 Version:
CodeBase: file:///C:/Program%20Files/Open%20Dental/SigPlusNET.DLL
----------------------------------------
AxInterop.AcroPDFLib
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/AxInterop.AcroPDFLib.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
MySql.Data
Assembly Version: 1.0.9.0
Win32 Version: 1.0.9.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/MySql.Data.DLL
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
CDT
Assembly Version: 7.1.1.0
Win32 Version: 7.1.1.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/CDT.DLL
----------------------------------------
Microsoft.DirectX
Assembly Version: 1.0.2902.0
Win32 Version: 5.04.00.2904
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.DirectX/1.0.2902.0__31bf3856ad364e35/Microsoft.DirectX.dll
----------------------------------------
Microsoft.DirectX.Direct3DX
Assembly Version: 1.0.2911.0
Win32 Version: 9.12.589.0000
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.DirectX.Direct3DX/1.0.2911.0__31bf3856ad364e35/Microsoft.DirectX.Direct3DX.dll
----------------------------------------
Microsoft.VisualC
Assembly Version: 8.0.0.0
Win32 Version: 8.00.50727.3053
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualC/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualC.dll
----------------------------------------
Interop.Word
Assembly Version: 8.2.0.0
Win32 Version: 8.2.0.0
CodeBase: file:///C:/Program%20Files/Open%20Dental/Interop.Word.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>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

Please post back when you have a solution!Thanks

I just heard back from technical support today. It appears Open Dental has a fix and it will be released in version 7.1.32

Thanks for the quick fix!

Jeff

Ive been playing around with the merge facilities and they are somewhat limited without running advanced queries.
Lets say i have 5000 patients in 2000 family units,and i wanted to write to each one of the head of the families so 2000 letters using a mail merge text can it be done and what query would i run? Previous softwares i used would write letters to the female of a family group if they were above a certain age or otherwise the oldest male or female so well thought out marketing, I guess this isnt possible?

One way of doing it would be to write a query that select patients based on these criteria you mention and save the data in a custom table (for example _mytable), always the same table that you will overwrite every time you run the query.

Before you can use it for the first time, you need to establish an ODBC link between your MySQL database and MS Word or OO Writer. Once the link is created, edit your letter template, include the fields from your custom table in your letter then use Word's or Writer's regular mail merge wizard. After the first time using it, you just need to 1) run the custom query and 2) run the mail merge wizard in your text editor and that's it.

We use this for printing our recall postcards as we write them in the mother tongue of our patient (french or english) and have a different template based on the age of the patient as well. In addition, using Word or OO Writer you can use your fancy letterhead, insert graphics and more.

As for building the custom query, I'm quite sure you can find several helpful examples in OD's query examples page.