Video Screencast Help

Clients won't connect to Manager, can't log into console

Created: 28 Nov 2012 • Updated: 28 Nov 2012 | 6 comments

Windows 2003 Standard R2, 32-bit
Version: Symantec Endpoint Protection 11.0 (11.0.7200.1147)
Database User: DBA

Hi, since I installed SEPM, I can't manage the computers from the console, if I try, SEPM show me the following message:
some of the selected clients have not yet connected to the server. you cannot do ....

This this the results of the Symantec Endpoint Protection Support Tool

Error No applications are using 's configured port 8005 with a state of 'Listen'.
Information IIS location /LM/W3SVC/2 is not configured for SSL

The 8005 port is open.

This is the scm-server-1.log
2012-11-27 17:17:19.559 GRAVE: ================== Server Environment ===================
2012-11-27 17:17:19.559 GRAVE: os.name = Windows 2003
2012-11-27 17:17:19.559 GRAVE: os.version = 5.2
2012-11-27 17:17:19.559 GRAVE: os.arch = x86
2012-11-27 17:17:19.559 GRAVE: java.version = 1.6.0_31
2012-11-27 17:17:19.559 GRAVE: java.vendor = Sun Microsystems Inc.
2012-11-27 17:17:19.559 GRAVE: java.vm.name = Java HotSpot(TM) Server VM
2012-11-27 17:17:19.559 GRAVE: java.vm.version = 20.6-b01
2012-11-27 17:17:19.574 GRAVE: java.home = C:\Program Files\Symantec\Symantec Endpoint Protection Manager\jre
2012-11-27 17:17:19.574 GRAVE: catalina.home = C:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat
2012-11-27 17:17:19.574 GRAVE: java.user = null
2012-11-27 17:17:19.574 GRAVE: user.language = es
2012-11-27 17:17:19.574 GRAVE: user.country = VE
2012-11-27 17:17:19.574 GRAVE: scm.server.version = 11.0.7200.1147
2012-11-27 17:17:29.996 GRAVE: ================== StartClientTransport ===================
2012-11-27 17:17:31.856 GRAVE: Schedule is started!
2012-11-27 17:46:12.799 GRAVE: Unknown Exception
java.sql.SQLException: JZ006: Se ha detectado IOException: java.net.ConnectException: Connection timed out: connect
 at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:557)
 at com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:861)
 at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3967)
 at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3912)
 at com.sybase.jdbc2.tds.Tds.login(Tds.java:440)
 at com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:254)
 at com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:230)
 at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:200)
 at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:134)
 at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)
 at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
 at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
 at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1181)
 at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
 at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:291)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:282)
 at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:985)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:958)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:993)
 at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:1020)
 at com.sygate.scm.server.metadata.MetadataManager.getMetadataAttributes(MetadataManager.java:265)
 at com.sygate.scm.server.configmanager.ConfigManager.getTopLevelObject(ConfigManager.java:328)
 at com.sygate.scm.server.configmanager.ConfigManager.getSemLocalSettings(ConfigManager.java:2290)
 at com.sygate.scm.server.task.ScheduledReportingHelper.isReportingServer(ScheduledReportingHelper.java:210)
 at com.sygate.scm.server.task.SecurityAlertNotifyTask.run(SecurityAlertNotifyTask.java:280)
 at java.util.TimerThread.mainLoop(Timer.java:512)
 at java.util.TimerThread.run(Timer.java:462)
2012-11-27 17:46:15.783 GRAVE: Unexpected server error. in: com.sygate.scm.server.task.SecurityAlertNotifyTask
com.sygate.scm.server.metadata.MetadataException:
 at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:987)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:958)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:993)
 at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:1020)
 at com.sygate.scm.server.metadata.MetadataManager.getMetadataAttributes(MetadataManager.java:265)
 at com.sygate.scm.server.configmanager.ConfigManager.getTopLevelObject(ConfigManager.java:328)
 at com.sygate.scm.server.configmanager.ConfigManager.getSemLocalSettings(ConfigManager.java:2290)
 at com.sygate.scm.server.task.ScheduledReportingHelper.isReportingServer(ScheduledReportingHelper.java:210)
 at com.sygate.scm.server.task.SecurityAlertNotifyTask.run(SecurityAlertNotifyTask.java:280)
 at java.util.TimerThread.mainLoop(Timer.java:512)
 at java.util.TimerThread.run(Timer.java:462)
