This issue applies only to upgrades from a 12.x release to Release 13.3.
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. An upgrade check script runs and alerts you that this problem exists.
The not null database constraint for the RESOURCE_CLASS and TRANSCLASS columns in the PAC_MNT_RESOURCES table was added in Version 13.0. If you are upgrading from a previous version of CA Clarity PPM, it is possible that the information is missing.
We recommend 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 that there are issues with the PAC_MNT_RESOURCES table data. We recommend reviewing all returned records and updating the records with valid transaction class and resource class values.
|
Copyright © 2013 CA.
All rights reserved.
|
|