Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019214Openbravo ERP05. Production managementpublic2011-11-30 17:512012-01-16 18:27
Reporterjecharri 
Assigned Tojonalegriaesarte 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP36 
Target Version2.50MP39Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0019214: 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
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00192133.0MP8 closed jonalegriaesarte When you change the project status to order the aplication can fail 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-11-30 17:52jecharriTypedefect => backport
2011-11-30 17:52jecharrifix_in_branch => 2.50
2011-11-30 17:52jecharriWeb browserGoogle Chrome => Google Chrome
2011-11-30 17:52jecharriversionpi => 2.50MP36
2011-11-30 17:52jecharriTarget Version3.0MP8 => 2.50MP39
2012-01-10 12:30hgbotCheckin
2012-01-10 12:30hgbotNote Added: 0044170
2012-01-10 12:30hgbotStatusscheduled => resolved
2012-01-10 12:30hgbotResolutionopen => fixed
2012-01-10 12:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/e06a23c3cbc29564421174a92898458bfcf2a5c9 [^]
2012-01-16 18:26hgbotCheckin
2012-01-16 18:26hgbotNote Added: 0044409
2012-01-16 18:27jecharriNote Added: 0044411
2012-01-16 18:27jecharriStatusresolved => closed

Notes
(0044170)
hgbot   
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   
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   
2012-01-16 18:27   
Verified