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
SEP 14.2 MP1 with SQL Server.
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.
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.