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

Article
06/06/2011

Here’s a quick heads up on a new Knowledge Base article for AVIcode that we published this morning:

=====

Symptoms

When using AVIcode Intercept Studio 5.7, you receive the following error in the SE-Viewer Configuration Utility when you try to update the SE-Viewer database for use with Advisor:

Invalid column name 'ASPECTID'.

Specifically, this problem affects SE-Viewer installations that previously ran the 4.1 version.

Cause

The dbo.ASPECT table had different columns and data types in the 4.1 version of Intercept Studio. When you upgrade from 4.1 to version 5.0 or higher, the upgrade retains these old column names and data types. However, the script in 5.7 to prepare the SE-Viewer database for use with Advisor does not work with the old version of the table.

Resolution

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

Create a full backup of the SE-Viewer database.
Open SQL Management Studio and connect to the database instance that contains the SE-Viewer database.
In Object Explorer, expand Databases/<SE-Viewer database>/Tables.
Right-click the dbo.ASPECT table and click Rename.
Rename the table to dbo.ASPECT_old or something similar.
Click the New Query button.
On the SQL Editor toolbar, make sure the SE-Viewer database is the current table.
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.

=====

For the most current information please see the following:

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

J.C. Hornbeck | System Center Knowledge Engineer

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

Symptoms

Cause

Resolution

Additional resources