Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020102Openbravo ERPA. Platformpublic2012-03-23 14:562012-04-02 06:12
Reporteregoitz 
Assigned Toalostale 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP8 
Target Version3.0MP10Fixed in Version3.0MP10 
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
Summary0020102: The usage audit can not be disable
DescriptionAfter unchech de usage audit checkbox on system information window, and restart tomcat, the table ad_seesion_usage_audit continues increasing.
Steps To Reproduce-Deactivate usage audit and restar tomcat
-count the registers on the ad_session_usage_audit table
-use the application from windows, reports..
-see that the number of rows on the table ad_session_usage_audit increases.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0019895 closed alostale CPU spike during invoice header click 
depends on defect 0020124 closed alostale Usage audit is not working for fetch actions 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-03-23 14:56egoitzNew Issue
2012-03-23 14:56egoitzAssigned To => alostale
2012-03-23 14:56egoitzModules => Core
2012-03-26 15:12alostaleNote Added: 0046733
2012-03-26 15:13alostaleRelationship addedrelated to 0019895
2012-03-27 13:50alostaleRelationship addeddepends on 0020124
2012-03-27 15:13hgbotCheckin
2012-03-27 15:13hgbotNote Added: 0046772
2012-03-27 15:13hgbotStatusnew => resolved
2012-03-27 15:13hgbotResolutionopen => fixed
2012-03-27 15:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4ba927f6028390b2349e6380960f665d8388a12e [^]
2012-03-27 15:18alostaleNote Added: 0046773
2012-03-29 11:44marvintmStatusresolved => closed
2012-03-29 11:44marvintmFixed in Version => 3.0MP10
2012-04-02 06:12hudsonbotCheckin
2012-04-02 06:12hudsonbotNote Added: 0047242

Notes
(0046733)
alostale   
2012-03-26 15:12   
This can be reproduced for 2.50 windows/processes.
(0046772)
hgbot   
2012-03-27 15:13   
Repository: erp/devel/pi
Changeset: 4ba927f6028390b2349e6380960f665d8388a12e
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Mar 27 15:13:08 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/4ba927f6028390b2349e6380960f665d8388a12e [^]

fixed bug 20102: Usage audit can not be disabled
  -Fixed boolan xsql to check if audit is enabled
  -Now query is not executed on each request but it is cached

---
M src-core/src/org/openbravo/database/SessionInfo.java
M src/org/openbravo/erpCommon/security/SessionListener.java
M src/org/openbravo/erpCommon/security/SessionLogin_data.xsql
M src/org/openbravo/erpCommon/security/UsageAudit.java
A modules/org.openbravo.client.application/src/org/openbravo/client/application/event/UsageAuditHandler.java
---
(0046773)
alostale   
2012-03-27 15:18   
This fix is not risky.

It should also slightly improve performance as now, information about usage audit is cached and it is not queried to DB on each request.

Test plan:
 -Disable usage audit and, without restarting, check no new entries appear in audit table. Do it for generated windows as well as for manual processes.
 -Enable it again and do the same test, now actions should be audited.
 -Restart tomcat and check again actions are audited.
 -Disable audit, restart tomcat and check actions are not audited.
(0047242)
hudsonbot   
2012-04-02 06:12   
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/7814864461ac [^]

Maturity status: Test