DE14861: Error: "Cannot find data type 'ntext'" when writing data to Azure SQL database

[gtorres8]

Issue

After upgrading from 2019.4 to 2021.3, any workflows that will write data with a V_String or V_WString to an Azure SQL Database now produce the following error:
 

Error: Output Data (3): Error creating table "MY_TABLE": [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cannot find data type 'ntext'.

There was no error present in 2019.4.
 

Environment Details

 

• Alteryx Designer
  • 2019.4
  • 2021.3
• SQL Server
  • All versions
• SQL Server ODBC Drivers
  • 13
  • 17

Cause

Defect ID: DE14861. When a field size of a V_String or V_WString is 1024 or greater, the workflow attempts to assign an ntext data type, which is a deprecated data type not recognized in Azure.

Resolution

 

If the size of the V_String/V_WString is 1023 or less in the column size before writing to the Azure table, the issue is will not occur. This change must be applied to all areas in all workflows manually. If a greater size is required, there are no other workarounds available.

 

Status

Waiting for a fix in a future release of the Alteryx platform.

null