Dbisam Engine Error 9729 Duplicate Key Found In The Index
Moderated by: Jeff Ward, garyt New Topic Reply Printer Friendly Rating: Rate This Topic Excellent Good Fair Poor Horrible AuthorPost Posted: Tue Oct 11th, 2011 03:44 am PMQuoteReply 1st Post canthe Verified Joined:Sat Mar 21st, 2009 Location:Seattle, Washington USA Posts:40 Status: Offline back to top So tonight our hard drive got completely full (don't ask, it's an old PC), and all of a sudden we started getting random DB errors whenever trying to do something. I pretty quickly diagnosed the space issue, and cleared up a bunch of dead files. Then I attempted stopping and restarting the DB, then restarting the service itself. I can login now, but if I attempt to make an order I get this error: DBISAM Engine Error #9729 Duplicate key found in the index 'Primary' of table 'Order' I also tried running a verify data, and everything came out OK on the DB. I'm pretty sure I know what happened - the last transaction never closed, so now it's attempting to repeat a transaction ID that already exists. I'm assuming I either need to delete the old row or increment the new order in the table, but I have no idea how to do that. Any ideas, I'm fairly desperate at this point! Help! Posted: Tue Oct 11th, 2011 05:01 am PMQuoteReply 2nd Post canthe Verified Joined:Sat Mar 21st, 2009 Location:Seattle, Washington USA Posts:40 Status: Offline back to top OK, so a little bit more information. I found the dbsys utility and installed it. I then attempted to open the Order table and now I get the error: DBISAM Engine Error #8961 Header information corrupt in the table 'Order' So now I'm in a bit of a jam. I tried running Repair in the Utilities menu, except I get the same error. I noticed an option to "Force Index Rebuild", but I don't want to take that action yet without some help/guidance. I know it's late, but I don't want this problem to be waiting for me in the morning. Any ideas? Thanks! Posted: Tue Oct 11th, 2011 05:36 am PMQuoteReply 3rd Post canthe Verified Joined:Sat Mar 21st, 2009 Lo
Confluence Log in ACSSpace shortcutsHelp CentersPage tree Browse pagesConfigureSpace tools Attachments (0) Page History Page Information Resolved comments Link to this Page… View in Hierarchy View Source Export to PDF Export to HTML Export to Word Getting StartedSystem RequirementsSoftware License AgreementConfiguring Your Computer http://www.posroundtable.com/wowbb/view_topic.php?id=1928&forum_id=1 and Optimizing PerformanceInstalling ACSUninstalling ACSReinstalling ACSAnti-Virus Software and ACSInstalling Software Upgrades and Minor RevisionsGetting to Know ACSSetting Up the Backup UtilityResourcesLogging Into ACSVerifying Your ACS VersionFinding ACS, Windows Tools, Utilities, and Files in WindowsRelease NotesACS Backup and RestoreImplementing a Backup PlanInstalling http://wiki.acstechnologies.com/pages/viewpage.action?pageId=29699422 ACS Backup RestoreConfiguring ACS Backup RestoreCreating and Storing ACS BackupsRestoring a BackupUsers and Security ACS and Network Rights and PermissionsManaging ACS UsersWorking with Users and Security TemplatesWorking with the User LogViewing User Security SettingsSetting People Suite Security RightsSetting Financial Suite Security RightsPeople SuitePeopleContributionsCheckpointAttendanceOrganizationsSearchesLabelsMail ModulesReservationsConnectionsSpecial MailingsChurch Growth ToolsPeople Suite ToolsPeople Suite ImportsSync ACS Data with The CityFinancial SuiteGeneral LedgerAccounts PayablePurchase OrdersAccounts ReceivablePayrollFixed AssetsParochial ReportCheck Layout DesignReportsThe Reports WindowCustomizing ReportsManaging Report Page SetupSearching for Text in ReportsPreviewing ReportsSetting Report FontsCopying Reports as ImagesRefreshing ReportsRenaming ReportsSaving ReportsPrinting ReportsE-mailing and Exporting ReportsReport DesignerCustomizing the Reports WindowYear-End Guide2015 Changes to Year-End ProceduresAbout Year-End ProceduresPreparing for Year-EndAccounts Payable Year-End ProceduresPurchase Orders Year-End ProceduresAccounts Receivable Year-End ProceduresFixed Assets Year-End ProceduresContributions Year-End ProceduresPayroll Year-End ProceduresGeneral Ledger Year-End ProceduresGetting Ready for
This error indicates you have some minor http://www.resourcemate.com/support/help/resourcemate/DBISAMErrorMessages1.html corruption in your PhonePad data. This can be easily resolved by following these steps:Ask all users to log out of PhonePad (and PhonePad Admin). This step is dbisam engine vital. If users are still logged in to PhonePad the repair will fail.Run DBRepair.Click the Repair option.This may take a while if you have a lot of messages.Check the repair log. Important: If there dbisam engine error are any red crosses then someone still has PhonePad open and you will need to repeat the above steps.For more information on what can cause data corruption, please refer to this Frequently Asked Question: http://www.cybercom-software.com/phonepadfaqs.htm#data_corrupt Related Articles Data Corruption Repairing Your PhonePad Data Knowledge Base Software by: KnowledgeBase Manager Pro v6.2.2 (Built with: JS.GUI - AJAX Controls) JavaScript must be enabled in order for you to use Knowledgebase Manager Pro. However, it seems JavaScript is either disabled or not supported by your browser. To use Knowledgebase Manager Pro, enable JavaScript by changing your browser options, then try again. Learn more.
run RM Services. The following is a comprehensive list of DBISAM error messages that could appear. DBISAM is the database that ResourceMate data is stored in. 8705 Beginning of table '