Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.

Alteryx Designer: Internal Error in Field_Blob::GetAsSpatialBlob: Invalid SpatialBlob when using Spatial Object in SQL Server

Alteryx Alumni (Retired)

Environment Details

A SQL Server input tool using a SpatialObj data type caused the following error to occur:

Internal Error in Field_Blob::GetAsSpatialBlob: Invalid SpatialBlob

idea Skyscrapers
  • Alteryx Designer 2019.4
  • SQL Server 2008R2
  • ODBC Driver


The current SQL Server ODBC driver being used.


Select a different ODBC driver for SQL Server:

  1. On the Start menu, type in ODBC and click on ODBC Data Sources (64-bit).
  2. Click on the System DSN tab and click the Add button.
  3. Select the driver: SQL Server Native Client 11.0 and click on Finish.
  4. Configure the DSN following the on-screen prompts and test the connection.
  5. If the connection is successful, use the newly configured DSN as the data source in the workflow and re-test the issue.