Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019213Openbravo ERP05. Production managementpublic2011-11-30 17:512012-01-25 18:12
Reporterjecharri 
Assigned Tojonalegriaesarte 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP8Fixed in Version3.0MP8 
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
Summary0019213: 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
depends on backport 00192142.50MP39 closed jonalegriaesarte When you change the project status to order the aplication can fail 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-11-30 17:51jecharriNew Issue
2011-11-30 17:51jecharriAssigned To => jonalegriaesarte
2011-11-30 17:51jecharriWeb browser => Google Chrome
2011-11-30 17:51jecharriModules => Core
2011-11-30 17:51jecharriResolution time => 1329692400
2011-11-30 17:51jecharriWeb browserGoogle Chrome => Google Chrome
2011-11-30 17:51jecharriSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=2955#r2955
2011-11-30 17:51jecharriProposed Solution updated
2011-11-30 17:52jecharriStatusnew => scheduled
2011-11-30 17:52jecharrifix_in_branch => pi
2012-01-10 12:17hgbotCheckin
2012-01-10 12:17hgbotNote Added: 0044168
2012-01-10 12:17hgbotStatusscheduled => resolved
2012-01-10 12:17hgbotResolutionopen => fixed
2012-01-10 12:17hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8df306c69e74f7192c659e97163fb9a102597c5c [^]
2012-01-14 21:20hudsonbotCheckin
2012-01-14 21:20hudsonbotNote Added: 0044342
2012-01-25 18:12jecharriNote Added: 0044587
2012-01-25 18:12jecharriStatusresolved => closed
2012-01-25 18:12jecharriFixed in Version => 3.0MP8

Notes
(0044168)
hgbot   
2012-01-10 12:17   
Repository: erp/devel/pi
Changeset: 8df306c69e74f7192c659e97163fb9a102597c5c
Author: Jon Alegría <jon.alegria <at> openbravo.com>
Date: Tue Jan 10 12:17:03 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/8df306c69e74f7192c659e97163fb9a102597c5c [^]

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

---
M src-db/database/model/functions/C_CHANGEPROJECTSTATUSTOORDER.xml
---
(0044342)
hudsonbot   
2012-01-14 21:20   
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/0f91795528e4 [^]

Maturity status: Test
(0044587)
jecharri   
2012-01-25 18:12   
Verified