Video Screencast Help

SEP 11.7 MP2 upgrade to 12.1.2 failed at database schema upgraed

Created: 22 Dec 2012 | 5 comments

Hi,

I'm trying to upgrade my sep from 11.7 MP2 to SEP 12.1.2-as seggested from symantec support and it failed at database schema upgraed-

 

2012-10-23 11:15:48.673 THREAD 1 SEVERE: ================== Server Environment ===================

2012-10-23 11:15:48.689 THREAD 1 SEVERE: os.name = Windows Server 2008 R2

2012-10-23 11:15:48.689 THREAD 1 SEVERE: os.version = 6.1

2012-10-23 11:15:48.689 THREAD 1 SEVERE: os.arch = x86

2012-10-23 11:15:48.689 THREAD 1 SEVERE: java.version = 1.6.0_26

2012-10-23 11:15:48.689 THREAD 1 SEVERE: java.vendor = Sun Microsystems Inc.

2012-10-23 11:15:48.689 THREAD 1 SEVERE: java.vm.name = Java HotSpot(TM) Client VM

2012-10-23 11:15:48.689 THREAD 1 SEVERE: java.vm.version = 20.1-b02

2012-10-23 11:15:48.689 THREAD 1 SEVERE: java.home = C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\jre

2012-10-23 11:15:48.689 THREAD 1 SEVERE: catalina.home = C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat

2012-10-23 11:15:48.689 THREAD 1 SEVERE: java.user = null

2012-10-23 11:15:48.689 THREAD 1 SEVERE: user.language = en

2012-10-23 11:15:48.689 THREAD 1 SEVERE: user.country = US

2012-10-23 11:15:48.689 THREAD 1 SEVERE: scm.server.version = 12.1.1000.157

2012-10-23 11:15:48.689 THREAD 1 INFO: Main>> Main> Upgrade parameters

2012-10-23 11:15:48.689 THREAD 1 INFO: Main>> Main> Upgrade args length = 1

2012-10-23 11:15:48.689 THREAD 1 INFO: Upgrade args = SQL

2012-10-23 11:15:48.689 THREAD 1 INFO: Waited for 1 seconds to get info from stdin.

2012-10-23 11:15:48.689 THREAD 1 INFO: Get string from stdin:username=sa

2012-10-23 11:15:48.689 THREAD 1 INFO: adminUserID sa

2012-10-23 11:15:48.689 THREAD 1 INFO: Password is received

2012-10-23 11:15:48.689 THREAD 1 INFO: Get string from stdin:END_INPUT_FROM_STDIN

2012-10-23 11:15:48.689 THREAD 1 INFO: Main>> Main> Unable to retrieve the admin password

2012-10-23 11:15:48.689 THREAD 1 INFO: Main>> Main> Server Home: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat

2012-10-23 11:15:50.095 THREAD 1 INFO: Main>> Main> You are using MSSQL server.

2012-10-23 11:15:50.517 THREAD 1 INFO: Has valid SAV license

2012-10-23 11:15:50.517 THREAD 1 INFO: Info>> No SNAC license file in C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat\etc\license

2012-10-23 11:15:52.564 THREAD 1 INFO: Main>> executePreLaunchSteps> Config schema format is upgraded from (schema version from db): 11.0.7.0

2012-10-23 11:15:52.767 THREAD 1 INFO: Saving disaster recovery data to: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat\..\Server Private Key Backup\recovery_2012-10-23-11-15-52.zip

2012-10-23 11:15:52.798 THREAD 1 INFO: Main>> executePreLaunchSteps> DbVersion: 11.0.7.0 schemaVersionFromDB: 11.0.7.0 isSpm51Mr7: false hasOtherOSAgents: false dbcompanySize: 0 dbConnected: true

2012-10-23 11:15:52.798 THREAD 1 INFO: Main>> checkUpgradeFeasibility> Checking for upgrade feasibility, current schema version = 12.1.1.0, schema version from db = 11.0.7.0

2012-10-23 11:15:52.814 THREAD 1 INFO: Main>> displayOnlineServerListIfAny> Checking online servers... siteId = A9A36CEF0814041A011A731D92944BC4

2012-10-23 11:15:52.830 THREAD 1 INFO: SELECT CONTENT FROM SYSTEM_STATE WHERE OWNER = '108DB1990814041A006DAE3B733C49FA'