Caused by: java.sql.SQLException: JZ006: Se ha detectado IOException: java.net.ConnectException: Connection timed out: connect
 at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:557)
 at com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:861)
 at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3967)
 at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3912)
 at com.sybase.jdbc2.tds.Tds.login(Tds.java:440)
 at com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:254)
 at com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:230)
 at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:200)
 at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:134)
 at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)
 at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
 at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
 at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1181)
 at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
 at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:291)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:282)
 at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:985)
 ... 10 more
com.sygate.scm.server.util.ServerException: Unexpected server error.
 at com.sygate.scm.server.configmanager.ConfigManager.getTopLevelObject(ConfigManager.java:370)
 at com.sygate.scm.server.configmanager.ConfigManager.getSemLocalSettings(ConfigManager.java:2290)
 at com.sygate.scm.server.task.ScheduledReportingHelper.isReportingServer(ScheduledReportingHelper.java:210)
 at com.sygate.scm.server.task.SecurityAlertNotifyTask.run(SecurityAlertNotifyTask.java:280)
 at java.util.TimerThread.mainLoop(Timer.java:512)
 at java.util.TimerThread.run(Timer.java:462)
Caused by: com.sygate.scm.server.metadata.MetadataException:
 at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:987)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:958)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:993)
 at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:1020)
 at com.sygate.scm.server.metadata.MetadataManager.getMetadataAttributes(MetadataManager.java:265)
 at com.sygate.scm.server.configmanager.ConfigManager.getTopLevelObject(ConfigManager.java:328)
 ... 5 more
Caused by: java.sql.SQLException: JZ006: Se ha detectado IOException: java.net.ConnectException: Connection timed out: connect
 at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:557)
 at com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:861)
 at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3967)
 at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3912)
 at com.sybase.jdbc2.tds.Tds.login(Tds.java:440)
 at com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:254)
 at com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:230)
 at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:200)
 at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:134)
 at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)
 at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
 at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
 at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1181)
 at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
 at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:291)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:282)
 at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:985)
 ... 10 more
2012-11-27 17:46:21.283 GRAVE: Unknown Exception
java.sql.SQLException: JZ006: Se ha detectado IOException: java.net.ConnectException: Connection timed out: connect
 at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:557)
 at com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:861)
 at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3967)
 at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3912)
 at com.sybase.jdbc2.tds.Tds.login(Tds.java:440)
 at com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:254)
 at com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:230)
 at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:200)
 at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:134)
 at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)
 at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
 at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
 at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1181)
 at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
 at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:291)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:282)
 at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:985)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:958)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:993)
 at com.sygate.scm.server.db.util.DbHelper.getInstance(DbHelper.java:65)
 at com.sygate.scm.server.db.util.DbHelper.getInstance(DbHelper.java:55)
 at com.sygate.scm.server.task.AgentLogCollector.run(AgentLogCollector.java:91)
 at java.util.TimerThread.mainLoop(Timer.java:512)
 at java.util.TimerThread.run(Timer.java:462)
2012-11-27 17:46:21.283 GRAVE: Unknown Exception
com.sygate.scm.server.metadata.MetadataException:
 at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:987)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:958)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:993)
 at com.sygate.scm.server.db.util.DbHelper.getInstance(DbHelper.java:65)
 at com.sygate.scm.server.db.util.DbHelper.getInstance(DbHelper.java:55)
 at com.sygate.scm.server.task.AgentLogCollector.run(AgentLogCollector.java:91)
 at java.util.TimerThread.mainLoop(Timer.java:512)
 at java.util.TimerThread.run(Timer.java:462)
Caused by: java.sql.SQLException: JZ006: Se ha detectado IOException: java.net.ConnectException: Connection timed out: connect
 at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:557)
 at com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:861)
 at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3967)
 at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3912)
 at com.sybase.jdbc2.tds.Tds.login(Tds.java:440)
 at com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:254)
 at com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:230)
 at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:200)
 at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:134)
 at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)
 at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
 at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
 at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1181)
 at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
 at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:291)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:282)
 at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:985)
 ... 7 more
