CA Service Management

Expand all | Collapse all

coracleanup utility

Jump to Best Answer
  • 1.  coracleanup utility

    Posted 01-19-2015 10:04 AM

    Hi team,

    I'm trying to use coracleanup utility. I've implemented the patch, Java_Home seems to be correctly set up, but I still get some Java errors..

     

    Any experiences with this?

     

    Thanks,

    Jakub

     

    C:\>CORACLEANUP /DATABASE mdb /SERVER localhost /SCOPE all /METHOD reinit /TYPE

    sqlServer /USERNAME ServiceDesk /PASSWORD CAdemo123 /LOG full

     

     

    C:\>"c:\Program Files (x86)\CA\SC\JRE\1.6.0_30\bin\java" -cp .\corajava.jar;.\co

    rautil.jar;.\log4j-1.2.15.jar;.\ojdbc6.jar;.\sqljdbc4.jar com.ca.Cora.util.Conso

    leManager /DATABASE mdb /SERVER localhost /SCOPE all /METHOD reinit /TYPE sqlSer

    ver /USERNAME ServiceDesk /PASSWORD CAdemo123 /LOG full

    Exception in thread "main" java.lang.NoClassDefFoundError: com/ca/Cora/util/Cons

    oleManager

    Caused by: java.lang.ClassNotFoundException: com.ca.Cora.util.ConsoleManager

            at java.net.URLClassLoader$1.run(Unknown Source)

            at java.security.AccessController.doPrivileged(Native Method)

            at java.net.URLClassLoader.findClass(Unknown Source)

            at java.lang.ClassLoader.loadClass(Unknown Source)

            at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

            at java.lang.ClassLoader.loadClass(Unknown Source)

    Could not find the main class: com.ca.Cora.util.ConsoleManager.  Program will ex

    it.



  • 2.  Re: coracleanup utility

    Posted 01-19-2015 11:17 PM

    Hi Jakub,

     

    • Run coracleanup command in the command prompt from NX_ROOT/bin path.

     

    • Run coracleanup command without any arguments and note that /type accepts numbers not a string. Since it is a SQLSERVER, it should be “2” not “sqlServer”.


    • Edit the coracleanup.cmd file and verify the Java path.


    Thanks,

    Naveen



  • 3.  Re: coracleanup utility
    Best Answer

    Posted 01-20-2015 03:06 AM

    Like Naveen said you need to run the coracleanup from the path NX_ROOT/bin.

    after you have apply the patch the list of parameters has changed, this the new list

     

    Usage: ConsoleManager <argList> where argList is:

    /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>

     

     

    as you can see the /type argument is now integer value and the /log parameter doesn't exist any more. so your call should look like this

    CORACLEANUP /DATABASE mdb /SERVER localhost /SCOPE all /METHOD reinit /TYPE

    2 /USERNAME ServiceDesk /PASSWORD CAdemo123



  • 4.  Re: coracleanup utility

    Posted 01-20-2015 09:57 AM

    Hi Naveen and Aleksandar,

    thank you guys for your replies - everything seems to be OK now.

     

    Nice to be a part of the team!

     

    Jakub



  • 5.  Re: coracleanup utility

    Posted 09-17-2015 03:10 PM

    What patch did you run?

     

    I am trying to find the correct patch to install CORACLEANUP utility. No success so far.