XMC will not start smoothly

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
Below is the log that i am finding it every time. sometimes the netsight server will start via services manager after random attempts to start the server from services manager, but most of the time the server will not start and the page will not open in the browser.
kindly suggest the relevant java version to download in order for the netsight server to work (if thats the issue here), in windows services i can see netsight database and netsight server running along with other services, but server will not load/open.

2018-03-29 11:02:40,651 ERROR [com.enterasys.netsight.reporting.topn.util.TopNDbTableUtils] error updating topn data in database (More errors like this will not be logged): java.sql.SQLException: Table has no partition for value 1522303200000
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1192)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:442)
at com.enterasys.netsight.reporting.topn.util.TopNDbTableUtils.runPreparedSql(TopNDbTableUtils.java:315)
at com.enterasys.netsight.reporting.topn.util.TopNDbTableUtils.updateTable(TopNDbTableUtils.java:351)
at com.enterasys.netsight.reporting.topn.collector.db.TopNDbDataStoreImpl.storeData(TopNDbDataStoreImpl.java:37)
at com.enterasys.netsight.reporting.topn.collector.task.TopNCalculatorTask.run(TopNCalculatorTask.java:563)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Photo of Arjumand Qazi

Arjumand Qazi

  • 928 Points 500 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of Pala, Zdenek

Pala, Zdenek, Employee

  • 8,474 Points 5k badge 2x thumb
I suggest to open GTAC ticket with complete log.
It seems to me as some issue with the underlaying mySQL database.
Photo of Arjumand Qazi

Arjumand Qazi

  • 928 Points 500 badge 2x thumb
Hello Pala,

Just to eliminate the doubt i downloaded of XMC with new eval license.
i am still getting the same response which is, the netsight Database will load without any issue, after then via services manager if i try to start the Netsight server.. it will never get started and will give no warning or error.

Is there any step in installation that i have skipped but again i did installation 2 times, it didn't ask for anything which can have impact on server or database setting, or is it Windows 10 an issue here?
Photo of Arjumand Qazi

Arjumand Qazi

  • 928 Points 500 badge 2x thumb
Btw this time in the Log.. there was no error shown.