NowMD Roundtable Home
Home Search search Menu menu Not logged in - Login | Register

Encounter Error
 Moderated by: Jeff Ward, Gary Tallman
 New Topic   Reply   Printer Friendly 
 Rate Topic 
AuthorPost
 Posted: Mon Oct 8th, 2018 06:59 pm
   PM  Quote  Reply 
1st Post
EMB
Verified
 

Joined: Tue Jul 25th, 2017
Location: USA
Posts: 15
Status: 
Offline

  back to top

I'm receiving the following information only on one database I have. It just started giving this error. When I try to delete the encounter, it says its in use by another user but I'm don't have multiple users. I have tried reinstalling with no luck.
DBISAM Engine Error #9729 Duplicate key found in the index "Primary" of the table "Encounteritems"



 Posted: Mon Oct 8th, 2018 07:39 pm
   PM  Quote  Reply 
2nd Post
Gary Tallman



Joined: Tue Jun 4th, 2013
Location:  
Posts: 42
Status: 
Offline

  back to top

A duplicate key error means that the data has been damaged and needs to be repaired.
Here is a short explanation of how to repair the database:
A power outage or other event can damage the Practice DATA set causing error messages.  While data damage is not the only cause for an error message, many error messages can be cleared by performing a data repair.

NOTE:  To avoid data error messages, our system requirements page states the following

Install an Uninterruptible Power Supply (also called a UPS or battery backup) for each computer, then connect computers, printers, displays and network equipment to the battery-protected outlets. A UPS protects against damage caused by power fluctuations and power failures.

To perform a data repair follow the steps below:
  1. Exit NowMD.
  2. From the server computer's Windows Start button, navigate to Start>All Programs>NowMD>Database Administrator.
  3. Once the Database Administrator Opens, choose the Data Maintenance tab.
  4. Choose the practice name data set.
  5. Choose the REPAIR DATA NOW button.
You will either see two scroll bars progressing as the data repairs or you will see an error message in the lower left corner of the Database Administrator screen.  The error message will read "Exclusive Access is Required".  This means that something (some process) is still accessing the database. 

NOTE:  Sometimes it's just as easy to restart the server computer and then follow the data repair steps.

Once the data repair has completed you will see a verification message in the lower left corner of the Database Administrator stating "Data was repaired if necessary."
Open NowMD and try the same task again that created the error message to confirm the problem is resolved.


Here is a link to error messages displayed by the database server:
Arsenal Database Error Message List



 Posted: Wed Oct 10th, 2018 12:22 pm
   PM  Quote  Reply 
3rd Post
EMB
Verified
 

Joined: Tue Jul 25th, 2017
Location: USA
Posts: 15
Status: 
Offline

  back to top

I don't have a Database Administrator tab. This is setup on a single computer only.



 Posted: Wed Oct 10th, 2018 02:54 pm
   PM  Quote  Reply 
4th Post
Gary Tallman



Joined: Tue Jun 4th, 2013
Location:  
Posts: 42
Status: 
Offline

  back to top

The database administrator is not a tab. It's a separate program on the computer.  You can also navigate to C:\Program Files (x86)\ADBServer and there you will find DBADMIN.  That is the short name for the database administrator.



 Posted: Wed Oct 10th, 2018 03:01 pm
   PM  Quote  Reply 
5th Post
EMB
Verified
 

Joined: Tue Jul 25th, 2017
Location: USA
Posts: 15
Status: 
Offline

  back to top

You are awesome! I'm so glad I invested in this software. I use it for over 13 providers and would be lost without it. So much better than an online system! Thank you so much for your help!



 Posted: Wed Oct 10th, 2018 03:04 pm
   PM  Quote  Reply 
6th Post
Gary Tallman



Joined: Tue Jun 4th, 2013
Location:  
Posts: 42
Status: 
Offline

  back to top

Thank you.  We work very hard to make the software easy to use.



 Current time is 12:15 am
Top




UltraBB 1.172 Copyright © 2007-2013 Data 1 Systems