Kbase P123872: Prostrct reorder ai fails if AI extents are all FULL/LOCKED and busy extent is full
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/4/2009 |
|
Status: Verified
SYMPTOM(s):
Prostrct reorder ai fails if AI extents are all FULL/LOCKED and busy extent is full
SYSTEM ERROR: Found invalid AI extent state 1, area num <num>. (12196)
FACT(s) (Environment):
prostrct reorder ai <dbname>
OpenEdge 10.1B
All Supported Operating Systems
OpenEdge Database Category: Maintenance
CAUSE:
Bug# OE00149698
FIX:
Upgrade to 10.1B03 or later
Workarounds:
1. If any AI areas are marked as FULL, empty those areas and retry the prostrct reorder ai command.
If OpenEdge Replication is enabled and all extents are LOCKED, there is currently no way to re-order the AI areas. You will need to backup & restore the database:
1. Backup the database using probkup with the -norecover option and then restore the database into a new structure.
probkup <dbname> <dbname.bkup> -norecover
2. Restore the source database from a previous backup and roll-forward AI files, delete the recovery files, enable after imaging and replication and re-create the target database.