Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012819Openbravo ERPA. Platformpublic2010-03-26 13:052010-05-18 12:12
Reporteregoitz 
Assigned Toalostale 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP13 
Target Version2.50MP17Fixed in Version2.50MP15 
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
Summary0012819: The variable length of the variable v_ClassName on the trigger ad_tab_trg2 is not correct
DescriptionThe variable length of the variable v_ClassName on the trigger ad_tab_trg2 is not correct.

The length of the variable is 60 and should be bigger because on the trigger
the variable is filled with the mane of the window that could have 60 caracteres plus the tab id.

See the following code of the trigger:

       SELECT AD_MAPPING_FORMAT(TO_CHAR(W.NAME)),
               AD_MAPPING_FORMAT(TO_CHAR(:new.NAME))
        INTO v_WindowName, v_ClassName
        FROM AD_WINDOW W
        WHERE W.AD_WINDOW_ID = :new.AD_WINDOW_ID;
        
        --Add tab id to name for non core modules
        IF (:new.AD_Module_ID != '0') THEN
          v_ClassName := v_ClassName || :new.AD_Tab_ID;
         END IF;
Steps To Reproduce-Starting on a 2.50mp8 create a new window with name with length 59.
-Add a tab
-Update to the last release
-You will get errors.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-03-26 13:05egoitzNew Issue
2010-03-26 13:05egoitzAssigned To => alostale
2010-03-26 13:05egoitzOBNetwork customer => Yes
2010-03-29 08:18alostaleStatusnew => scheduled
2010-03-29 08:18alostalefix_in_branch => pi
2010-04-06 09:06hgbotCheckin
2010-04-06 09:06hgbotNote Added: 0025884
2010-04-06 09:06hgbotStatusscheduled => resolved
2010-04-06 09:06hgbotResolutionopen => fixed
2010-04-06 09:06hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cdfd97ab9a819e1855bb105d0d4ccb54fde370d8 [^]
2010-04-09 13:04marvintmNote Added: 0026028
2010-04-09 13:04marvintmStatusresolved => closed
2010-04-09 13:04marvintmFixed in Version => 2.50MP15
2010-04-10 00:00anonymoussf_bug_id0 => 2984776
2010-04-19 21:12hudsonbotCheckin
2010-04-19 21:12hudsonbotNote Added: 0026411
2010-05-18 12:12gorka_gilTarget Version2.50MP15 => 2.50MP17

Notes
(0025884)
hgbot   
2010-04-06 09:06   
Repository: erp/devel/pi
Changeset: cdfd97ab9a819e1855bb105d0d4ccb54fde370d8
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Apr 06 09:17:40 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/cdfd97ab9a819e1855bb105d0d4ccb54fde370d8 [^]

fixed bug 12819: The variable length of the variable v_ClassName incorrect

---
M src-db/database/model/triggers/AD_TAB_TRG2.xml
---
(0026028)
marvintm   
2010-04-09 13:04   
The fix is correct
(0026411)
hudsonbot   
2010-04-19 21:12   
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/cdfd97ab9a81 [^]
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 [^]