2012-10-23 11:15:52.939 THREAD 1 INFO: SYSOUT : Checking onlist status for server SERVERSEP

2012-10-23 11:15:52.939 THREAD 1 INFO: SYSOUT : Not checking status. offline status detected

2012-10-23 11:15:52.939 THREAD 1 INFO: SYSOUT : [name=SERVERSEP,id=108DB1990814041A006DAE3B733C49FA] is offline

2012-10-23 11:15:52.939 THREAD 1 INFO: Main>> displayOnlineServerListIfAny> Checking online servers... exclude local server id = 108DB1990814041A006DAE3B733C49FA

2012-10-23 11:15:52.939 THREAD 1 INFO: Main>> displayOnlineServerListIfAny> Online servers:[]

2012-10-23 11:15:52.939 THREAD 1 INFO: Main>> launchMainFrame> Launching the UI

2012-10-23 11:15:53.298 THREAD 1 INFO: isDefaultWebSite: null

2012-10-23 11:15:53.298 THREAD 1 INFO: iisPort: 8014

2012-10-23 11:15:53.298 THREAD 1 INFO: bReplaceIISwithApache: true

2012-10-23 11:15:53.330 THREAD 1 INFO: isLicenseInstallationValid:  sep.slf =true  OD file=true

2012-10-23 11:15:57.174 THREAD 21 INFO: scm.webserver.http.port is not found in conf.properties

2012-10-23 11:15:57.174 THREAD 21 INFO: scm.webserver.https.port is not found in conf.properties

2012-10-23 11:15:57.174 THREAD 21 INFO: scm.shutdown.port is not found in conf.properties

2012-10-23 11:15:57.174 THREAD 21 INFO: scm.iis.https.port is not found in conf.properties

2012-10-23 11:15:57.174 THREAD 21 INFO: scm.iisproxy.http.port is not found in conf.properties

2012-10-23 11:15:57.174 THREAD 21 INFO: scm.iisproxy.https.port is not found in conf.properties

2012-10-23 11:15:58.189 THREAD 21 INFO: scm.webserver.http.port is not found in conf.properties

2012-10-23 11:15:58.189 THREAD 21 INFO: scm.webserver.https.port is not found in conf.properties

2012-10-23 11:15:58.189 THREAD 21 INFO: scm.shutdown.port is not found in conf.properties

2012-10-23 11:15:58.189 THREAD 21 INFO: scm.iis.https.port is not found in conf.properties

2012-10-23 11:15:58.189 THREAD 21 INFO: scm.iisproxy.http.port is not found in conf.properties

2012-10-23 11:15:58.189 THREAD 21 INFO: scm.iisproxy.https.port is not found in conf.properties

2012-10-23 11:16:04.127 THREAD 26 INFO: Initializing ...

2012-10-23 11:16:04.127 THREAD 26 INFO: Executing command - stop semsrv

2012-10-23 11:16:04.299 THREAD 26 INFO: The Symantec Endpoint Protection Manager service is not started.

2012-10-23 11:16:04.299 THREAD 26 INFO:

2012-10-23 11:16:04.299 THREAD 26 INFO: More help is available by typing NET HELPMSG 3521.

2012-10-23 11:16:04.299 THREAD 26 INFO:

2012-10-23 11:16:04.299 THREAD 26 INFO: Waiting for service termination: semsrv

2012-10-23 11:16:04.299 THREAD 26 INFO: Checking whether the service is running semsrv

2012-10-23 11:16:04.549 THREAD 26 INFO: Service is not running.

2012-10-23 11:16:04.549 THREAD 26 INFO: Executing command - stop semwebsrv

2012-10-23 11:16:04.643 THREAD 26 INFO: The service name is invalid.

2012-10-23 11:16:04.643 THREAD 26 INFO:

2012-10-23 11:16:04.643 THREAD 26 INFO: More help is available by typing NET HELPMSG 2185.

2012-10-23 11:16:04.643 THREAD 26 INFO:

2012-10-23 11:16:04.643 THREAD 26 INFO: Stop SemSrv done.

2012-10-23 11:16:04.643 THREAD 26 INFO: Action Start:0

2012-10-23 11:16:04.643 THREAD 26 INFO: initDataSource

