Kbase P163367: 4GL/ABL: Errors (132) and (151) Applying an incremental delta.df to a table using the Data Administ
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/7/2010 |
|
Status: Unverified
SYMPTOM(s):
4GL/ABL: Errors (132) and (151) Applying an incremental delta.df to a table using the Data Administration Tool.
** <file-name> already exists with <field/value...>. (132)
** File <file> - Cannot apply dictionary changes to existing records. (151)
** fs-funds already exists with New Sort "". (132)
** File fs-funds - Cannot apply dictionary changes to existing records. (151)
The delta.df file adds a new CHARACTER field to an existing table and defines a unique index using that field.
The new field has an initial value of "", the empty string.
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
OpenEdge Category: Language (4GL/ABL)
CAUSE:
When the new field is added, it is initialized for all the records that are already in the table with the default initial value of "" (i.e. the empty string). This means that its value is not unique for the records that have been created in the table before the creation of the new field. Hence error 132. Error 151 is a consequence of the failure to create the unique index against the field that already has non unique values in the table.
FIX:
Set the INITIAL value of the new field in the delta.df file to unknown. Alternatively, add the field, populate the field in all the existing records with unique values and then define the unique index using that field.