Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020221Openbravo ERPA. Platformpublic2012-04-10 09:432012-05-25 12:11
Reporterjonalegriaesarte 
Assigned Toguilleaer 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP12Fixed in Version3.0MP12 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020221: Linked items functionality in oracle does not work in user window
DescriptionLinked items functionality in oracle does not work in user window
Steps To Reproduce- Access to user window
- Select "David McHill"
- Linked items section
- An oracle error appears (see attached)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0022732 new AugustoMauch Impossible to delete user 
Attached Filespng userwindow.png (57,226) 2012-04-10 09:43
https://issues.openbravo.com/file_download.php?file_id=5122&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2012-04-10 09:43jonalegriaesarteNew Issue
2012-04-10 09:43jonalegriaesarteAssigned To => alostale
2012-04-10 09:43jonalegriaesarteFile Added: userwindow.png
2012-04-10 09:43jonalegriaesarteModules => Core
2012-05-08 08:44alostaleNote Added: 0048429
2012-05-10 10:53alostaleAssigned Toalostale => guilleaer
2012-05-10 17:44hgbotCheckin
2012-05-10 17:44hgbotNote Added: 0048561
2012-05-10 17:44hgbotStatusnew => resolved
2012-05-10 17:44hgbotResolutionopen => fixed
2012-05-10 17:44hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/78d28661d80a832998fd9e5e3a52d6271d7bd721 [^]
2012-05-10 17:58guilleaerNote Added: 0048565
2012-05-16 11:38marvintmStatusresolved => closed
2012-05-16 11:38marvintmFixed in Version => 3.0MP12
2012-05-25 12:11hudsonbotCheckin
2012-05-25 12:11hudsonbotNote Added: 0049095
2013-04-02 08:43alostaleRelationship addedrelated to 0022732

Notes
(0048429)
alostale   
2012-05-08 08:44   
Some windows are linked from many places (user, client, org...), these are the problematic ones as described in the issue. Making them to work would penalize in terms of performance for the rest of users in the application when trying to calculate linked items. The proposed solution is to detect these cases and display a message informing there are many linked items and they cannot be shown rather than trying to show them.
(0048561)
hgbot   
2012-05-10 17:44   
Repository: erp/devel/pi
Changeset: 78d28661d80a832998fd9e5e3a52d6271d7bd721
Author: Guillermo Álvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Thu May 10 17:43:01 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/78d28661d80a832998fd9e5e3a52d6271d7bd721 [^]

Fixed issue 20221: If too many linked items exists they will not be shown.

In order to avoid problems with oracle (only accepts 1000 items for in expession) and to preserve the performance, the tabs which are related with too many columns (more than 999) will not show the linked items. A new message has been created to be shown.

---
M src-db/database/sourcedata/AD_MESSAGE.xml
M src/org/openbravo/erpCommon/utility/UsedByLink.java
---
(0048565)
guilleaer   
2012-05-10 17:58   
Test plan:

To reproduce the issue with the new demo data, follow the steps to reproduce but select the user "F&BAdmin" instead of "David McHill"

This fix is not risky.
(0049095)
hudsonbot   
2012-05-25 12:11   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/5401e185a8b0 [^]

Maturity status: Test