cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
979
Views
0
Helpful
1
Replies

Cisco Configuration Professional and Monitor Controller Data Base wont start

sdoniger1
Level 1
Level 1

Using Cisco Config Pro,  I am able to manage our switch. 

 

The problem I am having is when I try to start the collector database.  I am running Win7 64bit.  Two separate Dos windows pop up with the following text.  I am running Java 7 Update 67.  Once the two DOS windows pop up,  it just goes back to asking to start the collector service and that the Database server used by collector service is stopped.  Reinstalling it doesn't help.

 

Help!

 

Thanks

 

Scott

 

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


C:\Program Files (x86)\Cisco Systems\CiscoCP\bin>cd c:
C:\Program Files (x86)\Cisco Systems\CiscoCP\bin

C:\Program Files (x86)\Cisco Systems\CiscoCP\bin>java  -Xmx512m -cp hsqldb.jar o
rg.hsqldb.server.Server --database.0 file:mydb --dbname.0 xdb
Picked up _JAVA_OPTIONS:
Error: Could not find or load main class org.hsqldb.server.Server

C:\Program Files (x86)\Cisco Systems\CiscoCP\bin>

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

 

and

 

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


C:\Program Files (x86)\Cisco Systems\CiscoCP\bin>java -Xmx512m -classpath c:\mys
ql-connector-java-3.1.10-bin.jar;c:\hsqldb.jar;c:\cmdsvc.jar;c:\cmdsvcx.jar;c:\c
ommons-httpclient-3.0.jar;c:\commons-logging-1.1.jar;c:\commons-codec-1.3.jar;c:
\IntfDataCollector.jar com.cisco.collector.InterfaceDataCollector
Picked up _JAVA_OPTIONS:
Start collector service...
java.sql.SQLException: java.net.ConnectException: Connection refused: connect
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
        at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at com.cisco.collector.DBConnection.getConnection(DBConnection.java:47)
        at com.cisco.collector.DBConnection.isTableExists(DBConnection.java:104)

        at com.cisco.collector.DBConnection.initializeDB(DBConnection.java:91)
        at com.cisco.collector.DBConnection.<init>(DBConnection.java:41)
        at com.cisco.collector.InterfaceDataCollector.refreshDeviceCollection(In
terfaceDataCollector.java:116)
        at com.cisco.collector.InterfaceDataCollector.run(InterfaceDataCollector
.java:95)
        at java.lang.Thread.run(Unknown Source)
java.sql.SQLException: java.net.ConnectException: Connection refused: connect
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
        at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at com.cisco.collector.DBConnection.getConnection(DBConnection.java:47)
        at com.cisco.collector.DBConnection.updateTable(DBConnection.java:73)
        at com.cisco.collector.DBConnection.initializeDB(DBConnection.java:92)
        at com.cisco.collector.DBConnection.<init>(DBConnection.java:41)
        at com.cisco.collector.InterfaceDataCollector.refreshDeviceCollection(In
terfaceDataCollector.java:116)
        at com.cisco.collector.InterfaceDataCollector.run(InterfaceDataCollector
.java:95)
        at java.lang.Thread.run(Unknown Source)
Exception in thread "Thread-1" java.lang.NullPointerException
        at com.cisco.collector.DBConnection.updateTable(DBConnection.java:75)
        at com.cisco.collector.DBConnection.initializeDB(DBConnection.java:92)
        at com.cisco.collector.DBConnection.<init>(DBConnection.java:41)
        at com.cisco.collector.InterfaceDataCollector.refreshDeviceCollection(In
terfaceDataCollector.java:116)
        at com.cisco.collector.InterfaceDataCollector.run(InterfaceDataCollector
.java:95)
        at java.lang.Thread.run(Unknown Source)

 

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

 

1 Reply 1

donkuliano
Level 1
Level 1

This one was a cracker :-) until i looked at the error very closely, all its saying is that it could not find the needed .jar file where its supposed to be. A search for the file actually does show that its not there....

you will find the actual path in that same command prompt. Copy and paste in the CPP GUI where it says "Installation path" note that this is actually the installation path of CPP. Then click on re-install. 

Everything should work fine.