Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

gtorres8
Alteryx Alumni (Retired)
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.