1. Created the Artifact Type : ABC-ABC.DEF
2. Added Artifact definitions like Build and Config
3. Our Jenkins build added some Build files under the Artifact definitions
When we tried to deploy, it failed as it was looking for Artifact Type name format like ABC-Abc.Def (case sensitive) instead of ABC-ABC.DEF.
So we deleted the artifact Type and artifact definitions from ROC. and try to add the new artifact type ABC-Abc.Def.
But it does not allow us to create with the name ABC-Abc.Def and said already exist as below.
We followed the below article for deleting from the database
Release Automation KB: Delete Artifact Types and Definitions .
But we could not delete artifact_type and artifact_definition and we get the below Error.(REFERENCE constraint Error)
Need help on how to remove this Artifact Type very safely in this scenario ?
Msg 547, Level 16, State 0, Line 1
The DELETE statement conflicted with the REFERENCE constraint "FKA85A0DE075A7A68B". The conflict occurred in database "Nolio_DB", table "dbo.artifact_definition", column 'artifactType_id'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 1
The DELETE statement conflicted with the REFERENCE constraint "FKCA4C74531FDE38DB". The conflict occurred in database "Nolio_DB", table "dbo.rc_artifacts", column 'artifactDefinition'.
The statement has been terminated.