Upgrade to RU2 fails with error: Must declare the scalar variable "@tooOldDef"

Products

• Endpoint Protection

Issue/Introduction

An upgrade of the Symantec Endpoint Protection Manager (SEPM) to version 12.1 RU2 fails with the error:

 

THREAD 12 SEVERE: java.sql.SQLException: Failed to upgrade schema: java.sql.SQLException: java.sql.SQLException: Must declare the scalar variable "@tooOldDef".

 

Cause

The SQL server is using an unsupported case-sensitive SQL Server Collation.

 

Resolution

See article TECH167300 for moving the SEPM database to a SQL Server instance with a supported collation.