Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
There's still time to register for the Q3 ACE Panel - Spatial Edition presentation tomorrow! | Need more information about the event? Check out the post here

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

Alteryx
Alteryx
Created

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


Cause


The current SQL Server ODBC driver being used.

Resolution


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.