This version of the software is currently available only to customers in the Controlled Availability (CA) program.

Troubleshooting migration pack issues


This topic lists the issues that you might encounter with the BMC Helix Data Manager migration packs. See the guidelines in this topic to obtain the appropriate logging and troubleshooting steps.


Issue symptoms

You might encounter the following errors or failures with BMC Helix Data Manager Migration Packs:

  • You cannot download BMC Helix Data Manager Migration Packs from the File Transfer Protocol (FTP) location.
  • The Migration Pack fails or remains empty during the copying process.
  • The custom Migration Pack is not listed after you select the source and target system.
  • When you modify the Migration Pack, the custom forms are not listed under the Add Forms tab in the Migration Pack window.
  • You encounter an enum warning while performing Data Mapping. 


Issue scope

The Migration Pack issues might occur for the following use cases:

  • On-premises to on-premises data migration.
  • On-premises to SaaS data migration.


Resolution

Verify the configuration checks and troubleshoot the issue that you have faced.

Important

You must follow the steps described in the table in the specified order.  

Review the tasks in the table before looking for additional details under the Common cause and possible solution section.

Step

Task

Description

1

Review the source and target system configurations.

  1. Review the source and target system configurations by performing the following tasks:
    1. Log in to BMC Helix Data Manager.
    2. On the System Configuration page, select Source or Target System Configuration.
    3. Under Action, select Test System Connectivity.
      connectivity (1).PNG

For more information, see Registering-source-and-target-systems.

2. Review the defined file system connections by performing the following tasks:


    1. Confirm that the default connection path is correct.
      1. Log in to BMC Helix Data Manager.
      2. Select Configuration > Configure File System connections.
        Then, select Defined File Systems > Review Path.    
    2. Confirm that the Test Write Data and Test Read Data & Files are successful.
      1. Under Configure, select the correct Source and Target Systems > Configure Connections.
      2. Validate Test Write Data and Test Read Data & Files.

              image-2024-5-3_20-57-20.png

            Test Export.png

               image-2024-5-3_20-53-26.png

              Test Import.png

For more information, see validating file system configuration.

3. Review the discovered Data Dictionary from the source and target system, and make sure that the Forms & Fields tab shows a valid list of forms (Base, Custom, Overlay).


    1. Log in to BMC Helix Data Manager.
    2. From Discovery & Analysis, select Discovered Dictionary.

      Discovered DD.PNG

    3. Under Forms & Fields, Select the correctly labeled and dated Data Dictionary and review the Custom, Base, and Overlay forms list.

             Screenshot 2024-03-28 163146.pngFor more information, see Discovering-data-dictionaries

4. To review whether the version of the Migration Pack that is imported and published is valid, perform the following tasks:


    1. Log in to BMC Helix Data Manager.
    2. Select Data Migration > Migration Packs.
    3. Confirm that the Migration Pack Name and its Status are correct.
    4. Review the Included Forms tab to confirm that the correct form list is displayed.

           image-2024-3-22_15-55-37.png

For more information, see Adding custom forms to a migration pack and Creating-a-migration-pack-for-your-systems.


2

Enable and collect the logs.

BMC Helix Data Manager logs are enabled under the BMC Helix Data Manager directory on both source and target systems.
Find the logs in the following path:
\BMC Software Install Directory\Helix Data Manager\Engine\log\hdm.log
.

hdm log.png

Check the hdm.log to verify whether the  Date and Time details of when the activity was carried out are recorded.    

3

Create a BMC support case. 

Make sure you capture detailed information by using the following list while creating a case with BMC Support:

  • What is the version and name of the Migration Pack?
    For example, 20.02 to 21.3, ITSM or Smart IT application
  • What is the version and type of source and target database server?
  • What is the hotfix version of BMC Helix Data Manager tool on the source and target system?
  • What are the steps to reproduce the issue or error?
  • Is the migration activity performed on the source or target system?
  • Is the migration taking place from an on-premises to an on-premises system or from an on-premises to BMC Helix system?
  • Is the hdm.log captured as explained in step 2?
  • Are there any screenshots of errors that were encountered?


 

After you determine a specific symptom or error message, use the following table to identify the cause and possible solution:

Symptom

Cause

Action

Reference

BMC Helix Data Manager Migration Packs are unavailable after logging into the BMC's FTP folder

Detail: The BMC Helix Data Manager Migration Packs are not available under the pub folder on the FTP site ftp.bmc.com  

image-2024-3-22_16-8-27.png


This error could occur when you directly click the pub folder after logging on to BMC's FTP site,  ftp://ftp.bmc.com.

  1. Log in to the BMC's FTP folder using the URL ftp://ftp.bmc.com.
  2. Using the path  /pub/BMC_Helix_Data_Manager, navigate to the BMC Helix Data Manager Metadata directory.
    For example,
    (In case you are using WinSCP file manager) in the OpenDirectory field, select Open Directory icon and enter the path /pub/BMC_Helix_Data_Manager.

image-2024-3-22_16-8-54.png

The included Forms tab is empty when copying the Migration Pack

Detail:  The Included Forms tab is empty when you make a copy of a Migration Pack.

DD forms are empty.png

  • The value of Data Dictionary is invalid.
  • The system configuration is invalid.
  • An incorrect ARS version was selected during the registration of source or target system.

Verify that the Data Dictionary on the source and target systems is correct, and confirm if the Forms & Fields tab shows a valid list of forms.

Important: If the Data Dictionary is empty, there could be an issue with the System Configuration.

image-2024-3-22_16-19-46.png

Custom migration pack is not available during data migration

Detail: During data migration, the custom Migration Pack is not listed after you select the source and the target systems.

image-2024-3-29_11-53-27-1.png


This scenario occurs if the Migration Pack that is associated with the source and the target system is not published. 

The custom Migration Pack must be published to make it available for migration. confirm that the status of the custom Migration Pack is set to Published to make it available for migration.

Important:
Template Migration Packs are in Draft status, so the custom Migration Packs copied from a Template Pack will also be in Draft status by default.

image-2024-3-22_16-31-13.png

For additional details, see Opening-a-migration-pack.

Custom forms are not listed during the modification of the Migration Packs

Detail: During the modification of the Migration Packs, the custom forms are not listed under the Add Forms tab.

image-2024-3-22_16-33-20.png


This scenario occurs when the Data Dictionary is discovered before the customization or custom objects are migrated to the target system.

To get the custom forms listed:

  1. Verify that the target Data Dictionary is discovered after the customization migration is completed. The custom forms must be found in the discovered Data Dictionary after completing the custom migration.
  2. If the custom forms are unavailable, rediscover the target Data Dictionary and confirm that the custom forms are listed in the new Data Dictionary.
  3. Create a valid copy of the template Migration Pack with the newly discovered source and the latest target Data Dictionary.


Enum warning appears during data mapping

Detail: The BMC Helix Data Manager alerts a potential migration issue when a source enum value is absent in the target system.

This error occurs as the enum values do not exist in the target system.

To obtain the number of records for each enum value in the source system, perform the following steps:

  1. From the Data Mapping page, select the Form Mapping for the form you want to check, and click the  Source Form tab.
  2. Select the Fields tab, and select the field you want to check.
  1. Click Get Enum Distribution.
    image-2024-5-9_14-49-50.png
  2. In the dialog box, click Get Enum Distribution  to run the check against your source database.
    image-2024-5-9_14-53-19.png

Important: Only BMC Helix Service Management systems linked to the Data Dictionary are available for this check.




 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*