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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0002790
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementminoralways2008-04-01 12:382008-07-03 17:44
ReporterroklenardicView Statuspublic 
Assigned Topheenan 
PrioritynormalResolutionfixedFixed in Version2.40beta
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0002790: Commision field length

DescriptionIn Sales Management || Setup || Commission || Header
I created a new commission named
"Sales Commission for Mcgiver on today's date from Rok".

When I click the Generate commision button, i get the following error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

So field length of the name of the commision here should be restricted or the process fixed.

source: demo2.openbravo.com
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0003690 closedpheenan Commision field length 

-  Notes
(0003408)
pheenan (viewer)
2008-04-25 17:55
edited on: 2008-06-12 09:25

Logged In: YES
user_id=1883435
Originator: NO

Issue is in the C_Commission_Process procedure. Field length for the name variable is 60 characters. The maximum length for the value being passed into this variable is 60 characters. During the process extra values are appended to the variable adding an extra 30 characters. Change the variable length to 90 characters. Following the addition of the appended characters the only inserts involving this variable are to a description field of length 255 characters.
(0003409)
pheenan (viewer)
2008-04-28 10:27
edited on: 2008-06-12 09:25

Logged In: YES
user_id=1883435
Originator: NO

Fixed in revision 3850. Updated v_name variable length to 90 characters to allow for additional characters added to the name value during the process.
(0006379)
user71
2005-06-01 00:00
edited on: 2008-06-12 09:43

This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1931088 [^]

- Issue History
Date Modified Username Field Change
2008-07-03 17:44 plujan Status resolved => closed
2008-07-03 17:44 plujan Fixed in Version 2.40alpha-r2 => 2.40beta


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker