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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0034877
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementmajorhave not tried2017-01-09 21:452017-03-15 20:18
Reportermarkmm82View Statuspublic 
Assigned Torqueralta 
PriorityhighResolutionfixedFixed in Version3.0PR17Q2
StatusclosedFix in branchFixed in SCM revision2c1823b1139d
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned Tomarkmm82
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0034877: Some changes needed to improve the performance in pending goods receipt window

DescriptionThere are some changes in the Pending Goods Receipt window can be improved:
1. There is an extra query to the database to calculate the record's count. It makes more slow the window loading.
2. It is used a deprecated API of XSQL's logic to work with the limits of query.
3. The message is showing must be reviewed to make more descriptive.
Steps To ReproduceAs system administrator
  Go to preference screen and change the Forms Limit preference value to 3

As International Group Admin role
  Create 4 Purchase Order and complete it
  Go to Pending Goods Receipt and a warning message is shown indicating that the form data it's limited to 3
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to design defect 0025186 closedcollazoandy4 Jave heap error accessing to the pending goods receipt window when there are 16000 lines for orders not receipt 
depends on backport 00348783.0PR17Q1 closedrqueralta Some changes needed to improve the performance in pending goods receipt window 

-  Notes
(0093556)
hgbot (developer)
2017-01-13 16:32

 Repository: erp/devel/pi
Changeset: 2c1823b1139d3f25de108c29c891c1b5ec0b1672
Author: Rafael Queralta Pozo <rqueralta <at> nauta.cu>
Date: Tue Jan 10 07:24:48 2017 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/2c1823b1139d3f25de108c29c891c1b5ec0b1672 [^]

Fixed issue 34877: Some changes needed to improve the performance in Pending GR

To improve the performance in Pending Goods Receipt window, the extra query was
remove and the message was corrected.

---
M src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending.java
M src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending_data.xsql
---
(0093558)
markmm82 (viewer)
2017-01-13 16:41

 Code review + Testing OK
(0095098)
hudsonbot (viewer)
2017-03-15 20:18

 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/54e102bef53e [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2017-01-09 21:45 markmm82 New Issue
2017-01-09 21:45 markmm82 Assigned To => rqueralta
2017-01-09 21:45 markmm82 OBNetwork customer => Yes
2017-01-09 21:45 markmm82 Modules => Core
2017-01-09 21:45 markmm82 Triggers an Emergency Pack => No
2017-01-09 21:50 markmm82 Relationship added related to 0025186
2017-01-09 21:50 markmm82 Status new => scheduled
2017-01-10 10:46 aferraz OBNetwork customer Yes => No
2017-01-13 16:32 hgbot Checkin
2017-01-13 16:32 hgbot Note Added: 0093556
2017-01-13 16:32 hgbot Status scheduled => resolved
2017-01-13 16:32 hgbot Resolution open => fixed
2017-01-13 16:32 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2c1823b1139d3f25de108c29c891c1b5ec0b1672 [^]
2017-01-13 16:41 markmm82 Review Assigned To => markmm82
2017-01-13 16:41 markmm82 Note Added: 0093558
2017-01-13 16:41 markmm82 Status resolved => closed
2017-01-13 16:41 markmm82 Fixed in Version => 3.0PR17Q2
2017-03-15 20:18 hudsonbot Checkin
2017-03-15 20:18 hudsonbot Note Added: 0095098

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker