Deprecated: Array and string offset access syntax with curly braces is deprecated in /homepages/12/d802028692/htdocs/forum/Sources/Subs.php on line 3863
What do I do if I get DBISAM Engine Error code 9217 or 9218 ?

Author Topic: What do I do if I get DBISAM Engine Error code 9217 or 9218 ?  (Read 5995 times)

Rick Leffler

  • Administrator
  • Sr. Member
  • *****
  • Posts: 263
    • Approved Workman
This post only applies to the Legacy database!

Error code 9217 is a READ error and indicates that the database engine was unable to read a table (file) because the file is corrupted. Error code 9218 is a WRITE error, also indicating there is table corruption.

Solution:

First try to resolve the problem by going to Admin > Database Utilities and running the REPAIR utility.  If you can't get to the Admin > Database Utilities tab, exit and restart AWdb. From the log in screen, click the Utilities button and select the drop down menu item to run the REPAIR utility immediately after logging in.

If this does not work, you will need to restore your last backup; so hopefully you do run AWdb's built-in backup utility each week. It only takes about 30 seconds to do a backup!

Note: Table corruption is most frequently caused when a USB drive is disconnected from the computer without having first properly shut it down.  Always exit AWdb first, then use the "Safely remove hardware..." action by clicking the USB icon in your Windows system tray and selecting the drive letter you want to remove. Wait until Windows gives you a message that it is safe to remove the device before you actually remove it.

Another common cause of table corruption is when your computer shuts down unexpectedly due to a power outage.
« Last Edit: March 24, 2022, 10:56:39 AM by Annette »
Rick at Leffler Systems
Murfreesboro, Tennessee