Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

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

gtorres8
Alteryx
Alteryx
Created

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
No ratings