Spectrum Error: Failed to complete the operation. The server responded: "Unable to add named table GeoToolEx_UnsupportedBinding

Product Feature: Spatial Data

 

Issue

User is unable to add a Named Table in LIM:

Failed to complete the operation. The server responded: "Unable to add named table: GeoToolEx_UnsupportedBinding: Unsupported binding:"
 
Named Table type is a database and a SQL table.

Details of error in wrapper log:

INFO | jvm 1 | 2014/01/24 16:18:54 | <REMOTE>>[spatial.feature] - [pool-1-thread-1] WARN com.mapinfo.midev.dp.geotools - Missing length for string column "Address". Using length of 256.
INFO | jvm 1 | 2014/01/24 16:18:54 | <REMOTE>>[spatial.feature] - [pool-1-thread-1] WARN com.mapinfo.midev.dp.geotools - Missing length for string column "City". Using length of 256.
INFO | jvm 1 | 2014/01/24 16:18:54 | <REMOTE>>[spatial.feature] - [pool-1-thread-1] WARN com.mapinfo.midev.dp.geotools - Missing length for string column "ZIP". Using length of 256.
INFO | jvm 1 | 2014/01/24 16:18:54 | <REMOTE>>[spatial.feature] - [pool-1-thread-1] WARN com.mapinfo.midev.dp.geotools - Missing length for string column "ZIP4". Using length of 256.
INFO | jvm 1 | 2014/01/24 16:18:54 | <REMOTE>>[spatial.feature] - [pool-1-thread-1] WARN com.mapinfo.midev.dp.geotools - Missing length for string column "GeoResult". Using length of 256.
INFO | jvm 1 | 2014/01/24 16:18:54 | <REMOTE>>[spatial.feature] - [pool-1-thread-1] WARN com.mapinfo.midev.dp.geotools - Missing length for string column "State". Using length of 256.
INFO | jvm 1 | 2014/01/24 16:18:54 | ERROR [SpatialNamedTableManagerService] Unable to add named table:GeoToolsEx_UnsupportedBinding: Unsupported binding: [B.: /AccountsTable


User's Named Connection works:
 
User-added image

SQL table setup:

CREATE TABLE [dbo].[xxx](
[ID] [int] NOT NULL,
[Address] [char](50) NULL,
[City] [varchar](50) NULL,
[ZIP] [varchar](5) NULL,
[ZIP4] [varchar](4) NULL,
[GeoResult] [varchar](11) NULL,
[State] [varchar](2) NULL,
[Max_Load_KVA] [decimal](9, 2) NULL,
[Longitude] [decimal](10, 6) NULL,
[Latitude] [decimal](10, 6) NULL,
[plot_point] [geography] NULL,
PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

Cause

Spectrum Spatial uses GeoTools under the covers to access SQL Server. Unfortunately, GeoTools does not support the Geography data type. Only Geometry.

Resolution

UPDATED: March 30, 2017
Remove column that has datatype "Geography"