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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0012906
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 02. Master data managementminoralways2010-04-07 18:152010-04-19 07:31
ReporteradrianromeroView Statuspublic 
Assigned Toadrianromero 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision0b5cf110d2b2
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40MP12SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012906: If you fill a field with the maximum length permited and one of the character is special it fails when saving

DescriptionIf you fill a field with the maximum length permited and one of the character is special it fails when saving

ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "TAD_240_FULL.C_BPARTNER_LOCATION_TRG", line 70 ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-04088: error during execution of trigger 'TAD_240_FULL.C_BPARTNER_LOCATION_TRG'
Steps To Reproduce1. Master Data Management || Business Partner || Business Partner >> Location/Address: create new record
2. Press Location selector and set 1st line= áaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa (60length with special character)
SAVE
3. Try to deactivate the record and you will get the error

If you create a new record with 1st line= aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa (60length with NO special character) you can deactivate record without problems
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0012708 closedadrianromero If you fill a field with the maximum length permited and one of the character is special it fails when saving 

-  Notes
(0026084)
adrianromero (manager)
2010-04-12 19:09

Repository: erp/devel/stable/2.40
Changeset: 0b5cf110d2b2
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon Apr 12 19:17:18 2010 +0200
URL: https://code.openbravo.com/erp/stable/2.40/rev/0b5cf110d2b2 [^] [^]

Fixes issue 0012708: If you fill a field with the maximum length permited and one of the character is special it fails when saving

---
M src-db/database/model/triggers/C_BPARTNER_LOCATION_TRG.xml
(0026326)
arunkumar (reporter)
2010-04-19 07:31

Tested & working fine

- Issue History
Date Modified Username Field Change
2010-04-07 18:15 adrianromero New Issue
2010-04-07 18:15 adrianromero Assigned To => adrianromero
2010-04-07 18:15 adrianromero Issue generated from 0012708
2010-04-07 18:15 adrianromero Relationship added blocks 0012708
2010-04-07 18:15 adrianromero Status new => scheduled
2010-04-07 18:15 adrianromero fix_in_branch => pi
2010-04-12 19:09 adrianromero Note Added: 0026084
2010-04-12 19:09 adrianromero Status scheduled => resolved
2010-04-12 19:09 adrianromero Resolution open => fixed
2010-04-12 19:09 adrianromero Fixed in SCM revision => https://code.openbravo.com/erp/stable/2.40/rev/0b5cf110d2b2 [^]
2010-04-12 19:09 adrianromero fix_in_branch pi =>
2010-04-19 07:31 arunkumar Note Added: 0026326
2010-04-19 07:31 arunkumar Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker