Connection unavailable error while Upgrading Clarity

Products

• Clarity PPM On Premise

Issue/Introduction

Clarity 15.9.1 to 15.9.3 fails during 15.9.2 step with a DB disconnection as follows:

The error as per install.log:

(ExecTask) Executing Ant script: c:\Clarity\upgrade\15.9.2\component\preupgrade\union.xml
(ExecTask) Script to create Delete access rights for all Custom Objects and CITs
(ExecTask) com.niku.dbtools.ant.ExecutableException: c:\Clarity\upgrade\15.9.2\component\preupgrade\union.xml:31: Java returned: 1
(ExecTask) Exception in thread "main" java.sql.SQLException: Connection unavailable

 (ExecTask) c:\Clarity\.setup\scripts\db.xml:2727: ERROR: Upgrade failed.  Please review the upgrade logs for details.

FATAL ..[main] union.persistence (clarity:admin:-1:none) Failed to initialize Context properties
java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-04088: error during execution of trigger 'SYS.LOGONAUDITING'
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 13

This time I have also found a detailed error in upgrade-ca.log:

FATAL ...16,866 [main] union.persistence (clarity:admin:-1:none) Failed to initialize Context properties
java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-04088: error during execution of trigger 'SYS.LOGONAUDITING'
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 13

Environment

Clarity 15.9.3

Resolution

Disable the DB side trigger ('SYS.LOGONAUDITING') and rerun the upgrade