Hi @omkarb26011,
According to SQL Server documentation, error code 1946 states:
Operation failed. The index entry of length %d bytes for the index '%.*ls' exceeds the maximum length of %d bytes.
Seems to indicate an issue with the index on the column. Have you by any chance defined an Alternate Key that uses your multiline text column, or do you have Dataverse search enabled for the column? If so, what is the maximum length defined for your multiline text? I believe there is a maximum size for non-clustered index values in SQL Server which is 1700.
If you do have a Key defined for the column or enabled Dataverse search for the column, I would try removing it and see if that fixes the issue.
---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.