Migrating BMC Helix Digital Workplace Catalog data
After you perform the data migration for BMC Helix ITSM, perform the BMC Helix Digital Workplace Catalog data migration.
The following image shows the tasks to migrate BMC Helix Digital Workplace Catalog data:
Important
- The supported migration versions are not dependent on the version of the BMC Helix Data Manager tool. For example, you can use BMC Helix Data Manager version 21.3.05 to perform BMC Helix Digital Workplace data migration to version 22.1 or later.
However, we recommend that you use the latest version of BMC Helix Data Manager. For more information on the supported versions, see Available migration packs.
- After you perform the data migration, you can run delta data migration by using the Template DWPC Migration pack. Delta data migration is not supported for the Template DWPC Process Migration pack.
Before you begin
Make sure that you have completed the following actions:
- Migrated BMC Helix ITSM data.
- If you are migrating data from an Remedy on-premises system to BMC Helix Innovation Suite Cloud, make sure that you complete all the tasks of Stages 1 to 4 in the topic Migration process for Remedy on-premises to BMC Helix Innovation Suite Cloud before you migrate the DWPC data.
- If you are testing the application on Production database, make sure that you first take a backup of the database, test the application, and restore the backup after testing to avoid any new issues.
Downloaded and imported the following migration packs:
Important
To use BMC Helix Digital Workplace 23.3 SaaS Migration Packs, contact BMC Support.
Master Template Clear Down ITSM pack
Data Update Packs for ITSM and DWPC
Template DWPC Migration pack
Template DWPC Process Migration pack
- DWPC Process Source Migration Template pack
- Stopped BMC Helix Digital Workplace Catalog application and make sure that escalations in the source system are disabled during cutover, and escalations in the target system are disabled until the migration is fully complete.
- Updated the company details for the hannah_admin the in Company*+ field in the CTM:People form in the BMC Helix ITSM target system.
If not, set the customer name for the hannah_admin user as Company. Created a back up of your source systems.
Important
Do not perform any data migration step on your production source systems. You must perform the data migration steps on the back up of your source systems.
- Downloaded the BMC-DWPC-HDM_Accessories_21.xx.zip file located at
BMC Helix Digital Workplace Catalog OnPrem Data Migration Accessories
on EPD.
Search for BMC Helix Digital Workplace Advanced OnPrem and download the latest version of BMC-DWPC-HDM_Accessories_21.xx.zip file. The file includes the build_hdm_csv.py, Fix_cache-21.3, and processupgrader-21.x.jar utilities. - Installed Python version 3.10.5.
To download Python version 3.10.5, see https://www.python.org/downloads/ .
For steps on installing Python, see Python documentation . - Verified that the myit-sb:mp_search_categories table in DWP-C do not have any duplicate categories. Fix any duplicate categories in the DWP-C source system.
- If you are migrating to BMC Helix Innovation Suite version 21.3.07 or above, set the CCS setting Disable-Process-Timer-Task-Execution value to T (true).
- In a browser, open the BMC Remedy AR System Administration Console, and click System > General > Centralized Configuration.
- In the AR System Configuration Generic UI form, from the Component Name list, select com.bmc.arsys.server.shared.*.
- Set the Disable-Process-Timer-Task-Execution setting to T and click Apply.
To perform the full migration
Register the following source and target systems:
System Steps to register the system BMC Helix Digital Workplace Catalog source system Register a source system.
Important:- While registering the BMC Helix Digital Workplace Catalog source system, specify the Catalog - Logical Db Name value as Catalog and Tenant - Logical Db Name value as Tenant.
- Set the HDM User value to hdm.
- In the BMC Helix Digital Workplace Catalog registered source system, set the Unique Id Transform value to 'D'. The value must be different from the Remedy Source system value.
For more information about updating the Unique Id Transform value, see Actions you can perform on a system you have registered.
- Create a BMC Helix Data Manager user.
- Test system connectivity and get database character set details on the source system.
BMC Helix ITSM target system BMC Helix Digital Workplace Catalog process migration source and target system - Register source and target process system.
- Create a BMC Helix Data Manager user.
Note - If you have already created an HDM user, you can skip this step. - Test system connectivity and get database character set details on the source and target DWPC process system.
- Discover the source and target DWPC process system.
Copy the Master Template Clear Down ITSM Pack, DWPC Migration Template Pack, and DWPC Process Migration Template Pack migration packs to the source and target data dictionaries.
- In BMC Helix Data Manager, select Data Migration > Migration Packs.
- Select the migration pack that you want to copy.
- Select Action > Copy.
Select the source and target data dictionaries for the respective DWPC and Process systems.
For the DWPC migration pack, select the following data dictionaries:Source data dictionary Catalog and Tenant database registered as DWPC System in BMC Helix Data Manager. Target data dictionary System registered as Remedy in BMC Helix Data Manager and connecting to the database used for ITSM configuration.
For the Process systems, select the following data dictionaries:Source data dictionary Tenant database defined as Relational System in BMC Helix Data Manager Target data dictionary System defined as Relational System in BMC Helix Data Manager and connecting to the database used by the standard migration pack on the target system. - Click Copy Migration Pack.
- Set up the source and target systems for data migration.
- Take a backup of the target system.
In the BMC Helix Digital Workplace Catalog process source system, run the pre-migration script.
Perform the following steps:In BMC Helix Data Manager, select Discovery & Analysis > System Analysis & Administration, and select the BMC Helix Digital Workplace Catalog source system.
Navigate to the Data Update tab and click Run Data Updates.
Select Create Data Update Job.
Select PreMigration Scripts_DWPC Source.
For a 20.02 process source, run the Set DWPC Admin Flag, Set DWPC Agent Flag, and Update Process_permissions_x scripts by using the Run Selected Script option.
For a 20.08 process source, run all the scripts by using the Run All Scripts option.
- Run the Data Update Job to tag the Groups linked to Virtual Marketplace in the source system.
Perform the following steps:- In BMC Helix Data Manager, select Discovery & Analysis > System Analysis & Administration, and select the BMC Helix Digital Workplace Catalog source system.
- Navigate to the Data Update tab and select Run Data Updates.
- Select Create Data Update Job.
- Select the latest Data Update Template - DWPC 20.02 or Above to 2x.x template and DWPC source system.
- Click Create New Data Update Job.
- Run the Tag groups linked to VM script using the Run Selected Script option.
Take a backup of the configuration data.
In BMC Helix Data Manager, select Discovery & Analysis > System Analysis & Administration, and select the target system.
Navigate to the Data Updates tab and select Run Data Updates.
Select Create New Data Update Job and select the DWPC Data Update Template and Target System.
On the Track Data Update Jobs tab, select the data update job.
Run the Pre-Migration Backup script by selecting it and clicking the Run Selected Script option.
Verify that the job is successfully completed.
- If you are migrating your BMC Helix Digital Workplace Catalog data to target version 22.1.xx or 23.3.xx, run the PreMigrationDataFix_myit_sb_mp_product_products script.
Run Clear Down migration pack on the target system for BMC Helix Digital Workplace Catalog.
Important
- If you have already migrated ITSM data and run the Master Template Clear Down ITSM pack for ITSM, you do not need to run the clear down pack again.
- If the Shared File System list is empty, create a new file system. Learn about how to create file system at Creating a file system.
In BMC Helix Data Manager, select Data Migration > Delete Data, select the DWP Catalog 20.02 and above export template for BMC Helix Digital Workplace, and click Next.
- From the Migration Pack dropdown, select the Master Template Clear Down ITSM pack.
On the Delete Data-Confirm page, specify the deletion job and forms for deletion, and click Confirm Delete.
- After the deletion job is completed, navigate to the Summary tab of the job, select Action > Start Export.
After the export is completed, on the Summary tab of the job, select Action > Delete Data.
Take a database backup of the target system gold build - Gold Build Backup 1.
- Perform data migration.
- Fix overlays and process definitions by running the Process Definition utility.
- Apply the required licenses.
For more information, see Activating application licenses . - Update the group_cache and user_cache tables.
- Running the postmigration utility for BMC Helix Digital Workplace.
- Perform the delta data migration.
To migrate BMC Helix Digital Workplace Catalog groups from the source system to target system
Prepare a group ID mapping sheet in CSV format with Source_Group_ID, Source_Group_Name, Target_Group_ID, and Target_Group_Name headers.
Important
If you are migrating your data from BMC Helix Digital Workplace version 21.3 to version 21.3, do not perform Group ID transformation.
Use the build_hdm_csv.py script to prepare a group ID mapping sheet. To download the script, navigate to <FTP_directory>/BMC_Helix_Data_Manager/HDM Metadata/21.3 Target/DWPC/Utilities folder in the FTP directory. For information on accessing the FTP directory, see the topic Downloading the installation files.
Perform the following steps:Run the following query in the source databases (DWPC tenant) and the target databases, and export the results to a CSV file respectively:
select group_id, group_name from group_x
After you run the command in the source databases and the target databases, you have two CSV files, <source>.csv and <target>.csv.
Important
Make sure that the CSV files to which you export the results do not contain any column titles or headers.
- Save the <source>.csv and <target>.csv files with UTF-8 encoding:
- Open the CSV file in Microsoft Excel.
- Select File > Save As.
- In the Save as type list, select CSV UTF-8 (Comma delimited) (. csv).
- Click Save.
Run the script to prepare the group ID mapping sheets output.csv and output2.csv by using the following command:
python3 build_hdm_csv.py source.csv target.csv output.csv output2.csv
If you are using a newer version of python, use the following command:
py build_hdm_csv.py source.csv target.csv output.csv output2.csv
To prepare the group ID mapping for a source database set as Assigned To = "Migrate" in group form for sbe-public-computed and dwpc-non-subtenant-admins group records, use the following premigration script:
Perform the following steps:In BMC Helix Data Manager, select Discovery & Analysis > System Analysis & Administration, and select the BMC Helix Digital Workplace Catalog process source system.
Navigate to the Data Update tab and click Run Data Updates.
Select Create Data Update Job.
Select PreMigration Scripts_DWPC Source.
- Run the Set DWPC Group Assigned To Migrate script.
Upload the mapping sheet that you created in step 1 to the transformation group IDs in the DWPC Migration pack.
- In the BMC Helix Data Manager, navigate to the Data Migration tab, and select Data Mapping.
- Select the data migration pack name.
- From the list, select the mapping Tenant: ACT_GE_BYTEARRAY - > ACT_GE_BYTEARRAY.
- On the Data Enrichment tab, select each row in the tab and upload the respective CSV file.
For the group ID, in the Mapping Data tab, click Upload CSV, and upload the group mapping sheet file output.csv generated in step 1b.
Important
Upload the same group mapping sheet file for data enrichment to the GroupIDListTransform, GroupIDListTransform2, GroupIDListTransform3, GroupIDListTransform4, and GroupIDListTransform_User group IDs.
- In the BMC Helix Data Manager, navigate to the Data Migration tab, and select Data Mapping.
To export data
Perform the following steps to export the BMC Helix Digital Workplace Catalog data:
- In BMC Helix Data Manager, select Data Migration > Migrate Data.
- On the Migrate Data page, in the Migration Pack field, select the DWPC Migration pack.
- Complete the fields and click Next.
- On the Migrate Data - Confirm page, in the Migration Job Name field, specify the migration job, and click Confirm Migration.
- On the Migration View Job page, click Start Export.
Perform the following steps to export the BMC Helix Digital Workplace Catalog process data:
- In BMC Helix Data Manager, select Data Migration > Migrate Data.
- On the Migrate Data page, in the Migration Pack field, select the DWPC Process Migration pack.
- Complete the fields and click Next.
- On the Migrate Data - Confirm page, in the Migration Job Name field, specify the migration job, and click Confirm Migration.
- On the Migration View Job page, click Start Export.
To import data
You must import both the BMC Helix Digital Workplace Catalog data and BMC Helix Digital Workplace Catalog process data for successful migration.
To import BMC Helix Digital Workplace Catalog data
Perform the following steps to import the BMC Helix Digital Workplace Catalog data by using the DWPC Migration Pack:
- After the data export is complete, on the Migration View Job page, navigate to the Import tab.
- On the import tab, click Create import Job.
- On the Import Data page, in the Migration Pack field, select the DWPC Migration pack.
- Complete the fields and click Next.
On the Import Data - Confirm page, in the Group IDs field, perform the following steps:
Important
If you are migrating your data from BMC Helix Digital Workplace version 21.3 to version 21.3, do not perform Group ID transformation.
Apply the group ID transformations.
Set User Cache Import Action to Modify.
- Set the Group IDs Prefix value to 1.
Click Confirm Data Import.
Important
Do not apply any other transformations - Request IDs, Ticket Numbers, or SLA IDs to avoid errors in the migration. Apply the Group ID transformation only.
- On the Migration View Job page, to start the import job, click Start.
To import BMC Helix Digital Workplace Catalog process data
Perform the following steps to import the BMC Helix Digital Workplace Catalog data by using the DWPC Process Migration Pack:
- After the data export is complete, on the Migration View Job page, navigate to the Import tab.
- On the import tab, click Create import Job.
- On the Import Data page, in the Migration Pack field, select the DWPC Process Migration pack.
- Complete the fields and click Next.
On the Import Data - Confirm page, perform the following steps:
Important
If you are migrating your data from BMC Helix Digital Workplace version 21.3 to version 21.3, do not perform Group ID transformation.
In the Group IDs field, apply the group ID transformation.
- Set User Cache Import Action to Modify.
Click Confirm Data Import.
Important
Do not apply any other transformations - Request IDs, Ticket Numbers, or SLA IDs to avoid errors in the migration. Apply the Group ID transformation only.
- On the Migration View Job page, to start the import job, click Start.
To run data update scripts
- In BMC Helix Data Manager, navigate to the Discovery & Analysis tab, and select the target system.
Click Run Data Updates.
Important
If you are migrating your data from BMC Helix Digital Workplace version 21.3 to version 21.3, run the Data Update Template - DWPC 21.3 to 21.3.cmt script only.
- In the Create Data Update Job pane, specify the job details, and click Create New Data Update Job.
(Microsoft SQL Server) Before running the data update scripts on a Microsoft SQL Server based target system, run the following SQL command:
ALTER DATABASE ARSystem SET COMPATIBILITY_LEVEL = <COMPATIBILITY_LEVEL>
where,
COMPATIBILITY_LEVEL can be { 160 | 150 | 140 | 130 | 120 | 110 | 100 | 90 | 80 }.
To find out the COMPATIBILITY_LEVEL of your system, see ALTER DATABASE (Transact-SQL) compatibility level .Run all the scripts based on the source version of BMC Helix Digital Workplace Catalog:
Important
- Do not run the PreMigration Scripts_DWPC Source and Tag groups linked to VM scripts in this step.
If you are migrating your data from BMC Helix Digital Workplace version 21.3 to version 21.3, run the Data Update Template - DWPC 21.3 to 21.3.cmt script only.
Script details:
Order Script Application for 20.02-21.3.xx Migration
Application for 20.08-21.3.xx Migration
Application for 20.02/20.08-22.1.xx Migration
Application for 20.02/20.08-23.3.xx Migration
1 PreMigrationBackup Yes Yes Yes Yes 2 Tag groups linked to VM Yes Yes Yes Yes 2002001 M20200302_02_PatchExistingContentsWithReferenceSources Yes Yes Yes 2002002 M20200302_03_UpdateContentSecurityLabelToPublic Yes Yes Yes 2002003 M20200710_01_
PopulateMissingRowPermissionsToQuestionnaireTranslationYes Yes Yes 2002101 M20200928_02_PopulateLastReopenDateForServiceRequest Yes Yes Yes Yes 2002201 M20201204_01_PopulateServiceRequestSubmittedDate Yes Yes Yes Yes 2002202 M20200205_01_PopulateLocaleForMessageTemplate Yes Yes Yes 2002301 M20200506_01_
UpdateProcessDefinitionToReplaceDollarExpressionForRenderTemplateActionYes Yes Yes 2002302 M20200519_01_
MigrateExistingConnectionConfigurationSettingsToTheirOwnBundlesYes Yes Yes 2002303 M20200528_01_UpdateRlsLabelsOfServiceRelatedEntities Yes Yes Yes 2002304 M20200622_01_MoveConnectionComponentsFromMyitsbeToDwpcGroup Yes Yes Yes 2002305 M20200729_01_UpdateLaunchServiceCatalogProductActionOutput Yes Yes Yes 2002306 M20200819_01_NullifyUserSyncFlags Yes Yes Yes 2002307 M20200522_01_UpdateProcessExecutionPermissionToPublic Yes Yes Yes 2105001 M20210520_01_InitializingServiceRequestIds Yes Yes Yes Yes 2105002 M20210902_01_UpdateUserCriteriaInVirtualMarketplace Yes Yes Yes Yes 2130001 M20220215_01_DisableIsDraftQuestionAnswersByDefault Yes Yes Yes Yes 2130002 M20220613_01_UpdateContentDefinitionReferenceSource Yes Yes Yes Yes 2130003 M20230301_01_UpdateRslReadForITSMIntegrationService Yes Yes 2130004 M20221102_01_SeedingServiceSearchCacheForITSMTicketService Yes Yes 2130005 M20220912_01_EnablePasswordVisibilityForQuestionnaire Yes Yes 2130006 M20230322_01_UpdateRslReadForHeadlessService Yes Yes 2130008 M20220413_01_UpdateReopenTypeInServiceSearchCache Yes Yes 2130009 M20220603_01_UpdateReopenTypeInServiceVersion Yes Yes 2130010 M20221103_01_FixingProductIdForITSMTicketService Yes Yes 2130011 M20230307_01_InsertMissingContentDefinition Yes Yes Yes Yes 2130012 CleanupDeletedRecordsFromSource Yes Yes Yes Yes 2130013 M20230525_01_UpdatePricingRevisionIdForHeadlessServices Yes 2130014 M20230615_01_UpdateLogoForMissingContentDefinitions Yes 2130015 M20230621_01_FixServiceRevisionLogoId Yes 2130016 MM20231208_01_PopulateExternalLastModifiedDate Yes 2130017 M20231227_01_PopulateImportModeForExistingImports Yes 9999993 UpdateDataAccessGroupReadDataAccessGroupWrite Yes Yes Yes Yes 9999994 FixedLicenseToDWPCAdminUsers Yes Yes Yes Yes 9999995 UpdateEmptyGroupList Yes Yes Yes Yes 9999996 UpdateRemoteServerApplicationName Yes Yes Yes Yes 9999997 UpdateApplicationLicense Yes Yes Yes Yes 9999998 UpdateGroupListandFunctionalRoles Yes Yes Yes Yes 9999999 MergeSourceApplocalconfigstorageWithTarget Yes Yes Yes Yes 10000000 DeleteObsoleteGroups Yes Yes Yes Yes 10000001 Process Context and Historic Process Context Updates Yes Yes Yes Yes 10000002 Update CTM:People Form License From User Form
Yes Yes Yes Yes 10000003 UpdateStatusOfUsers Yes Yes Yes Yes 10000004 UpdateNameOfSubProcesses Yes Yes Yes Yes 10000005 Update Rls Write Fields when MSP is off Yes Yes Yes Yes 10000007 RemoveDomainNameSBRemoteApprovalConfiguration Yes Yes Yes Yes 10000008 Remove Users From Deleted Groups Yes Yes Yes Yes 10000009 Insert Administrator Permissions For CTM:People Permission Groups Yes Yes Yes Yes 10000010 MergeSourceCMDBConnectorApplocalconfigstorageWithTarget Yes Yes Yes Yes 10000011 Update functional_role_list For User Yes Yes Yes Yes 10000012 MergeSourceISConnectorApplocalconfigstorageWithTarget Yes Yes Yes Yes 10000013 UpdateSbUser Yes Yes Yes Yes 20000000 Next ID Yes Yes Yes Yes To run a script, perform the following steps:
Select the data update job that you created in step 3.
Select the script that you want to run and click Run Selected Script.
In some cases, the HDM user must be a super user to run the Data Update script. Run the following script on your target system to make the HDM user as super user:
ALTER USER HDM WITH SUPERUSER;
Perform the following steps to run the BMC Helix ITSM data updates.
Navigate to the Discovery & Analysis tab, and select the target system.
- Click Run Data Updates.
- In the Create Data Update Job pane, specify the job details, and click Create New Data Update Job.
In the data update job, select the Next ID script, and click Run Selected Script.
To fix overlays and process definitions
You must fix your overlays and process definitions to preserve the customizations you performed before migration.
To fix overlays and process definitions by using Process Upgrader
Important
We recommend that you use the Process Upgrader utility to fix overlays and process definitions. If you are using other utilities like rxmigrator, contact BMC Support.
Run the following command to run the Process Upgrader utility:
java -jar processupgrader-21.3.jar <command> -dbtype <database type> -dbhost <database host> -dbport <database port> -dbname <database name> -dbuser <database user> -dbpassword <database password> -ignorefile <ignorefile.txt>
Parameters list:
Parameter
Description
<command>
List of commands:
Command Description fix-all This command runs all the fixes supported by this tool successively.
We recommend you to use the fix-all command for optimal results.fix-overlay-group This command fixes the overlay group reference in the `smobjprop` field of process variables.
fix-expressions This command upgrades the expressions in assignments, conditions. fix-permissions This command enforces an execution permission open to 'Public' for all DWPC processes.
connect This command validates the connection to the database. help This command prints usage of the utility. -dbtype <database type>
Type of database, such as:
- postgres
- oracle
- mssql
-dbhost <database host>
Database host.
For example,
clm-dbhost
-dbport <database port>
Database port.
For example,
5432
-dbname <database name>
Database Name.
For example.
ARSystem
If you are using an Oracle database:
- We recommend you to use a specific AR Database user, instead of a system-wide user like “system”.
- use -dbname = <service name> (where <service name> is the Service Name/SID of Oracle DB)
-dbuser <database user>
Database user.
For example,
ARAdmin
-dbpassword <database password>
Database password.
-ignorefile <ignorefile.txt> Ignore Text File to track the items processed by the tool.
You can use any name for this file.
-safemappings Option to allow the tool to run on a shorter list of mappings.
Use this option when you re-run the tool. You can safely re-run the mappings on processed data.
For example:
java -jar processupgrader-21.3.jar fix-all -dbtype postgres -dbhost clm-dbhost -dbport 5432 -dbname ARSystem -dbuser ARAdmin -dbpassword password -ignorefile ignorefile.txt
- After you successfully run the utility, restart all the AR pods on your environment.
To update the group_cache and user_cache tables
During the migration, the user and group records are modified. You must refresh or update the group_cache and user_cache tables to reflect the changes in the user and group records.
To update the group_cache table, perform the following steps:
- In your BMC Helix Data manager workbench, copy the fixcache utility JAR file.
- In a command prompt, navigate to the location where you have copied the JAR file.
(Optional) Take a backup of the group_cache table through a database client by using the following command:
SELECT * into bkup_group_cache FROM group_cache
Run the fixcache utility by using the following command:
java -jar fixcache-21.3.00-SNAPSHOT.jar -h <AR_EXTERNAL_IP> -t <PORT> -u <AR_ADMIN> -p <AR_ADMIN_PASSWORD> -c group
To update the user_cache table, perform the following steps:
- In your BMC Helix Data manager workbench, copy the fixcache utility JAR file.
- In a command prompt, navigate to the location where you have copied the JAR file.
(Optional) Take a backup of the user_cache table through a database client by using the following command:
SELECT * into bkup_user_cache FROM user_cache
Run the fixcache utility by using the following command:
java -jar fixcache-21.3.00-SNAPSHOT.jar -h <AR_EXTERNAL_IP> -t <PORT> -u <AR_ADMIN> -p <AR_ADMIN_PASSWORD> -c user
To perform the delta data migration
You must perform the delta data migration to fully synchronize the source and target systems. Use the Template DWPC migration pack for running the delta data migration.
Important
You can run the delta data (incremental) migration for DWPC by using the Template DWPC migration pack only. You cannot use the Process Migration pack for delta data migration.
Perform the following steps:
- Download the Form Deletion Set DWPC.cmt file from BMC FTP.
To download the file, navigate to <FTP_directory>/BMC_Helix_Data_Manager/HDM Metadata/21.x Target/DWPC folder in the FTP directory. For information on accessing the FTP directory, see the topic Downloading the installation files. - Copy the Form Deletion Set DWPC.cmt file to the <HDM_Installation_directory>/Metadata folder.
- Log in to HDM and select Configuration > Import HDM Meta Data from the navigation bar.
- Select Scan.
- Select Form Deletion Set DWPC.cmt from the list and click the Import Meta Data button.
After the import is successful, you can see the deletion list in the Configuration > Form Deletion list. - Click Data Migration > Migrate Data.
- On the Migrate Data page, in the Migration Pack field, select the DWPC source, DWPC target, and DWPC Tenant Migration pack.
- From the Export Template list, select All Data Incremental.
- Complete all the fields and click Next.
- Specify the Incremental Start and End date.
- Click Next and run the export job.
- After the export is completed successfully, click Create Import Job to open the Create Import Job dialog box.
- On the Import Data page, click Next.
Select Form Deletion Set as DWPC, apply Group ID transformation and set User Cache Import Action to Modify and confirm.
Important
- Make sure that you have not selected the Form Deletion Check as Default.
- If you are migrating your data from BMC Helix Digital Workplace version 21.3 to version 21.3, do not apply Group ID transformation.
- Click Confirm Data Import.
- After the delta migration is complete, rerun the DWPC data update template and ITSM data updates postmigration scripts.
To migrate DWPC process data
Perform the following steps if you want to re-run the migration to migrate the process data for DWPC:
- Download the PreDDM Process Deletion_DWPC.cmt file from BMC FTP.
To download the file, navigate to <FTP_directory>/BMC_Helix_Data_Manager/HDM Metadata/21.x Target/DWPC folder in the FTP directory. For information on accessing the FTP directory, see the topic Downloading the installation files. - Copy the PreDDM Process Deletion_DWPC.cmt file to the <HDM_Installation_directory>/Metadata folder.
- Log in to HDM and select Configuration > Import HDM Meta Data from the navigation bar.
- Select Scan.
- Navigate to Discovery & Analysis > System Analysis & Administration and select the Process target system.
- In the Available Data Updates tab, select PreDDM Process Deletion and click Run Data Updates.
- Click Run Selected Script.
The Process deletion script is run successfully. - Run the migration again for process data.
- After you complete the migration, run data update scripts.
- Fix overlays and process definitions.
Where to go from here
Running the postmigration utility for BMC Helix Digital Workplace
Comments
Link for Registering the target system for DWPC taking us to the page of 'registering source system'? is configuration for target and source is same ?
Hi Dnyaneshwar,
Thank you for your comment. We have updated the documentation.
If you want to configure target system for DWPC, you can refer the same topic for the steps. See Registering a system for BMC Digital Workplace Catalog.
Regards,
Himanshu
Thanks Himanshu !
Section "To Migrate data" : Point 3-B-ii and Point 3-C-ii where it says "Navigate to the Data Update tab and select Create Data Update Job." but there is no option available to create data update job under tab "Data update"
You need to first click on "Run Data Updates" button and then window appear to configure new data update job.
This is confusing and steps are not clear here. You need to consider this to be corrected.
Hi Dnyaneshwar,
Thank you for pointing out this issue with the content. We have corrected the topic with your feedback.
Regards,
Himanshu
Section "To Migrate data" : Point 3-d In "Track Data Update Jobs" tab you won't have jobs there, you need to first create job then it will appear there and you can run the individual scripts.
Hi Dnyaneshwar,
Thank you for pointing out this issue with the content. We have corrected the topic with your feedback.
Regards,
Himanshu
Section : "To migrate BMC Helix Digital Workplace Catalog groups from the source system to target system"
Where there is important warning says "Make sure that the CSV files to which you export the results do contain any column titles or headers" so is it "do contain" OR "Do not contain"?
Hi Dnyaneshwar,
Thank you for pointing out this issue with the content. We have corrected the topic with your feedback.
Regards,
Himanshu
Section "Before you begin": "Verified that the myit-sb:mp_search_categories table in DWP-C do not have any duplicate categories. Fix any duplicate categories in the DWP-C source system."
Can you specify what makes a category a duplicate? Is it by name only or by name and Parent_id? In our system I can see 3 ootb entries for "Productivity" but they are linked to 3 different parent_ids - is this considered a duplicate?
Log in or register to comment.