Kbase P5874: Loading index's without fields results in error 996
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/17/2011 |
|
Status: Verified
SYMPTOM(s):
Loading index's without fields results in error 996
SYSTEM ERROR: Schema cache key, xref, or key field count incorrect. (996)
FACT(s) (Environment):
Progress 9.1x
All Supported Operating Systems
CAUSE:
Error (996) will usually result if you are trying to compile another logical file while the resulting object already exists.
Index properties window in Data Dictionary contains a row in the browse:
field name "", field type "character", Ascending/Descending "A".
When you load an index without any fields, Progress allows you to load such a schema definition (.df). It makes no logical sense to have an index without fields.
Progress Data Dictionary does not allow the creation of an index without field specification, so it shouldn't be allowed to load the df which attempts to create such an index.
CAUSE:
Bug# OE00080607
CAUSE:
While it doesn't make logical sense to load an index without any fields, the code was not checking for this.
FIX:
Upgrade to OpenEdge 10.0A where the code to load schema disallows non-component indexes unless they are the default index (in other words, there are no specific indexes defined on that table).
Do not load index's without fields.