Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0019214
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 05. Production managementminorhave not tried2011-11-30 17:512012-01-16 18:27
ReporterjecharriView Statuspublic 
Assigned Tojonalegriaesarte 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branch2.50Fixed in SCM revisione06a23c3cbc2
ProjectionnoneETAnoneTarget Version2.50MP39
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP36SCM revision 
Review Assigned To
Web browserGoogle Chrome
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0019214: When you change the project status to order the aplication can fail

DescriptionWhen you change the project status to order the aplication can fail.

The application will fail in case that the business partner asocciated to the project has a name larger than 49 characters.
Steps To ReproduceIf you go to function c_changeprojectstatustoorder you will see that there are inserts in column name (character varying(60)) for tables M_PRICELIST and M_PRICELIST_VERSION where is inserting:
(Cur_SO.value || ' - ' || v_BPName)
(Cur_SO.value || ' - ' ||v_BPName|| ' - ' ||TRUNC(TO_DATE(NOW()), 'DD'))

And the definition for column "v_BPName"(is referenced to "c_bpartner.name") is character varying(60).
Proposed SolutionSubstring of the "business partner name" when it has more than 49 characters
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 00192133.0MP8 closedjonalegriaesarte When you change the project status to order the aplication can fail 

-  Notes
(0044170)
hgbot (developer)
2012-01-10 12:30

 Repository: erp/stable/2.50
Changeset: e06a23c3cbc29564421174a92898458bfcf2a5c9
Author: Jon Alegría <jon.alegria <at> openbravo.com>
Date: Tue Jan 10 12:30:25 2012 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/e06a23c3cbc29564421174a92898458bfcf2a5c9 [^]

Fixes issue 0019214: When you change the project status to order the
aplication can fail

---
M src-db/database/model/functions/C_CHANGEPROJECTSTATUSTOORDER.xml
---
(0044409)
hgbot (developer)
2012-01-16 18:26

 Repository: erp/stable/2.50
Changeset: 839dde1f226aa134c4679dcdb922ed7a36240623
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Mon Jan 16 18:25:28 2012 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/839dde1f226aa134c4679dcdb922ed7a36240623 [^]

issue 19214: When you change the project status to order the aplication can fail.
TRUNC(now(),'DD')) return '2012-01-16', so the substring needs to be shorter.

---
M src-db/database/model/functions/C_CHANGEPROJECTSTATUSTOORDER.xml
---
(0044411)
jecharri (developer)
2012-01-16 18:27

 Verified

- Issue History
Date Modified Username Field Change
2011-11-30 17:52 jecharri Type defect => backport
2011-11-30 17:52 jecharri fix_in_branch => 2.50
2011-11-30 17:52 jecharri Web browser Google Chrome => Google Chrome
2011-11-30 17:52 jecharri version pi => 2.50MP36
2011-11-30 17:52 jecharri Target Version 3.0MP8 => 2.50MP39
2012-01-10 12:30 hgbot Checkin
2012-01-10 12:30 hgbot Note Added: 0044170
2012-01-10 12:30 hgbot Status scheduled => resolved
2012-01-10 12:30 hgbot Resolution open => fixed
2012-01-10 12:30 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/e06a23c3cbc29564421174a92898458bfcf2a5c9 [^]
2012-01-16 18:26 hgbot Checkin
2012-01-16 18:26 hgbot Note Added: 0044409
2012-01-16 18:27 jecharri Note Added: 0044411
2012-01-16 18:27 jecharri Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker