Showing results for 
Search instead for 
Do you mean 

Database Utilities returns invaild column name "GPARAMETER"

by Technical Evangelist on ‎07-18-2016 08:03 AM - edited on ‎07-26-2016 10:52 AM by Moderator (507 Views)

Symptoms

Database Utilities returns invalid column name "GPARAMETER"

Diagnosis

Connection to a new SQL Server Spatial database via Database Utilities is returning the error:

 

Invalid column name 'GParameter'.

 

This occurs after creating the required metadata tables.

Solution

This is caused by the use of a database collation that makes object names case sensitive. In this case Latin1_General_CS_AS

 

When Database Utilities queries on the GParameters table, it is using:

 

SELECT GParameter from GParameters;

 

But the column is actually named GPARAMETER.

 

The workaround is to use SQL Server Management Studio and change the column name in the GPARAMETERS table from GPARAMETER to GParameter. This should make the problem will go away.

 

This is actually a bug in that the data server should be making calls to columns as they are defined.

Contributors