Description Columns causing upgrade to fail. – Geobank Quick Articles

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] 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'.

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

Related articles