THANKS!!!! There was a field that was set as unique!!! - this must have been set either in the demo, or when the table was moved to my system from a demo, either way I didn't realize that one field was even flagged as unique.
Unchecking the unique property resolved the issue. On Wed, 17 Aug 2016 18:51:33 +0200, Timothy Penner wrote: > Hi Chip, > > Starting with v13.5: > You need to make sure that all unique fields have an index. > > Please see the big red note at the top of the bug fix list for v13.5: > ftp://ftp.4d.com/ACI_PRODUCT_REFERENCE_LIBRARY/Bug_Fix_Lists/Version_13/v13.5/Fixed_bugs_4D_v13.5.pdf > > See also: > http://kb.4d.com/assetid=77065 > > -Tim > > > > > > -----Original Message----- > From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Chip > Scheide > Sent: Wednesday, August 17, 2016 9:13 AM > To: 4D iNug Technical > Subject: Re: v13 - Can not add record & Maintenance issues > > 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?? > ********************************************************************** > 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 **********************************************************************