Kbase P126443: Error 996 and crash during bulkload
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
Error during bulkload:
SYSTEM ERROR: Schema cache key, xref, or key field count incorrect. (996)
The bulkload utility crashes.
One of the tables in the database has a 0-component index.
0-component index is named Def-idx.
The same table also has other single- or multi-component indexes.
CAUSE:
This is a known issue.
A 0-component Def-idx index is an anomaly that comes from older versions of Progress (version 7, or even version 6).
The possible reasons why such an index can still appear in a Version 9 or Release 10 database are:
- the database was migrated to each later release by means of the conversion utilities (for example, proutil -C conv78, then proutil -C conv89); in this case, the conversion utilities do not detect, nor attempt to remove the anomalous 0-component index).
- the database was migrated to version 9 by means of a dump and reload; in this case, the Data Dictionary is not defensive enough to detect and reject the definition of a 0-component index that comes from the Data Definition file dumped from the older database.
FIX:
The 0-component index must be removed from the table definitions. Once this is accomplished, the bulkloader utility will work.