INFORMATIONAL ** THIS INFORMATION HAS NOT BEEN VERIFIED **

"ERROR [42S22][(Microsoft)][ODBC SQL Server Driver][SQL Server]Invalid column name 'X'"

Entry Type: Informational

Product: Sage MAS Intelligence

Application: n/a

Version Reported: 7.30

Subject:
"ERROR [42S22][(Microsoft)][ODBC SQL Server Driver][SQL Server]Invalid column name 'X'" displays when running the SMI Database Upgrade Utility.

Steps to Duplicate:

1. In Microsoft Windows, Start, All Programs, Sage Software, Sage MAS 500, Utilities, SMI Database Upgrade Utility.
2. Enter/Select a Server Name, Database Name. 
3. Enter MAS 500 SQL Server database credentials.
4. Click Ok. The following displays:
   "Database update error"
   "An error occurred creating Sage MAS 500 Intelligence modules, tasks and desktop icons."
   "ERROR [42S22][(Microsoft)][ODBC SQL Server Driver][SQL Server]Invalid column name 'GroupID'"
   "ERROR [42S22][(Microsoft)][ODBC SQL Server Driver][SQL Server]Invalid column name 'GroupContentPath'"
   "ERROR [42S22][(Microsoft)][ODBC SQL Server Driver][SQL Server]Invalid column name 'GroupImageIndex'"
   "ERROR [42S22][(Microsoft)][ODBC SQL Server Driver][SQL Server]Invalid column name 'GroupID'"
   "ERROR [42S22][(Microsoft)][ODBC SQL Server Driver][SQL Server]Invalid column name 'GroupContentPath'"
   "ERROR [42S22][(Microsoft)][ODBC SQL Server Driver][SQL Server]Invalid column name 'GroupImageIndex'"
   "ERROR [42S22][(Microsoft)][ODBC SQL Server Driver][SQL Server]Invalid column name 'GroupID'"
   "ERROR [42S22][(Microsoft)][ODBC SQL Server Driver][SQL Server]Invalid column name 'GroupContentPath'"
   "ERROR [42S22][(Microsoft)][ODBC SQL Server Driver][SQL Server]Invalid column name 'GroupImageIndex'"
   "ERROR [42S22][(Microsoft)][ODBC SQL Server Driver][SQL Server]Invalid column name 'GroupID'"

Possible Resolution:
Review the version of MAS 500.

In this case, the customer was attempting to install SMI on version 7.20. SMI is only compatible on MAS 500 versions 7.30 and up.