Upgrade Error: Checkinstall on columns RESOURCE_CLASS and TRANSCLASS in table PAC_MNT_RESOURCES

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Checkinstall error message:

Script: PREUPGRADE_VALIDATE_FM_PAC_MNT.xml
ERROR
Pre-upgrade validation failed for not-null constraints on columns RESOURCE_CLASS and TRANSCLASS in table PAC_MNT_RESOURCES. The details for this can be found in Section Known Issues in the Installation and Upgrade chapter in Change Impact and Upgrade User Guide for V13.

Cause

This failure occurs because financially-enabled resources do not have the Resource Class or Transaction Class fields set or populated with a value.

Resolution

1.   Run and export the results of the query to a spreadsheet:

select s.unique_name from srm_resources s
where s.id in (select p.ID from pac_mnt_resources p
where p.resource_class is null OR p.transclass is null)

2.    For each resource in the results,

a. Go to Home > Resources > select resource > Properties > Financial
b. Populate the Transaction Class field
c. Populate the Resource Class field
d. Click Save

3.  Rerun the upgrade.