First three tabs of Endpoint Protection Manager are blank after upgrading to 14.2 MP1

Products

• Endpoint Protection

Issue/Introduction

After upgrading Symantec Endpoint Protection Manager (SEPM) from 12.1 to 14.2 MP1, the first three tabs on management console are blank. The remaining tabs are loaded as expected.

Following error is observed in reporting.log relating to unable to find or execute stored procedures:

2019-01-01 00:00:01 Login:start

2019-01-01 00:00:02 ERROR:<br>QUERY: EXEC SEM_GET_GUI_PARAMETERS<br>EXCEPTION: com_exception: <b>Source:</b> Microsoft OLE DB Provider for ODBC Drivers<br/><b>Description:</b> [Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'SEM_GET_GUI_PARAMETERS'. in C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Php\Include\Common\ado.php:584

Environment

SEPM 14.2 MP1 with SQL Server.

Cause

During the SEPM 14.2 MP1 upgrade, the stored procedure schema was not updated from sem5 to dbo for all stored procedures. Some stored procedures may need to have their schema manually updated. 

Resolution

Backup your SEPM database and update the schema on all stored procedures from sem5 to dbo. The SEPM stored procedures can be found under sem5/Programmability/Stored Procedures/dbo.SEM_GET_GUI_PARAMETERS.