Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0030570 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| defect | [Openbravo ERP] I. Performance | minor | sometimes | 2015-08-13 12:06 | 2015-08-31 13:28 | ||||||
| Reporter | malsasua | View Status | public | ||||||||
| Assigned To | dmiguelez | ||||||||||
| Priority | immediate | Resolution | open | Fixed in Version | |||||||
| Status | acknowledged | Fix in branch | Fixed in SCM revision | ||||||||
| Projection | none | ETA | none | Target Version | |||||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_18 | ||||||
| OS Version | Community Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | ||||||
| Product Version | 3.0PR15Q2.3 | SCM revision | |||||||||
| Review Assigned To | |||||||||||
| Web browser | Google Chrome | ||||||||||
| Modules | Core | ||||||||||
| Regression level | |||||||||||
| Regression date | |||||||||||
| Regression introduced in release | |||||||||||
| Regression introduced by commit | |||||||||||
| Triggers an Emergency Pack | No | ||||||||||
| Summary | 0030570: the "add details" button in payment window is generating performance problems | ||||||||||
| Description | with a big amount data, sometimes, in the "payment in" window, when "add details" button is clicked, the system performance problems are generated, and after some minutes, the tomcat is down, and it is not possible to access to the application When it occurs, the query in execution is: select array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') as col_0_0_, array_to_string(array_agg(order2_.DocumentNo), ',') as col_1_0_, case when invoice7_.IsSOTrx='N' and (organizati12_.AD_Org_ID is not null) and (organizati12_.EM (...) | ||||||||||
| Steps To Reproduce | .create several payments | ||||||||||
| Tags | Performance | ||||||||||
| Attached Files | |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0079829) dmiguelez (developer) 2015-08-31 12:45 |
In order to help the Customer with this problem, we used the Grid Configuration at Window Level. We configured this Grid to be Lazy loaded, meaning that the data will not load until the user filters the Grid properly (by Invoice No. for example) and asks for the data. With so many data to be shown, the user was forced to filter the Grid always, so no functionality was lost with this fix. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-08-13 12:06 | malsasua | New Issue | |
| 2015-08-13 12:06 | malsasua | Assigned To | => platform |
| 2015-08-13 12:06 | malsasua | Web browser | => Google Chrome |
| 2015-08-13 12:06 | malsasua | Modules | => Core |
| 2015-08-13 12:06 | malsasua | Resolution time | => 1439589600 |
| 2015-08-13 12:06 | malsasua | Triggers an Emergency Pack | => No |
| 2015-08-13 12:08 | malsasua | Tag Attached: Performance | |
| 2015-08-13 12:09 | malsasua | Relationship added | related to 0028854 |
| 2015-08-14 09:20 | alostale | Assigned To | platform => Triage Finance |
| 2015-08-14 09:55 | malsasua | Web browser | Google Chrome => Google Chrome |
| 2015-08-14 09:55 | malsasua | Severity | major => critical |
| 2015-08-20 13:09 | dmiguelez | Assigned To | Triage Finance => dmiguelez |
| 2015-08-20 13:09 | dmiguelez | Status | new => acknowledged |
| 2015-08-26 08:00 | malsasua | Web browser | Google Chrome => Google Chrome |
| 2015-08-26 08:00 | malsasua | Severity | critical => minor |
| 2015-08-31 12:45 | dmiguelez | Note Added: 0079829 | |
| 2015-08-31 13:28 | malsasua | Web browser | Google Chrome => Google Chrome |
| 2015-08-31 13:28 | malsasua | Resolution time | 1439589600 => |
| 2015-09-29 13:33 | vmromanos | Relationship added | has duplicate 0030612 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |