When adding a new artifact, the following error is received:
After checking the RA's UI, there is no artifact found with this name.
Release Automation 6.7 and above
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
In order re add a deleted artifact, the name has to be changed.