Kbase P121856: 8897 binary loading data into a table that was dropped and re-added
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/01/2010 |
|
Status: Unverified
SYMPTOM(s):
8897 binary loading data into a table that was dropped and re-added
SYSTEM ERROR: Unable to extend database within area invhead. (8897)
The table is the only one in the area
More than enough extents to handle the data being loaded
CAUSE:
Appears Progress is not re-using blocks after dropping or deleting the table. Steps to reproduce using a .df an binary dump from the sports2000 customer table.
1) Edit the sports2000.st file and remove the variable length extent entry for Cust_data (sports2000_9.d2). Shrink the size of the .d1 file to 260 from 360.
2) Prostrct create sports2000
3) procopy $DLC/empty sports2000
4) Connect to the database in single user mode via the Data Dictionary/Admin tool and load the customer.df file. Exit the Dictionary/Admin tool
5) run "proutil sports2000 -C load customer.bd"
6) Connect to the database in single user mode via the Data Dictionary and delete the table. Commit changes.
7) Re-add the customer.df file and exit the Data Dictionary/Admin tool
8) run "proutil sports2000 -C load customer.bd". The 8897 error should appear.
CAUSE:
Bug# OE00136228
FIX:
No fix at this time.
To get workaround this problem:
1) proutil dbname -C truncate bi
2) proutil dbname -C truncate area "areaname"
3) proutil dbname -C load tablename.bd