Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017913Openbravo ERPA. Platformpublic2011-07-06 10:022011-07-13 10:52
Reporteralostale 
Assigned Toalostale 
PriorityurgentSeveritymajorReproducibilityrandom
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP0 
Target Version3.0MP2Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesJSON Datasource
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017913: Navigation to blank tab
DescriptionDirect navigation to related objects results in a blank page in some occasions.

This can happen when the number of records in the destiny table is big enough and the default sorting column for that tab does not do a deterministic order.

When doing the navigation, it is not only loaded the selected record but a set of records that must contain the selected one. This is done to be able to switch to grid view quickly. In order to do it 2 queries are executed to DB: 1st one to determine the position of the selected record and 2nd one to get the actual data limiting the results to a number (100) of records that includes the selected one.

In the case described above, it can happen 2nd query doesn't order in the same way 1st one does. If this happens and the 2nd query does not include selected record, tab is shown blank.

Workaround: when this happens it can be easily solved by using a sort column (Record Sort No. in tab) one which is unique (i.e. document no) so it makes the order deterministic.
Steps To ReproduceCan be reproduced in ob@ob3 navigating from SO 10000528 to its contract
Proposed SolutionAlways append record id to the order by clause
Additional Information
TagsNo tags attached.
Relationships
related to defect 00179253.0MP2 closed alostale Navigation to blank tab having inactive records 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-07-06 10:02alostaleNew Issue
2011-07-06 10:02alostaleAssigned To => alostale
2011-07-06 10:02alostaleModules => JSON Datasource
2011-07-06 10:31alostaleDescription Updatedbug_revision_view_page.php?rev_id=2361#r2361
2011-07-06 10:31alostaleProposed Solution updated
2011-07-06 11:04hgbotCheckin
2011-07-06 11:04hgbotNote Added: 0038893
2011-07-06 11:04hgbotStatusnew => resolved
2011-07-06 11:04hgbotResolutionopen => fixed
2011-07-06 11:04hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/02f28176ed17911766685cdcbfef6e57d4e35e32 [^]
2011-07-06 20:41hudsonbotCheckin
2011-07-06 20:41hudsonbotNote Added: 0038909
2011-07-07 07:56alostaleRelationship addedrelated to 0017925
2011-07-13 10:52maiteNote Added: 0039032
2011-07-13 10:52maiteStatusresolved => closed

Notes
(0038893)
hgbot   
2011-07-06 11:04   
Repository: erp/devel/pi
Changeset: 02f28176ed17911766685cdcbfef6e57d4e35e32
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Jul 06 10:51:48 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/02f28176ed17911766685cdcbfef6e57d4e35e32 [^]

fixed bug 17913: Navigation to blank tab

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/DefaultJsonDataService.java
---
(0038909)
hudsonbot   
2011-07-06 20:41   
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/7aa2bbafa595 [^]

Maturity status: Test
(0039032)
maite   
2011-07-13 10:52   
verified