New case error

Technical problems with Medisoft.
Post Reply
EHCS
Posts: 122
Joined: Tue Oct 02, 2012 10:34 am

New case error

Post by EHCS » Mon Sep 17, 2018 3:59 pm

one of my practices all of a sudden can not create new cases. . I get error 7057 everytime I try and copy or create a case. then it creates a case without a # and won't let me delete it. It has assigned case #7 to both the cases it did create, it is like it is trying to assign case #7 to everthing and then cant so it errors out...the cases i have should be more like 2998 not 7.... IT was working fine on friday and now today it won't create cases. all of my other practices are creating cases just fine. Not sure why all of a sudden it is doing this. Any help would be appreciated.

EHCS
Posts: 122
Joined: Tue Oct 02, 2012 10:34 am

Re: New case error

Post by EHCS » Mon Sep 17, 2018 4:08 pm

just a quick note I just created a new patient and it create a new case just fine, but it assigned her case #7 so now i have 3 case #7 for different patients and if I try and create an additional case for the same patient under a different provider it errors out because it is trying to assign case 7 again.....

EHCS
Posts: 122
Joined: Tue Oct 02, 2012 10:34 am

Re: New case error

Post by EHCS » Mon Sep 17, 2018 5:14 pm

i just tried to copy a case and I got error 3111.....then it freezes

User avatar
Gavin Walker
Posts: 4625
Joined: Wed Apr 04, 2007 10:11 pm
Location: Springfield, MO
Contact:

Re: New case error

Post by Gavin Walker » Mon Sep 17, 2018 9:07 pm

Make sure you have a backup and then pack and rebuild all indexes in File Maintenance. Then make sure you have the latest service pack installed for your version of Medisoft. If you get any errors doing either of these, then you probably have data corruption of some sort. If you need our help performing a Medisoft data repair, then you can purchase that off our shopping cart here. If you have Medisoft v19 or older, then private message me for pricing.
Gavin Walker
Walker Tek Solutions, LLC
417-890-6777 x0
fax: 417-763-6386

EHCS
Posts: 122
Joined: Tue Oct 02, 2012 10:34 am

Re: New case error

Post by EHCS » Tue Sep 18, 2018 10:33 am

is it a good idea to pack and rebuild indexes periodically?? I wasn't sure what that did exactly so I have never done that with any of my practices.

User avatar
Gavin Walker
Posts: 4625
Joined: Wed Apr 04, 2007 10:11 pm
Location: Springfield, MO
Contact:

Re: New case error

Post by Gavin Walker » Tue Sep 18, 2018 11:16 am

I would do it along with recalculating all balances once per month before you send out patient statements.

User avatar
Gavin Walker
Posts: 4625
Joined: Wed Apr 04, 2007 10:11 pm
Location: Springfield, MO
Contact:

Re: New case error

Post by Gavin Walker » Wed Sep 19, 2018 1:33 pm

When we got your data there were a few key columns that should have been auto-increment data type but were integer instead. I have seen this caused by some data repair utilities such as MediUtils Copy Data Tables or it can even be done in ARC32. Otherwise, not sure how this could have happened. There were several cases with duplicate case numbers so we had to renumber about a dozen of them throughout the database. Note, since this happened in the Case table, it could have lurked for a while before it became obvious it was a problem.

Post Reply