Troubleshooting uploaded files

Edit online

As a system administrator, in IBM® Envizi ESG Suite you can do some basic checks to determine whether a file has failed to upload and why.

Viewing uploaded files

When an account or setup file is uploaded to the system, the files are available on the Files Processed - Accounts & Setup page. To access the page, from the main menu, click Manage > Files Processed - Accounts & Setup. By default, files that were loaded in the previous 24 hours are displayed on the page. You can select another time range, for example, Last 7 days.

In the Files Processed - Accounts & Setup page, check the file's status in the File Status column. If the status is Loaded, the file was processed and the data is loaded into the system. A file status value of Error or Loaded with errors indicates that some of the rows in a file were not loaded.

The Files Processed - Accounts & Setup page also provides visibility of the number of skipped rows, non-informational parse errors, load errors, and alerts.

For files that are loaded in the previous 48 hours, you can check the following details about file loading from the File Details section in the preview panel:
  • Total rows
  • Skipped rows
  • Load errors
  • Loaded rows
  • Result

For setup files, the Result field shows additional diagnostic information related to the configuration. For example, the Result field shows the number of new accounts that are created.

File loading process

When a file is loaded, each row in the file is scanned by a connector in Envizi ESG Suite, which determines whether the row can be loaded. The connector checks whether the row is an empty row, is a column header, is flagged to be skipped, or is in a row format that is not recognizable by the connector.

The connector tries to load only the rows that are identified as valid rows, that is, rows in, which correspond to Records In. During the loading process, if a row is flagged as having load errors, it is not loaded.

The total rows in a file are defined as:

Total rows = Rows with process errors + skipped rows + rows in + rows with load errors + loaded rows

Where:
  • Process errors include column headers, empty rows, and invalid rows
  • Rows in are Records In
  • Rows out are Records Out

Generally, if a file has two or more process errors, or it has any number of load errors, you must troubleshoot the file.

After you complete basic troubleshooting of the file, you have a good understanding of the file loading status. If you still have issues with the file, you can complete more comprehensive troubleshooting. For more information, see the topics in this section.