Method 1: Enable Large FilesIf an
Enterprise Database License is in use and the FileSystem support largefiles, enable the largefiles feature (available since Progress 9.1D) on the database then restart it. Refer to Article
Method 2: Empty or Add more AI ExtentsIf the variable AI Extent is within 32-bytes of 2GB Stat, a few notes need to be written in the current AI extent when it is switched:
- Ensure that all FULL extents have been emptied with RFUTIL -C aimage empty
- Add more AI Extents with PROSTRCT add
Unless the variable extent that has reached the 2GB limit is the last extent in the sequence, after emptying and or adding AI files, they will need to be re-ordered. Refer to Article
Method 3: Fix the AI extents then Re-enable After-Imaging
- Backup all database files with OS utilties.
- Copy any of the other empty or smaller ai extent to replace the ai extent reported in the 4524 message.
- Fix the inconsistencies in the file structure with "prostrct unlock <dbname>"
- Disable AI: "rfutil <dbname> -C aimage end"
- Remove all AI extents after and including the extent that had the problem: "prostrct remove <dbname> -a"
- Add the AI extents back again: "prostrct add <dbname> addai.st"
- Backup the database
- Restart AI: "rfutil <dbname> -C aimage begin"
- Restart the database