Endpoint Protection Small Business Edition

 View Only
Expand all | Collapse all

Unable to start symantec embedded database

Migration User

Migration UserSep 03, 2014 07:32 PM

  • 1.  Unable to start symantec embedded database

    Posted Sep 03, 2014 03:49 AM

    Hi Guys

     

    I am running symantec endpoint proection center on windows server 2003 and i am unable to log into the endpoint protection manager as we are unable to start the symantec embedded database! everytime we start the service it fails to start.

     

    Any ideas?



  • 2.  RE: Unable to start symantec embedded database

    Posted Sep 03, 2014 04:01 AM

    What the error message?

    Reboot the server and start again.

    Check

    Error when logging to Symantec Endpoint Protection Manager: "Failed to connect to server". Unable to start the embedded database service.

    Article:TECH134782  |  Created: 2010-01-07  |  Updated: 2013-05-16  |  Article URL http://www.symantec.com/docs/TECH134782

     



  • 3.  RE: Unable to start symantec embedded database

    Posted Sep 03, 2014 04:09 AM

    Have you try repair SEPM on add/remove programe ?

    Please post catalina.out and scm-server-0.log files

    Available here : C:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\logs\



  • 4.  RE: Unable to start symantec embedded database

    Posted Sep 03, 2014 07:51 AM

    Enable advanced debugging

    How to debug the Symantec Endpoint Protection Manager

    Post the logs here for review



  • 5.  RE: Unable to start symantec embedded database

    Posted Sep 03, 2014 09:24 AM

    @consoleadmin is probably on the right track. 

    I too am on Windows Server 2003 and I expect your hardware is probably pretty old like mine.  I have exactly the same sort of problem because the sem5.log gets too large and the system bogs right down, thrashing the hard disk.  This seems to cause the database service to not stop cleanly if required, and potentially it will then not start correctly due to a bad or too large sem5.log.  Maybe you have a similar issue as me.

    I have logged a support ticket with Symantec to disagnose why the log is not truncating as the current version should be doing this every 4 hours from what I understand.  What version are you using?

    Let us know how you get on with following TECH134782 and how big your sem5.log is.

    Also verify the Database Engine process is in fact stopped before trying to start, its called dbsrv12.exe in the Windows process list if it still actually running.



  • 6.  RE: Unable to start symantec embedded database

    Posted Sep 03, 2014 09:40 AM

    whats the size of sem5.log? do you have enough space on the drive?



  • 7.  RE: Unable to start symantec embedded database

    Posted Sep 03, 2014 07:27 PM

    I get the following message when trying to start Symantec Embedded database service " the symantec embedded database service on the local computer started then stopped, some services stop autmoatically if they have no work to do, for example the performance logs and alerts".

     

    After this occurs i check the event viewer and see that it produces a error SQLANYs_Sem5.

     

    the Sem5.db file is 4.8GB.

     

     



  • 8.  RE: Unable to start symantec embedded database

    Posted Sep 03, 2014 07:32 PM

    we are running version 12.1.4013 



  • 9.  RE: Unable to start symantec embedded database

    Posted Sep 03, 2014 10:51 PM

    Have you try repair SEPM on add/remove programe ?

    Please post catalina.out and scm-server-0.log files

    Available here : C:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\logs\



  • 10.  RE: Unable to start symantec embedded database

    Posted Sep 03, 2014 11:04 PM

    Yes i ahve tried to repair it and that was fine hwoever when i get to the configure the server side it does not allow me to do anything with the database as it can not start the service.

    here is the scm-server-0.logfile

    2014-09-03 17:05:14.220 THREAD 12 SEVERE: ================== Server Environment ===================
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: os.name = Windows 2003
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: os.version = 5.2
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: os.arch = x86
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: java.version = 1.7.0_25
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: java.vendor = Oracle Corporation
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: java.vm.name = Java HotSpot(TM) Server VM
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: java.vm.version = 23.25-b01
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: java.home = C:\Program Files\Symantec\Symantec Protection Center\jre
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: catalina.home = C:\Program Files\Symantec\Symantec Protection Center\tomcat
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: java.user = null
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: user.language = en
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: user.country = AU
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: scm.server.version = 12.1.4023.4080
    2014-09-03 17:05:52.595 THREAD 12 SEVERE: 
    org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory ([Sybase][JDBC Driver][SQL Anywhere]Database server not found)
        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:402)
        at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:286)
        at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:271)
        at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:261)
        at com.sygate.scm.server.db.util.DatabaseUtilities.getDBConnection(DatabaseUtilities.java:2499)
        at com.sygate.scm.server.db.util.DatabaseUtilities.testConnection(DatabaseUtilities.java:2456)
        at com.sygate.scm.server.servlet.StartupServlet.init(StartupServlet.java:131)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5027)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5314)
        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:633)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:657)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1637)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        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:724)
    Caused by: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Database server not found
        at sybase.jdbc4.sqlanywhere.IDriver.makeODBCConnection(Native Method)
        at sybase.jdbc4.sqlanywhere.IDriver.connect(IDriver.java:772)
        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.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
        ... 26 more
    2014-09-03 17:05:52.595 THREAD 12 SEVERE:  in: com.sygate.scm.server.servlet.StartupServlet
    com.sygate.scm.server.util.ScmServerError: Failed to connect to database after tried 20 times, please start the database!
        at com.sygate.scm.server.servlet.StartupServlet.init(StartupServlet.java:132)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5027)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5314)
        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:633)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:657)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1637)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        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:724)
    2014-09-03 17:05:52.626 THREAD 12 SEVERE: DomainId: null
    SiteId: null
    ServerId: 9613080E0A0000BD009F2CFF9CE75417
    SystemEventId: 1281
    EventDesc: Unexpected server error.
    MessageId: 1
    ErrorCode: 268500992
    com.sygate.scm.server.util.ScmServerError: Failed to connect to database after tried 20 times, please start the database!
        at com.sygate.scm.server.servlet.StartupServlet.init(StartupServlet.java:132)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5027)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5314)
        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:633)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:657)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1637)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        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:724)
    com.sygate.scm.server.util.ServerException: Unexpected server error.
        at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:399)
        at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:364)
        at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:360)
        at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:356)
        at com.sygate.scm.server.servlet.StartupServlet.init(StartupServlet.java:314)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5027)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5314)
        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:633)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:657)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1637)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        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:724)
    Caused by: com.sygate.scm.server.util.ScmServerError: Failed to connect to database after tried 20 times, please start the database!
        at com.sygate.scm.server.servlet.StartupServlet.init(StartupServlet.java:132)
        ... 17 more
    2014-09-03 17:05:54.673 THREAD 12 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:339)
        at com.sygate.scm.server.util.logging.DbLogHandler.publish(DbLogHandler.java:58)
        at java.util.logging.Logger.log(Logger.java:610)
        at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:401)
        at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:364)
        at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:360)
        at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:356)
        at com.sygate.scm.server.servlet.StartupServlet.init(StartupServlet.java:314)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5027)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5314)
        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:633)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:657)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1637)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        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:724)
    Caused by: java.lang.NullPointerException
        at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:290)
        ... 24 more

     

     



  • 11.  RE: Unable to start symantec embedded database

    Posted Sep 04, 2014 07:27 PM

    2014-09-03 17:05:14.220 THREAD 12 SEVERE: ================== Server Environment ===================
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: os.name = Windows 2003
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: os.version = 5.2
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: os.arch = x86
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: java.version = 1.7.0_25
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: java.vendor = Oracle Corporation
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: java.vm.name = Java HotSpot(TM) Server VM
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: java.vm.version = 23.25-b01
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: java.home = C:\Program Files\Symantec\Symantec Protection Center\jre
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: catalina.home = C:\Program Files\Symantec\Symantec Protection Center\tomcat
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: java.user = null
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: user.language = en
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: user.country = AU
    2014-09-03 17:05:14.220 THREAD 12 SEVERE: scm.server.version = 12.1.4023.4080
    2014-09-03 17:05:52.595 THREAD 12 SEVERE: 
    org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory ([Sybase][JDBC Driver][SQL Anywhere]Database server not found)
        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:402)
        at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:286)
        at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:271)
        at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:261)
        at com.sygate.scm.server.db.util.DatabaseUtilities.getDBConnection(DatabaseUtilities.java:2499)
        at com.sygate.scm.server.db.util.DatabaseUtilities.testConnection(DatabaseUtilities.java:2456)
        at com.sygate.scm.server.servlet.StartupServlet.init(StartupServlet.java:131)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5027)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5314)
        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:633)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:657)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1637)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        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:724)
    Caused by: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Database server not found
        at sybase.jdbc4.sqlanywhere.IDriver.makeODBCConnection(Native Method)
        at sybase.jdbc4.sqlanywhere.IDriver.connect(IDriver.java:772)
        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.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
        ... 26 more
    2014-09-03 17:05:52.595 THREAD 12 SEVERE:  in: com.sygate.scm.server.servlet.StartupServlet
    com.sygate.scm.server.util.ScmServerError: Failed to connect to database after tried 20 times, please start the database!
        at com.sygate.scm.server.servlet.StartupServlet.init(StartupServlet.java:132)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5027)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5314)
        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:633)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:657)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1637)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        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:724)
    2014-09-03 17:05:52.626 THREAD 12 SEVERE: DomainId: null
    SiteId: null
    ServerId: 9613080E0A0000BD009F2CFF9CE75417
    SystemEventId: 1281
    EventDesc: Unexpected server error.
    MessageId: 1
    ErrorCode: 268500992
    com.sygate.scm.server.util.ScmServerError: Failed to connect to database after tried 20 times, please start the database!
        at com.sygate.scm.server.servlet.StartupServlet.init(StartupServlet.java:132)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5027)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5314)
        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:633)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:657)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1637)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        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:724)
    com.sygate.scm.server.util.ServerException: Unexpected server error.
        at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:399)
        at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:364)
        at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:360)
        at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:356)
        at com.sygate.scm.server.servlet.StartupServlet.init(StartupServlet.java:314)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5027)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5314)
        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:633)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:657)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1637)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        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:724)
    Caused by: com.sygate.scm.server.util.ScmServerError: Failed to connect to database after tried 20 times, please start the database!
        at com.sygate.scm.server.servlet.StartupServlet.init(StartupServlet.java:132)
        ... 17 more
    2014-09-03 17:05:54.673 THREAD 12 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:339)
        at com.sygate.scm.server.util.logging.DbLogHandler.publish(DbLogHandler.java:58)
        at java.util.logging.Logger.log(Logger.java:610)
        at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:401)
        at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:364)
        at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:360)
        at com.sygate.scm.server.util.ServerLogger.log(ServerLogger.java:356)
        at com.sygate.scm.server.servlet.StartupServlet.init(StartupServlet.java:314)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5027)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5314)
        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:633)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:657)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1637)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        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:724)
    Caused by: java.lang.NullPointerException
        at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:290)
        ... 24 more

     



  • 12.  RE: Unable to start symantec embedded database

    Posted Sep 04, 2014 10:57 PM

    If the database wont start it is very probably the sem5.log file is corrupt, as we have said earlier.  Please advise how big the sem5.log file is and follow http://www.symantec.com/docs/TECH134782 section Version 12.1.2xxx. 

    If then the database service does not start please post most current info from C:\%programfiles%\Symantec\Symantec Endpoint Protection Manager\db\ err.log and out.log



  • 13.  RE: Unable to start symantec embedded database

    Posted Sep 04, 2014 11:08 PM

    Try this

    1. Navigate to C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\ within Windows Explorer.
    2. Locate the sem5.log and rename it to sem5.log.old
    3. Open a command prompt  and navigate to the following location: C:\Program Files\Symantec\Symantec Endpoint Protection Manager\ASA\win32
    4. Issue the following command: dbsrv11 -f "C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db
    5. Start the Symantec Embedded Database service through the service control manager (services.msc).


  • 14.  RE: Unable to start symantec embedded database

    Posted Sep 05, 2014 01:10 AM

    What the disk space availalble in your SEPM?

    Check the thread attach comment

    https://www-secure.symantec.com/connect/forums/sepm-dont-work-embedded-database-service-are-down#comment-6971181

    The Symantec Endpoint Protection Manager service doesn't stay started

    Article:TECH95362  |  Created: 2009-01-03  |  Updated: 2010-11-02  |  Article URL http://www.symantec.com/docs/TECH95362


  • 15.  RE: Unable to start symantec embedded database

    Posted Sep 05, 2014 02:17 AM

    We have more than 80Gb available and i ahve tried the renaming the old file and running the dbsrv12 -f command and restartong the service however we are still getting the same result.

     

    database file was 4.2GB in size.



  • 16.  RE: Unable to start symantec embedded database

    Posted Sep 05, 2014 02:28 AM

    I suggest you to follow the disaster recovery process to save the time.

    Symantec Endpoint Protection 12.1: Best Practices for Disaster Recovery with the Symantec Endpoint Protection Manager

     
    Check the below thread

    https://www-secure.symantec.com/connect/forums/failed-connect-server-22



  • 17.  RE: Unable to start symantec embedded database

    Posted Sep 09, 2014 05:30 AM

    Have you run the Disaster Recovery to fix the issue.

    You have already tried the repair and some other troubleshoot which not be fixed it. So best option is go with Disaster Process.