Account data compilation status has errors

Edit online

When you load account data, account statistics are generated after the file is loaded. Generating statistics is a separate process from file loading. Check the File Processed - Accounts & Setup Compilation Status column to view the status of statistics processing.

Problem

When an account file loads successfully, the compilation states are similar to the following values:
  • n/a, which means the file is still being physically loaded
  • 0%; Estimated to start in 5 minute(s)
  • 65%
  • 100%
If an error occurs during the compilation stage, the compilation states are similar to the following values:
  • n/a, which means the file is still being physically loaded
  • 0%; Estimated to start in 5 minute(s)
  • 65%; 53 Success, 1 Fail
  • 100%: 87 Success 1 Fail
Note: The compilation status enables you to check whether recently loaded data is available for reporting. Therefore, the compilation status is only retained for 72 hours and then it changes to n/a.

Cause

Statistics generation occurs after file loading. If other files that require compilation are ahead of the current file, an estimated compilation start time is provided for the file. The estimation is based on the assumption that one account typically requires one second of time to compile statistics for the data.

Although errors during the statistics compilation state are rare, they might occur when data is corrupted.

Solution

Check the compilation status and address issues:
  1. On the Files Processed - Accounts & Setup page, review the Compilation Status values and any error messages in the preview panel.
  2. If the status shows an estimated start time, wait for compilation to complete.
  3. If errors occur, correct the underlying data and reload the file.