Fixing the following error message during upgrade process.
Upgrade error:
“Invalid column name 'DESCRIPTION'. Invalid column name 'DESCRIPTION'. Please see log file for detail information.”
Copy of the full error message:
[06:20:50] Checking DATABASE_MODEL for module upgrades...
[06:20:50] Ensure Mapping tables for Datasource "DATABASE_MODEL"
[06:20:50] Updating function...
[06:20:50] Updating function...
[06:20:50] Creating view...
[06:20:50] Applying Core module patches to databases Primary Configuration and DATABASE_MODEL...
[06:20:50] Patching Core to version 11.2.205.0 to database DATABASE_MODEL
[06:20:51] Patching Core to version 22.0.433.0 to database DATABASE_MODEL
[06:20:51] Adding image metadata columns to GB_INTERVAL_IMAGE
[06:20:52] Patching Core to version 23.0.854.0 to database DATABASE_MODEL
[06:20:52] Adding status management columns to GB_SITE
[06:20:52] Creating table: DT_CONFIG...
[06:20:52] Creating table: DT_TABMAP...
[06:20:52] Creating table: DT_TABFILTER...
[06:20:52] Creating table: DT_KEYFLDS...
[06:20:52] Creating table: DT_FLDMAP...
[06:20:52] Creating table: DT_OPS...
[06:20:52] Creating table: DT_OPMAP...
[06:20:52] Creating view VW_DT_LOOKUP...
[06:20:52] Error on DATABASE_MODEL.
Invalid column name 'DESCRIPTION'.
Invalid column name 'DESCRIPTION'.
Please see log file for detail information.
Summary
Upgrade Failed :
- DATABASE_MODEL
Fixing the problem:
There are three common tables where this offending column can exist.
GB_LKP_CODE
GB_LKP_PROJECT
And
GB_COORD_SYSTEM
To address the problem, you will have to open Microsoft SQL Server Management studio.
Then go to the tables that might be causing the problem and right click on them to open the options menu and click on the design option.
When you are in the design window, change the name of the column that is incorrect to DESCRIPTION.
Once the change has been made, click on the save button and this should then save the changes, and the upgrade can be tested again.
Make sure to check all 3 the tables and the problem might be in 1, 2 or all of them.
Once the changes have been made, retry the upgrade process and the problem should be resolved.
Want to learn more?
Online Help Manuals - Click here for the latest version
Learning Management System - Click here to login or here to request access
Comments
0 comments
Please sign in to leave a comment.