2012-10-23 11:16:05.002 THREAD 26 INFO: createODBC: the SQL Server port number:1433

2012-10-23 11:16:05.252 THREAD 26 INFO: grantSEMUserPrivilege isDBowner true

2012-10-23 11:16:05.252 THREAD 26 INFO: Config schema format is upgraded from: 11.0.7.0

2012-10-23 11:16:05.284 THREAD 26 INFO: Max Log File Size from DB: 20000

2012-10-23 11:16:05.284 THREAD 26 INFO: Upgrade call setUnrestrictedLogFileSize

2012-10-23 11:16:05.284 THREAD 26 INFO: setTransactionLogSizeUnrestricted ALTER DATABASE sem5 MODIFY FILE ( NAME = sem5_log1, MAXSIZE = UNLIMITED )

2012-10-23 11:16:05.315 THREAD 26 INFO: Upgrade call setUnrestrictedLogFileSize done

2012-10-23 11:16:05.315 THREAD 26 INFO: Upgrade schema started ...

2012-10-23 11:16:05.330 THREAD 26 INFO: Process SQL script file:MSSQLServerLicense.sql

2012-10-23 11:16:05.549 THREAD 26 INFO: Process SQL script file:MSSQLServer12000Misc.sql

2012-10-23 11:16:05.706 THREAD 26 INFO: Process SQL script file:MSSQLServerAmberLicense.sql

2012-10-23 11:16:05.815 THREAD 26 INFO: Inserted index disabled table names into the database. Table names are SEM_APPLICATION,COMPUTER_APPLICATION

2012-10-23 11:16:05.846 THREAD 26 INFO: Process SQL script file:MSSQLServerAmberMisc.sql

2012-10-23 11:16:09.565 THREAD 26 INFO: Process SQL script file:MSSQLServerRU6stoAmber.sql

2012-10-23 11:16:10.378 THREAD 26 INFO: Process SQL script file:MSSQLServerAmberMiscIndexes.sql

2012-10-23 11:16:14.144 THREAD 26 INFO: executeDroppingTempTable...temp=AGENT_SECURITY_LOG_INSERT_108DB1990814041A006DAE3B733C49FA, log=AGENT_SECURITY_LOG_1

2012-10-23 11:16:14.159 THREAD 26 INFO: executeDroppingTempTable...temp=AGENT_TRAFFIC_LOG_INSERT_108DB1990814041A006DAE3B733C49FA, log=AGENT_TRAFFIC_LOG_1

2012-10-23 11:16:14.159 THREAD 26 INFO: Process SQL script file:MSSQLServerAmberBeta1toAmberBeta2.sql

2012-10-23 11:16:14.581 THREAD 26 INFO: Upgrade Filter Tables...

2012-10-23 11:16:14.597 THREAD 26 INFO: FilterTableUpgrader>>doUpgrade: Begin... table=INVENTORYREPORT,col_idx=INVENTORYFILTER_IDX

2012-10-23 11:16:14.597 THREAD 26 INFO: FilterTableUpgrader>>dropOldPrimaryKey: Begin... table=INVENTORYREPORT, idx_constraint=PK_INVENTORYREPORT

2012-10-23 11:16:14.597 THREAD 26 INFO: FilterTableUpgrader>>dropOldPrimaryKey, sql=IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'PK_INVENTORYREPORT' ) ALTER TABLE INVENTORYREPORT DROP CONSTRAINT PK_INVENTORYREPORT

2012-10-23 11:16:14.612 THREAD 26 INFO: FilterTableUpgrader>>dropOldPrimaryKey: End. table=INVENTORYREPORT

2012-10-23 11:16:14.612 THREAD 26 INFO: FilterTableUpgrader>>checkTable: Begin... table=INVENTORYREPORT

2012-10-23 11:16:14.612 THREAD 26 INFO: FilterTableUpgrader>>checkTable: End. table=INVENTORYREPORT

2012-10-23 11:16:14.612 THREAD 26 INFO: FilterTableUpgrader>>delDuplicateFilters: Begin... table=INVENTORYREPORT, idx_del_list=[]

2012-10-23 11:16:14.612 THREAD 26 INFO: FilterTableUpgrader>>delDuplicateFilters: End. table=INVENTORYREPORT

