denorm_account_name too long

I am running into an issue with opportunities where the account name is too long for the denorm version:

'UPDATE opportunities SET denorm_account_name = ? WHERE id = ?' with params ["Ecole some very long name here that is more than 50 chars", "616793de-7c43-11ef-8422-001a4a160394"]:

Data too long for column 'denorm_account_name' at row 1

I noticed that account name on our accounts table is varchar(150) while the denorm_account_name on the opportunities table is varchar(50)

I don't remember, quite honestly, if we extended the original size of the account name to match our Oracle ERP back when we started using Sugar in 2010.

Has anyone else run into this issue? 

FrancescaS

 

Parents Reply Children
No Data