Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009738Openbravo ERP00. Application dictionarypublic2009-07-01 12:472009-07-22 00:00
Reporternetworkb 
Assigned Toshuehner 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionGentoo
Product Version2.50 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009738: Creation of Forms with long classnames fails.
DescriptionWhen 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 ReproduceGo 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 Solutionfix the length of the v_classname variable in the ad_form_trg2 trigger.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-01 12:47gorkaionNew Issue
2009-07-01 12:47gorkaionAssigned To => rafaroda
2009-07-01 12:47gorkaionOBNetwork customer => Yes
2009-07-01 12:48gorkaionReportergorkaion => networkb
2009-07-01 15:34shuehnerNote Added: 0017738
2009-07-03 19:42pjuvaraNote Added: 0017906
2009-07-03 19:42pjuvaraStatusnew => feedback
2009-07-08 11:33rafarodaNote Added: 0018013
2009-07-13 17:26networkbStatusfeedback => new
2009-07-13 17:26networkbversion => 2.50
2009-07-13 17:31rafarodaAssigned Torafaroda => shuehner
2009-07-13 17:31rafarodaStatusnew => scheduled
2009-07-15 12:21hgbotCheckin
2009-07-15 12:21hgbotNote Added: 0018254
2009-07-15 12:21hgbotStatusscheduled => resolved
2009-07-15 12:21hgbotResolutionopen => fixed
2009-07-15 12:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a419871c7ec76feeca332810b5970761502eb7ef [^]
2009-07-21 08:44sureshbabuStatusresolved => closed
2009-07-21 08:44sureshbabuNote Added: 0018458
2009-07-21 08:44sureshbabuFixed in Version => pi
2009-07-22 00:00anonymoussf_bug_id0 => 2825053

Notes
(0017738)
shuehner   
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   
2009-07-03 19:42   
Please specify the product version.
(0018013)
rafaroda   
2009-07-08 11:33   
Reminder sent to: networkb

Please provide the feedback required. Thanks.
(0018254)
hgbot   
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   
2009-07-21 08:44   
Tested working fine, able to give class name's more than 60 chars.