Database upgrade failed during schema upgrade 12.1 RU1

Products

• Endpoint Protection

Issue/Introduction

While upgrading the Symantec Endpoint Protection Manager (SEPM) from version 12.1.671.4971 to 12.1 RU1 (12.1.1000.157) the installation fails during the database schema upgrade with the error listed below.

Database upgrade failed

Details:

2012-01-16 11:46:51.172 THREAD 19 INFO: fixAppProtectPolicyForSEP11>> Started.
2012-01-16 11:46:51.172 THREAD 19 SEVERE: java.lang.NullPointerException
2012-01-16 11:46:51.172 THREAD 19 SEVERE: at com.sygate.scm.server.upgrade.SchemaAmberRCToAmberRU1.fixAppProtectPolicyForSEP11(SchemaAmberRCToAmberRU1.java:909)
2012-01-16 11:46:51.172 THREAD 19 SEVERE: at com.sygate.scm.server.upgrade.SchemaAmberRCToAmberRU1.upgradeADCPolicyAndLockDownSetting(SchemaAmberRCToAmberRU1.java:866)
2012-01-16 11:46:51.172 THREAD 19 SEVERE: at com.sygate.scm.server.upgrade.SchemaAmberRCToAmberRU1.upgrade(SchemaAmberRCToAmberRU1.java:210)
2012-01-16 11:46:51.172 THREAD 19 SEVERE: at com.sygate.scm.server.upgrade.SchemaUpgrade.execute(SchemaUpgrade.java:57)
2012-01-16 11:46:51.172 THREAD 19 SEVERE: at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:912)
2012-01-16 11:46:51.172 THREAD 19 SEVERE: at com.sygate.scm.server.upgrade.ui.UpgradeTask.go(UpgradeTask.java:94)
2012-01-16 11:46:51.172 THREAD 19 SEVERE: at com.sygate.scm.server.upgrade.ui.UpgradeProgressPanel$2.construct(UpgradeProgressPanel.java:131)
2012-01-16 11:46:51.172 THREAD 19 SEVERE: at com.sygate.scm.util.SwingWorker$2.run(SwingWorker.java:145)
2012-01-16 11:46:51.172 THREAD 19 SEVERE: at java.lang.Thread.run(Thread.java:662)
2012-01-16 11:46:51.172 THREAD 19 SEVERE: Upgrade.doUpgrade java.lang.NullPointerException
2012-01-16 11:47:31.454 THREAD 15 INFO: UpgradeFinalPanel >> saveStage > Launching log file...
 

Cause

It is caused by a missing policy on the original Symantec Endpoint Protection Manager (SEPM).  While the database schema is upgrading it queries the policy and gets the NULL because the policy does not exist.  The upgrade fails.

Resolution

Check all the policies on the original Symantec Endpoint Protection Manager (SEPM) to find any policies that may have been deleted. 

For example:  The customer doesn't want to use the software firewall so instead of disabling the default policy, they just delete it.

Applies To

This applies to any environment using the embedded database with the Symantec Endpoint Protection Manager (SEPM)