How to apply the CORACLEANUP?

Document ID : KB000107855
Last Modified Date : 25/07/2018
Show Technical Document Details
Question:
How to apply the CORACLEANUP?
Environment:
CA Service Desk Manager 14.1.x
Answer:
1 - Unzip the file T5N6346.caz using the CAZIPXP;
2 - Once extracted open the file "T5N6346_SD.jcl" and locate the section:
Release: 12.7
3 - You should adjust this for your SDM version:
Release: 12.9 or 14.1
4 - Stop all SDM services, including IIS.
5 - Then use APPLYPTF to apply the correction, but instead of pointing to the file CAZ, point to the file "T5N6346_SD.jcl";
6 - Open a command prompt run java -version
7 - Create the variable JAVA_HOME:
C:\PROGRA~2\CA\SC\JRE\1.7.0_10
8 - Edit the PATH variable and add the following in the end:
;%JAVA_HOME%\bin
9 - Restart all SDM services, including IIS
10 - Open a new command prompt as Administrator and run Coracleanup from the NX_ROOT/bin directory
coracleanup.cmd /SERVER <server_name> /TYPE 3 /USERNAME sa /PASSWORD <password> /SCOPE USD /METHOD REINIT /DATABASE mdb

About the command fields:

/SERVER <database servername> (REQUIRED)
/TYPE [2 (MSSQL) |3 (Oracle) ] (REQUIRED)
/USERNAME <database username> (REQUIRED)
/PASSWORD <database password> (REQUIRED)
/SCOPE [USD| NSM| DSM| SPM| ALL] (REQUIRED)
/METHOD [REINIT| DELETE| APITEST| PRODTEST| UPDTEST| REPAIR] (REQUIRED)
/DATABASE <MSSQL database name> (REQUIRED FOR MSSQL)
/INSTANCE <server instance> (REQUIRED FOR ORACLE)
/DBOWNER <database owner (if different from database username)>
/PORT <jdbc port if not using DBMS default port>