2012-10-23 11:16:14.612 THREAD 26 INFO: FilterTableUpgrader>>createNewPrimaryKey: Begin... table=INVENTORYREPORT

2012-10-23 11:16:14.612 THREAD 26 INFO: FilterTableUpgrader>>createNewPrimaryKey: End. table=INVENTORYREPORT

2012-10-23 11:16:14.612 THREAD 26 INFO: FilterTableUpgrader>>doUpgrade: End. table=INVENTORYREPORT

2012-10-23 11:16:14.612 THREAD 26 INFO: FilterTableUpgrader>>doUpgrade: Begin... table=ALERTFILTER,col_idx=ALERTFILTER_IDX

2012-10-23 11:16:14.612 THREAD 26 INFO: FilterTableUpgrader>>dropOldPrimaryKey: Begin... table=ALERTFILTER, idx_constraint=PK_ALERTFILTER

2012-10-23 11:16:14.612 THREAD 26 INFO: FilterTableUpgrader>>dropOldPrimaryKey, sql=IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'PK_ALERTFILTER' ) ALTER TABLE ALERTFILTER DROP CONSTRAINT PK_ALERTFILTER

2012-10-23 11:16:14.628 THREAD 26 INFO: FilterTableUpgrader>>dropOldPrimaryKey: End. table=ALERTFILTER

2012-10-23 11:16:14.628 THREAD 26 INFO: FilterTableUpgrader>>checkTable: Begin... table=ALERTFILTER

2012-10-23 11:16:14.628 THREAD 26 INFO: FilterTableUpgrader>>checkTable: End. table=ALERTFILTER

2012-10-23 11:16:14.628 THREAD 26 INFO: FilterTableUpgrader>>delDuplicateFilters: Begin... table=ALERTFILTER, idx_del_list=[]

2012-10-23 11:16:14.628 THREAD 26 INFO: FilterTableUpgrader>>delDuplicateFilters: End. table=ALERTFILTER

2012-10-23 11:16:14.628 THREAD 26 INFO: FilterTableUpgrader>>createNewPrimaryKey: Begin... table=ALERTFILTER

2012-10-23 11:16:14.628 THREAD 26 INFO: FilterTableUpgrader>>createNewPrimaryKey: End. table=ALERTFILTER

2012-10-23 11:16:14.628 THREAD 26 INFO: FilterTableUpgrader>>doUpgrade: End. table=ALERTFILTER

2012-10-23 11:16:14.628 THREAD 26 INFO: FilterTableUpgrader>>doUpgrade: Begin... table=AUDIT_REPORT,col_idx=AUDITFILTER_IDX

2012-10-23 11:16:14.628 THREAD 26 INFO: FilterTableUpgrader>>dropOldPrimaryKey: Begin... table=AUDIT_REPORT, idx_constraint=PK_AUDITREPORT

2012-10-23 11:16:14.628 THREAD 26 INFO: FilterTableUpgrader>>dropOldPrimaryKey, sql=IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'PK_AUDITREPORT' ) ALTER TABLE AUDIT_REPORT DROP CONSTRAINT PK_AUDITREPORT

2012-10-23 11:16:14.659 THREAD 26 INFO: FilterTableUpgrader>>dropOldPrimaryKey: End. table=AUDIT_REPORT

2012-10-23 11:16:14.659 THREAD 26 INFO: FilterTableUpgrader>>checkTable: Begin... table=AUDIT_REPORT

2012-10-23 11:16:14.659 THREAD 26 INFO: FilterTableUpgrader>>checkTable: End. table=AUDIT_REPORT

2012-10-23 11:16:14.659 THREAD 26 INFO: FilterTableUpgrader>>delDuplicateFilters: Begin... table=AUDIT_REPORT, idx_del_list=[]

2012-10-23 11:16:14.659 THREAD 26 INFO: FilterTableUpgrader>>delDuplicateFilters: End. table=AUDIT_REPORT

2012-10-23 11:16:14.659 THREAD 26 INFO: FilterTableUpgrader>>createNewPrimaryKey: Begin... table=AUDIT_REPORT

2012-10-23 11:16:14.659 THREAD 26 INFO: FilterTableUpgrader>>createNewPrimaryKey: End. table=AUDIT_REPORT

