KNOWLEDGE BASE

Fail to Write Some Records Which Have More Than 3072 Characters in One Column to MS SQL Server


Published: 02 Sep 2021
Last Modified Date: 08 Sep 2021

Issue

When using Tableau Prep Builder on the web, some records which have more than 3072 characters in one column fail to be written to MS SQL Server.

Environment

  • Tableau Prep Builder 2021.2.2

Resolution

Current workaround:
Adding a Clean node before the output node with the calculation: LEFT(<field>, 3072)

Cause

 This behavior is caused by a defect, ID 1292181, which is currently under investigation. 
 

Additional Information

For more information, see Tableau Prep on the Web

Up to 3072 characters can be written for text field values. Longer values will be truncated.
Did this article resolve the issue?