Error "Artifact defintion with this name already exists" received while adding a new artifact

Products

• CA Release Automation - Release Operations Center (Nolio)

Issue/Introduction

When adding a new artifact, the following error is received:

After checking the RA's UI, there is no artifact found with this name.

Environment

Release Automation 6.7 and above

Cause

This error is caused because previously there was an artifact with this same name which was deleted. When an artifact is deleted from the UI, actually it's a soft delete, the database keeps a record of this artifact.

In order to check the artifacts currently found in the database, the following query can be executed:

select
  app.app_name as application_name,
  ad.name as art_definition,
  at.name as artifact_type_name,
  count(ad.name) as total_occurrence
from artifact_definition as ad
  join applications as app
    on app.id = ad.applicationId
  join artifact_type as at
    on at.id = ad.artifactType_id
group by
  app.app_name,
  at.name,
  ad.name

Resolution

In order re add a deleted artifact, the name has to be changed.