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

[gtorres8]

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

• 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.