Engine Error 9729 Duplicate
Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com
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 http://www.elevatesoft.com/forums?action=view&category=dbisam&id=dbisam_general&page=30&msg=61370 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 http://www.posroundtable.com/wowbb/view_topic.php?id=1928&forum_id=1 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
given permission to view it. Knowledgebase (47)ABM ABM 2009 SP2 Info ABM a Transactional System (148)Downloads ABM SB 100 Creating Email Messages ABM SB 101 Report http://advancedbusinessmanager.helpserve.com/index.php?/Knowledgebase/Article/View/69 List Groups (5)BM BM Compatibility with Windows 7 BM Transaction Types ABM Service SB 21 Purchase Order reserve for Service Call ABM Service SB 21 Purchase Order reserve for Service Call ABM Service SB 22 Adding Tag Custom Field to Job Card ABM Service SB 22 Adding Tag Custom Field to Job Card ABM Service SB 23 Adding engine error Delivery Address to Job Card ABM Service SB 23 Adding Delivery Address to Job Card ABM Service SB 24 How to re-open a closed call ABM Service SB 24 How to re-open a closed call ABM Service SB 25 SMS Set up Clickatell ABM Service SB 25 SMS Set up Clickatell ABM Service SB 26 Service Confirm Time engine error 9729 ABM Service SB 26 Service Confirm Time ABM Service SB 27 Service Uninstall TroubleShooting ABM Service SB 27 Service Uninstall TroubleShooting SB 30 ABM Service Quotes SB 30 ABM Service Quotes SB28 ABM Service Clear User Settings SB28 ABM Service Clear User Settings SB29 ABM Service has stopped working SB29 ABM Service has stopped working Most popular articles ABM Compatibility with Windows 7 ABM a Transactional System ABM Support Bulletin Link ABM Dealer Downloads Link Page ABM Quick Sale Pos Resume Sale file Error received: "Unexpected incident Account Dataset. Cannot perf... Error Received when Loggin In: "The ABMControl Database will not ... ABM 2009 SP2 Info Newest articles SB 30 ABM Service Quotes SB29 ABM Service has stopped working SB28 ABM Service Clear User Settings ABM Service SB 27 Service Uninstall TroubleShooting ABM Service SB 26 Service Confirm Time ABM Service SB 25 SMS Set up Clickatell ABM Service SB 24 How to re-open a closed call ABM Service SB 23 Adding Delivery Address to Job Card Help Desk Software by Kayako