ORA-01400 - NMC_PARTICIPANTS - Upgrade to 16.0.3 fails

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Upgrade to 16.0.3 fails with the following error in the install.log.

26/01/1950 7:00 AM (ExecTask) Process - post-upgrade: POSTUPGRADE_EXISTING_ROADMAP_PARTICIPANT_OWNERS.xml
26/01/1950 7:00 AM (ExecTask) java.sql.BatchUpdateException: error occurred during batching: ORA-01400: cannot insert NULL into ("someDB"."NMC_PARTICIPANTS"."USER_ID")
...
...
26/01/1950 7:00 AM (ExecTask) Caused by: java.sql.BatchUpdateException: error occurred during batching: ORA-01400: cannot insert NULL into ("someDB"."NMC_PARTICIPANTS"."USER_ID")
26/01/1950 7:00 AM (ExecTask) ORA-06512: at line 16
26/01/1950 7:00 AM (ExecTask) ORA-06512: at line 16

Environment

Version: 16.0.3

Cause

Team resources being marked as owners of Roadmaps.

Resolution

Pointing to named resources, before upgrading and then changing the reference if required.