Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Invalid column name 'ASPECTID' error in the AVIcode 5.7 SE-Viewer Configuration Utility
Article ID: 2560917 - View products that this article applies to.
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.
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.
To resolve this problem, use the steps below to rename the existing dbo.ASPECT table and recreate it.
GRANT SELECT ON DBO.ASPECT TO PUBLIC
INSERT INTO DBO.ASPECT VALUES('All', 'All')
INSERT INTO DBO.ASPECT VALUES('ApplicationFailure', 'Application Failure')
INSERT INTO DBO.ASPECT VALUES('Connectivity', 'Connectivity')
INSERT INTO DBO.ASPECT VALUES('Security', 'Security')
INSERT INTO DBO.ASPECT VALUES('Performance', 'Performance')
INSERT INTO DBO.ASPECT VALUES('uncategorized', 'Operational Info')
INSERT INTO DBO.ASPECT VALUES('SystemFailure', 'System Failure')
After you run the script, run the SE-Viewer Configuration Utility to configure Advisor.
(http://go.microsoft.com/fwlink/?LinkId=151500)for other considerations.