2012-11-27 17:46:21.283 GRAVE: Unknown Exception in: com.sygate.scm.server.task.AgentLogCollector
java.lang.NullPointerException
 at com.sygate.scm.server.task.AgentLogCollector.run(AgentLogCollector.java:92)
 at java.util.TimerThread.mainLoop(Timer.java:512)
 at java.util.TimerThread.run(Timer.java:462)
2012-11-27 17:46:21.955 GRAVE: Unknown Exception
java.sql.SQLException: JZ006: Se ha detectado IOException: java.net.ConnectException: Connection timed out: connect
 at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:557)
 at com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:861)
 at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3967)
 at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3912)
 at com.sybase.jdbc2.tds.Tds.login(Tds.java:440)
 at com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:254)
 at com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:230)
 at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:200)
 at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:134)
 at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)
 at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
 at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
 at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1181)
 at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
 at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:291)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:282)
 at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:985)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:958)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:993)
 at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:1020)
 at com.sygate.scm.server.metadata.MetadataManager.getMetadataAttributes(MetadataManager.java:265)
 at com.sygate.scm.server.configmanager.ConfigManager.getTopLevelObject(ConfigManager.java:328)
 at com.sygate.scm.server.configmanager.ConfigManager.getSemLocalSettings(ConfigManager.java:2290)
 at com.sygate.scm.server.task.ScheduledReportingHelper.isReportingServer(ScheduledReportingHelper.java:210)
 at com.sygate.scm.server.task.ScheduledReportingTask.run(ScheduledReportingTask.java:98)
 at java.util.TimerThread.mainLoop(Timer.java:512)
 at java.util.TimerThread.run(Timer.java:462)
2012-11-27 17:46:21.955 GRAVE: Unexpected server error. in: com.sygate.scm.server.task.ScheduledReportingTask
com.sygate.scm.server.metadata.MetadataException:
 at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:987)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:958)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:993)
 at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:1020)
 at com.sygate.scm.server.metadata.MetadataManager.getMetadataAttributes(MetadataManager.java:265)
 at com.sygate.scm.server.configmanager.ConfigManager.getTopLevelObject(ConfigManager.java:328)
 at com.sygate.scm.server.configmanager.ConfigManager.getSemLocalSettings(ConfigManager.java:2290)
 at com.sygate.scm.server.task.ScheduledReportingHelper.isReportingServer(ScheduledReportingHelper.java:210)
 at com.sygate.scm.server.task.ScheduledReportingTask.run(ScheduledReportingTask.java:98)
 at java.util.TimerThread.mainLoop(Timer.java:512)
 at java.util.TimerThread.run(Timer.java:462)
Caused by: java.sql.SQLException: JZ006: Se ha detectado IOException: java.net.ConnectException: Connection timed out: connect
 at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:557)
 at com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:861)
 at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3967)
 at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3912)
 at com.sybase.jdbc2.tds.Tds.login(Tds.java:440)
 at com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:254)
 at com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:230)
 at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:200)
 at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:134)
 at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)
 at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
 at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
 at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1181)
 at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
 at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:291)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:282)
 at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:985)
 ... 10 more
com.sygate.scm.server.util.ServerException: Unexpected server error.
 at com.sygate.scm.server.configmanager.ConfigManager.getTopLevelObject(ConfigManager.java:370)
 at com.sygate.scm.server.configmanager.ConfigManager.getSemLocalSettings(ConfigManager.java:2290)
 at com.sygate.scm.server.task.ScheduledReportingHelper.isReportingServer(ScheduledReportingHelper.java:210)
 at com.sygate.scm.server.task.ScheduledReportingTask.run(ScheduledReportingTask.java:98)
 at java.util.TimerThread.mainLoop(Timer.java:512)
 at java.util.TimerThread.run(Timer.java:462)
