Analyzing the Data Transfer Log

When you perform either a Preliminary Data Transfer or a Final Data Transfer on the Import Data Transfer form, the Log tab contains the transfer status and details about the transfer, as well as messages that are generated during processing.

  1. Select View History to see details of previous transfers.
  2. Click the grid and then click the refresh button on the tool bar to display the most recent information.
  3. View the records for the selected sequences to check the transfer status and look for errors. If the status is Failed, select the sequence in the log to display the related error messages in the Error grid.

    The log includes this information:

    Task Number
    Number of the background task from the Background Task History form that was used to run the utility.
    Seq
    Sequence number from the Import Steps form.
    Source Table
    Table name in the source database.
    Target Table
    Table name in the target database.
    Status
    One of these values:
    • Not Started: The data transfer has not been performed for the current step.
    • In Progress: Data is transferring from the source to the target.
    • Failed: The data transfer failed.
    • Success: The data transfer succeeded.
    Percentage
    Percentage of records that were successfully migrated. This value is calculated as number of records transferred / number of records processed x 100.
    Transfer Type
    One of these values:
    • Preliminary indicates preliminary data transfer.
    • Final indicates final data transfer.
    User Name
    User who performed the utility transaction.
    Source
    Total number of records in the source table.
    Target
    Total number of records in the target table.
    Processed
    Number of records that were processed.
    Transferred
    Number of records that were successfully transferred into the target table.
    Error
    Number of records that encountered errors. The grid at the bottom of the form includes this information about the errors that occurred for a selected sequence in the Log:
    Line
    Line number in the grid.
    Source Column
    Column name in the source table where the error occurred.
    Target Column
    Column name in the target database where the error occurred..
    Error Message
    Message that indicates the transfer detail of the current table import transaction. During final data transfer, if you see the error message Data is invalid, refer to the Troubleshooting the Data Transfer topic in the list below.
  4. Select a row from the Error grid and click Table Column Rule Definition to open the Import Table Column Rule Definition form, filtered on the table for the selected error.
Related topics