I have four locations running SEPM that are configured to replicate data between the locations. All sites were working fine and replication was working fine. The main location had a SQL server so we leveraged SQL for the database at the main location. All branch locations just use the embedded database. Everything was fine until our SQL service account was "accidentally" deleted. And before we knew what happened, the account was recreated rather than restored. Obviously this wrecked SQL. We finally got everything sorted out on the SQL side and accounts are working and can successfully logon to all databases from within the SQL Management Studio. However, we continue to ge the "Unexpected Server Error" when attempting to logon to the SEPM console at the main location. All branch locations can still logon without issues but obviously replication is still broken. Here is the output from the scm-server-0.log file:
2015-07-06 11:43:58.550 THREAD 12 SEVERE: ================== Server Environment ===================
2015-07-06 11:43:58.550 THREAD 12 SEVERE: os.name = Windows Server 2012 R2
2015-07-06 11:43:58.550 THREAD 12 SEVERE: os.version = 6.3
2015-07-06 11:43:58.550 THREAD 12 SEVERE: os.arch = x64
2015-07-06 11:43:58.550 THREAD 12 SEVERE: java.version = 1.7.0_55
2015-07-06 11:43:58.550 THREAD 12 SEVERE: java.vendor = Oracle Corporation
2015-07-06 11:43:58.550 THREAD 12 SEVERE: java.vm.name = Java HotSpot(TM) Server VM
2015-07-06 11:43:58.550 THREAD 12 SEVERE: java.vm.version = 24.55-b03
2015-07-06 11:43:58.550 THREAD 12 SEVERE: java.home = C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\jre
2015-07-06 11:43:58.550 THREAD 12 SEVERE: catalina.home = C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat
2015-07-06 11:43:58.550 THREAD 12 SEVERE: java.user = null
2015-07-06 11:43:58.550 THREAD 12 SEVERE: user.language = en
2015-07-06 11:43:58.550 THREAD 12 SEVERE: user.country = US
2015-07-06 11:43:58.550 THREAD 12 SEVERE: scm.server.version = 12.1.5337.5000
2015-07-06 11:44:17.863 THREAD 12 SEVERE:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The SELECT permission was denied on the object 'CONNECTION_TEST', database 'sem5', schema 'dbo'.)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDataSourceDBConnection(DatabaseUtilities.java:453)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:333)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:317)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:307)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDBConnection(DatabaseUtilities.java:2827)
at com.sygate.scm.server.db.util.DatabaseUtilities.testConnection(DatabaseUtilities.java:2765)
at com.sygate.scm.server.servlet.StartupServlet.init(StartupServlet.java:113)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1279)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1192)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1087)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5210)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5493)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:670)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1839)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: The SELECT permission was denied on the object 'CONNECTION_TEST', database 'sem5', schema 'dbo'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1427)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:658)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1558)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
... 25 more
2015-07-06 11:44:17.878 THREAD 43 SEVERE: DatabasePing> run>> Trying to connect database...
2015-07-06 11:44:40.413 THREAD 54 SEVERE:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The SELECT permission was denied on the object 'CONNECTION_TEST', database 'sem5', schema 'dbo'.)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDataSourceDBConnection(DatabaseUtilities.java:453)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:333)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:317)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:307)
at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:1003)
at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:971)
at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:1011)
at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:1037)
at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:258)
at com.sygate.scm.server.configmanager.ConfigManagerCache.prepareTopLevelObject(ConfigManagerCache.java:405)
at com.sygate.scm.server.configmanager.ConfigManagerCache.getTopLevelObject(ConfigManagerCache.java:318)
at com.sygate.scm.server.configmanager.ReadonlyConfigManager.getTopLevelObject(ReadonlyConfigManager.java:24)
at com.sygate.scm.server.configmanager.ConfigManager.getSemConfigRootObject(ConfigManager.java:2232)
at com.sygate.scm.server.consolemanager.RequestHandlerCache.<init>(RequestHandlerCache.java:55)
at com.sygate.scm.server.consolemanager.RequestHandlerCache.getInstance(RequestHandlerCache.java:64)
at com.sygate.scm.server.consolemanager.RequestHandler.handleRequest(RequestHandler.java:192)
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:150)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:116)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.sygate.scm.server.servlet.ConsoleFilter.doFilter(ConsoleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: The SELECT permission was denied on the object 'CONNECTION_TEST', database 'sem5', schema 'dbo'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1427)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:658)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1558)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
... 40 more
2015-07-06 11:44:42.413 THREAD 54 SEVERE: Unexpected server error.
com.sygate.scm.server.metadata.MetadataException:
at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:1005)
at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:971)
at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:1011)
at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:1037)
at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:258)
at com.sygate.scm.server.configmanager.ConfigManagerCache.prepareTopLevelObject(ConfigManagerCache.java:405)
at com.sygate.scm.server.configmanager.ConfigManagerCache.getTopLevelObject(ConfigManagerCache.java:318)
at com.sygate.scm.server.configmanager.ReadonlyConfigManager.getTopLevelObject(ReadonlyConfigManager.java:24)
at com.sygate.scm.server.configmanager.ConfigManager.getSemConfigRootObject(ConfigManager.java:2232)
at com.sygate.scm.server.consolemanager.RequestHandlerCache.<init>(RequestHandlerCache.java:55)
at com.sygate.scm.server.consolemanager.RequestHandlerCache.getInstance(RequestHandlerCache.java:64)
at com.sygate.scm.server.consolemanager.RequestHandler.handleRequest(RequestHandler.java:192)
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:150)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:116)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.sygate.scm.server.servlet.ConsoleFilter.doFilter(ConsoleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The SELECT permission was denied on the object 'CONNECTION_TEST', database 'sem5', schema 'dbo'.)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDataSourceDBConnection(DatabaseUtilities.java:453)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:333)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:317)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:307)
at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:1003)
... 33 more
Caused by: java.sql.SQLException: The SELECT permission was denied on the object 'CONNECTION_TEST', database 'sem5', schema 'dbo'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1427)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:658)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1558)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
... 40 more
com.sygate.scm.server.util.ServerException: Unexpected server error.
at com.sygate.scm.server.configmanager.ConfigManagerCache.prepareTopLevelObject(ConfigManagerCache.java:422)
at com.sygate.scm.server.configmanager.ConfigManagerCache.getTopLevelObject(ConfigManagerCache.java:318)
at com.sygate.scm.server.configmanager.ReadonlyConfigManager.getTopLevelObject(ReadonlyConfigManager.java:24)
at com.sygate.scm.server.configmanager.ConfigManager.getSemConfigRootObject(ConfigManager.java:2232)
at com.sygate.scm.server.consolemanager.RequestHandlerCache.<init>(RequestHandlerCache.java:55)
at com.sygate.scm.server.consolemanager.RequestHandlerCache.getInstance(RequestHandlerCache.java:64)
at com.sygate.scm.server.consolemanager.RequestHandler.handleRequest(RequestHandler.java:192)
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:150)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:116)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.sygate.scm.server.servlet.ConsoleFilter.doFilter(ConsoleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.sygate.scm.server.metadata.MetadataException:
at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:1005)
at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:971)
at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:1011)
at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:1037)
at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:258)
at com.sygate.scm.server.configmanager.ConfigManagerCache.prepareTopLevelObject(ConfigManagerCache.java:405)
... 28 more
Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The SELECT permission was denied on the object 'CONNECTION_TEST', database 'sem5', schema 'dbo'.)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDataSourceDBConnection(DatabaseUtilities.java:453)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:333)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:317)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:307)
at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:1003)
... 33 more
Caused by: java.sql.SQLException: The SELECT permission was denied on the object 'CONNECTION_TEST', database 'sem5', schema 'dbo'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1427)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:658)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1558)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
... 40 more
2015-07-06 11:45:01.741 THREAD 54 SEVERE:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The SELECT permission was denied on the object 'CONNECTION_TEST', database 'sem5', schema 'dbo'.)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDataSourceDBConnection(DatabaseUtilities.java:453)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:333)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:317)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:307)
at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:1003)
at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:971)
at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:1011)
at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:1037)
at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:258)
at com.sygate.scm.server.configmanager.ConfigManagerCache.prepareTopLevelObject(ConfigManagerCache.java:405)
at com.sygate.scm.server.configmanager.ConfigManagerCache.getTopLevelObject(ConfigManagerCache.java:318)
at com.sygate.scm.server.configmanager.ReadonlyConfigManager.getTopLevelObject(ReadonlyConfigManager.java:24)
at com.sygate.scm.server.configmanager.ConfigManager.getSemLocalSettings(ConfigManager.java:2796)
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.findLocalSite(AuthorizationContext.java:233)
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.<init>(AuthorizationContext.java:122)
at com.sygate.scm.server.security.requestauthorization.RequestAuthorizer.authorizeRequest(RequestAuthorizer.java:180)
at com.sygate.scm.server.consolemanager.RequestHandler.handleRequest(RequestHandler.java:232)
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:150)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:116)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.sygate.scm.server.servlet.ConsoleFilter.doFilter(ConsoleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: The SELECT permission was denied on the object 'CONNECTION_TEST', database 'sem5', schema 'dbo'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1427)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:658)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1558)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
... 41 more
2015-07-06 11:45:01.756 THREAD 54 SEVERE: Unknown Exception in: com.sygate.scm.server.consolemanager.RequestHandler
java.lang.NullPointerException
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.findLocalServer(AuthorizationContext.java:407)
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.<init>(AuthorizationContext.java:124)
at com.sygate.scm.server.security.requestauthorization.RequestAuthorizer.authorizeRequest(RequestAuthorizer.java:180)
at com.sygate.scm.server.consolemanager.RequestHandler.handleRequest(RequestHandler.java:232)
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:150)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:116)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.sygate.scm.server.servlet.ConsoleFilter.doFilter(ConsoleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
2015-07-06 11:45:01.756 THREAD 54 SEVERE: DomainId: null
SiteId: null
ServerId: 53372019C0A8141B0157BC3C7EE8632E
SystemEventId: 1281
EventDesc: Unexpected server error.
MessageId: 1
ErrorCode: 268500992
java.lang.NullPointerException
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.findLocalServer(AuthorizationContext.java:407)
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.<init>(AuthorizationContext.java:124)
at com.sygate.scm.server.security.requestauthorization.RequestAuthorizer.authorizeRequest(RequestAuthorizer.java:180)
at com.sygate.scm.server.consolemanager.RequestHandler.handleRequest(RequestHandler.java:232)
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:150)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:116)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.sygate.scm.server.servlet.ConsoleFilter.doFilter(ConsoleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
com.sygate.scm.server.util.ServerException: Unexpected server error.
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:478)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:443)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:439)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:435)
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:164)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:116)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.sygate.scm.server.servlet.ConsoleFilter.doFilter(ConsoleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.findLocalServer(AuthorizationContext.java:407)
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.<init>(AuthorizationContext.java:124)
at com.sygate.scm.server.security.requestauthorization.RequestAuthorizer.authorizeRequest(RequestAuthorizer.java:180)
at com.sygate.scm.server.consolemanager.RequestHandler.handleRequest(RequestHandler.java:232)
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:150)
... 21 more
2015-07-06 11:45:02.772 THREAD 54 SEVERE: SEM: Connect to database failed
java.sql.SQLException: SEM: Connect to database failed
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:388)
at com.sygate.scm.server.util.logging.DbLogHandler.publish(DbLogHandler.java:58)
at java.util.logging.Logger.log(Logger.java:616)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:480)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:443)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:439)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:435)
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:164)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:116)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.sygate.scm.server.servlet.ConsoleFilter.doFilter(ConsoleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:337)
... 28 more
2015-07-06 11:45:02.772 THREAD 54 SEVERE: in: com.sygate.scm.server.servlet.ConsoleServlet
java.lang.RuntimeException: java.lang.NullPointerException
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:165)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:116)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.sygate.scm.server.servlet.ConsoleFilter.doFilter(ConsoleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.findLocalServer(AuthorizationContext.java:407)
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.<init>(AuthorizationContext.java:124)
at com.sygate.scm.server.security.requestauthorization.RequestAuthorizer.authorizeRequest(RequestAuthorizer.java:180)
at com.sygate.scm.server.consolemanager.RequestHandler.handleRequest(RequestHandler.java:232)
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:150)
... 21 more
2015-07-06 11:45:02.772 THREAD 54 SEVERE: DomainId: null
SiteId: null
ServerId: 53372019C0A8141B0157BC3C7EE8632E
SystemEventId: 1281
EventDesc: Unexpected server error.
MessageId: 1
ErrorCode: 268500992
java.lang.RuntimeException: java.lang.NullPointerException
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:165)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:116)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.sygate.scm.server.servlet.ConsoleFilter.doFilter(ConsoleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.findLocalServer(AuthorizationContext.java:407)
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.<init>(AuthorizationContext.java:124)
at com.sygate.scm.server.security.requestauthorization.RequestAuthorizer.authorizeRequest(RequestAuthorizer.java:180)
at com.sygate.scm.server.consolemanager.RequestHandler.handleRequest(RequestHandler.java:232)
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:150)
... 21 more
com.sygate.scm.server.util.ServerException: Unexpected server error.
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:478)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:443)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:439)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:435)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:177)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.sygate.scm.server.servlet.ConsoleFilter.doFilter(ConsoleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: java.lang.NullPointerException
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:165)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:116)
... 20 more
Caused by: java.lang.NullPointerException
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.findLocalServer(AuthorizationContext.java:407)
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.<init>(AuthorizationContext.java:124)
at com.sygate.scm.server.security.requestauthorization.RequestAuthorizer.authorizeRequest(RequestAuthorizer.java:180)
at com.sygate.scm.server.consolemanager.RequestHandler.handleRequest(RequestHandler.java:232)
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:150)
... 21 more
2015-07-06 11:45:03.803 THREAD 54 SEVERE: SEM: Connect to database failed
java.sql.SQLException: SEM: Connect to database failed
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:388)
at com.sygate.scm.server.util.logging.DbLogHandler.publish(DbLogHandler.java:58)
at java.util.logging.Logger.log(Logger.java:616)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:480)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:443)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:439)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:435)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:177)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.sygate.scm.server.servlet.ConsoleFilter.doFilter(ConsoleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:337)
... 27 more
2015-07-06 11:45:17.913 THREAD 43 SEVERE: Trying to connect database...
2015-07-06 11:46:17.930 THREAD 43 SEVERE: Trying to connect database...
2015-07-06 11:47:17.955 THREAD 43 SEVERE: Trying to connect database...
2015-07-06 11:48:17.977 THREAD 43 SEVERE: Trying to connect database...
2015-07-06 11:49:18.003 THREAD 43 SEVERE: Trying to connect database...
2015-07-06 11:50:18.024 THREAD 43 SEVERE: Trying to connect database...
2015-07-06 11:51:18.069 THREAD 43 SEVERE: Trying to connect database...
2015-07-06 11:52:18.098 THREAD 43 SEVERE: Trying to connect database...
2015-07-06 11:53:18.127 THREAD 43 SEVERE: Trying to connect database...
2015-07-06 11:54:18.147 THREAD 43 SEVERE: Trying to connect database...
2015-07-06 11:55:18.168 THREAD 43 SEVERE: Trying to connect database...
2015-07-06 11:56:18.185 THREAD 43 SEVERE: Trying to connect database...
2015-07-06 11:57:18.205 THREAD 43 SEVERE: Trying to connect database...
2015-07-06 11:58:18.221 THREAD 43 SEVERE: Trying to connect database...
2015-07-06 11:59:18.237 THREAD 43 SEVERE: Trying to connect database...
2015-07-06 12:00:18.255 THREAD 43 SEVERE: Trying to connect database...
2015-07-06 12:01:18.277 THREAD 43 SEVERE: Trying to connect database...
2015-07-06 12:02:18.300 THREAD 43 SEVERE: Trying to connect database...
2015-07-06 12:03:18.318 THREAD 43 SEVERE: Trying to connect database...
2015-07-06 12:03:18.333 THREAD 43 SEVERE:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The SELECT permission was denied on the object 'CONNECTION_TEST', database 'sem5', schema 'dbo'.)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDataSourceDBConnection(DatabaseUtilities.java:453)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:333)
at com.sygate.scm.server.db.util.DatabaseUtilities.testDBConnectionDuringStartup(DatabaseUtilities.java:2786)
at com.sygate.scm.server.servlet.StartupServlet$DatabasePing.run(StartupServlet.java:151)
Caused by: java.sql.SQLException: The SELECT permission was denied on the object 'CONNECTION_TEST', database 'sem5', schema 'dbo'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1427)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:658)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1558)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
... 6 more
2015-07-06 13:37:25.472 THREAD 122 SEVERE:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The SELECT permission was denied on the object 'CONNECTION_TEST', database 'sem5', schema 'dbo'.)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDataSourceDBConnection(DatabaseUtilities.java:453)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:333)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:317)
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:307)
at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:1003)
at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:971)
at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:1011)
at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:1037)
at com.sygate.scm.server.metadata.MetadataManager.getMetadata(MetadataManager.java:258)
at com.sygate.scm.server.configmanager.ConfigManagerCache.prepareTopLevelObject(ConfigManagerCache.java:405)
at com.sygate.scm.server.configmanager.ConfigManagerCache.getTopLevelObject(ConfigManagerCache.java:318)
at com.sygate.scm.server.configmanager.ReadonlyConfigManager.getTopLevelObject(ReadonlyConfigManager.java:24)
at com.sygate.scm.server.configmanager.ConfigManager.getSemLocalSettings(ConfigManager.java:2796)
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.findLocalSite(AuthorizationContext.java:233)
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.<init>(AuthorizationContext.java:122)
at com.sygate.scm.server.security.requestauthorization.RequestAuthorizer.authorizeRequest(RequestAuthorizer.java:180)
at com.sygate.scm.server.consolemanager.RequestHandler.handleRequest(RequestHandler.java:232)
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:150)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:116)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.sygate.scm.server.servlet.ConsoleFilter.doFilter(ConsoleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: The SELECT permission was denied on the object 'CONNECTION_TEST', database 'sem5', schema 'dbo'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1427)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:658)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1558)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
... 41 more
2015-07-06 13:37:25.488 THREAD 122 SEVERE: Unknown Exception in: com.sygate.scm.server.consolemanager.RequestHandler
java.lang.NullPointerException
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.findLocalServer(AuthorizationContext.java:407)
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.<init>(AuthorizationContext.java:124)
at com.sygate.scm.server.security.requestauthorization.RequestAuthorizer.authorizeRequest(RequestAuthorizer.java:180)
at com.sygate.scm.server.consolemanager.RequestHandler.handleRequest(RequestHandler.java:232)
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:150)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:116)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.sygate.scm.server.servlet.ConsoleFilter.doFilter(ConsoleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
2015-07-06 13:37:25.488 THREAD 122 SEVERE: DomainId: null
SiteId: null
ServerId: 53372019C0A8141B0157BC3C7EE8632E
SystemEventId: 1281
EventDesc: Unexpected server error.
MessageId: 1
ErrorCode: 268500992
java.lang.NullPointerException
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.findLocalServer(AuthorizationContext.java:407)
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.<init>(AuthorizationContext.java:124)
at com.sygate.scm.server.security.requestauthorization.RequestAuthorizer.authorizeRequest(RequestAuthorizer.java:180)
at com.sygate.scm.server.consolemanager.RequestHandler.handleRequest(RequestHandler.java:232)
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:150)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:116)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.sygate.scm.server.servlet.ConsoleFilter.doFilter(ConsoleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
com.sygate.scm.server.util.ServerException: Unexpected server error.
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:478)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:443)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:439)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:435)
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:164)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:116)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.sygate.scm.server.servlet.ConsoleFilter.doFilter(ConsoleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.findLocalServer(AuthorizationContext.java:407)
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.<init>(AuthorizationContext.java:124)
at com.sygate.scm.server.security.requestauthorization.RequestAuthorizer.authorizeRequest(RequestAuthorizer.java:180)
at com.sygate.scm.server.consolemanager.RequestHandler.handleRequest(RequestHandler.java:232)
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:150)
... 21 more
2015-07-06 13:37:26.503 THREAD 122 SEVERE: SEM: Connect to database failed
java.sql.SQLException: SEM: Connect to database failed
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:388)
at com.sygate.scm.server.util.logging.DbLogHandler.publish(DbLogHandler.java:58)
at java.util.logging.Logger.log(Logger.java:616)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:480)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:443)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:439)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:435)
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:164)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:116)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.sygate.scm.server.servlet.ConsoleFilter.doFilter(ConsoleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:337)
... 28 more
2015-07-06 13:37:26.503 THREAD 122 SEVERE: in: com.sygate.scm.server.servlet.ConsoleServlet
java.lang.RuntimeException: java.lang.NullPointerException
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:165)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:116)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.sygate.scm.server.servlet.ConsoleFilter.doFilter(ConsoleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.findLocalServer(AuthorizationContext.java:407)
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.<init>(AuthorizationContext.java:124)
at com.sygate.scm.server.security.requestauthorization.RequestAuthorizer.authorizeRequest(RequestAuthorizer.java:180)
at com.sygate.scm.server.consolemanager.RequestHandler.handleRequest(RequestHandler.java:232)
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:150)
... 21 more
2015-07-06 13:37:26.503 THREAD 122 SEVERE: DomainId: null
SiteId: null
ServerId: 53372019C0A8141B0157BC3C7EE8632E
SystemEventId: 1281
EventDesc: Unexpected server error.
MessageId: 1
ErrorCode: 268500992
java.lang.RuntimeException: java.lang.NullPointerException
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:165)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:116)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.sygate.scm.server.servlet.ConsoleFilter.doFilter(ConsoleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.findLocalServer(AuthorizationContext.java:407)
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.<init>(AuthorizationContext.java:124)
at com.sygate.scm.server.security.requestauthorization.RequestAuthorizer.authorizeRequest(RequestAuthorizer.java:180)
at com.sygate.scm.server.consolemanager.RequestHandler.handleRequest(RequestHandler.java:232)
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:150)
... 21 more
com.sygate.scm.server.util.ServerException: Unexpected server error.
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:478)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:443)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:439)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:435)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:177)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.sygate.scm.server.servlet.ConsoleFilter.doFilter(ConsoleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: java.lang.NullPointerException
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:165)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:116)
... 20 more
Caused by: java.lang.NullPointerException
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.findLocalServer(AuthorizationContext.java:407)
at com.sygate.scm.server.security.requestauthorization.AuthorizationContext.<init>(AuthorizationContext.java:124)
at com.sygate.scm.server.security.requestauthorization.RequestAuthorizer.authorizeRequest(RequestAuthorizer.java:180)
at com.sygate.scm.server.consolemanager.RequestHandler.handleRequest(RequestHandler.java:232)
at com.sygate.scm.server.consolemanager.RequestHandler.<init>(RequestHandler.java:150)
... 21 more
2015-07-06 13:37:27.519 THREAD 122 SEVERE: SEM: Connect to database failed
java.sql.SQLException: SEM: Connect to database failed
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:388)
at com.sygate.scm.server.util.logging.DbLogHandler.publish(DbLogHandler.java:58)
at java.util.logging.Logger.log(Logger.java:616)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:480)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:443)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:439)
at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:435)
at com.sygate.scm.server.servlet.ConsoleServlet.doPost(ConsoleServlet.java:177)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.sygate.scm.server.servlet.ConsoleFilter.doFilter(ConsoleFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException
at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:337)
... 27 more
I went to control panel > administrative tools > ODBC Data Source Adaministrator > System DSN and went through the configuration of the SymantecEndpointSecurityDSN to test the ODBC connection and all was successful. But obviously I have a few errors in this log that need to be addressed.
- org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The SELECT permission was denied on the object 'CONNECTION_TEST', database 'sem5', schema 'dbo'.)
- Caused by: java.sql.SQLException: The SELECT permission was denied on the object 'CONNECTION_TEST', database 'sem5', schema 'dbo'
-
2015-07-06 13:37:27.519 THREAD 122 SEVERE: SEM: Connect to database failed
java.sql.SQLException: SEM: Connect to database failed
Any help would be appreciated.