Caused by: com.sygate.scm.server.metadata.MetadataException:
 at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:987)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:958)
 at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:993)
 at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:1020)
 at com.sygate.scm.server.metadata.MetadataManager.getMetadataAttributes(MetadataManager.java:265)
 at com.sygate.scm.server.configmanager.ConfigManager.getTopLevelObject(ConfigManager.java:328)
 ... 5 more
Caused by: java.sql.SQLException: JZ006: Se ha detectado IOException: java.net.ConnectException: Connection timed out: connect
 at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:557)
 at com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:861)
 at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3967)
 at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3912)
 at com.sybase.jdbc2.tds.Tds.login(Tds.java:440)
 at com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:254)
 at com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:230)
 at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:200)
 at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:134)
 at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)
 at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
 at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
 at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1181)
 at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
 at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:291)
 at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:282)
 at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:985)
 ... 10 more
2012-11-28 09:10:18.218 GRAVE: Schedule is stopped!

Somebody can help me here?

Thanks a lot.

Comments 6 CommentsJump to latest comment

.Brian's picture

Is the SEPM service running? Can you try restarting...

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

sandra.g's picture

2012-11-27 17:17:29.996 GRAVE: ================== StartClientTransport ===================
2012-11-27 17:17:31.856 GRAVE: Schedule is started!
2012-11-27 17:46:12.799 GRAVE: Unknown Exception
java.sql.SQLException: JZ006: Se ha detectado IOException: java.net.ConnectException: Connection timed out: connect

 at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:557)
 at com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:861)
 at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3967)

...

Looks like the database connection is timing out.

  • Is this the embedded database, with default values otherwise? (never mind about SQL, just saw "sybase" in the quoted text smiley)
  • Any associated Windows Event IDs?
  • Does the SEPM service stay running? What about the database service?

The file scm-server-0 log will have the most recent logging. Or is all the same error, repeating, like it is here?

sandra

Symantec, Information Developer
Installation, Migration, Deployment and Patching
User Protection & Productivity, Endpoint Protection

Don't forget to mark your thread as 'solved' with the answer that best help

pete_4u2002's picture

its related to DB connection timeout, is there sufficient space on the machine? is the DB service started?

ddtx2's picture

Thanks for the info,

 

Sandra:

this is the scm-server-0 log most recent:

2012-11-28 09:14:09.861 GRAVE: ================== Server Environment ===================
2012-11-28 09:14:09.861 GRAVE: os.name = Windows 2003
2012-11-28 09:14:09.861 GRAVE: os.version = 5.2
2012-11-28 09:14:09.861 GRAVE: os.arch = x86
2012-11-28 09:14:09.877 GRAVE: java.version = 1.6.0_31
2012-11-28 09:14:09.877 GRAVE: java.vendor = Sun Microsystems Inc.
2012-11-28 09:14:09.877 GRAVE: java.vm.name = Java HotSpot(TM) Server VM
2012-11-28 09:14:09.877 GRAVE: java.vm.version = 20.6-b01
2012-11-28 09:14:09.877 GRAVE: java.home = C:\Program Files\Symantec\Symantec Endpoint Protection Manager\jre
2012-11-28 09:14:09.877 GRAVE: catalina.home = C:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat
2012-11-28 09:14:09.877 GRAVE: java.user = null
2012-11-28 09:14:09.877 GRAVE: user.language = es
2012-11-28 09:14:09.877 GRAVE: user.country = VE
2012-11-28 09:14:09.877 GRAVE: scm.server.version = 11.0.7200.1147
2012-11-28 09:14:36.907 GRAVE: ================== StartClientTransport ===================
2012-11-28 09:14:40.370 GRAVE: Schedule is started!
 

I attached the print sceen with the services running and the event viewer.

Pete:

The server currently has 9.18Gb of free space, however, since this is a small office and I just begun the test with a few pcs (actually, it's only one running the client) I think this should be enough (IMHO)

 

services.JPG Event Viewer.JPG
sandra.g's picture

If you're using the embedded database then the SQL errors shouldn't have any bearing, unless both are conflicting with each other in some way, or the system resources (particularly and especially RAM) are maxed out.

sandra

Symantec, Information Developer
Installation, Migration, Deployment and Patching
User Protection & Productivity, Endpoint Protection

Don't forget to mark your thread as 'solved' with the answer that best help