Status: Verified
SYMPTOM(s):
Cannot dump the database via the dictionary due to 450 and 3191 errors.
Receives 450 and 3191 errors when extracting data from the database
SYSTEM ERROR: Cannot read field <field-num> from record, not enough fields. (450)
SYSTEM ERROR: Failed to extract field <field-num> from <file-name> record (table <table-num>) with recid <RECID>. (3191)
SYSTEM ERROR: Failed to extract field from file -1 with recid 2250. (3191)
File -1 is the metaschema file _File.
RECIDS and fields from error 450 and 3191 are not always consistent
Cannot access the database due to BI corruption.
Forced (-F) into database multiple times.
Attempts to fix corruption via DBRPR were unsuccessful
FACT(s) (Environment):
A good backup does not exist
Progress 7.3E
All Supported Operating Systems
CAUSE:
Database corruption due to forcing into the database multiple times
FIX:
To resolve the issue, the database will need to be dumped outside of the dictionary. This can be done via a binary dump and load. As this is version 7.3, the only binary dump and load function available is DBRPR, Database Repair tool. DBRPR is an option to the proutil command.
Syntax: proutil dbname -C DBRPR
Steps for doing a binary dump and load via DBRPR utility:
1. Access the database in single user mode.
Syntax: pro dbname
2. Access the data dictionary and dump the Data Definitions for the database.
Dict -> Admin -> Dump data and definitions -> Data Definitions -> Select all the tables.
Press F1 to get to next screen which prompts for output filename. (Default filename is dbname.df)
Press F1 to complete download.
3. Exit the single user session.
4. Truncate the BI file..
Syntax: proutil dbname -C truncate bi
5. Access DBRPR Main Menu.
Syntax: proutil dbname -C DBRPR
6. From Main Menu, select option 1 for Scan Menu
7. Select option 6 to Dump data to an RM file.
8. Take defaults for all prompts except for: Delete place holders - answer no
9. Specify name of the file that data will be dumped into.
10. Exit the database.
11. Create a new empty database.
Syntax: prodb newdbname empty
12. Access database in single user mode.
Syntax: pro dbname
13. Access Dictionary and load the data.
Dict -> Admin -> Load Data and Definitions -> Data Definitions file -> Enter name of the .df file created in step 2.
14. Press F1 to perform the load.
15. Exit this database.
16. Truncate the BI file.
Syntax: proutil dbname -C truncate bi
17. Go into the DBRPR, Database Repair Tool.
Syntax: proutil dbname -C DBRPR
18. On Main Menu, select 7 to load RM Dump file. Take defaults for all questions. Delete place holders: no
19. Enter name of file created in step 9.
20. Once the data has been loaded, the indexes need to be rebuilt.
Syntax: proutil dbname -C idxbuild all
Use the -B and -TB and -TM parameters with this command to increase speed of idxbuild process.