Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013900Openbravo ERP09. Financial managementpublic2010-07-06 11:152010-09-13 12:38
Reporternetworkb 
Assigned Tosivaraman 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP19 
Target Version2.50MP20Fixed in Version2.50MP21 
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
Summary0013900: The Payment Tracker does not work with a big amount of data
DescriptionThe Financial Management || Receivables & Payables || Analysis Tools || Payment Tracker || Payment Tracker does not work with a big amount of data. The report is not shown but you don't get any error.
The applications seems locked.

Steps To Reproducewith the following amount of data execute the Payment Tracker

c_debt_payment 480296
c_bankstatement 167721
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00136572.50MP20 closed adrianromero The sales invoice Dimensional Report does not work with a big amount of data using partner dimension 
Attached Filespng error_message.PNG (27,275) 2010-08-19 11:04
https://issues.openbravo.com/file_download.php?file_id=2884&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2010-07-06 11:15networkbNew Issue
2010-07-06 11:15networkbAssigned To => dalsasua
2010-07-08 12:19adrianromeroDescription Updatedbug_revision_view_page.php?rev_id=574#r574
2010-07-08 12:20adrianromeroAssigned Todalsasua => adrianromero
2010-07-08 12:20adrianromeroStatusnew => scheduled
2010-07-08 12:20adrianromerofix_in_branch => pi
2010-07-21 08:48sivaramanAssigned Toadrianromero => sivaraman
2010-07-22 06:27hgbotCheckin
2010-07-22 06:27hgbotNote Added: 0029455
2010-07-22 06:27hgbotStatusscheduled => resolved
2010-07-22 06:27hgbotResolutionopen => fixed
2010-07-22 06:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/289974ed369e5f370d14201f0a4cbe3e40eb4535 [^]
2010-07-22 06:29sivaramanNote Added: 0029456
2010-07-27 15:41hudsonbotCheckin
2010-07-27 15:41hudsonbotNote Added: 0029596
2010-08-03 12:05sureshbabuNote Added: 0029766
2010-08-19 10:53adrianromeroRelationship addedrelated to 0013657
2010-08-19 11:04psarobeFile Added: error_message.PNG
2010-08-19 11:05psarobeNote Added: 0030141
2010-08-19 11:05psarobeStatusresolved => closed
2010-08-19 11:05psarobeFixed in Version => 2.50MP21
2010-09-13 12:38anonymoussf_bug_id0 => 3065156

Notes
(0029455)
hgbot   
2010-07-22 06:27   
Repository: erp/devel/pi
Changeset: 289974ed369e5f370d14201f0a4cbe3e40eb4535
Author: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com>
Date: Thu Jul 22 09:56:13 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/289974ed369e5f370d14201f0a4cbe3e40eb4535 [^]

Fixes issue 13900: The Payment Tracker does not work with a big amount of data

Pagination has been implemented for Payment Tracker report and also validation rule has been implemented for exporting PDF functionality.

---
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPaymentTrack.java
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPaymentTrack_data.xsql
---
(0029456)
sivaraman   
2010-07-22 06:29   
Steps to test:

1. Log on to Openbravo with 'System Administrator' role
2. Go to General Setup || Application || Session Preferences || Session Preferences
3. Set Records range to 20 and Save Preferences
4. Go to General Setup || Application || Preference || Preference and Select ReportsLimit
5. Set the value to 10 and Save
6. Change role to 'Openbravo Admin'
7. Go to Financial Management || Receivables & Payables || Analysis Tools || Payment Tracker || Payment Tracker
8. Set From Date = 21-07-2006 and To Date = 21-07-2010
9. Click HTML Format button
10. Verify If pagination works properly
11. Click PDF Format button
12. Verify if proper error message is displayed
(0029596)
hudsonbot   
2010-07-27 15:41   
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/289974ed369e [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/634cc0909ed2 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17922.obx [^]
(0029766)
sureshbabu   
2010-08-03 12:05   
@Siva, kindly explain what is the fix here..


Note: i just followed the steps you have mentioned in the notes. It works fine..
(0030141)
psarobe   
2010-08-19 11:05   
Tested working fine