2012-10-23 11:16:14.659 THREAD 26 INFO: FilterTableUpgrader>>doUpgrade: End. table=AUDIT_REPORT

2012-10-23 11:16:14.659 THREAD 26 INFO: FilterTableUpgrader>>doUpgrade: Begin... table=BEHAVIOR_REPORT,col_idx=BEHAVIORFILTER_IDX

2012-10-23 11:16:14.659 THREAD 26 INFO: FilterTableUpgrader>>dropOldPrimaryKey: Begin... table=BEHAVIOR_REPORT, idx_constraint=PK_BEHAVIORREPORT

2012-10-23 11:16:14.659 THREAD 26 INFO: FilterTableUpgrader>>dropOldPrimaryKey, sql=IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'PK_BEHAVIORREPORT' ) ALTER TABLE BEHAVIOR_REPORT DROP CONSTRAINT PK_BEHAVIORREPORT

2012-10-23 11:16:14.675 THREAD 26 INFO: FilterTableUpgrader>>dropOldPrimaryKey: End. table=BEHAVIOR_REPORT

2012-10-23 11:16:14.675 THREAD 26 INFO: FilterTableUpgrader>>checkTable: Begin... table=BEHAVIOR_REPORT

2012-10-23 11:16:14.675 THREAD 26 INFO: FilterTableUpgrader>>checkTable: End. table=BEHAVIOR_REPORT

2012-10-23 11:16:14.675 THREAD 26 INFO: FilterTableUpgrader>>delDuplicateFilters: Begin... table=BEHAVIOR_REPORT, idx_del_list=[]

2012-10-23 11:16:14.675 THREAD 26 INFO: FilterTableUpgrader>>delDuplicateFilters: End. table=BEHAVIOR_REPORT

2012-10-23 11:16:14.675 THREAD 26 INFO: FilterTableUpgrader>>createNewPrimaryKey: Begin... table=BEHAVIOR_REPORT

2012-10-23 11:16:14.675 THREAD 26 INFO: CovertSQLServerDBNullableColumn, check default constraint sql=SELECT name FROM sysobjects so JOIN sysconstraints sc ON so.id=sc.constid WHERE object_name(so.parent_obj) = 'BEHAVIOR_REPORT' AND so.xtype='D' AND sc.colid = (SELECT colid FROM syscolumns WHERE id=object_id('BEHAVIOR_REPORT') AND name='BEHAVIORTYPE')

2012-10-23 11:16:14.706 THREAD 26 INFO: CovertSQLServerDBNullableColumn, drop default constraint sql=ALTER TABLE BEHAVIOR_REPORT DROP CONSTRAINT DF__BEHAVIOR___BEHAV__2610A626

2012-10-23 11:16:14.706 THREAD 26 INFO: CovertSQLServerDBNullableColumn, update default value sql=UPDATE BEHAVIOR_REPORT SET BEHAVIORTYPE=0 WHERE BEHAVIORTYPE IS NULL

2012-10-23 11:16:14.706 THREAD 26 INFO: CovertSQLServerDBNullableColumn, convert nullable column sql=ALTER TABLE BEHAVIOR_REPORT ALTER COLUMN BEHAVIORTYPE TINYINT NOT NULL

2012-10-23 11:16:14.706 THREAD 26 INFO: CovertSQLServerDBNullableColumn, set default constraint sql=ALTER TABLE BEHAVIOR_REPORT ADD CONSTRAINT DCONS_BEHAVIOR_REPORT_BEHAVIORTYPE DEFAULT 0 FOR BEHAVIORTYPE

2012-10-23 11:16:14.722 THREAD 26 INFO: FilterTableUpgrader>>createNewPrimaryKey: End. table=BEHAVIOR_REPORT

2012-10-23 11:16:14.722 THREAD 26 INFO: FilterTableUpgrader>>doUpgrade: End. table=BEHAVIOR_REPORT

2012-10-23 11:16:14.722 THREAD 26 INFO: FilterTableUpgrader>>doUpgrade: Begin... table=COMPLIANCE_REPORT,col_idx=COMPLIANCEFILTER_IDX

2012-10-23 11:16:14.722 THREAD 26 INFO: FilterTableUpgrader>>dropOldPrimaryKey: Begin... table=COMPLIANCE_REPORT, idx_constraint=PK_COMPLIANCEREPORT

