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

Products

• Endpoint Protection

Issue/Introduction

After upgrading from SEPM 12.1 to SEPM 14.2 MP1, you notice that the first three tabs on your management console are blank. The remaining SEPM tabs load as expected.

In the reporting.log, you observe that you are unable to find or execute stored procedures on your SEPM database.

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

Cause

During the SEP 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. 

Environment

SEP 14.2 MP1 with SQL Server.

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.