Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0019090Openbravo ERP00. Application dictionarypublic2011-11-16 18:142011-11-22 03:50
xabiermerino 
alostale 
immediatemajoralways
closedfixed 
5
3.0MP5 
3.0MP5.1 
User Interface Application
No
0019090: Error when you save a view
There are some times that length of the column value (table: OBUIAPP_UIPersonalization) is not enough. This error appears:

...abSetHeight":332}}}) is too long, it has length 41712, the maximum allowed length is 40000 (http://pastebin.com/6NME496S [^])

See file attached
Go to Application dictionary, table OBUIAPP_UIPersonalization, column value.

Realize that the value is 40000.
Change the length of the column to 100000
No tags attached.
related to design defect 0019092 acknowledged Triage Platform Base DAL forces column length check when saving 
png saveview.png (192,149) 2011-11-16 18:14
https://issues.openbravo.com/file_download.php?file_id=4755&type=bug
png
Issue History
2011-11-16 18:14xabiermerinoNew Issue
2011-11-16 18:14xabiermerinoAssigned To => alostale
2011-11-16 18:14xabiermerinoFile Added: saveview.png
2011-11-16 18:14xabiermerinoModules => User Interface Application
2011-11-16 18:14xabiermerinoResolution time => 1323990000
2011-11-16 18:19xabiermerinoIssue Monitored: networkb
2011-11-17 11:17shuehnerPriorityurgent => immediate
2011-11-17 11:17shuehnerTarget Version3.0MP6 => 3.0MP5.1
2011-11-17 12:01alostaleRelationship addedrelated to 0019092
2011-11-17 12:04alostaleNote Added: 0042924
2011-11-17 12:05hgbotCheckin
2011-11-17 12:05hgbotNote Added: 0042925
2011-11-17 12:05hgbotStatusnew => resolved
2011-11-17 12:05hgbotResolutionopen => fixed
2011-11-17 12:05hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e12facb86555f88591e488fd82a84fc20d8edc8a [^]
2011-11-17 16:16marvintmStatusresolved => closed
2011-11-17 16:17marvintmNote Added: 0042941
2011-11-18 20:02shuehnerNote Added: 0042997
2011-11-22 03:50hudsonbotCheckin
2011-11-22 03:50hudsonbotNote Added: 0043043

Notes
(0042924)
alostale   
2011-11-17 12:04   
I was not able to reproduce the issue, trying to save view in Financial Account window in Spanish is no higher than 35K.

Applying proposed solution anyway.

This change shouldn't create any regression, as it is localized in a single column definition.
(0042925)
hgbot   
2011-11-17 12:05   
Repository: erp/devel/pi
Changeset: e12facb86555f88591e488fd82a84fc20d8edc8a
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Nov 17 12:04:41 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/e12facb86555f88591e488fd82a84fc20d8edc8a [^]

fixed bug 19090: Error when you save a view

---
M modules/org.openbravo.client.application/src-db/database/sourcedata/AD_COLUMN.xml
---
(0042941)
marvintm   
2011-11-17 16:17   
Reviewed diff, and tried to reproduce the original issue as reported. Like Asier, I could not generate a view as long as the one reported. However, with the new size, the problem should no longer happen in any situation.
(0042997)
shuehner   
2011-11-18 20:02   
Retested in MP5.1 appliance. Using system administrator role just saving view of the 'Reference' windows leads to have around a saved datasize of 37k which is already near the old 40k limit. Adding some really long values for some of the filter fields (which need to get saved also) allows to easily produce saved size of 40-50k thus allowing to verify that saving of those sized still works correctly (it does).
(0043043)
hudsonbot   
2011-11-22 03:50   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/ebd713dfe507 [^]

Maturity status: Test