Kbase P139982: Loading data in a database via the data dictionary fails with error 275 and error 142
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/16/2010 |
|
Status: Unverified
SYMPTOM(s):
Loading data in a database via the data dictionary fails with error 275 and error 142
** <Field-name> is mandatory, but has a value of ?. (275)
** Unable to update <filename> Field. (142)
One of the fields in the table is a mandatory date field that has some unknown values
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B03 Service Pack
OpenEdge Category: Language (4GL/ABL)
CAUSE:
The table that is being dumped and loaded via the dictionary has some mandatory fields. One of the mandatory fields has records that did not contain a NULL value. Instead these records had an UNKNOWN value.
FIX:
If possible, change the field with the UNKNOWN values into a non-mandatory field or fix the data so that these fields contain some value instead of an UNKNOWN value.