Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009738 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 00. Application dictionary | major | always | 2009-07-01 12:47 | 2009-07-22 00:00 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | pi | |||
| Status | closed | Fix in branch | Fixed in SCM revision | a419871c7ec7 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | Oracle | Java version | 1.5.0_15 | |||
| OS Version | Gentoo | Database version | 11g | Ant version | 1.7.0 | |||
| Product Version | 2.50 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0009738: Creation of Forms with long classnames fails. | |||||||
| Description | When you try to create a new form with a long classname it fails with an error in the trigger. ORA-06502: PL/SQL: error : buffer de cadenas de caracteres demasiado pequeño numérico o de valor ORA-06512: en "TAD_FINAL.AD_FORM_TRG2", línea 73 ORA-04088: error durante la ejecución del disparador 'TAD_FINAL.AD_FORM_TRG2' | |||||||
| Steps To Reproduce | Go to Application Dictionary || Form || Form Create a new form with a classname longer than 60 characters. Notice that you can shorten the classname and once is inserted go back to the original classname as the field length is 200. | |||||||
| Proposed Solution | fix the length of the v_classname variable in the ad_form_trg2 trigger. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0017738) shuehner (administrator) 2009-07-01 15:34 |
Please do not just change the length of the variable! Instead please change the variable definition to use the %TYPE syntax to define it as the same type (and length) as the classname column in the ad_forms table. This way it automatically adjusts if the classname field is changed ever to a different length. |
|
(0017906) pjuvara (viewer) 2009-07-03 19:42 |
Please specify the product version. |
|
(0018013) rafaroda (viewer) 2009-07-08 11:33 |
Reminder sent to: networkb Please provide the feedback required. Thanks. |
|
(0018254) hgbot (developer) 2009-07-15 12:21 |
Repository: erp/devel/pi Changeset: a419871c7ec76feeca332810b5970761502eb7ef Author: Stefan Hühner <stefan.huehner <at> openbravo.com> Date: Wed Jul 15 12:21:12 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/a419871c7ec76feeca332810b5970761502eb7ef [^] Fixed 9738: Creation of Forms with long classnames fails. modify variable declaration to pick type+length from target column --- M src-db/database/model/triggers/AD_FORM_TRG2.xml --- |
|
(0018458) sureshbabu (viewer) 2009-07-21 08:44 |
Tested working fine, able to give class name's more than 60 chars. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-07-01 12:47 | gorkaion | New Issue | |
| 2009-07-01 12:47 | gorkaion | Assigned To | => rafaroda |
| 2009-07-01 12:47 | gorkaion | OBNetwork customer | => Yes |
| 2009-07-01 12:48 | gorkaion | Reporter | gorkaion => networkb |
| 2009-07-01 15:34 | shuehner | Note Added: 0017738 | |
| 2009-07-03 19:42 | pjuvara | Note Added: 0017906 | |
| 2009-07-03 19:42 | pjuvara | Status | new => feedback |
| 2009-07-08 11:33 | rafaroda | Note Added: 0018013 | |
| 2009-07-13 17:26 | networkb | Status | feedback => new |
| 2009-07-13 17:26 | networkb | version | => 2.50 |
| 2009-07-13 17:31 | rafaroda | Assigned To | rafaroda => shuehner |
| 2009-07-13 17:31 | rafaroda | Status | new => scheduled |
| 2009-07-15 12:21 | hgbot | Checkin | |
| 2009-07-15 12:21 | hgbot | Note Added: 0018254 | |
| 2009-07-15 12:21 | hgbot | Status | scheduled => resolved |
| 2009-07-15 12:21 | hgbot | Resolution | open => fixed |
| 2009-07-15 12:21 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/a419871c7ec76feeca332810b5970761502eb7ef [^] |
| 2009-07-21 08:44 | sureshbabu | Status | resolved => closed |
| 2009-07-21 08:44 | sureshbabu | Note Added: 0018458 | |
| 2009-07-21 08:44 | sureshbabu | Fixed in Version | => pi |
| 2009-07-22 00:00 | anonymous | sf_bug_id | 0 => 2825053 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |