Using a MAXTEXTATTRIBUTELENGTH annotation > 4000 wrongly results in an error when uploading data
When defining an annotation with type MAXTEXTATTRIBUTELENGTH and title 5000 and trying to upload data to such dataflow, then the data upload fails with the error: "The size (5000) given to the parameter 'COMP_3' exceeds the maximum allowed (4000)." This behaviour is incorrect. When MAXTEXTATTRIBUTELENGTH > 4000 then the attribute column should use [NVARCHAR](MAX)
.
Tasks
-
Convert all values used for max text attribute length that are smaller than 0 or bigger than 4000 to 0. Whenever such value is 0 then use NVARCHAR(MAX)
. See: dotstatsuite-core-data-access!348 (closed) -
Update documentation for the MAXTEXTATTRIBUTELENGTH (https://sis-cc.gitlab.io/dotstatsuite-documentation/using-dlm/manage-structures/upload-structure/text-attribute-length/) to specify that there is no maximum value for this setting. A value of 0
or any value higher than4000
means that the limit is practically unlimited (536,870,912 characters). See: sis-cc/dotstatsuite-documentation!542 (merged)
Edited by Jens Dossé