Viewing and monitoring import jobs

You can see the progress of an import job.

To view an import job

Select Data Migration > Migration Jobs,
Select the migration job.

On the Import tab, click View.

The following summary details are displayed for the selected import job:

Option	Description
Job Name	The name of the import job.
To Environment	The BMC Helix ITSM system to which the data will be imported.
Status	The status of the job. Possible values are: Draft—The job is being created. Submitted—The job has been submitted for the BMC Helix Data Manager Runtime to start running it. In Progress—The job is currently being run. Complete—The job is complete. Cancelled—The job has been cancelled. Paused—The job has been paused.
Result	The result of the completion of the job. Possible values are: None—The job is not yet complete Success—The overall result was successful, however there may be some errors which occurred during the processing of the job. Failure—The job encountered a critical failure and was unable to complete successfully
Created Date	The date and time when the migration job was created.
Execution Start	The date and time when the BMC Helix Data Manager Runtime started the export job.
Execution End	The date and time when the BMC Helix Data Manager Runtime completed the export job.

To view the settings configured for the import job including the identifier prefixing configuration, click the Parameters sub-tab.
To submit the Job to the BMC Helix Data Manager Runtime for processing, click Start.
To view the progress of an import job, click View.
The View Import Job page appears.

The Summary tab

The Summary tab on the View Import Job is divided into four sections:

Job summary (top left)
Checklist (top right)
History (bottom left)
Progress tracker (bottom right)

Job summary

The job summary section shows the core details for the import job.

Field	Description
System	The name of the BMC Helix ITSM system from which data will be imported.
Environment	The name of the environment of the BMC Helix ITSM system from which data will be imported.
Status	The status of the job, the following values may be shown: Draft—The job is being created Submitted—The job has been submitted for the BMC Helix Data Manager Runtime to start it. In Progress—The job is currently running. Complete—The job is complete. Cancelled—The job has been cancelled. Paused—The job has been paused.
Result	The result of the completed job, the following values may be shown: None—The Job is not yet complete Success—The overall result was successful; however, there may be some errors that occurred during the processing of the job. Failure—The job encountered a critical failure and could not complete successfully.
Updated	The date and time when the current view was last updated. This timestamp is automatically updated when the view is refreshed by the Refresh button or by the Auto-refresh option.

The summary section also shows the Action menu that allows you to trigger process-sensitive actions for the Import Job or to display the Migration Job.

History

The history section shows a list of all actions that were performed for the import job.

The list shows a summary description and the timestamp of when the action occurred.

Checklist

The checklist section shows a list of the high-level actions and their statuses. The checklist will show the following activities for an Import Job:

Checklist	Action
Validate Import Request	Validation that all required information has been submitted and that the import job can be processed successfully.
Remedy System Connectivity	Checks that the BMC Helix Data Manager Runtime can connect to the BMC Helix ITSM system database.
Remedy System Connectivity	Prepares the database for the port of data. This process may diﬀer depending on the underlying BMC Helix ITSM system database type.
Import Data	Import of the data from the data package.
Clean Up	Cleanup of any temporary tables or files that BMC Helix Data Manager created during the import process.

Progress tracker

The progress tracker graphically illustrates the progress of the staging and importing phases. The inner circle shows progress as a % of total forms or tables, and the outer circle shows progress as a % of total records.

Successful forms or tables appear in lime green, failed forms or tables appear in red, and warnings appear in orange.

If some forms or tables failed, the outer circle may not reach 100%.

The Forms tab and the Tables tab

The Forms tab and Tables tab show all forms or tables in the scope of the import as a migration tree. This tree is updated during the processing of the import to display the latest progress.

The icons on this tab are:

	Queued for processing.
	Import failed.
	Data successfully imported.
	The node was successfully processed. There were no data records, but entry lists were imported for an incremental export.
	The form or table is currently processing.
	No data was found, or the parent had no data.
	There was a noncritical failure processing this node.

You can select any form or table in the tree to view the following details:

Field	Description
Status	The current status for this form or table.
Imported	The number of records that were imported into the form or table. For a successful import, this number will match the Exported record count.
Entry List	The list of records that were found for this form or table on the source system. The entry list is exported only during a delta data migration.
Deleted	The number of records that are marked for deletion. Record deletion occurs only during a delta data migration.
Start Time	The time that the data import for this form or table started.
End Time	The time that the data import for this form or table was completed.
Duration	The total time taken to import the data.

The date and time the data for the migration tree was last updated is shown at the top left of the tree. You can click Refresh to update the tree immediately, or you can select Auto-refresh to update the tree in real time.

Do not enable the Auto-refresh on the Summary tab and the tree because the amount of data may cause issues for the browser connection.

You may search the tree or expand and collapse all nodes using the search bar and buttons at the top of the tree.

SQL Executed tab

The SQL Executed tab displays a list of SQL queries executed for insert or merge for T tables of the forms that were executed during the import job. Use this tab for troubleshooting and debugging the import job errors.

Progress Tracker tab

The Tracker tab displays the start time, end time, and the progress percentage of each table in the migration node.

The Tracker tab displays the following information:

Field	Description
Table Type	Displays the type of table or form. The following values are displayed: DATA HISTORY SECURITY LOCALIZED ATTACHMENT ATTACHMENT_BINARY
StartTime	The time that the data import for this form or table started.
EndTime	The time that the data import for this form or table was completed.
Progress	Progress bar to indicate the import status for all table types.

If you click on any table type, you get the detailed Progress Tracker. For example, see the following image for Data Progress Tracker:

The detailed Progress Tracker displays the following information:

Field	Description
Table Type	Type of table or form.
Record	Number of records imported for the selected table type.
Import Stage	Displays the details of the import stages for a selected table type. The following stages can be displayed: STAGE POST_STAGE MULTI_RECORD_SPLIT PRIMARY_ID_STAGE MERGE
StartTime	Start time of the selected import stage.
EndTime	End time of the selected import.
Count	Number of records processed for the selected import stage.
Query	Displays the process query which is triggered by the import job, for the selected import stage.

The Errors & Warnings tab

The Errors and Warnings tab shows the list of any issues that occurred when performing the export or packing operations. The number of issues is shown in the tab title. The example below shows four errors for the import job.

To view the full details for an error, select an error from the list. You can view summary and advanced error messages.

To reimport failed forms or tables

If one or more forms or tables fail to import into the target system, you can create a new import job for those failed forms. Use one of the following methods:

To automatically create a new import job that contains only the forms or tables that failed or that were not imported from the previous run, select Action > Reimport Failed. (The import job must be in a Complete status before this option is available.)
Create a new import job from the migration job at any point to reimport any of the data in the data package.

What happens when an import job is submitted for processing

The following example shows an import job that has just been submitted for processing. Only the summary details for the import job are displayed.

As the BMC Helix Data Manager Runtime processes the import job, the data will be updated in the BMC Helix Data Manager Repository. you may request the latest data by clicking the Refresh button, or you may enable automatic refresh of the data by clicking the Auto-refresh button. The Auto-refresh button will be displayed in black if auto-refresh is enabled.

At the top of the page, a progress bar shows the overall progress of the export process.

The following phases are displayed:

Import—The data is being imported for each form or table.
Complete—The import process is complete.