Hi,

When doing update SEP 12.1.4 to SEP 12.1.5 everything is fine but as you see on picture, database schema migration step doing fail when it comes to 2%, 

Please see attached picture and log.

Best Regards.

Attachment(s)

sepdatabaseerror.txt   106 KB 1 version

You can reboot and try running the upgrade.bat file from the bin directory on the SEPM (c:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\bin)

Hi, already try this but same error. 

open a support ticket .

the issue seems to be becuase of the invalid stored procedure..

2015-02-25 15:45:52.914 THREAD 19 SEVERE: java.sql.SQLException: Invalid object name 'S_UPDATE_VIRUS_CATEGORY'.

Hi, 

Already opened but 5-6 days not answered. 

Ticket number: 08307449 

I still waiting ticket answer.

Best Regards.

Best to open a case as there are issues in the db schema per the log

Follow this document and try

Migration to Endpoint Protection Manager 12.1.4 (RU4) MP1 fails when size of filegroup FG_CONTENT is greater than 30000 MB

http://www.symantec.com/business/support/index?page=content&id=TECH216465

Hello,

This is similar to this same error when upgrading SEPM 12.1.4mp1a

Migration of the Symantec Endpoint Protection Manager to 12.1 RU4 MP1 fails when the FG_CONTENT group's size is greater than 30000MB

See sumit G Comments

https://www-secure.symantec.com/connect/forums/upgrade-sep-manager-ru4-mp1a-failed#comment-10082931

Hope that helps!!

Nope didnt work, still same error. Any other suggest ?

Open a support case.

Thank you all, i will wait for support case answer. If finish well i will write here. 

Best Regards.

Hi all,

At least my problem is solved. 

On the database server we do below query's. 

ALTER SCHEMA dbo TRANSFER db_owner.S_UPDATE_VIRUS_CATEGORY;
ALTER SCHEMA dbo TRANSFER db_owner.SEM_AV_SUMMARY_RISK_DIST;
ALTER SCHEMA dbo TRANSFER db_owner.SEM_HOMEPAGE_UNMANAGED_DISTINCT_MACHINES;
ALTER SCHEMA dbo TRANSFER db_owner.V_HPP_APPLICATION_RISK;