Consultor Eletrônico

Status: Unverified

SYMPTOM(s):

Cannot add an index to the job-nr field on the table fieldhistory but no errors appear during the add.

Help -> Recent Messages from the Procedure Editor shows error 151.

** File <file> - Cannot apply dictionary changes to existing records. (151)

Table involved contains mandatory fields.

Attempting to dump and load the table into the schema only database using import .d function failed with errors 275 and 142.

** <Field-name> is mandatory, but has a value of ?. (275)

ERROR READING LINE #18 (Offset=1354):** request-dt is mandatory, but has a value of ?. (275)

** Unable to update <filename> Field. (142)

ERROR READING LINE #18 (Offset=1354:** Unable to update fieldhistory Field. (142)

FACT(s) (Environment):

Index add being performed by a character client.
No errors being reported to screen or database log file.
Error 151 occurs regardless if this is a unique or non-unique index.
Can add indexes to other tables in the database without receiving an error.
Can add an index to a schema only version of this database
Linux
OpenEdge 10.1B03 Service Pack

CAUSE:

One of the mandatory fields in this table contains unknown values. This is not allowed. When the index is in the process of being added, a failure occurs when the record that contains the mandatory field with the unknown values is encountered.

FIX:

1. If possible, change the field with the UNKNOWN values into a non-mandatory field or
2. Modify the records that have mandatory fields with an UNKNOWN value to contain some value other than UNKNOWN