Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019941Openbravo ERP04. Warehouse managementpublic2012-03-05 12:002012-06-28 12:36
Reporterxabiermerino 
Assigned Tojecharri 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP10Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket14401
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0019941: Error: value too long for type character varying(2000) in m_generate_average_costs
DescriptionError: value too long for type character varying(2000) in m_generate_average_costs.

This error is related with variables:
v_ResultStr
v_CheckResultStr
Steps To ReproduceAs Openbravo Admin execute the process
Realize that the error appears (use a proper database. See notes)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to backport 00226692.50MP50 closed ioritzCia Error: value too long for type character varying(2000) in m_generate_average_costs 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-03-05 12:00xabiermerinoNew Issue
2012-03-05 12:00xabiermerinoAssigned To => vmromanos
2012-03-05 12:00xabiermerinoModules => Core
2012-03-05 12:00xabiermerinoOBNetwork customer => Yes
2012-03-05 12:00xabiermerinoSupport ticket => 14401
2012-03-05 12:00xabiermerinoResolution time => 1333231200
2012-03-05 12:01xabiermerinoIssue Monitored: networkb
2012-03-05 16:32vmromanosAssigned Tovmromanos => jonalegriaesarte
2012-03-06 18:44jonalegriaesarteAssigned Tojonalegriaesarte => jecharri
2012-03-07 12:40jonalegriaesartePriorityurgent => immediate
2012-03-07 18:52hgbotCheckin
2012-03-07 18:52hgbotNote Added: 0046152
2012-03-07 18:52hgbotStatusnew => resolved
2012-03-07 18:52hgbotResolutionopen => fixed
2012-03-07 18:52hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/bb7453d74015e3659d3d65b7a1e015b816a07f2c [^]
2012-03-12 16:31gorkaionIssue Monitored: gorkaion
2012-03-16 09:33jecharriNote Added: 0046498
2012-03-28 10:06xabiermerinoNote Added: 0046805
2012-03-28 10:06xabiermerinoStatusresolved => closed
2012-04-01 20:38hudsonbotCheckin
2012-04-01 20:38hudsonbotNote Added: 0047058
2012-06-27 20:23hgbotCheckin
2012-06-27 20:23hgbotNote Added: 0050203
2012-06-27 20:23hgbotStatusclosed => resolved
2012-06-27 20:23hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/bb7453d74015e3659d3d65b7a1e015b816a07f2c [^] => http://code.openbravo.com/erp/devel/pi/rev/8ce0e3fd4509d53933ad5dd881bb77bbe159826d [^]
2012-06-28 08:01hudsonbotCheckin
2012-06-28 08:01hudsonbotNote Added: 0050229
2012-06-28 12:36jecharriStatusresolved => closed
2012-12-26 10:59maiteRelationship addedrelated to 0022669

Notes
(0046152)
hgbot   
2012-03-07 18:52   
Repository: erp/devel/pi
Changeset: bb7453d74015e3659d3d65b7a1e015b816a07f2c
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Mar 07 18:51:43 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/bb7453d74015e3659d3d65b7a1e015b816a07f2c [^]

Fixes issue 19941: Error: value too long for type
character varying(2000) in m_generate_average_costs

---
M src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml
---
(0046498)
jecharri   
2012-03-16 09:33   
Test case:
-reporter has one database to test the problem
(0046805)
xabiermerino   
2012-03-28 10:06   
verified
(0047058)
hudsonbot   
2012-04-01 20:38   
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/640de9acc2d5 [^]

Maturity status: Test
(0050203)
hgbot   
2012-06-27 20:23   
Repository: erp/devel/pi
Changeset: 8ce0e3fd4509d53933ad5dd881bb77bbe159826d
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Mar 07 18:51:43 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/8ce0e3fd4509d53933ad5dd881bb77bbe159826d [^]

Fixes issue 19941: Error: value too long for type
character varying(2000) in m_generate_average_costs

---
M src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml
---
(0050229)
hudsonbot   
2012-06-28 08:01   
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/c66e853c5cf4 [^]

Maturity status: Test