Looks like you should try too export all records/ truncate table and then re-import. How big is the data. If not too big you might try exporting all and re-importing into an empty data file
Regards Chuck ------------------------------------------------------------------------------------------------ Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmiller<AT SIGN>informed-solutions.com Brookline, MA 02446 USA Registered 4D Developer Providers of 4D and Sybase connectivity http://www.informed-solutions.com ------------------------------------------------------------------------------------------------ > On Aug 17, 2016, at 9:52 AM, Chip Scheide <4d_o...@pghrepository.org> wrote: > > since this is development - it is not so much a problem as I can > replace the data file, however, I would like to understand what is > going on. > all of this is: > C/S v13.5 OS X 10.6.8 on client side, OS X 10.9.? server side. > > I attempted to add a record to a table, this is the first record in the > table (in other words the table is empty) > Create record([table]) > > set some values in the record, and save it. > Upon saving, I get an error (not exact message) > The record can be saved bad index. > > I go into the structure editor, remove the indexes on the table. > I then add them back. > try again to add a record - no joy, same error. > > I remove all the indexes completely. > I try adding a new record - STILL no joy. > *same* error - even though there is no longer an index on the table. > > Run maintenance, from client, 'verify' fails showing an orphaned blob > in a different table from the one I am having trouble with. > Go to server, run maintenance, 'Compact', it starts hits the table with > the orphaned blob - and crashes! > > Any ideas what is going on? > > Thanks! > Chip > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************