I have: installed a stand alone copy of 4D v13 pulled a copy of the datafile from a backup. It had the same problem (orphaned blob) I ran repair, and compact - no issues (supposedly)
I restarted the server with the repaired & compacted data file run the code to create a new record, this is NOT the table (Department) with the orphaned blob, and am getting the same errors. 1248 - Connot save new record in table calendar of database 1247 - cannot update new record in table calendar of database 1088 - Index is invalid or missing I have removed all indexes, and all relations. What is going on?? On Wed, 17 Aug 2016 11:25:55 -0400, Chuck Miller wrote: > 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 >> <[email protected]> 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:[email protected] >> ********************************************************************** > > ********************************************************************** > 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:[email protected] > ********************************************************************** ********************************************************************** 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:[email protected] **********************************************************************
