Downloading Error Data from Diagnostics

You can download error data from automatic ETL diagnostics in a zip file. In this zip file, you see some system columns to describe the error number, error message, and automatic correction done by the ETL program.

To download error data:

  1. In the Tasks pane of Configuration Manager, select Manage Load Plans under Load Plans Administration.
    The Manage Load Plans page is displayed.
  2. In the Load Plans master list, select the load plan that has failed and whose report you want to download.
  3. Click Show Data Problems.
  4. In the list of tasks that encountered data problems and were corrected, the task name and the target table this task is inserting into or updating are noted. These are the rows were the Component column has a value of ETL. Select each of these rows and click Download.
  5. In your browser, download the zip file containing the report, then unzip the file on your system.

     Each line in the file is an entire row of data for the target table with all of the columns. Along with the columns of the target table, you see some system columns in the file to describe the error number, error message, other relevant information in understanding the problem with each row of data. and the automatic correction done by the ETL program.