Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012982Openbravo ERPA. Platformpublic2010-04-14 18:122010-07-07 00:00
Reportershuehner 
Assigned Toadrianromero 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP11 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012982: BusinessPartnerSelectorMultiple, number of total rows shown is less than numRows shown
DescriptionThe BusinessPartnerMultiple selector in the testcase did show a rowcount of 1208 rows, however the number of the last row shown is 1120, and then only blank lines without content and row-number are shown.

See also attached screenshot.
Steps To ReproduceUse mp13 (i.e. demo1.openbravo.com as of today)
Goto: financials -> accounting -> analysis tools - General Ledger Report
Open the BusinessPartnerMultiplSelector
scroll near the end of the record range
Proposed Solution
Additional Information
TagsRegression
Relationships
depends on backport 0013465 closed harikrishnan BusinessPartnerSelectorMultiple, number of total rows shown is less than numRows shown 
Attached Filespng bpmultiple_selector_count_vs_rows_shown.png (72,947) 2010-04-14 18:13
https://issues.openbravo.com/file_download.php?file_id=2438&type=bug
png

diff 12982.diff (8,144) 2010-06-10 17:58
https://issues.openbravo.com/file_download.php?file_id=2665&type=bug
Issue History
Date ModifiedUsernameFieldChange
2010-04-14 18:12shuehnerNew Issue
2010-04-14 18:12shuehnerAssigned To => alostale
2010-04-14 18:12shuehnerOBNetwork customer => No
2010-04-14 18:13shuehnerFile Added: bpmultiple_selector_count_vs_rows_shown.png
2010-04-19 08:33alostaleAssigned Toalostale => shuehner
2010-04-19 08:34alostaleStatusnew => scheduled
2010-05-27 16:45shuehnerNote Added: 0027781
2010-05-27 19:25psarobeTag Attached: Regression
2010-05-27 19:27psarobeversion2.50MP13 => 2.50MP11
2010-05-27 19:31psarobeStatusscheduled => feedback
2010-05-27 19:31psarobeStatusfeedback => scheduled
2010-05-27 19:31psarobefix_in_branch => pi
2010-06-10 17:58shuehnerFile Added: 12982.diff
2010-06-10 18:01shuehnerNote Added: 0028272
2010-06-10 18:01shuehnerAssigned Toshuehner => adrianromero
2010-07-02 13:54hgbotCheckin
2010-07-02 13:54hgbotNote Added: 0028981
2010-07-02 13:54hgbotStatusscheduled => resolved
2010-07-02 13:54hgbotResolutionopen => fixed
2010-07-02 13:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/80925690f42b9170414e308bca8e015daaa625b8 [^]
2010-07-02 13:54harikrishnanNote Added: 0028982
2010-07-03 06:17hudsonbotCheckin
2010-07-03 06:17hudsonbotNote Added: 0029029
2010-07-06 05:22sureshbabuNote Added: 0029074
2010-07-06 05:22sureshbabuStatusresolved => closed
2010-07-07 00:00anonymoussf_bug_id0 => 3026043

Notes
(0027781)
shuehner   
2010-05-27 16:45   
Problem was introduced in this commit: https://code.openbravo.com/erp/devel/pi/rev/47d65eff6384 [^]
(0028272)
shuehner   
2010-06-10 18:01   
Attached work in progress patch intended to fix the issue and new testcase for verify the implicit consistency requirement between the two sql queries which needs to be in agreement on number of rows returned.
(0028981)
hgbot   
2010-07-02 13:54   
Repository: erp/devel/pi
Changeset: 80925690f42b9170414e308bca8e015daaa625b8
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Fri Jul 02 17:23:16 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/80925690f42b9170414e308bca8e015daaa625b8 [^]

Fixes issue 12982 Data from Select query is different from the Count rows.And test cases for multiple business partner is added.

---
M src-test/org/openbravo/test/AllAntTaskTests.java
M src-test/org/openbravo/test/AllQuickAntTaskTests.java
M src-test/org/openbravo/test/AllTests.java
M src-test/org/openbravo/test/AntTaskTests.java
M src/org/openbravo/erpCommon/info/BusinessPartnerMultiple_data.xsql
A src-test/org/openbravo/erpCommon/info/ClassicSelectorTest.java
---
(0028982)
harikrishnan   
2010-07-02 13:54   
Steps to test:

Go to Sales Management || Analysis Tools || Sales Dimensional Report || Sales Dimensional Report and select the Business Partner.Their the issue can be tested

Root Cause:

Data from Select query is different from the Count rows.

Impact:

Their is no impact because of this fix.
(0029029)
hudsonbot   
2010-07-03 06:17   
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/80925690f42b [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/244f7cfdddaf [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17800.obx [^]
(0029074)
sureshbabu   
2010-07-06 05:22   
Verified...working fine