Invalid column name 'ASPECTID' error in the AVIcode 5.7 SE-Viewer Configuration Utility

To resolve this problem, use the steps below to rename the existing dbo.ASPECT table and recreate it.

1. Create a full backup of the SE-Viewer database.
2. Open SQL Management Studio and connect to the database instance that contains the SE-Viewer database.
3. In Object Explorer, expand Databases/<SE-Viewer database>/Tables.
4. Right-click the dbo.ASPECT table and click Rename.
5. Rename the table to dbo.ASPECT_old or something similar.
6. Click the New Query button.
7. On the SQL Editor toolbar, make sure the SE-Viewer database is the current table.
8. Paste the below script into the query window and press F5 to execute it.

/*==============================================================*/
/* Table: ASPECT                                                */
/*==============================================================*/
CREATE TABLE DBO.ASPECT (
   ASPECT               NVARCHAR(50)         NOT NULL,
   DESCRIPTION          NVARCHAR(255)        NULL,
   ASPECTID             INT                  IDENTITY,
   CONSTRAINT PK_ASPECT PRIMARY KEY (ASPECTID)
)
go

GRANT SELECT ON DBO.ASPECT TO PUBLIC
GO

INSERT INTO DBO.ASPECT VALUES('All', 'All')
GO

INSERT INTO DBO.ASPECT VALUES('ApplicationFailure', 'Application Failure')
GO

INSERT INTO DBO.ASPECT VALUES('Connectivity', 'Connectivity')
GO

INSERT INTO DBO.ASPECT VALUES('Security', 'Security')
GO

INSERT INTO DBO.ASPECT VALUES('Performance', 'Performance')
GO

INSERT INTO DBO.ASPECT VALUES('uncategorized', 'Operational Info')
GO

INSERT INTO DBO.ASPECT VALUES('SystemFailure', 'System Failure')
GO

/*==============================================================*/
/* End of script */
/*==============================================================*/

After you run the script, run the SE-Viewer Configuration Utility to configure Advisor.