Kbase P128617: Adding fields to table via SQL corrupts metaschema
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/29/2008 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1A
OpenEdge 10.1B
SYMPTOM(s):
Adding fields to table using SQL (ALTER TABLE ADD COLUMN)
Table has had columns dropped
Dumping .df file with r-code positions included shows duplicate POSITION entries for fields within the same table
ABL clients accessing table report various errors indicating database corruption
CAUSE:
Bug# OE00126449
FIX:
Upgrade to 10.1B01 or later release
This fixes the bug and stops the issue from (re)occurring.
To recover from the damage done, dump and load the table definitions without the r-code positions.
(Data will need to be reloaded as well)