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...