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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0012982
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2010-04-14 18:122010-07-07 00:00
ReportershuehnerView Statuspublic 
Assigned Toadrianromero 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision80925690f42b
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP11SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012982: 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
TagsRegression
Attached Filespng file icon bpmultiple_selector_count_vs_rows_shown.png [^] (72,947 bytes) 2010-04-14 18:13


diff file icon 12982.diff [^] (8,144 bytes) 2010-06-10 17:58 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0013465 closedharikrishnan BusinessPartnerSelectorMultiple, number of total rows shown is less than numRows shown 

-  Notes
(0027781)
shuehner (administrator)
2010-05-27 16:45

Problem was introduced in this commit: https://code.openbravo.com/erp/devel/pi/rev/47d65eff6384 [^]
(0028272)
shuehner (administrator)
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 (developer)
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 (reporter)
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 (developer)
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 (reporter)
2010-07-06 05:22

Verified...working fine

- Issue History
Date Modified Username Field Change
2010-04-14 18:12 shuehner New Issue
2010-04-14 18:12 shuehner Assigned To => alostale
2010-04-14 18:13 shuehner File Added: bpmultiple_selector_count_vs_rows_shown.png
2010-04-19 08:33 alostale Assigned To alostale => shuehner
2010-04-19 08:34 alostale Status new => scheduled
2010-05-27 16:45 shuehner Note Added: 0027781
2010-05-27 19:25 psarobe Tag Attached: Regression
2010-05-27 19:27 psarobe version 2.50MP13 => 2.50MP11
2010-05-27 19:31 psarobe Status scheduled => feedback
2010-05-27 19:31 psarobe Status feedback => scheduled
2010-05-27 19:31 psarobe fix_in_branch => pi
2010-06-10 17:58 shuehner File Added: 12982.diff
2010-06-10 18:01 shuehner Note Added: 0028272
2010-06-10 18:01 shuehner Assigned To shuehner => adrianromero
2010-07-02 13:54 hgbot Checkin
2010-07-02 13:54 hgbot Note Added: 0028981
2010-07-02 13:54 hgbot Status scheduled => resolved
2010-07-02 13:54 hgbot Resolution open => fixed
2010-07-02 13:54 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/80925690f42b9170414e308bca8e015daaa625b8 [^]
2010-07-02 13:54 harikrishnan Note Added: 0028982
2010-07-03 06:17 hudsonbot Checkin
2010-07-03 06:17 hudsonbot Note Added: 0029029
2010-07-06 05:22 sureshbabu Note Added: 0029074
2010-07-06 05:22 sureshbabu Status resolved => closed
2010-07-07 00:00 anonymous sf_bug_id 0 => 3026043


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker