coracleanup utility

[Anon Anon]

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.

[Anon Anon]

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

[Aleksandar Stancic]

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

[Anon Anon]

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

[Fabian Basoalto]

Hello, somebody can help with this error??

Best regards,
Fabian

------------------------------
[Designation]
[City]
------------------------------

[Brian Mathato]

Hi Fabiano,

What is the OS, JRE\Java and SDM versions for your environment?

------------------------------
Kind Regards,
Brian
------------------------------

[Legacy User]

What patch did you run?

 

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