Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022669Openbravo ERP04. Warehouse managementpublic2012-12-26 10:592013-08-20 01:26
Reportermaite 
Assigned ToioritzCia 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP49 
Target Version2.50MP50Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket18687
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0022669: 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 defect 00199413.0MP10 closed jecharri Error: value too long for type character varying(2000) in m_generate_average_costs 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-12-26 10:59maiteNew Issue
2012-12-26 10:59maiteAssigned To => dmiguelez
2012-12-26 10:59maiteModules => Core
2012-12-26 10:59maiteOBNetwork customer => Yes
2012-12-26 10:59maiteSupport ticket => 18687
2012-12-26 10:59maiteTriggers an Emergency Pack => No
2012-12-26 10:59maiteAssigned Todmiguelez => maite
2012-12-26 10:59maiteAssigned Tomaite => ioritzCia
2012-12-26 10:59maiteRelationship addedrelated to 0019941
2012-12-26 11:00maiteversion => 2.50MP49
2012-12-26 11:00maiteTarget Version => 2.50MP50
2013-01-24 13:17hgbotCheckin
2013-01-24 13:17hgbotNote Added: 0055813
2013-01-24 13:17hgbotStatusnew => resolved
2013-01-24 13:17hgbotResolutionopen => fixed
2013-01-24 13:17hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/56a1306e07a032838db938b3b5a410472a249186 [^]
2013-01-28 16:48maiteNote Added: 0055917
2013-01-28 16:48maiteStatusresolved => closed
2013-08-16 13:21hgbotCheckin
2013-08-16 13:21hgbotNote Added: 0060607
2013-08-16 13:21hgbotStatusclosed => resolved
2013-08-16 13:21hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.50/rev/56a1306e07a032838db938b3b5a410472a249186 [^] => http://code.openbravo.com/erp/devel/pi/rev/c76f162b7ab00fa04fafe7d1fa5051133a019a4e [^]
2013-08-16 13:24shuehnerNote Added: 0060609
2013-08-16 13:24shuehnerStatusresolved => closed
2013-08-20 01:26hudsonbotCheckin
2013-08-20 01:26hudsonbotNote Added: 0060664

Notes
(0055813)
hgbot   
2013-01-24 13:17   
Repository: erp/stable/2.50
Changeset: 56a1306e07a032838db938b3b5a410472a249186
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Thu Jan 24 13:16:12 2013 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/56a1306e07a032838db938b3b5a410472a249186 [^]

Fixes issue 22669: Value too long in m_generate_average_costs.

---
M src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml
---
(0055917)
maite   
2013-01-28 16:48   
verified
(0060607)
hgbot   
2013-08-16 13:21   
Repository: erp/devel/pi
Changeset: c76f162b7ab00fa04fafe7d1fa5051133a019a4e
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Fri Aug 16 13:21:17 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c76f162b7ab00fa04fafe7d1fa5051133a019a4e [^]

Fixed 22176. Fixed 22669. Improve api-check
- Ignore ad_process_para insertions for new added processes as those
  are false positives.
- Report dropping of a not null constraint as api-check as existing
  code may rely on the column having a value.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0060609)
shuehner   
2013-08-16 13:24   
Was accidentally re-opened only, closing again.
(0060664)
hudsonbot   
2013-08-20 01:26   
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/28c60a43e596 [^]

Maturity status: Test