Version 3.x to 4.2

❗️

Mandatory for V3.x to V4.2 Upgrades

This instruction mandatory only for customers upgrading from UPM·X Version 3.x to Version 4.2.

Upgrading Best-Practices

It is strongly recommended to upgrade from major to major release without skipping a major release e.g.

  • ✅ DO: Version 3.x to V4.x
  • ⛔️ DON'T: Version 2.x to V4.x

Major Changes

UPM·X V4.2 includes the following major improvements:

  • Data Quality: We have improved the data quality calculations performance and logic. Backup existing data definitions and re-create them in the new Data Quality Portal (see point Migrate Data Quality Configuration.
  • UPM·X Portal: We have replaced the cache table and business rule with a new API.

Upgrade Procedure

  1. Go to System Applications/Installed and search for UPM·X.
  2. Select the latest UPM·X version and click on Update.
  1. The Update will take some time. Wait until the update has been completed before you proceed.

Migrate Data Quality Configuration

Backup Existing Data Quality Configuration

Please backup the following table content (if not empty) by exporting them to Excel (.xlsx) and XML:

'Data Definition Table
https://YOUR-INSTANCE.service-now.com/x_inpgh_upmx_data_definition.LIST

'Data Definition Scope Table
https://YOUR-INSTANCE.service-now.com/x_inpgh_upmx_data_definition_scope.LIST

Execute Scheduled Jobs

Please run the following scheduled jobs by clicking the "Execute Now" button on your instance:

❗️

Wait between 2 scheduled scripts

Please wait approximately 10 minutes before you execute the second scheduled job!

'To remove legacy Data Quality configuration
'ON DEMAND: UPM·X DQ Remove complete Data Quality configuration
https://YOUR-INSTANCE.service-now.com/nav_to.do?uri=%2Fsysauto_script.do%3Fsys_id%3Da46fdb2adbc1c450cf7cd7b7f4961954%26sysparm_record_target%3Dsysauto%26sysparm_record_row%3D1%26sysparm_record_rows%3D4%26sysparm_record_list%3DnameCONTAINSremove%255EORDERBYDESCsys_updated_on

'To recreate the full hierarchy path for all portfolio elements
'ON DEMAND: UPM·X Load full path of portfolio elements
https://YOUR-INSTANCE.service-now.com/nav_to.do?uri=%2Fsysauto_script.do%3Fsys_id%3Df9f4b55ddb77df407ae4f00ebf96193f%26sysparm_record_target%3Dsysauto%26sysparm_record_row%3D2%26sysparm_record_rows%3D6%26sysparm_record_list%3DnameCONTAINSload%255EORDERBYDESCsys_updated_on

Restoring Data Quality Configuration

You need the previously exported Excel Spreadsheets to restore the Data Quality Configuration.
Open the new Data Governance Portal and follow the steps below:

https://YOUR-INSTANCE.service-now.com/x_inpgh_upmx_DQ_Data_Governance_Portal.do
  • Click the "+" button at the bottom left of the Data Governance Portal to add a new entry.
  • Enter the same values from the Excel Spreadsheet to the new Data Governance Portal following the mapping table below:

Data Governance Portal Field

Export Sheet

Export Sheet Column

Short Description

Data Definition Scope

Scope Description

Table Name

Data Definition

Table

Steward Type

Data Definition Scope

Select “Steward Group” to add a group or “Single” if you have no group and the steward should review the data

Steward Group

Data Definition Scope

Steward Group

Data Review Cycle

Data Definition Scope

Data Review Cycle

Reminder Cycle

Data Definition Scope

Data Review Cycle

Audit

Data Definition Scope

Audit

Include All Records

Data Definition Scope

If “Scope Filter” is empty, click on the checkbox and set it to true

OR Include Record That Satisfy

Data Definition Scope

If “Scope Filter is not empty, enter it here

Example Mapping

  • Confirm the mapping by clicking on the SAVE button on the Data Quality Card.

Data Quality Card Example

  • Now, add all "Mapped Fields" by clicking the "+" icon. To be mapped fields are in the column "Data Definition" in the Excel Spreadsheet "Data Definition Scope".

Mapped Fields

Deleting Legacy Configuration

❗️

Mandatory Step

This step is mandatory for all customers migrating from any prior version to V4.2!

STEP 1

  • Download the Update Set and unzip.
  • Go to "Retrieved Update Sets" in ServiceNow
  • Click on "Import Update Set from XML" under the related links
  • Select the downloaded UpdateSet and upload it
  • Click on "Preview Update Set" after the upload is completed
  • Accept all Warnings and Errors and click on "Commit Update Set"

STEP 2

  • Delete the following Scheduled Jobs:
'RETIRED: UPM·X Create portfolio tree
https://YOUR-INSTANCE.service-now.com/nav_to.do?uri=%2Fsysauto_script.do%3Fsys_id%3Dc3cfdccb0fec83007fc1ba8ce1050e90%26sysparm_record_target%3Dsysauto%26sysparm_record_row%3D1%26sysparm_record_rows%3D1%26sysparm_record_list%3DnameCONTAINSportfolio%2Btree%5EORDERBYname

'ON DEMAND: UPM·X Create portal tree for existing definitions
https://YOUR-INSTANCE.service-now.com/nav_to.do?uri=%2Fsysauto_script.do%3Fsys_id%3Dd875bfccdbabef00df4292d8db96199a%26sysparm_record_target%3Dsysauto%26sysparm_record_row%3D1%26sysparm_record_rows%3D1%26sysparm_record_list%3DnameCONTAINSCreate%2Bportal%2Btree%2Bfor%5EORDERBYname

'ON DEMAND: UPM·X Data Governance — Set Value field on "Data Quality" table
https://YOUR-INSTANCE.service-now.com/nav_to.do?uri=%2Fsysauto_script.do%3Fsys_id%3De12da76d0f324b007fc1ba8ce1050ebb%26sysparm_record_target%3Dsysauto%26sysparm_record_row%3D1%26sysparm_record_rows%3D1%26sysparm_record_list%3DnameCONTAINSset%2Bvalue%2Bfiel%5EORDERBYname

The Upgrade procedure has been successfully completed.
If you are facing any issues, please contact us through our support portal.

Updated 14 days ago

Version 3.x to 4.2


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.