Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012906Openbravo ERP02. Master data managementpublic2010-04-07 18:152010-04-19 07:31
Reporteradrianromero 
Assigned Toadrianromero 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP12 
Target VersionFixed in Version 
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
Summary0012906: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0012708 closed adrianromero If you fill a field with the maximum length permited and one of the character is special it fails when saving 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-04-07 18:15adrianromeroNew Issue
2010-04-07 18:15adrianromeroAssigned To => adrianromero
2010-04-07 18:15adrianromeroOBNetwork customer => No
2010-04-07 18:15adrianromeroIssue generated from0012708
2010-04-07 18:15adrianromeroRelationship addedblocks 0012708
2010-04-07 18:15adrianromeroStatusnew => scheduled
2010-04-07 18:15adrianromerofix_in_branch => pi
2010-04-12 19:09adrianromeroNote Added: 0026084
2010-04-12 19:09adrianromeroStatusscheduled => resolved
2010-04-12 19:09adrianromeroResolutionopen => fixed
2010-04-12 19:09adrianromeroFixed in SCM revision => https://code.openbravo.com/erp/stable/2.40/rev/0b5cf110d2b2 [^]
2010-04-12 19:09adrianromerofix_in_branchpi =>
2010-04-19 07:31arunkumarNote Added: 0026326
2010-04-19 07:31arunkumarStatusresolved => closed

Notes
(0026084)
adrianromero   
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   
2010-04-19 07:31   
Tested & working fine