0007407: Organization's tree works randomly - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0007407

Openbravo ERP

A. Platform

public

2009-02-06 09:55

2009-04-23 18:11

Reporter

vmromanos

Assigned To

alostale

Priority

immediate

Severity

critical

Reproducibility

random

Status

closed

Resolution

fixed

Platform

OS Version

Ubuntu 8.04

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0007407: Organization's tree works randomly

Description

The 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 Reproduce

1- 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 Solution

The 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

Additional Information