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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0019213
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 05. Production managementminorhave not tried2011-11-30 17:512012-01-25 18:12
ReporterjecharriView Statuspublic 
Assigned Tojonalegriaesarte 
PriorityhighResolutionfixedFixed in Version3.0MP8
StatusclosedFix in branchpiFixed in SCM revision8df306c69e74
ProjectionnoneETAnoneTarget Version3.0MP8
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browserGoogle Chrome
ModulesCore
Support ticket13406
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0019213: 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 ]
depends on backport 00192142.50MP39 closedjonalegriaesarte When you change the project status to order the aplication can fail 

-  Notes
(0044168)
hgbot (developer)
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 (viewer)
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 (viewer)
2012-01-25 18:12

 Verified

- Issue History
Date Modified Username Field Change
2011-11-30 17:51 jecharri New Issue
2011-11-30 17:51 jecharri Assigned To => jonalegriaesarte
2011-11-30 17:51 jecharri Web browser => Google Chrome
2011-11-30 17:51 jecharri Modules => Core
2011-11-30 17:51 jecharri OBNetwork customer => Yes
2011-11-30 17:51 jecharri Support ticket => 13406
2011-11-30 17:51 jecharri Resolution time => 1329692400
2011-11-30 17:51 jecharri Web browser Google Chrome => Google Chrome
2011-11-30 17:51 jecharri Steps to Reproduce Updated View Revisions
2011-11-30 17:51 jecharri Proposed Solution updated
2011-11-30 17:52 jecharri Status new => scheduled
2011-11-30 17:52 jecharri fix_in_branch => pi
2012-01-10 12:17 hgbot Checkin
2012-01-10 12:17 hgbot Note Added: 0044168
2012-01-10 12:17 hgbot Status scheduled => resolved
2012-01-10 12:17 hgbot Resolution open => fixed
2012-01-10 12:17 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8df306c69e74f7192c659e97163fb9a102597c5c [^]
2012-01-14 21:20 hudsonbot Checkin
2012-01-14 21:20 hudsonbot Note Added: 0044342
2012-01-25 18:12 jecharri Note Added: 0044587
2012-01-25 18:12 jecharri Status resolved => closed
2012-01-25 18:12 jecharri Fixed in Version => 3.0MP8

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker