This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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 firstname.lastname@example.org for assistance.
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.
SQL Server ODBC Drivers
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.
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.
Waiting for a fix in a future release of the Alteryx platform.