Error: "SQLState: S0001 Argument data type bigint is invalid...." when upgrading Endpoint Protection Manager

Products

• Endpoint Protection

Issue/Introduction

You are upgrading your Symantec Endpoint Protection Manager (SEPM) to version 14.2 MP1, and the SEPM upgrade fails with an error.

The SEPM upgrade fails with SQL error "SQLState: S0001 Argument data type bigint is invalid for argument 1 of substring function."

Environment

• Symantec Endpoint Protection Manager 14.2 MP1
• Microsoft Windows Server 2012
• Microsoft SQL Server 2012

Cause

A data type for the column SOURCE_COMPUTER_IP is set incorrectly in the ALERTS database table. An index dependent on this column is preventing the upgrade script from changing it.

Resolution

You will need to delete the index that references SOURCE_COMPUTER_IP prior to continuing with the upgrade. Be sure to test your changes and back up or snapshot your production database before proceeding. If you wish, you can re-create the index after you are finished.

1. Open Microsoft SQL Server Management Studio.
2. Determine which indexes are dependent on the column SOURCE_COMPUTER_IP is using the following commands (these instructions use the default SEM5 database name) by following:
   USE SEM5;
   SELECT * FROM sys.indexes
   WHERE object_id = (SELECT object_id FROM sys.objects WHERE NAME = 'ALERTS')
3. After running this query and getting a list of indexes, export the CREATE INDEX query to a text editor via the clipboard:
   1. Right-click on the index name.
   2. Click Script Index As... -> Create To -> Clipboard.
   3. Paste the query to a text editor and save it. You can give it any name you wish.
4. If the CREATE INDEX query has SOURCE_COMPUTER_IP in the INCLUDE clause, the index will need to be deleted to proceed with the upgrade. Delete it with the following command:
   USE SEM5;
   DROP INDEX [index.name];
   Replace [index.name] with the actual name of the index.
5. After upgrading the SEPM, if you wish to re-create the index, execute the saved query from step 3c.