Kbase P7656: Bulkloader fails when dumping tables with RECID type fields
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/27/2010 |
|
Status: Verified
SYMPTOM(s):
Fields of type RECID contains no value after a conv910
A bulkload description file does not contain RECID field types in the .fd file
Dumping data silently ignores to dump recid fields.
** <file-name>.<field-name> is mandatory, but has unknown (?) value. (110)
Mandatory field(s) with initial unknown value not assigned in input. (1529)
Bulkloader fails
The table contains mandatory RECID fields
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
CAUSE:
The option to generate the Bulk Loader Description File of the Data Administration Tool will generate a .fd file with no RECID fields.
The bulkloader itself will load RECIDs, but the routine in the dictionary that creates the bulk load description files specifically excludes any RECID fields (see prodict/dumpbulk.p or prodict/dump/dumpbulk.p). This is because loading creates new records, and the new records will most likely not have the same RECIDs as they did before the dump.
While doing the bulkload using a .fd file which excludes the RECID
fields, you may get the errors (110) and/or (1529).
FIX:
If you define a database field with a data type of RECID, then the RECID values in that field are dumped and reloaded as unknown value (?). You must write your own dump and reload procedures to accommodate RECID fields.