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

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

book

Article ID: 102430

calendar_today

Updated On:

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.