Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.

Alteryx Designer Knowledge Base

Definitive answers from Designer 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.