Upgrade Fails With Generic Error: _dbBackupCheck Task "nsql" finished with error
search cancel

Upgrade Fails With Generic Error: _dbBackupCheck Task "nsql" finished with error

book

Article ID: 279255

calendar_today

Updated On: 02-13-2024

Products

Clarity PPM On Premise

Issue/Introduction

As soon as the prompt for making a back up of the database is displayed, the installation fails.

The install.log shows only:

2/12/24 12:44 PM (ReleaseUtilityTask) Current version: 15.9.3.740
2/12/24 12:44 PM (ReleaseUtilityTask) Upgrading to:    16.0.3.1009

2/12/24 12:44 PM (Expand) Expanding: D:\16.0.3\install-packages\16.0.0\upgrade-repack.16.0.0.890tpexcludes.jar into D:\16.0.3\install-packages\16.0.0\upgrade-repack.16.0.0.890tpexcludes
2/12/24 12:44 PM (Expand) Expanding: D:\16.0.3\install-packages\16.0.1\upgrade-repack.16.0.1.838tpexcludes.jar into D:\16.0.3\install-packages\16.0.1\upgrade-repack.16.0.1.838tpexcludes
2/12/24 12:44 PM (Expand) Expanding: D:\16.0.3\install-packages\16.0.2\upgrade-repack.16.0.2.861tpexcludes.jar into D:\16.0.3\install-packages\16.0.2\upgrade-repack.16.0.2.861tpexcludes
2/12/24 12:45 PM (Project) Trying to override old definition of task java
2/12/24 12:45 PM (Target) Target "init" started.
2/12/24 12:45 PM (Target) Target "init" finished.
2/12/24 12:45 PM (Target) Target "_dbBackupCheck" started.
2/12/24 12:45 PM (Echo)   CA PPM upgrade from 15.9.3 to 16.0.3 detected.
2/12/24 12:45 PM (Echo)     
2/12/24 12:45 PM (UnknownElement) Task "nsql" finished with error.
org.apache.tools.ant.BuildException: java.lang.NullPointerException
              at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:116) ~[ant.jar:?]
              at org.apache.tools.ant.Task.perform(Task.java:348) ~[ant.jar:1.9.4]
              at com.niku.tools.taskdefs.IfTask.execute(IfTask.java:219) ~[tools.jar:?]
              at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
              at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
              at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
              at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]

Resolution

Check the version of the database that the Clarity database was restored to with the following commands:

MSSQL: select @@version
Oracle: select * from v$version
PostgreSQL: SELECT version()

The version must be a supported product/version listed in the Clarity Hardware and Software Compatibility Specifications