2012-10-23 11:16:14.722 THREAD 26 INFO: FilterTableUpgrader>>dropOldPrimaryKey, sql=IF EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'PK_COMPLIANCEREPORT' ) ALTER TABLE COMPLIANCE_REPORT DROP CONSTRAINT PK_COMPLIANCEREPORT

2012-10-23 11:16:14.722 THREAD 26 INFO: FilterTableUpgrader>>dropOldPrimaryKey: End. table=COMPLIANCE_REPORT

2012-10-23 11:16:14.722 THREAD 26 INFO: FilterTableUpgrader>>checkTable: Begin... table=COMPLIANCE_REPORT

2012-10-23 11:16:14.722 THREAD 26 INFO: FilterTableUpgrader>>checkTable: End. table=COMPLIANCE_REPORT

2012-10-23 11:16:14.722 THREAD 26 INFO: FilterTableUpgrader>>delDuplicateFilters: Begin... table=COMPLIANCE_REPORT, idx_del_list=[]

2012-10-23 11:16:14.722 THREAD 26 INFO: FilterTableUpgrader>>delDuplicateFilters: End. table=COMPLIANCE_REPORT

2012-10-23 11:16:14.722 THREAD 26 INFO: FilterTableUpgrader>>createNewPrimaryKey: Begin... table=COMPLIANCE_REPORT

2012-10-23 11:16:14.737 THREAD 26 INFO: CovertSQLServerDBNullableColumn, check default constraint sql=SELECT name FROM sysobjects so JOIN sysconstraints sc ON so.id=sc.constid WHERE object_name(so.parent_obj) = 'COMPLIANCE_REPORT' AND so.xtype='D' AND sc.colid = (SELECT colid FROM syscolumns WHERE id=object_id('COMPLIANCE_REPORT') AND name='COMPLIANCE_TYPE')

2012-10-23 11:16:14.753 THREAD 26 INFO: CovertSQLServerDBNullableColumn, drop default constraint sql=ALTER TABLE COMPLIANCE_REPORT DROP CONSTRAINT DF__COMPLIANC__COMPL__1D314762

2012-10-23 11:16:15.175 THREAD 26 SEVERE: java.sql.SQLException: 'DF__COMPLIANC__COMPL__1D314762' is not a constraint.

2012-10-23 11:16:15.175 THREAD 26 SEVERE:  at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)

2012-10-23 11:16:15.175 THREAD 26 SEVERE:  at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)

2012-10-23 11:16:15.175 THREAD 26 SEVERE:  at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)

2012-10-23 11:16:15.175 THREAD 26 SEVERE:  at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)

2012-10-23 11:16:15.175 THREAD 26 SEVERE:  at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)

2012-10-23 11:16:15.175 THREAD 26 SEVERE:  at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)

2012-10-23 11:16:15.175 THREAD 26 SEVERE:  at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)

2012-10-23 11:16:15.175 THREAD 26 SEVERE:  at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1166)

2012-10-23 11:16:15.175 THREAD 26 SEVERE:  at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1119)

2012-10-23 11:16:15.175 THREAD 26 SEVERE:  at com.sygate.scm.server.upgrade.FilterTableUpgrader.CovertSQLServerDBNullableColumn(FilterTableUpgrader.java:166)

2012-10-23 11:16:15.175 THREAD 26 SEVERE:  at com.sygate.scm.server.upgrade.FilterTableUpgrader.createNewPrimaryKey(FilterTableUpgrader.java:113)

2012-10-23 11:16:15.175 THREAD 26 SEVERE:  at com.sygate.scm.server.upgrade.FilterTableUpgrader.doUpgrade(FilterTableUpgrader.java:57)

2012-10-23 11:16:15.175 THREAD 26 SEVERE:  at com.sygate.scm.server.upgrade.UpgradeUtil.upgradeFilterTables(UpgradeUtil.java:1823)

2012-10-23 11:16:15.175 THREAD 26 SEVERE:  at com.sygate.scm.server.upgrade.UpgradeUtil.upgradeFilterTables(UpgradeUtil.java:1765)

2012-10-23 11:16:15.175 THREAD 26 SEVERE:  at com.sygate.scm.server.db.util.SqlDbHelper.upgrade(SqlDbHelper.java:828)

