Installation and Upgrade › Known Issues › Missing Data for Resource Financials

Previous Topic: Duplicate Cost Plan Code Error

Next Topic: Upgrade Fails if the Default Language for the Admin User Is Not English

Missing Data for Resource Financials

If the Resource Class or Transaction Class fields are null for Resource financials, the upgrade process fails. The data must be corrected before you resume the upgrade process.

The not null database constraint for columns RESOURCE_CLASS and TRANSCLASS in table PAC_MNT_RESOURCES was added in v13.0. If you are upgrading from a previous version of CA Clarity PPM, it is possible the information may be missing.

CA recommends running the following query to identify records with this data issue before starting the upgrade.

Select * from pac_mnt_resources where RESOURCE_CLASS is null OR transclass is null

If this query returns any rows, it indicates issues with the PAC_MNT_RESOURCES table data. CA recommends reviewing all returned records and updating the records with valid transaction class and resource class values.