Kbase P38190: Loading Data that was dumped from an Enterprise Database to a Workgroup Database encounters error "
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/3/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 8.x
SYMPTOM(s):
Loading of data fails with error 210
SYSTEM ERROR: Attempt to read block <number> which does not exist. (210)
Database size is greater then 64gb in size
Database blocksize is 1k
CHANGE:
Data was dumped from a Database with an 8k blocksize and is being loaded into a Database with a 1k blocksize.
CAUSE:
A Progress 8.x Database with a 1k blocksize has a maximum size of 64GB. The variable blocksize feature is only available for single volume Workgroup Database.
FIX:
To workaround the problem create a Workgroup Database with an 8k blocksize. A Workgroup database can only have an 8k blocksize for a single volume database, thus the database must be created as a single volume with an 8k blocksize and then converted to multivolume.
1. Create a single volume database.
2. Run the following command to convert the database to an 8k blocksize:
Prostrct convert dbname
3. Use prostrct add command to add additional extents. The first extent will become fixed at it's current size.