As per existing functionality the operating unit name field in the UI allows up to 160 characters while in the Trial Balance Report the field“DIMNAME2”, which map to operating unit name is restricted upto 100 characters.

This creates the following error while running the Trial Balance Report whenever the character limit exceeds.

session 1025 (Admin)

UPDATE tempdb."DBO".t12042IISdev85ac10b8fa146528_C3683F93651C4DA18E71D08450782412 SET DIMNAME2 = DimAttributeProjTable.Name FROM DimAttributeProjTable WHERE tempdb."DBO".t12042IISdev85ac10b8fa146528_C3683F93651C4DA18E71D08450782412.DIMENTITYINSTANCE2 = DimAttributeProjTable.KEY_ AND DimAttributeProjTable.PARTITION = 5637144576 AND tempdb."DBO".t12042IISdev85ac10b8fa146528_C3683F93651C4DA18E71D08450782412.PARTITION = 5637144576

[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]String or binary data would be truncated.

Object Server Azure:

Cannot execute the required database operation. The SQL database has issued an error.

So we would request to either restrict the operating unit name' field in the UI to what the Database can support, or the Database gets increased to match the name field.