search cancel

Endpoint Protection Manager 14.0 upgrade fails with SQLException: Failed to upgrade schema

book

Article ID: 163864

calendar_today

Updated On:

Products

Endpoint Protection

Issue/Introduction

The upgrade process for Symantec Endpoint Protection Manager (SEPM) 14.0 fails and rolls back with an SQLException during the database schema upgrade.

 

The SEPM Upgrade-0.log or install_log.err file would contain the error.

STDERR: SQL Exception:
STDERR: SQL Command: WITH DATE_RANGE AS ( SELECT CAST('2000-01-01' AS DATETIME) ...
STDERR: SQLState:  S0003
STDERR: Message: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
STDERR: Vendor:  242

 

Cause

The error occurs if the MSSQL server DATEFORMAT setting is DMY rather than MDY.

This SQL command can find the current setting:

select DATEFORMAT from sys.syslanguages where name = @@LANGUAGE;

 

Resolution

This problem is fixed in Symantec Endpoint Protection 14 MP1. For information on how to obtain the latest build of Symantec Endpoint Protection, read Download the latest version of Symantec Endpoint Protection.