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."

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.

Environment

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

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.