1. Determine where the ai file-copy failed, then roll forward with the "
roll foward retry" option.
Assuming this ai file still available at it's original location:
- Compare the filezsizes and use checksum or similar to verify
For example, from a Windows Powershell console, compare the resulting SHA256 HASH output at both locations
C:\ powershell "Get-FileHash <full directory path>\<aifile> - If these don't match,
- Review the file transfer methods. Somewhere in the transfer of this ai file from it's origin to the current location, it's become corrupt/truncated. Once the complete ai file is available, use "rfutil -C roll forward retry".
- If these do match:
- There's likely a hardware or memory problem on this roll-forward machine. Unless this can be resolved, migrate to a new server and run the roll forward operations from there.
- If they do match because there was no file transfer between the archived copy and the roll forward, but the roll forward is from a mapped drive, it's likely the ai file was unable to be read for the duration of the roll forward or the size of the ai file is restricted by quotas. Once corrected at the OS levels, use "rfutil -C roll forward retry"
- The file transfer method itself can introduce corruption. For this reason, compressing (gzip, tar) the ai files to transfer is recommended.
2. If the AI Archiver (AIMGT) is not used to manage ai files, but RFUTIL scripts instead:
Before this AI file was marked EMPTY (rfutil -C aimage empty), the OS copy either:
- Copied the ai file before it was FULL, or
- Failed to copy the complete FULL ai file
Since the ai file was incomplete at source, the best option is to use a later PROBKUP of this database, or to take a new one, and roll forward from there.
Otherwise, if the source (Crashed) database is still available, but inaccessible, another option would be to force in with "
proutil -C truncate bi -F" then do a full ASCII (not binary) dump and load. Once loaded, you'd need to run application specific back-end reports to ensure logical application integrity (for example, orphan parent, child records like order numbers and order lines, or workflow like deliveries without invoices)
