14.3 RU3 upgrade immediately fails at database upgrade step

Products

• Endpoint Protection Cloud

Issue/Introduction

Upgrading to 14.3 RU2 to 14.3 RU3 fails immediately when it reaches the database upgrade step.

Error:

2021-12-21 11:47:45.063 THREAD 38 SEVERE: SQLState:  S0001
2021-12-21 11:47:45.063 THREAD 38 SEVERE: Message:  Incorrect syntax near '\'.

Environment

14.3 RU2

Cause

During the previous upgrade, tables were converted to the service account schema instead of dbo.

Tables:

Resolution

1. Rename the incorrect user-schema tables using SQL Enterprise Studio by right-clicking on the tables and choosing rename, adding _bak on the end.
2. Create new tables with the correct dbo schema. The below schema is for 14.3 RU2 or RU3. Schema may change between versions. To obtain a proper script, right-click on the table in a working instances and choose Script As: Create To: Query window.
   Query 1:
   

   /****** Object:  Table [dbo].[SEM_COMPUTER_NIC]    Script Date: 12/20/2021 2:14:58 PM ******/
   SET ANSI_NULLS ON
   GO

   SET QUOTED_IDENTIFIER ON
   GO

   CREATE TABLE [dbo].[SEM_COMPUTER_NIC](
   [COMPUTER_ID] [char](32) NOT NULL,
   [IP_ADDR] [varbinary](16) NOT NULL,
   [MAC_ADDR] [varchar](17) NULL,
   [GATEWAY] [varbinary](16) NULL,
   [SUBNET_MASK] [int] NULL,
   [NIC_NUMBER] [tinyint] NOT NULL,
   [USN] [bigint] NOT NULL,
   [TIME_STAMP] [bigint] NOT NULL,
   [DELETED] [tinyint] NOT NULL,
    CONSTRAINT [PK_SEM_COMPUTER_NIC] PRIMARY KEY CLUSTERED
   (
   [COMPUTER_ID] ASC,
   [IP_ADDR] ASC
   )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [FG_INDEX]
   ) ON [FG_INDEX]
   GO

   Query 2:
   

   /****** Object:  Table [dbo].[CIA_PSK_VERSIONS]    Script Date: 12/21/2021 4:16:35 PM ******/
   SET ANSI_NULLS ON
   GO

   SET QUOTED_IDENTIFIER ON
   GO

   CREATE TABLE [dbo].[CIA_PSK_VERSIONS](
   [PROFILE_SERIAL_NO] [varchar](64) NOT NULL,
   [PSK_VERSION] [int] NOT NULL,
    CONSTRAINT [PK_SERIAL_NO] PRIMARY KEY CLUSTERED
   (
   [PROFILE_SERIAL_NO] ASC
   )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
   ) ON [PRIMARY]
   GO

NOTE!!! Always backup the database before making any changes.

After the creation of the new tables, run the upgrade.