Kbase P107161: System Error 647 when accessing the database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/12/2008 |
|
Status: Verified
SYMPTOM(s):
System Error 647 when accessing the database
bkset: Extent <file-name> is below size <file-size>. (647)
SRV 0: bkset: Extent /DLC/dbname.dn is below size -2147483648. (647)
physical extent size is 2,147,483,647 bytes on disk
prostrct add fails
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
CAUSE:
The database manager has detected a size mismatch between the current extent size and its anticipated size defined when a variable extent needed extending beyond the 2GB filesize limitation.
FIX:
STEPS:
A.) If the database can still be truncated/accessed:
1.) prostrct create a new multi-volume database from a new structure file, based on the database which is inaccessible making sure that the extent sizes:
- are all accurately sized,
- properly reflect the physical location
- are divisible by 32
- are no larger than 2GB - (16 * db-blocksize)
- the physical extent sizes tally with the disk sizes
- the blocksize is the same as the database blocksize against which the probkup was created
- extra extents are added for future growth
and then
2.) procopy the database into the new structure.
B.) If the database can no longer be accessed:
1.1) We strongly recommend restoring a previous backup, to a structure with added extents in Storage Areas needing future growth.
1.2) Otherwise, refer to your OS utilities help pages on truncating files (removing bytes) from the errant extent to the expected size and then repairing the control area. The data integrity is then in question and should be resolved before further updates are allowed.