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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0007407
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformcriticalrandom2009-02-06 09:552009-04-23 18:11
ReportervmromanosView Statuspublic 
Assigned Toalostale 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision13038
ProjectionnoneETAnoneTarget Versionpi
OSLinux 32 bitDatabaseOracleJava version1.5
OS VersionUbuntu 8.04Database versionSEAnt version1.7
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0007407: Organization's tree works randomly

DescriptionThe organization's tree (inside General Setup || Enterprise || Organization) only works if the AD_Client_ID of the current client is less than 0 (which is the AD_Client_ID of the System client)

Example: Suppose that we have two clients ('0' and 'C99F9203BCA84A998926C5C8555E62A5'). If we try to display the organization's tree of the latest client, the application will show an empty tree called "BigBazaar OrganizaciĆ³n" instead of the client's one.

But, if the AD_Client_ID is, for example, '1000000', the tree will be displayed properly.
Steps To Reproduce1- Run an initial client setup
2- Go to the database and check if the new AD_Client_ID starts with a letter instead of a number. In this case you can follow with the steps, otherwise repeat this process until you get an AD_Client_ID which starts with a letter.
3- Change the role to the already created one.
4- Create a new organization using the initial org setup
5- Go to General Setup || Enterprise || Organization, display the tree and it will be wrong.
Proposed SolutionThe problem is inside the WindowTree.java file. In the line 58 it is using the WindowTreeData.selectTreeID() method, which returns the list of trees ordered by ad_client_id desc. The returned list includes the 0 tree and the current client's tree.

Then, in line 61, it is taken always the first one, so if the ad_client_id of the current client is less than 0 (i.e. it starts with a letter) the tree's won't be displayed properly
Tagsmain
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0007502pi closedalostale WindowTreeData generates incorrectly 

-  Notes
(0013328)
svnbot (reporter)
2009-02-10 18:15

Repository: openbravo
Revision: 13031
Author: alostale
Date: 2009-02-10 18:15:32 +0100 (Tue, 10 Feb 2009)

fixed bug 0007407: Organization's tree works randomly

---
U trunk/src/org/openbravo/erpCommon/utility/WindowTree_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=13031&sc=1 [^]
(0013335)
svnbot (reporter)
2009-02-11 08:40

Repository: openbravo
Revision: 13038
Author: alostale
Date: 2009-02-11 08:40:02 +0100 (Wed, 11 Feb 2009)

fixed bug 0007407: Organization's tree works randomly, fixed query for PG syntax

---
U trunk/src/org/openbravo/erpCommon/utility/WindowTree_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=13038&sc=1 [^]

- Issue History
Date Modified Username Field Change
2009-02-06 09:55 vmromanos New Issue
2009-02-06 09:55 vmromanos Assigned To => rafaroda
2009-02-06 09:55 vmromanos sf_bug_id 0 => 2571749
2009-02-06 09:55 vmromanos Regression testing => No
2009-02-10 11:06 psarobe Priority normal => urgent
2009-02-10 11:08 psarobe Assigned To rafaroda => alostale
2009-02-10 11:08 psarobe Priority urgent => immediate
2009-02-10 11:08 psarobe Severity major => critical
2009-02-10 11:08 psarobe Status new => scheduled
2009-02-10 11:08 psarobe Category 01. General setup => A. Platform
2009-02-10 18:15 svnbot Checkin
2009-02-10 18:15 svnbot Note Added: 0013328
2009-02-10 18:15 svnbot Status scheduled => resolved
2009-02-10 18:15 svnbot Resolution open => fixed
2009-02-10 18:15 svnbot svn_revision => 13031
2009-02-11 08:40 svnbot Checkin
2009-02-11 08:40 svnbot Note Added: 0013335
2009-02-11 08:40 svnbot svn_revision 13031 => 13038
2009-02-11 14:48 rafaroda Relationship added related to 0007502
2009-04-22 11:24 psarobe Tag Attached: main
2009-04-23 18:11 psarobe Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker