J
James Palmer
Guest
OE 10.2B08, Windows As part of a dump and reload I was requested to add a unique index on a table. All well and good except unbeknown to me there are duplicate values in the index. So the rebuild index reported a large number of errors. It's a simple fix in theory because the unique field is now sequence bound. I thought I'd just parse the logfile and find the records that failed in the index rebuild using the recid reported, and update them to the next value of the sequence. Except I get the error SYSTEM ERROR: Index trx-no in af for recid 1544 could not be deleted. (1422) Is there an easy way I can get around this?
Continue reading...
Continue reading...