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

Article ID: 2560917 - View products that this article applies to.
Expand all | Collapse all

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.

  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.

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2560917 - Last Review: June 6, 2011 - Revision: 2.0
APPLIES TO
  • AVIcode, Inc.
Keywords: 
KB2560917

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com