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

Article Id: 158053

Status: Published

Updated On: 31-05-2013 02:44

Legacy Id: TECH206774

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.