Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0013139
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2010-04-27 18:592010-05-18 21:43
ReporternetworkbView Statuspublic 
Assigned Toalostale 
PriorityurgentResolutionfixedFixed in Versionpi
StatusclosedFix in branchFixed in SCM revisionfcb37864f70d
ProjectionnoneETAnoneTarget Version2.50MP17
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP14SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0013139: The ad_tab_trg2 is not correct

DescriptionThe ad_trg2_trg is not correct.
This trigger obtain the javapackage from the module defined on the window and not on the tab.
This error is reproducible when the module of the window is different than the module of the tab.
Steps To Reproduce-Create a new module A. Set name, javapackage, prefix, description and set as indevelopment.
-Create a new module B. Set name, javapackage, prefix, description and set as indevelopment.
-Define a new window. Select A in the module field.
-Create a new tab. Select B in the module field.
-Create fields.

-Compile the application and you get an error because the validation on the Model Object.
Proposed SolutionOn the ad_tab_trg2 field the following select is not correct:

   SELECT W.IsActive,
           (CASE WHEN M.AD_MODULE_ID ='0' THEN NULL ELSE JavaPackage END)
    INTO v_IsActive, v_JavaPackage
    FROM AD_WINDOW W, AD_MODULE M
    WHERE AD_WINDOW_ID = :NEW.AD_WINDOW_ID
     AND W.AD_MODULE_ID = M.AD_MODULE_ID;

You should use the module of the tab and not from the window.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0026797)
alostale (manager)
2010-04-29 15:33

The problem is not in the trigger, which is working correctly. All the tabs in the same window must have the same package.

The problem is in the validation that is not taken into account tabs in a different module than their window.
(0026798)
hgbot (developer)
2010-04-29 15:34

Repository: erp/devel/pi
Changeset: fcb37864f70da8b0315ba8b12f147dc83eacd8bf
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Apr 29 15:34:38 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/fcb37864f70da8b0315ba8b12f147dc83eacd8bf [^]

fixed bug 13139: Incorrect module checking for tabs

---
M src-wad/src/org/openbravo/wad/validation/WADValidator_data.xsql
M src/org/openbravo/erpCommon/utility/UsedByLink.java
M src/org/openbravo/erpCommon/utility/UsedByLink_data.xsql
---
(0027185)
marvintm (developer)
2010-05-13 10:05

Followed the steps to reproduce, and the compilation went well, so the problem appears to be fixed.
(0027456)
hudsonbot (developer)
2010-05-18 21:43

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/fcb37864f70d [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/aa11838d5f80 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17380.obx [^]

- Issue History
Date Modified Username Field Change
2010-04-27 18:59 networkb New Issue
2010-04-27 18:59 networkb Assigned To => alostale
2010-04-29 15:32 alostale Summary The ad_trg2_trg is not correct => The ad_tab_trg2 is not correct
2010-04-29 15:33 alostale Note Added: 0026797
2010-04-29 15:34 hgbot Checkin
2010-04-29 15:34 hgbot Note Added: 0026798
2010-04-29 15:34 hgbot Status new => resolved
2010-04-29 15:34 hgbot Resolution open => fixed
2010-04-29 15:34 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fcb37864f70da8b0315ba8b12f147dc83eacd8bf [^]
2010-05-11 18:19 jpabloae Target Version 2.50MP16 => 2.50MP17
2010-05-13 10:05 marvintm Note Added: 0027185
2010-05-13 10:05 marvintm Status resolved => closed
2010-05-13 10:05 marvintm Fixed in Version => pi
2010-05-14 00:00 anonymous sf_bug_id 0 => 3001313
2010-05-18 21:43 hudsonbot Checkin
2010-05-18 21:43 hudsonbot Note Added: 0027456


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker