Error while running the admin general upload-config command

Products

• Clarity PPM On Premise

Issue/Introduction

You get an error while running the admin general upload-config command. The properties.xml file is uploaded successfully though

STEPS TO REPRODUCE:

1. Run the following select statement against the Clarity DB
      SELECT * from cmn_config
2. You will notice there is an entry for the properties.xml file
3. On the Clarity server run the following command:
      admin general upload-config command

Expected Results: The command to be executed successfully and the properties.xml file to be uploaded to the DB
Actual Rsults: The command errors out, but the file is uploaded successfully.

Error in PostgreSQL:
09:21:25.931 [main] ERROR com.niku.union.persistence.PersistenceController - Error happened with error code:23505
Uploaded properties.xml

Error in MSSQL:
13:42:38.235 [main] ERROR com.niku.union.persistence.PersistenceController - Violation of PRIMARY KEY constraint 'CMN_CONFIG_PK'. Cannot insert duplicate key in object 'niku.CMN_CONFIG'. The duplicate key value is (properties.xml, [All]). 

Environment

Clarity 16.3.X

Cause

The upload command always does an insert to cmn_config, even if the file is already there. If the file is already there this will generate an error with a unique constraint violation in the PersistenceController.

After the insert then it does an update of the record. 

This is currently being reviewed by Engineering as part of DE173555

Resolution

This is a harmless error.

This is fixed in Clarity 16.4.0