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

0 Chris Raffle 15 hours ago

Hi Francesca Shiekh ,

Both the accounts.name and opportunities.denorm_account_name field are varchar(255) in the default schema, so it seems likely these values were reduced through extended vardefs or manual database schema updates. At a minimum, I recommend increasing the denorm_account_name on Opportunities to match your accounts.name length. I recommend also checking the denorm_account_name column on other tables such as contacts, cases, etc. to prevent similar failures.

Chris

Co-Founder | SugarCRM's 2024 Global Outfitters Partner of the Year
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Francesca Shiekh 2 hours ago in reply to Chris Raffle
This is very odd. I have Extensions for the denorm_account_name but I wasn't the one who did this, and I'm the only one who works in Sugar.

Revenue Line Items is new to us and I've not put it in use yet.

So something in the upgrade process added these:

custom/Extension/modules/Cases/Ext/Vardefs/denorm_account_name.php custom/Extension/modules/Contacts/Ext/Vardefs/denorm_account_name.php custom/Extension/modules/Opportunities/Ext/Vardefs/denorm_account_name.php custom/Extension/modules/RevenueLineItems/Ext/Vardefs/denorm_account_name.php
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Francesca Shiekh 2 hours ago in reply to Chris Raffle
This is very odd. I have Extensions for the denorm_account_name but I wasn't the one who did this, and I'm the only one who works in Sugar.

Revenue Line Items is new to us and I've not put it in use yet.

So something in the upgrade process added these:

custom/Extension/modules/Cases/Ext/Vardefs/denorm_account_name.php custom/Extension/modules/Contacts/Ext/Vardefs/denorm_account_name.php custom/Extension/modules/Opportunities/Ext/Vardefs/denorm_account_name.php custom/Extension/modules/RevenueLineItems/Ext/Vardefs/denorm_account_name.php
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data