Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016094Openbravo ERP01. General setuppublic2011-03-01 16:562011-04-15 11:33
Reporteregoitz 
Assigned Toegoitz 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP25 
Target Version2.50MP29Fixed in Version2.50MP29 
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
Summary0016094: The audit popup does not show any data when there a lot of entries on the ad_audit_trail table
DescriptionThe audit popup does not show any data when there a lot of entries on the ad_audit_trail table
For example when accessing to the Sales Invoice window and click on the audit button on the toolbar you can not see any audit information.

The table were we have reproduce the problem has 8353583 rows
Steps To Reproduce-In a database with 8353583 rows in ad_audit_trail table
go to the Sales invoice window.
-Then click on audit button on toolbar
-Try to find all the deleted elements.
*No data is show.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-03-01 16:56egoitzNew Issue
2011-03-01 16:56egoitzAssigned To => adrianromero
2011-03-01 16:56egoitzModules => Core
2011-03-01 16:58egoitzIssue Monitored: networkb
2011-03-09 17:15egoitzversion => 2.50MP25
2011-03-09 17:15egoitzTarget Version => 2.50MP28
2011-03-14 14:11adrianromeroNote Added: 0034806
2011-03-14 14:11adrianromeroStatusnew => closed
2011-03-14 14:11adrianromeroResolutionopen => unable to reproduce
2011-03-15 00:00anonymoussf_bug_id0 => 3212142
2011-03-15 09:48egoitzStatusclosed => new
2011-03-15 09:48egoitzResolutionunable to reproduce => open
2011-03-15 11:44egoitzNote Added: 0034862
2011-03-15 11:44egoitzStatusnew => closed
2011-03-15 11:44egoitzResolutionopen => no change required
2011-03-15 11:44egoitzNote Added: 0034863
2011-03-15 11:44egoitzStatusclosed => new
2011-03-15 11:44egoitzResolutionno change required => open
2011-04-01 10:55egoitzAssigned Toadrianromero => egoitz
2011-04-01 10:55egoitzPriorityurgent => high
2011-04-01 10:55egoitzSeveritymajor => minor
2011-04-01 10:55egoitzTarget Version2.50MP28 => 2.50MP29
2011-04-01 10:57egoitzSummaryThe audit trail window does not show any data when there a lot of entries on the ad_audit_trail window => The audit popup does not show any data when there a lot of entries on the ad_audit_trail table
2011-04-01 10:57egoitzDescription Updatedbug_revision_view_page.php?rev_id=1749#r1749
2011-04-01 10:57egoitzSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=1751#r1751
2011-04-01 12:22egoitzNote Deleted: 0034863
2011-04-01 12:22egoitzNote Deleted: 0034862
2011-04-01 13:32hgbotCheckin
2011-04-01 13:32hgbotNote Added: 0035463
2011-04-01 13:32hgbotStatusnew => resolved
2011-04-01 13:32hgbotResolutionopen => fixed
2011-04-01 13:32hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/fefdbbd938e1f616e33794bba9b1ab1eb3331836 [^]
2011-04-01 13:42egoitzNote Added: 0035465
2011-04-15 11:33jonalegriaesarteNote Added: 0035971
2011-04-15 11:33jonalegriaesarteStatusresolved => closed
2011-04-15 11:33jonalegriaesarteFixed in Version => 2.50MP29

Notes
(0034806)
adrianromero   
2011-03-14 14:11   
The pagination of grids with a lot of data has been implemented since 2.50 MP11: http://wiki.openbravo.com/wiki/ERP/2.50/Release_Notes/2.50MP11 [^]

By default the page size is 10000 but if you need to change the page size to an smaller value you can change it in the Preferences window: General Setup || Application || Preference || Preference Modifying the preference ReportsLimit
(0035463)
hgbot   
2011-04-01 13:32   
Repository: erp/stable/2.50
Changeset: fefdbbd938e1f616e33794bba9b1ab1eb3331836
Author: Egoitz Castillo <egoitz.castillo <at> openbravo.com>
Date: Fri Apr 01 13:31:35 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/fefdbbd938e1f616e33794bba9b1ab1eb3331836 [^]

Fixed Issue 16094: The audit popup does work with a lot of data

---
M src-db/database/model/tables/AD_AUDIT_TRAIL.xml
M src/org/openbravo/erpCommon/utility/plantilla.jrxml
---
(0035465)
egoitz   
2011-04-01 13:42   
The change on
src/org/openbravo/erpCommon/utility/plantilla.jrxml
was pushed by mistake, it has been reverted on the following commit:

https://code.openbravo.com/erp/stable/2.50/rev/ef3cd67ba7ac [^]
(0035971)
jonalegriaesarte   
2011-04-15 11:33   
Verified