2012-10-23 11:16:15.175 THREAD 26 SEVERE:  at com.sygate.scm.server.upgrade.Upgrade.upgradeDatabaseSchema(Upgrade.java:1738)

2012-10-23 11:16:15.175 THREAD 26 SEVERE:  at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:484)

2012-10-23 11:16:15.175 THREAD 26 SEVERE:  at com.sygate.scm.server.upgrade.ui.UpgradeTask.go(UpgradeTask.java:94)

2012-10-23 11:16:15.175 THREAD 26 SEVERE:  at com.sygate.scm.server.upgrade.ui.UpgradeProgressPanel$2.construct(UpgradeProgressPanel.java:131)

2012-10-23 11:16:15.175 THREAD 26 SEVERE:  at com.sygate.scm.util.SwingWorker$2.run(SwingWorker.java:145)

2012-10-23 11:16:15.175 THREAD 26 SEVERE:  at java.lang.Thread.run(Thread.java:662)

2012-10-23 11:16:15.191 THREAD 26 INFO: Upgrade call setBackMaxLogFileSize

2012-10-23 11:16:16.050 THREAD 26 INFO: Upgrade call setBackMaxLogFileSize done: 20000

2012-10-23 11:16:16.050 THREAD 26 SEVERE: java.sql.SQLException: Failed to upgrade schema: java.sql.SQLException: 'DF__COMPLIANC__COMPL__1D314762' is not a constraint.

2012-10-23 11:16:16.050 THREAD 26 SEVERE:  at com.sygate.scm.server.db.util.SqlDbHelper.upgrade(SqlDbHelper.java:859)

2012-10-23 11:16:16.050 THREAD 26 SEVERE:  at com.sygate.scm.server.upgrade.Upgrade.upgradeDatabaseSchema(Upgrade.java:1738)

2012-10-23 11:16:16.050 THREAD 26 SEVERE:  at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:484)

2012-10-23 11:16:16.050 THREAD 26 SEVERE:  at com.sygate.scm.server.upgrade.ui.UpgradeTask.go(UpgradeTask.java:94)

2012-10-23 11:16:16.050 THREAD 26 SEVERE:  at com.sygate.scm.server.upgrade.ui.UpgradeProgressPanel$2.construct(UpgradeProgressPanel.java:131)

2012-10-23 11:16:16.050 THREAD 26 SEVERE:  at com.sygate.scm.util.SwingWorker$2.run(SwingWorker.java:145)

2012-10-23 11:16:16.050 THREAD 26 SEVERE:  at java.lang.Thread.run(Thread.java:662)

2012-10-23 11:16:16.050 THREAD 26 SEVERE: Upgrade.doUpgrade java.sql.SQLException: Failed to upgrade schema: java.sql.SQLException: 'DF__COMPLIANC__COMPL__1D314762' is not a constraint.

2012-10-23 11:16:22.675 THREAD 21 INFO: UpgradeFinalPanel >> saveStage > Launching log file...

 

Comments 5 CommentsJump to latest comment

.Brian's picture

You'll want to open a support with Symantec so they can review the logs and work through this with you.

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

Chetan Savade's picture

Hi,

Are you able to login to SEPM 11.7 RU7 MP2?

Prior to the upgrade was everything working fine?

 

Chetan Savade
Sr Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<

Anna-Sap's picture

Prior to the upgrade everythings worked fine, after the upgrade I've reverted from snapshot and restored the sql server I still can't login to the console, I get server is not syncronized with sql error..

Can you help?

Ashish-Sharma's picture

Hi,

Can you post error screen shot or error code ?

 

Symantec Endpoint Protection 11.x: Best Practices for Disaster Recovery with the Symantec Endpoint Protection Manager

 

Article:TECH102333  |  Created: 2007-01-21  |  Updated: 2011-11-09  |  Article URL http://www.symantec.com/docs/TECH102333

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

 

Article:TECH160736  |  Created: 2011-05-24  |  Updated: 2012-10-29  |  Article URL http://www.symantec.com/docs/TECH160736

 

Thanks In Advance

Ashish Sharma

 

 

Rafeeq's picture

check this document

 

Unable to login to the Symantec Endpoint Protection Manager because the server is not synchronized with the database

 

http://www.symantec.com/business/support/index?pag...