Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2012-03-08 16:092012-04-01 20:39
ReporteralostaleView Statuspublic 
Assigned Toalostale 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionde657cf78aa7
ProjectionnoneETAnoneTarget Version3.0MP10
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0019985: AlertActionHandler response is unnecessary big

DescriptionEach 50s each client is sending a request to AlertActionHandler to obtain active alerts for current user/role. The response of to this request contains not only the counter of alerts but also the complete list of them.

In case of many active alerts, the response can be huge and the only used part is the counter. Increasing considerably the bandwidth used by Openbravo, note that this increases by each session.
Steps To Reproduce-Add an alert rule that creates many alert instances
  *In alert window add the following alert:
    -Name: dummy
    -SQL: select ad_column_id as referencekey_id,
       name as record_id,
       0 as ad_role_id,
       null as ad_user_id,
       name ||' is a column' as description,
       'Y' as isActive,
        now() as created,
        0 as createdBy,
        now() as updated,
        0 as updatedBy
       from ad_column
    -Tab: Column - Tables and Columns
    -Assign System Admin role to this alert
-Login with System Admin. Check network calls to AlertActionHandler.
Proposed SolutionAlertActionHandler should return just the count of active alerts
TagsNo tags attached.
Attached Filespng file icon Selection_041.png [^] (28,644 bytes) 2012-03-08 17:11

png file icon After_fix.png [^] (33,727 bytes) 2012-03-08 17:27

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0019989 closedalostale Having active alerts, application doesn't work in Oracle 
related to defect 00201463.0MP10 closedalostale AlertActionHandler PreparedStatement is not closed 

-  Notes
alostale (developer)
2012-03-08 17:34

This changeset does not introduce regression risk as the only part actually used in the response was the count which is the only preserved part.

Executed test plan.
-Ensure previous statement is true. This is not actually used anywhere else.
  * Code review of AlertActionHandler usage
  * Use Alert Management window by changing alert status
-Repeat steps to reproduce and check the difference:
  * The improvement depends on the actual number of active alerts for the user. In the example there are around 10K. The reductions are:
     * From 7.20MB to 205B in the response.
     * From ~1.3 seconds in the server to generate the response to ~30ms.
hgbot (developer)
2012-03-08 17:44

Repository: erp/devel/pi
Changeset: de657cf78aa790028cbf554fb4f19ddda3f26d97
Author: Asier Lostalé <asier.lostale <at>>
Date: Thu Mar 08 17:43:26 2012 +0100
URL: [^]

fixed bug 19985: AlertActionHandler response is unnecessary big

  AlertActionHandler returns now just the count of active alerts, but not the complete list of them.

M modules/org.openbravo.client.application/src/org/openbravo/client/application/
alostale (developer)
2012-03-09 09:20

Note this fix introduces issue 0019989 in Oracle!
hudsonbot (developer)
2012-04-01 20:39

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: [^]

Maturity status: Test

- Issue History
Date Modified Username Field Change
2012-03-08 16:09 alostale New Issue
2012-03-08 16:09 alostale Assigned To => alostale
2012-03-08 16:09 alostale Modules => Core
2012-03-08 17:11 alostale Steps to Reproduce Updated View Revisions
2012-03-08 17:11 alostale Steps to Reproduce Updated View Revisions
2012-03-08 17:11 alostale File Added: Selection_041.png
2012-03-08 17:27 alostale File Added: After_fix.png
2012-03-08 17:34 alostale Note Added: 0046207
2012-03-08 17:44 hgbot Checkin
2012-03-08 17:44 hgbot Note Added: 0046208
2012-03-08 17:44 hgbot Status new => resolved
2012-03-08 17:44 hgbot Resolution open => fixed
2012-03-08 17:44 hgbot Fixed in SCM revision => [^]
2012-03-09 09:16 alostale Relationship added related to 0019989
2012-03-09 09:20 alostale Note Added: 0046218
2012-03-16 16:42 marvintm Status resolved => closed
2012-03-29 10:58 alostale Relationship added related to 0020146
2012-04-01 20:39 hudsonbot Checkin
2012-04-01 20:39 hudsonbot Note Added: 0047074

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker