Video Screencast Help

SEPM not starting // Cannot determine the SEPM databse schema.

Created: 04 Feb 2014 • Updated: 04 Feb 2014 | 3 comments

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)
 
Operating Systems:

Comments 3 CommentsJump to latest comment

Rafeeq's picture

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

flutti's picture

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?
Nickv's picture

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.