Long text not saving text > 50000 chars

Support - Assistance technique
1

In a tracker program, we have defined an element under a stage as ‘long text’ which is expected to save any length data. In the tracker entry form, we tried to save data which is more than 50,000 chars (the limit of text field). But it is showing following import error -

image_2022_03_05T10_18_09_194Z
image_2022_03_05T10_18_09_194Z1920×1080 237 KB

The actual error message -

{
	"httpStatus": "Conflict",
	"httpStatusCode": 409,
	"status": "ERROR",
	"message": "An error occurred, please check import summary.",
	"response": {
		"responseType": "ImportSummary",
		"status": "ERROR",
		"importCount": {
			"imported": 0,
			"updated": 0,
			"ignored": 1,
			"deleted": 0
		},
		"conflicts": [
			{
				"object": "ViO7kF3fvQn",
				"value": "value_length_greater_than_max_length"
			}
		],
		"reference": "k6r04zQl4Y1"
	}
}

We also tried using API calls and faced the exact same error. Has anyone tried saving more than 50k text in long text field and faced the same issue? Is there any settings that can be changed to make this work?

2

Hi @Mahmud ,

That is by design. We put such limitation because it gives us better searching performance on data element and attribute values.

If the intention is to store such a large value, then it is best to convert the value type to FILE.

Thank you.
Abyot.

2 Likes
3

Sorry, that confused me a little. Then what is the difference between Text and Long Text field, if they both can save 50,000 chars max.

1 Like
4

I guess because of this update there isn’t a difference! (: