Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034877Openbravo ERP03. Procurement managementpublic2017-01-09 21:452017-03-15 20:18
Reportermarkmm82 
Assigned Torqueralta 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q2 
Merge Request Status
Review Assigned Tomarkmm82
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0034877: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0025186 closed collazoandy4 Jave heap error accessing to the pending goods receipt window when there are 16000 lines for orders not receipt 
depends on backport 00348783.0PR17Q1 closed rqueralta Some changes needed to improve the performance in pending goods receipt window 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-01-09 21:45markmm82New Issue
2017-01-09 21:45markmm82Assigned To => rqueralta
2017-01-09 21:45markmm82Modules => Core
2017-01-09 21:45markmm82Triggers an Emergency Pack => No
2017-01-09 21:50markmm82Relationship addedrelated to 0025186
2017-01-09 21:50markmm82Statusnew => scheduled
2017-01-13 16:32hgbotCheckin
2017-01-13 16:32hgbotNote Added: 0093556
2017-01-13 16:32hgbotStatusscheduled => resolved
2017-01-13 16:32hgbotResolutionopen => fixed
2017-01-13 16:32hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2c1823b1139d3f25de108c29c891c1b5ec0b1672 [^]
2017-01-13 16:41markmm82Review Assigned To => markmm82
2017-01-13 16:41markmm82Note Added: 0093558
2017-01-13 16:41markmm82Statusresolved => closed
2017-01-13 16:41markmm82Fixed in Version => 3.0PR17Q2
2017-03-15 20:18hudsonbotCheckin
2017-03-15 20:18hudsonbotNote Added: 0095098

Notes
(0093556)
hgbot   
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   
2017-01-13 16:41   
Code review + Testing OK
(0095098)
hudsonbot   
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