Kbase P104178: Proutil -C MVSCH corrupts metaschema indexes
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/08/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0x
All Supported Operating Systems
SYMPTOM(s):
Error 1422 occurs when trying to modify database schema
Modifying or removing fields from a table
SYSTEM ERROR: Index _Fieldphyspos in _Field cannot been deleted (1422)
SYSTEM ERROR: Index in for recid could not be deleted. (1422)
CHANGE:
Proutil -C MVSCH was used on the database
CAUSE:
Bug# OE00115767
FIX:
Upgrade to 10.0B03 or later
or
Upgrade to 10.1A or later
Workaround for earlier releases:
Run IDXFIX for the two indexes that get damaged.
Copy the following lines to a flat ASCII file ("idxfix.in"):
"
3
some
_field
_fieldphyspos
_StorageObject
_Object-Id
!
y
y
y
all
y
"
Take note of he last blank line.
Then run:
Proutil <dbname> -C idxfix < idxfix.in
Alternatively a full IDXBUILD can be performed for the database, but that will take much longer to complete.