Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0012708 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 02. Master data management | minor | always | 2010-03-17 13:27 | 2010-04-19 21:13 | |||
| Reporter | maite | View Status | public | |||||
| Assigned To | adrianromero | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 6bd4524448a7 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40MP12 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0012708: If you fill a field with the maximum length permited and one of the character is special it fails when saving | |||||||
| Description | If 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 Reproduce | 1. 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0025571) maite (viewer) 2010-03-17 13:29 |
sla date=02/06/2010 |
|
(0025956) adrianromero (viewer) 2010-04-07 18:17 |
The proposal to fix this issue is to change the type of the variable v_Name of the trigger "c_bpartner_location_trg" to NVARCHAR instead of VARCHAR2 because this variable is used to manipulate the data of the field NAME that is of type NVARCHAR. |
|
(0026081) hgbot (developer) 2010-04-12 18:50 |
Repository: erp/devel/pi Changeset: 6bd4524448a7c3aa2068726e7535abdce8d43315 Author: Adrián Romero <adrianromero <at> openbravo.com> Date: Mon Apr 12 19:02:43 2010 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/6bd4524448a7c3aa2068726e7535abdce8d43315 [^] 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 --- |
|
(0026083) adrianromero (viewer) 2010-04-12 19:00 |
To test the issue just follow the reproduction steps and check that after creating a new location with 60 characters in the name even if it has special characters of not it is possible to deactivate. The change set only changes the type of the v_name variable to NVARCHAR2 this what the data type of the v_name varialble is equal to the data type of the column is this variable used for. This change only affects when the Partner Location is modified, there is no other areas affected. |
|
(0026245) plujan (viewer) 2010-04-15 12:03 |
Tested in PI |
|
(0026457) hudsonbot (viewer) 2010-04-19 21:13 |
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated: Changeset: http://code.openbravo.com/erp/devel/main/rev/6bd4524448a7 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/91d98bda46c1 [^] Tests: http://builds.openbravo.com/view/devel-int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17088.obx [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-03-17 13:27 | maite | New Issue | |
| 2010-03-17 13:27 | maite | Assigned To | => adrianromero |
| 2010-03-17 13:29 | maite | Note Added: 0025571 | |
| 2010-04-07 18:15 | adrianromero | Issue cloned | 0012906 |
| 2010-04-07 18:15 | adrianromero | Relationship added | depends on 0012906 |
| 2010-04-07 18:15 | adrianromero | Status | new => scheduled |
| 2010-04-07 18:15 | adrianromero | fix_in_branch | => pi |
| 2010-04-07 18:17 | adrianromero | Note Added: 0025956 | |
| 2010-04-12 18:50 | hgbot | Checkin | |
| 2010-04-12 18:50 | hgbot | Note Added: 0026081 | |
| 2010-04-12 18:50 | hgbot | Status | scheduled => resolved |
| 2010-04-12 18:50 | hgbot | Resolution | open => fixed |
| 2010-04-12 18:50 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/6bd4524448a7c3aa2068726e7535abdce8d43315 [^] |
| 2010-04-12 19:00 | adrianromero | Note Added: 0026083 | |
| 2010-04-15 12:03 | plujan | Note Added: 0026245 | |
| 2010-04-15 12:03 | plujan | Status | resolved => closed |
| 2010-04-16 00:00 | anonymous | sf_bug_id | 0 => 2987968 |
| 2010-04-19 21:13 | hudsonbot | Checkin | |
| 2010-04-19 21:13 | hudsonbot | Note Added: 0026457 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |