Dbisam Engine Error 9729 Duplicate Key Found
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 Location:Seattle, Washington USA Posts:40 Status: Offline back to top Sigh. Problem solved. I went and ran the repair database utility instead of the verify, and it found the corrupted records and fixed them. I don't understand why the verify option showed everything as correct, but the repair found problems? That seems broken/like a bug to me. Anyway, all done.Thanks. Posted: Tue Oct 11th, 2011 03:19 pm PMQuoteReply 4th Post garyt Administrator Joined:Fri Aug 6th, 2010 Location:Mesa, Arizona USA Posts:1593 Status: Offline back to top Please navigate to C:\Point of SuccessBackupPOSDATA. There you will see several backup files ending in
This error indicates you have some minor 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 http://www.posroundtable.com/wowbb/view_topic.php?id=1928&forum_id=1 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 https://www.cybercom-software.com/knowledgebase/article/AA-00206/0/DBISAM-Engine-Error-9729-Duplicate-key-found-in.html 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.
Confluence Log in ACSSpace shortcutsHelp CentersPage tree Browse pagesConfigureSpace tools Attachments http://wiki.acstechnologies.com/pages/viewpage.action?pageId=29699422 (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 http://support.biblioscape.com/node/1906 Getting StartedSystem RequirementsSoftware License AgreementConfiguring Your Computer and Optimizing PerformanceInstalling ACSUninstalling ACSReinstalling ACSAnti-Virus Software and ACSInstalling Software Upgrades and Minor RevisionsGetting to Know ACSSetting Up dbisam engine the Backup UtilityResourcesLogging Into ACSVerifying Your ACS VersionFinding ACS, Windows Tools, Utilities, and Files in WindowsRelease NotesACS Backup and RestoreImplementing a Backup PlanInstalling 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 dbisam engine error 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 the New YearHelp for Scanners and PrintersSpeedCheckScanning and Posting Checks Using the MICRImage Check ReaderUtility ManagerACS UtilitiesSystem SnapshotSystem UtilitiesBack to Help Centers Pages … ACS Troubleshooting People Troubleshooting "DBISam engine error 9729 duplicate key found in the index 'byParentIDName'" displays when updating small groups Skip to end of metadata Created by Tammy Toney, last modif
table 'link_rec'". It doesn´t seem to me that it's related to a specific module or operation. If a reference is open, usually the fields go blank (even thoug I don't loose the information). When I try to move anywhere or close the panel, I receive the box "Cannot create file". Ultimately, it leaves me no choice but to shut it down using the windows task manager. I've already tried several times the "rebuild database" way (which you advice several weeks ago), but it has never found any file corrupted. I thought it had to do with using the trial version, but today I activated the upgrade, and had the same problem. I'll appreciate your advise. Thanks, Andrés. ‹ errors upon closing Serious problem with categories entry › 8.x Support Login or register to post comments Fri, 02/05/2010 - 15:32 — Ecks I am having the same trouble When I try to create links between references, sometimes it will let me, and sometimes it will flash this error up when: a) I attempt to add more links after the first one b) I try to close or save the reference window. There are no corruptions in the database, and I have a full install of 8.04 Login or register to post comments Sun, 02/07/2010 - 20:41 — Paul Chen Can you also zip all the Can you also zip all the files under your database folder and email me the zip? Please let me know the exact steps to reproduce this bug using your database. Thanks, Paul Login or register to post comments Sun, 08/09/2009 - 11:33 — Paul Chen Andres, Can you zip all the Andres, Can you zip all the files under your database folder and email me the zip (support@biblioscape.com)? So I can reproduce the problem. Thanks, Paul Login or register to post comments Mon, 08/10/2009 - 08:18 — abaytelman With attachments? Hi Paul, thanks for you help. Should I include the attachments too? Because the zip file is over 100MG. Login or register to post comments Thu, 08/13/2009 - 17:26 — Paul Chen There is no need to include There is no need to include the attachment folder. Login or register to post comments User login Username: * Password: * Create new accountRequest new password Navigation Recent posts