Common Data Service Text Field Length Error Message
When I try and set the length of a text field greater than that allowed, I get the error: The table could not be updated: Updating cr2e2_TCOCPlannerImport.cr2e2_taskname.Length is not valid because this is an indexed attribute and hence cannot have size greater than 1700. Original value:1000. New value:2000. Existing index is ndx_cr2e2_TaskName with type=6.
I am trying to set the text field size to 1000. The error message indicates I am trying to set to 2000. I suspect internally this is being doubled to allow for the index, however, the error message is misleading. Setting to 500 characters is permitted.
I wish Microsoft implemented a bug bounty program... I would be rich 🙂