Send Ins Claim bug. v 17.4.34

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
User avatar
drtech
Posts: 1647
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO
Contact:

Send Ins Claim bug. v 17.4.34

Post by drtech » Tue Feb 27, 2018 2:02 pm

We have three "claims" to go out in the send claim window with a date of 01/01/0001 that cause the error below if we try to send them. These have been here since v 16.x something. We need to figure out how to remove them. DBM does not remove them. We recreated new claims and it has already been paid, but these "phantoms" remain in the send claim window but do NOT show in the Pt account. Thanks.

______________________________________________________________________________________________________
Unhandled exception from ProgramEntry: Object reference not set to an instance of an object.
System.NullReferenceException
at OpenDentBusiness.X837_4010.Validate(Clearinghouse clearinghouseClin, ClaimSendQueueItem queueItem) in C:\SVN\beta\OpenDentBusiness\X12\X837_4010.cs:line 1816
at OpenDentBusiness.Eclaims.Eclaims.GetMissingData(Clearinghouse clearinghouseClin, ClaimSendQueueItem queueItem) in C:\SVN\beta\OpenDentBusiness\Eclaims\Eclaims.cs:line 222
at OpenDental.FormClaimsSend.ValidateClaims(List`1 listClaimSendQueueItems) in C:\SVN\beta\OpenDental\Forms\FormClaimsSend.cs:line 1105
at OpenDental.FormClaimsSend.RefreshAndValidateSelections() in C:\SVN\beta\OpenDental\Forms\FormClaimsSend.cs:line 892
at OpenDental.FormClaimsSend.SendEclaimsToClearinghouse(Int64 hqClearinghouseNum) in C:\SVN\beta\OpenDental\Forms\FormClaimsSend.cs:line 994
at OpenDental.FormClaimsSend.ToolBarMain_ButtonClick(Object sender, ODToolBarButtonClickEventArgs e) in C:\SVN\beta\OpenDental\Forms\FormClaimsSend.cs:line 731
at OpenDental.UI.ODToolBar.OnButtonClicked(ODToolBarButton myButton) in C:\SVN\beta\OpenDental\UI\ODToolBar.cs:line 278
at OpenDental.UI.ODToolBar.OnMouseUp(MouseEventArgs e) in C:\SVN\beta\OpenDental\UI\ODToolBar.cs:line 258
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.UserControl.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)
______________________________________________________________________________________________________
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: Send Ins Claim bug. v 17.4.34

Post by cmcgehee » Tue Feb 27, 2018 4:05 pm

Based on that error message, it looks like these claims are pointing to subscribers that do not exist in the patient table. Something like this generally looks like data corruption.
Chris McGehee
Open Dental Software
http://www.opendental.com

User avatar
drtech
Posts: 1647
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO
Contact:

Re: Send Ins Claim bug. v 17.4.34

Post by drtech » Mon Mar 05, 2018 7:53 am

So, what is the best way to remove them? These have been there for many months with no other continuing problems, I believe it was from when we were using an early beta of 17.2.x or so last fall.
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: Send Ins Claim bug. v 17.4.34

Post by cmcgehee » Mon Mar 05, 2018 8:08 am

It's hard to say generally how to fix a problem like this. I would have to get connected and run a few queries to get an idea how it should be fixed.
Chris McGehee
Open Dental Software
http://www.opendental.com

Post Reply