Release Automation

Hi,

I have an Artifact Definition that claims to have been Archived. I can see this in an Artifact Package as being the case. How do I un-archive it?

The definition is not visible under the Artifact Type and it's confusing to know it is there but not see it or change it - which I would like to do.

The only way to “unarchive” the artifact is to change the status in the backend database table. I think the table name is artifact or artifact_definition (or something to that effect! )

Thanks & Regards

Prasanna

A word of caution: CA does not support manually editing RA data stored in the database. While this may be possible, it is not intended, and may cause system instability.

Presently RA is not designed to allow a user to remove an artifact definition once it is archived. Please refer to the following KB for more details: Release Automation KB: Delete Artifact Types and Definitions.

Hi,

I actually do not want to delete it. I want to un-archive it so that I can edit it. I want to:

1) see it in the artifact definition table - even archived definitions should be visible so that you know not to try and recreate it

2) maybe modify the server type scope

If I can un-archive it by attacking the database I will. Did the definition change table, or was a flag added for archive status?

Thanks

Hi Andrew,

It looks like a flag was added for archive status. I'm not sure if there is anything else needed (and I suppose this isn't technically supported without further confirmation from engineering), but I did confirm that the query provided below will make the artifact visible in the UI again.

UPDATE "NOLIO"."RC_ARTIFACTS" SET DELETED = '0' WHERE ID = '<the artifact id that you're interested in>'

You can get the ID using the query: SELECT * FROM RC_ARTIFACTS where ARTIFACT_VERSION = '<the string used for your artifact version>'

I was able to track it down using the Oracle Search All Query found in this post: http://stackoverflow.com/questions/208493/search-all-fields-in-all-tables-for-a-specific-value-oracle?lq=1

Cheers,

Gregg

We received confirmation that this is not officially supported. If it is an important feature then I would recommend creating an Idea. If anyone does create an Idea for this feature then please post the link here for anyone that comes across this discussion and is interested in voting for the Idea.

Noticed Restore archived artifact was created today. If this is what you're looking for, be sure to go vote it up.