The CDX was somehow corrupted and in the process of getting hosed the duplicate primary key value was inserted. Once that happened you were toast until it was repaired. This reeks of unpatched SMB2/3 or out of date SMB2/3 patches.
-- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Jeff Johnson Sent: Friday, March 20, 2015 1:18 PM To: [email protected] Subject: Internal Consistency Error I solved a particularly difficult Internal Consistency Error and wanted to share it with you all in case it will help someone in the future. When saving a new record in an application the error popped up and closed down VFP. I will skip over all of the things I tried to fix it like Stonefield because none of them worked. Step 1 was to validate database. It showed that one table could not be reindexed. I deleted the CDX and rebuilt it manually and when I went to save, it said that the primary key was violated and deleted the primary key index. I did a select on the primary key to see if there were any duplicates and the answer was yes. One record was repeated twice. I deleted the duplicates, packed the table, and created the primary key. That solved the problem. Unanswered questions, how did a record get repeated twice without throwing some sort of primary key violation? Once the records were repeated, VFP silently deleted the primary key index. The application wanted that primary key index to add a record and shut down when it didn't find it, displaying an Internal Consistency Error dialog. I hope this helps someone in the future. -- Jeff _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cy1pr10mb021843e16133e68246902465d2...@cy1pr10mb0218.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
