Endpoint Protection

 View Only
  • 1.  SEPM not starting // Cannot determine the SEPM databse schema.

    Posted Feb 04, 2014 03:14 AM

    Hi, 

     

    I tried to move my SEPM server to a new server following this article http://www.symantec.com/business/support/index?page=content&id=TECH104389. I followed this until the screen where i must give the details for the DB server authentication (DB server, DB name, credentials, ...) I clicked nex and i got the message "The specified database contains user data. Installing a new site will clear all existing data".
    I clicked yes and then i received the error "Cannot determine the Symantec Endpoint protection Manager database schema. Use an Existing database that contains ....."

     

    I saw on my original server that the SEPM service was down. I wanted te restart the service but ik keeps stopping.
    Event ID 4096: The Java Virtual Machine has exited with a code of -1, the service is being stopped.

    I added the event log and the scm-server-0.log

    -----------------------------------
    Log Name:      Application

    Source:        semsrv
    Date:          3/02/2014 17:14:41
    Event ID:      4096
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      SVIMESPRDMGM02.beimes02.imes.be
    Description:
    The Java Virtual Machine has exited with a code of -1, the service is being stopped.
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="semsrv" />
        <EventID Qualifiers="49152">4096</EventID>
        <Level>2</Level>
        <Task>0</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2014-02-03T16:14:41.000000000Z" />
        <EventRecordID>12821</EventRecordID>
        <Channel>Application</Channel>
        <Computer>SVIMESPRDMGM02.beimes02.imes.be</Computer>
        <Security />
      </System>
      <EventData>
        <Data>The Java Virtual Machine has exited with a code of -1, the service is being stopped.</Data>
      </EventData>
    </Event>
    --------------------------------------

     

    Server 1 = server that needs to be moved to the new server

    Server 2 = new server

    DB = SQL

    OS server1, Server2 = Windows Servers 2008R2

    I wanted the install the same version op SEPM on Server2 as Server 1 = SEPM12.1.4 

     

    scm-server-0.log

    --------------------

    2014-02-04 09:06:27.248 THREAD 12 SEVERE: ================== Server Environment ===================

    2014-02-04 09:06:27.248 THREAD 12 SEVERE: os.name = Windows Server 2008 R2
    2014-02-04 09:06:27.248 THREAD 12 SEVERE: os.version = 6.1
    2014-02-04 09:06:27.248 THREAD 12 SEVERE: os.arch = x64
    2014-02-04 09:06:27.248 THREAD 12 SEVERE: java.version = 1.7.0_25
    2014-02-04 09:06:27.248 THREAD 12 SEVERE: java.vendor = Oracle Corporation
    2014-02-04 09:06:27.248 THREAD 12 SEVERE: java.vm.name = Java HotSpot(TM) Server VM
    2014-02-04 09:06:27.248 THREAD 12 SEVERE: java.vm.version = 23.25-b01
    2014-02-04 09:06:27.248 THREAD 12 SEVERE: java.home = C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\jre
    2014-02-04 09:06:27.248 THREAD 12 SEVERE: catalina.home = C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat
    2014-02-04 09:06:27.264 THREAD 12 SEVERE: java.user = null
    2014-02-04 09:06:27.264 THREAD 12 SEVERE: user.language = en
    2014-02-04 09:06:27.264 THREAD 12 SEVERE: user.country = US
    2014-02-04 09:06:27.264 THREAD 12 SEVERE: scm.server.version = 12.1.4013.4013
    2014-02-04 09:06:29.592 THREAD 12 INFO: Server startup
    2014-02-04 09:06:29.686 THREAD 12 SEVERE:  in: com.sygate.scm.server.servlet.StartupServlet
    com.sygate.scm.server.util.ScmServerError: Can't read local setting from database!
    at com.sygate.scm.server.servlet.StartupServlet.registerServer(StartupServlet.java:383)
    at com.sygate.scm.server.servlet.StartupServlet.init(StartupServlet.java:136)
    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-02-04 09:06:29.779 THREAD 12 SEVERE: DomainId: null
    SiteId: null
    ServerId: 33E55941AC1F650C01328D645DCF4EF3
    SystemEventId: 1281
    EventDesc: Unexpected server error.
    MessageId: 1
    ErrorCode: 268500992
    com.sygate.scm.server.util.ScmServerError: Can't read local setting from database!
    at com.sygate.scm.server.servlet.StartupServlet.registerServer(StartupServlet.java:383)
    at com.sygate.scm.server.servlet.StartupServlet.init(StartupServlet.java:136)
    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: Can't read local setting from database!
    at com.sygate.scm.server.servlet.StartupServlet.registerServer(StartupServlet.java:383)
    at com.sygate.scm.server.servlet.StartupServlet.init(StartupServlet.java:136)
    ... 17 more
    2014-02-04 09:06:30.123 THREAD 12 SEVERE: Cannot insert the value NULL into column 'SITE_ID', table 'SymantecEndpointProtection.sepuser.SERVER_SYSTEM_LOG_2'; column does not allow nulls. INSERT fails.
    java.sql.SQLException: Cannot insert the value NULL into column 'SITE_ID', table 'SymantecEndpointProtection.sepuser.SERVER_SYSTEM_LOG_2'; column does not allow nulls. INSERT fails.
    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
    at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:504)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at com.sygate.scm.server.util.logging.ServerSystemLogRecord.doLog(ServerSystemLogRecord.java:167)
    at com.sygate.scm.server.util.logging.DbLogHandler.publish(DbLogHandler.java:62)
    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)
     


  • 2.  RE: SEPM not starting // Cannot determine the SEPM databse schema.

    Posted Feb 04, 2014 03:48 PM

    Did you follow step 2?

    2) MACHINE_2 will have both IP and hostname different from MACHINE_1

    A) Replication method

    Make sure you have installed the same version of SEPM complete version number should be verified

    How many clients you have in your network? 

    You want move sepm to a different server but do you need replication?

    run the management server config wizard on server1 the service should be up



  • 3.  RE: SEPM not starting // Cannot determine the SEPM databse schema.

    Posted Feb 04, 2014 05:27 PM

    Few questions on this one:

    1. Is / was it really your intention to clear all existing data in the DB?
    2. Since when was the SEPM down? Did you install another service before which may be running on the same internal port as SEPM wants to start?
    3. Is the connectivity between Sever 2 and DB Server given?


  • 4.  RE: SEPM not starting // Cannot determine the SEPM databse schema.

    Posted Feb 05, 2014 02:48 AM

    Hi, 

    Thank you for the feedback. 

    I solved it with a DB restore and a rerun of the server configuration wizard on server 1, afterwards I installed SEPM on SERVER 2 with the option Install an additional management server to an existing site. It seems to be working.