Client Automation - Software Delivery cleanup procedure

book

Article ID: 38537

calendar_today

Updated On:

Products

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

Issue/Introduction

During the course of administering CA Client Automation you may run into issues where software jobs may hang or become corrupt. If this happens a manual cleanup may be required.  This document outlines the Software Delivery/Data Transport Service cleanup procedure (AKA SDO/DTS cleanup) required to correct these issues.

Environment

All Supported Windows operating systems
All Supported CA Client Automation versions 
 

Resolution

This document is divided into two sections one set of directions for the Domain manager and the other for the Scalability Server. It is recommended that both are done at the same time. 

Domain Manager


1. Delete or unseal any Job Containers currently active. (Very Important and not optional)

2. Stop CAF (CAF STOP) 

3. Run 'cam change disabled' 

4. Run 'camclose'

5. Run 'csampmux stop'

6. Delete all the files and folders in the "%sdroot%\asm\d" folder.

7. Delete all the files and folders in the "%sdroot%\asm\library\activate" except the scripts folder, the lgzip folder and scripts.zip. 
(Note: You should never do this if there are ANY active job containers!)

8. Delete all the files in the "..\CA\DSM\DTS\DTA\Staging" folder.

9. Make sure that  "..\CA\DSM\DTS\DTA\Status" folder contains only a zero-length file called 'Index' with no extension.

10. If the file 'INDEX' exists and is larger than '0 kb' then open it with notepad, perform 'select all', delete the content and then save. (It's ok if it shows as 1kb at this point) 

11. Delete the file "cfnotsrvd.dat" from the "..\CA\DSM\appdata" folder.

12. Create a folder called "CLEANSTART" in the "%SDROOT%\ASM\DATABASE\ftm_journals" folder.


13. Browse to "..\CA\DSM\ServerDB\SWJORDER" and delete all folders and .cof files, except .XML files.

14. Run 'csampmux start'

15. Run 'cam change auto & cam start -c -l'

16. Run 'caf start'

17. Confirm that the "CLEANSTART" folder created in step #11 has been deleted by the system now.
 

Scalability Server


1. Stop CAF (CAF STOP) 

2. Run 'cam change disabled' 

3. Run 'camclose'

4. Run 'csampmux stop'

5. Delete all the files and folders in the "%sdroot%\asm\d" folder.

6. Delete all the files and folders in the "%sdroot%\asm\library\activate" except the scripts folder, the lgzip folder and scripts.zip. 
(Note: You should never do this if there are ANY active job containers!)


7. Delete all the files in the "\CA\DSM\DTS\DTA\Staging" folder.

8. Delete all the files in the "\CA\DSM\DTS\DTA\Status" folder.

9. Browse to "..\CA\DSM\ServerDB\SWJORDER" and delete all folders and .cof files, except .XML files.

10. Run 'csampmux start'

11. Run 'cam change auto & cam start -c -l'

12. Run 'caf start'

Additional Information

In addition to the cleanup of the files, attached is a script to cleanup the USD database tables. The script should help get rid of any anomalies in the USD tables. 
 

For information on Supported Windows and CA Client Automation versions please look at the Compatibility Matrix at the below link:

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/clarity-client-automation/14-0/Supportability-Matrix-1.html

Attachments

1558534339796USD_Manual_Database_CleanUpScript.zip get_app