Upgrade fails on updating com.ca.ppm.database.upgrade.UpdateTeamAvailability.doUpgrade

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Upgrade to 15.9.2 fails with NullPointerException on UpdateTeamAvailability:

5/20/21, 7:40 AM (admin) Updating team availability

5/20/21, 7:40 AM (admin) com.niku.dbtools.ant.ExecutableException: /opt/ppm/upgrade/15.9.2/component/postupgrade/database.xml:94: Java returned: 1

5/20/21, 7:40 AM (admin)            at com.niku.dbtools.ant.AntUtil.executeAntScript(AntUtil.java:109)

5/20/21, 7:40 AM (admin)            at com.niku.dbtools.ant.AntUtil.executeAntScript(AntUtil.java:84)

5/20/21, 7:40 AM (admin)            at com.niku.dbtools.Utilities.executeAntScript(Utilities.java:2409)

5/20/21, 7:40 AM (admin)            at com.niku.dbtools.Utilities.run(Utilities.java:2002)

5/20/21, 7:40 AM (admin)            at com.niku.dbtools.Utilities.main(Utilities.java:1055)

5/20/21, 7:40 AM (admin) Caused by:

5/20/21, 7:40 AM (admin) Exception in thread "main" java.lang.NullPointerException

5/20/21, 7:40 AM (admin)            at com.ca.ppm.database.upgrade.UpdateTeamAvailability.doUpgrade(UpdateTeamAvailability.java:83)

5/20/21, 7:40 AM (admin)            at com.niku.union.utility.AbstractUpgrade.run(AbstractUpgrade.java:361)

5/20/21, 7:40 AM (admin)            at com.ca.ppm.database.upgrade.UpdateTeamAvailability.main(UpdateTeamAvailability.java:41)

5/20/21, 7:40 AM (admin) com.niku.dbtools.ant.ExecutableException: /opt/ppm/upgrade/15.9.2/component/postupgrade/database.xml:94: Java returned: 1

5/20/21, 7:40 AM (admin)            at com.niku.dbtools.ant.AntUtil.executeAntScript(AntUtil.java:109)

5/20/21, 7:40 AM (admin)            at com.niku.dbtools.ant.AntUtil.executeAntScript(AntUtil.java:84)

5/20/21, 7:40 AM (admin)            at com.niku.dbtools.Utilities.executeAntScript(Utilities.java:2409)

5/20/21, 7:40 AM (admin)            at com.niku.dbtools.Utilities.run(Utilities.java:2002)

5/20/21, 7:40 AM (admin)            at com.niku.dbtools.Utilities.main(Utilities.java:1055)

Environment

Release : 15.9.2

Component : CA PPM SAAS INSTALLATION AND UPGRADE

Cause

This is caused by a resource that is missing Availability being assigned to a Team Resource.

Resolution

This is DE61022, in review by Engineering

 

Workaround:

To identify the resources with the issue, run the query:

select sr.id Resource_id, sr.first_name Resource_name, tda.team_def_id Team_id,  sr2.last_name TEAM_NAME  from

prj_resources pr , srm_resources sr , team_def_allocations tda, srm_resources sr2 where pr.prid = sr.id and pr.prid = tda.resource_id 

and sr2.defined_team_id = tda.team_def_id and (nk_parse_curve_fct(pravailcurve)).default_rate < 1

 

 

If any resources are returned, connect to Clarity Classic - Resources

1. Find the Resource
2. Update the Availability field to a number, i.e. 8 (usually 8 or 7.5 will be default)
3. Save
4. Repeat for each resource
5. Stop services and restart the upgrade