Upgrade fails with ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

Products

• Clarity PPM On Premise

Issue/Introduction

During upgrade, we are hitting a failure. The error message is the following:
12/11/19 4:51 PM (ExecTask) Process - table: CMN_SCH_JOB_RUNS.xml
12/11/19 4:51 PM (ExecTask) 
12/11/19 4:51 PM (ExecTask) SQL Text:
12/11/19 4:51 PM (ExecTask) 
12/11/19 4:51 PM (ExecTask) ALTER TABLE CMN_SCH_JOB_RUNS MODIFY OUTPUT_PATH VARCHAR ( 1024 )
12/11/19 4:51 PM (ExecTask) 
12/11/19 4:51 PM (ExecTask) com.ca.clarity.jdbc.oraclebase.ddc: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

Note: This error can be on a different table as well, it will still be the same problem

Environment

Release : All supported Clarity releases

Resolution

This indicates that during the upgrade there was a query locking this table on database level so the install script could not upgrade it. 

To proceed:
1. Please rollback both files and database to previous version
2. Connect and pause all jobs 
3. If there are any Processing jobs please wait until they complete or cancel and delete them
4. Stop the services
5. Ask the DBA to confirm all Clarity sessions are stopped and nothing running on the database and nothing locking table CMN_SCH_JOB_RUNS
6. Restart the upgrade