Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035007Openbravo ERPA. Platformpublic2017-01-19 09:482017-03-15 20:18
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q2 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035007: audit trail causes excessive overhead
DescriptionTreated as a project: http://wiki.openbravo.com/wiki/Projects:Reduce_Audit_Trail_Infrastructure_Overhead [^]
Steps To Reproduce-
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 0034766 closed alostale Incomplete audit trail info for elements created from WebPOS 
related to defect 00334413.0PR16Q4 closed NaroaIriarte query to check if ad_context_info exists executed once per request 
depends on defect 0035060 closed alostale EntityPersistanceEventObservers are executed twice on commitAndClose 
causes defect 0035561 closed alostale logged NPE in audit trail creating tickets from POS 
causes defect 0040886 closed alostale incorrect audit trail for DAL WebServices 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-01-19 09:48alostaleNew Issue
2017-01-19 09:48alostaleAssigned To => platform
2017-01-19 09:48alostaleModules => Core
2017-01-19 09:48alostaleTriggers an Emergency Pack => No
2017-01-19 09:48alostaleStatusnew => scheduled
2017-01-19 09:48alostaleAssigned Toplatform => alostale
2017-01-19 09:48alostaleReview Assigned To => caristu
2017-01-20 13:18alostaleRelationship addedrelated to 0034766
2017-01-20 13:19alostaleRelationship addedrelated to 0033441
2017-01-20 13:30alostaleTag Attached: Performance
2017-01-26 14:23alostaleRelationship addeddepends on 0035060
2017-01-30 10:38hgbotCheckin
2017-01-30 10:38hgbotNote Added: 0093920
2017-01-30 10:38hgbotStatusscheduled => resolved
2017-01-30 10:38hgbotResolutionopen => fixed
2017-01-30 10:38hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/72cf9d166978c4cf23b1fd261fb81728e65172bc [^]
2017-01-30 11:26caristuNote Added: 0093926
2017-01-30 11:26caristuStatusresolved => closed
2017-01-30 11:26caristuFixed in Version => 3.0PR17Q2
2017-03-15 20:18hudsonbotCheckin
2017-03-15 20:18hudsonbotNote Added: 0095137
2017-03-17 14:10alostaleRelationship addedcauses 0035561
2019-05-16 12:04alostaleRelationship addedcauses 0040886

Notes
(0093920)
hgbot   
2017-01-30 10:38   
Repository: erp/devel/pi
Changeset: 72cf9d166978c4cf23b1fd261fb81728e65172bc
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Jan 30 10:28:40 2017 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/72cf9d166978c4cf23b1fd261fb81728e65172bc [^]

fixed issue 35007: reduced overhead in audit trail infrastructure

---
M modules/org.openbravo.client.application/src/org/openbravo/client/application/AlertActionHandler_data.xsql
M modules/org.openbravo.client.application/src/org/openbravo/client/application/StorePropertyActionHandler.java
M modules/org.openbravo.client.application/src/org/openbravo/client/application/process/BaseProcessActionHandler.java
M modules/org.openbravo.client.application/src/org/openbravo/client/application/report/BaseReportActionHandler.java
M modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/DataSourceServlet.java
M src-core/src/org/openbravo/data/Sql.java
M src-core/src/org/openbravo/data/Sqlc.java
M src-core/src/org/openbravo/database/ConnectionProviderImpl.java
M src-core/src/org/openbravo/database/JNDIConnectionProvider.java
M src-core/src/org/openbravo/database/RDBMSIndependent.java
M src-core/src/org/openbravo/database/SessionInfo.java
M src/org/openbravo/dal/core/DalRequestFilter.java
M src/org/openbravo/dal/core/DalSessionFactory.java
M src/org/openbravo/dal/service/OBDal.java
M src/org/openbravo/erpCommon/security/SessionLogin.java
M src/org/openbravo/erpCommon/security/SessionLogin_data.xsql
M src/org/openbravo/scheduling/DefaultJob.java
M src/org/openbravo/scheduling/ProcessRequest_data.xsql
M src/org/openbravo/scheduling/ProcessRun_data.xsql
M src/org/openbravo/service/db/DalConnectionProvider.java
M src/org/openbravo/service/importprocess/ImportEntryProcessor.java
---
(0093926)
caristu   
2017-01-30 11:26   
Code reviewed as part of the project.
(0095137)
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