English

Error: Update ID Missing

Solution or Workaround

Summary

Running IDEDIT produces the following error message:

Update ID Missing.

This requires BUILD or CLEAN be run first in order for the cover.PAT and cover.LAB to agree on the number of records, but that will scramble the coverage.

Cause

Data corruption.

Solution

Let's look at an example with a problematic coverage called PROBLEM. Let's also assume you have calculated the PROBLEM_ID to be a unique value in TABLES, and that the IDEDIT has failed.

[ARC] 	ADDXY PROBLEM
[ARC] &SYS
> CD PROBLEM
> COPY PAT.DBF XXX.DBF
> EXIT
[ARC] PULLITEM XXX YYY
: PROBLEM_ID
: X_COORD
: Y_COORD
: <return>
: Y
: Y
[ARC] CD ..
[ARC] TABLES
: SELECT PROBLEM.YYY
: DUMP PNT1.TXT DELIMITTED
: QUIT
[ARC] &SYS
> EDIT PNT2.TXT
END
[Then do a File | Save and then a File | Exit]
> COPY PNT*.TXT PNTFILE.TXT
> EXIT
[ARC] UNGEN LINE PROBLEM LINEFILE.TXT
[ARC] GENERATE NEWCOV
: INPUT LINEFILE.TXT
: LINES
: INPUT PNTFILE.TXT
: POINTS
: QUIT
[ARC] BUILD NEWCOV
[ARC] ADDITEM PROBLEM.XXX PROBLEM.XXX NEWCOV_ID 11 11 N 0
[ARC] TABLES
: SELECT PROBLEM.XXX
: CALCULATE NEWCOV_ID = PROBLEM_ID
: QUIT
[ARC] JOINITEM NEWCOV.PAT PROBLEM.XXX NEWCOV.PAT NEWCOV_ID NEWCOV_ID

The above procedure does not guarantee the coverage will be fixed. This is only meant as a last alternative before going to previous versions of the Master coverage. It may still be necessary you fix Missing Labels and Polygons with more that one Label. The above procedure is only meant to fix the problem of scrambling data caused by Duplicate cover_ID values in the cover.PAT.

Related Information