Thousands of .rcp directories under LIBRARY directory. How to remove them ?

Products

• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Software Delivery

Issue/Introduction

In CA Client Automation on the Domain Manager there are thousands of .rcp directories

under \CA\DSM\SD\ASM\LIBRARY.

Is it safe to delete them or which ones could be deleted ?

 

Environment

CA Client Automation - All Versions

Cause

On Domain Manager there are thousands of .rcp directories under \CA\DSM\SD\ASM\LIBRARY.

These directories are empty.

Is it safe to delete them or which ones could be deleted ?

Example :

 

Resolution

The directories .rcp are associated with SD procedures of packages.

It is possible to find the name of one SD procedure and package from directory name using a SQL Query :

 

SELECT convert(uniqueidentifier, a.objectid),r.itemname, r.itemversion, a.itemname

FROM usd_actproc a, usd_rsw r

WHERE a.rsw=r.objectid and convert(uniqueidentifier, a.objectid)='<directoryname>'

 

Example :

For directory 297E427F-39E7-4F7D-978F-1F81715EFC5B.rcp the query is :

SELECT convert(uniqueidentifier, a.objectid),r.itemname, r.itemversion, a.itemname

FROM usd_actproc a, usd_rsw r

WHERE a.rsw=r.objectid and convert(uniqueidentifier, a.objectid)='297E427F-39E7-4F7D-978F-1F81715EFC5B'

 

 

But sometimes a lot of directories .rcp could have no link with a SD procedure in database anymore.

In this case it is safe to delete these directories.

 

The script clean_rcp.bat could be use to find which directories .rcp have no link with a SD procedure in database and delete it.

Download the attached clean_rcp_script.zip.

 

Rename clean_rcp.bat.txt as clean_rcp.bat and copy it on Domain Manager.

 

Here is the syntax of this script :

 

Syntax :

-------- 

clean_rcp.bat [Servername[\InstanceName]] [user] [password] 

 

Parameters : 

------------ 

servername\InstanceName : Servername and InstanceName of SQL db. If missing localhost is used 

user : user for db. If missing trusted connection is used.

password : password of user to access the database

 

Examples : 

---------- 

clean_rcp.bat 

clean_rcp.bat SQLDB 

clean_rcp.bat SQLDB\INST1 sa pwdsa

 

Example :