Loading Dimension Build and Data Load Error Logs

If the dimension build or data load fails, you must determine whether the Isolation Level transaction setting is Committed or Uncommitted. If the transaction setting is Committed, you must restart the data load from the beginning. If it is Uncommitted, you can load only the records that failed by loading the error log. Reloading only the failed records is much faster than reloading every record.

  To reload the error log:

  1. If you load from the server, change the file extension from .err to .txt. For example, change the dataload.err file to dataload.txt.

    If you load from the client, you can leave the .err extension.

  2. Fix the problem that caused the dimension build or data load to fail. Fixing the problem might involve changing the outline, the text in the error log, or the rules file.

    Check whether the following conditions are true:

  3. Load the error log using the appropriate rules file.

    See Understanding Data Loading and Dimension Building.