We missed to upgrade our repository form 220.127.116.11 to higher version when we upgraded our NAC all the way to 18.104.22.1686. Due to this somewhere we encountered some issue that we now have some corrupt action packs, in our RA database, nexus repository and actionslib on NAC with "*.tmp" and we want to get rid of same.
Can you suggest how to clean the same?
Release : 6.X
Component : CA RELEASE AUTOMATION REPOSITORY
Cleaning corrupt data on actionslib and Nexus repository
Cleaning corrupt data from DB (compatible for SQL/Oracle)
select * from action_packs where name like '%.tmp' and file_name like '%.tmp';
delete from action_packs where name like '%.tmp' and file_name like '%.tmp'
In case of any failure, the backup of DB, NAC and Repository need to be restored and please contact Technical Support.