search cancel

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

book

Article ID: 173961

calendar_today

Updated On:

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.