Hi, this problem is pissing me off. I found "Unexpected server error" log message apperaing in the SEPM inteface every minute or even more often:
20. september 2016 09:52:47 CEST: Unexpected server error.
20. september 2016 09:52:46 CEST: Unexpected server error.
20. september 2016 09:50:07 CEST: Unexpected server error.
20. september 2016 09:50:06 CEST: Unexpected server error.
Live update is not working as well, I cannot get new definitions.
In stdout-0.log I can see that one the thread 31 failed to convert Number to string:
2016-09-19 14:41:57.656 THREAD 31 SEVERE: java.lang.NumberFormatException: For input string: "?0000023097144"
2016-09-19 14:41:57.656 THREAD 31 SEVERE: at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
2016-09-19 14:41:57.656 THREAD 31 SEVERE: at java.lang.Long.parseLong(Long.java:441)
2016-09-19 14:41:57.656 THREAD 31 SEVERE: at java.lang.Long.parseLong(Long.java:483)
2016-09-19 14:41:57.656 THREAD 31 SEVERE: at com.sygate.scm.util.StringUtilities.canConvertToLong(StringUtilities.java:241)
2016-09-19 14:41:57.656 THREAD 31 SEVERE: at com.sygate.scm.server.db.util.DatabaseUtilities.setUpPreparedStatementForOneColumn(DatabaseUtilities.java:1657)
2016-09-19 14:41:57.656 THREAD 31 SEVERE: at com.sygate.scm.server.db.util.DatabaseUtilities.setUpPreparedStatement(DatabaseUtilities.java:1584)
2016-09-19 14:41:57.656 THREAD 31 SEVERE: at com.sygate.scm.server.logreader.sep.BatchLogHandler.process(BatchLogHandler.java:204)
2016-09-19 14:41:57.656 THREAD 31 SEVERE: at com.sygate.scm.server.logreader.sep.LogHandler.process(LogHandler.java:153)
2016-09-19 14:41:57.656 THREAD 31 SEVERE: at com.sygate.scm.server.task.AgentLogCollector.enumerateInbox(AgentLogCollector.java:333)
2016-09-19 14:41:57.656 THREAD 31 SEVERE: at com.sygate.scm.server.task.AgentLogCollector.collectLogs(AgentLogCollector.java:176)
2016-09-19 14:41:57.656 THREAD 31 SEVERE: at com.sygate.scm.server.task.AgentLogCollector.execute(AgentLogCollector.java:139)
2016-09-19 14:41:57.656 THREAD 31 SEVERE: at com.sygate.scm.server.task.MonitoredTimerTask.run(MonitoredTimerTask.java:41)
2016-09-19 14:41:57.656 THREAD 31 SEVERE: at java.util.TimerThread.mainLoop(Timer.java:555)
2016-09-19 14:41:57.656 THREAD 31 SEVERE: at java.util.TimerThread.run(Timer.java:505)
At the same time in scm-server-0.log same thread throws execption "Connection refused: connect"
2016-09-20 09:54:48.574 THREAD 31 SEVERE: in: com.sygate.scm.server.db.util.SqlDbHelper
java.io.IOException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at java.net.Socket.connect(Socket.java:528)
at java.net.Socket.<init>(Socket.java:425)
at java.net.Socket.<init>(Socket.java:208)
at com.sygate.scm.server.util.SemLaunchService.sendCommand(SemLaunchService.java:645)
at com.sygate.scm.server.util.SemLaunchService.execute(SemLaunchService.java:230)
at com.sygate.scm.server.util.SemLaunchService.execute(SemLaunchService.java:317)
at com.sygate.scm.server.db.util.SqlDbHelper.excecuteBCPCommand(SqlDbHelper.java:404)
at com.sygate.scm.server.db.util.SqlDbHelper.bulkInsert(SqlDbHelper.java:148)
at com.sygate.scm.server.logreader.sep.LogHandler.process(LogHandler.java:139)
at com.sygate.scm.server.task.AgentLogCollector.enumerateInbox(AgentLogCollector.java:333)
at com.sygate.scm.server.task.AgentLogCollector.collectLogs(AgentLogCollector.java:176)
at com.sygate.scm.server.task.AgentLogCollector.execute(AgentLogCollector.java:139)
at com.sygate.scm.server.task.MonitoredTimerTask.run(MonitoredTimerTask.java:41)
at java.util.TimerThread.mainLoop(Timer.java:555)
at java.util.TimerThread.run(Timer.java:505)
We are running 12.1.7004.6500 version of SEPM.
How to fix the problem?