Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030544Openbravo ERPI. Performancepublic2015-08-11 12:332015-09-18 11:18
ReporterVictorVillar 
Assigned Todmiguelez 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0PR15Q4Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket37814
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0030544: Perfromance problem running module script in environments with large amount of transactions in ORACLE (invoices and orders)
DescriptionUpdateBpPaymentLine module script takes huge time to finish when updating from an environment with large amount of data (invoices and orders) using ORACLE
Steps To ReproduceExecute update.database on a ORACLE database with big amount of data (containing lots of invoices and orders).
the issue was reproduced in an environment with 286000 invoices
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to backport 00291993.0PR15Q1.2 closed eduardo_Argal Perfromance problem running module script in environments with large amount of transactions (invoices and orders) 
related to defect 00289393.0PR15Q1.2 closed eduardo_Argal Perfromance problem running module script in environments with large amount of transactions (invoices and orders) 
Attached Files? dbsourcemanager.jar (763,738) 2015-09-18 11:17
https://issues.openbravo.com/file_download.php?file_id=8460&type=bug
Issue History
Date ModifiedUsernameFieldChange
2015-08-11 12:33VictorVillarNew Issue
2015-08-11 12:33VictorVillarAssigned To => platform
2015-08-11 12:33VictorVillarOBNetwork customer => Yes
2015-08-11 12:33VictorVillarModules => Core
2015-08-11 12:33VictorVillarSupport ticket => 37814
2015-08-11 12:33VictorVillarResolution time => 1442268000
2015-08-11 12:33VictorVillarTriggers an Emergency Pack => No
2015-08-11 12:34VictorVillarAssigned Toplatform => Triage Finance
2015-08-11 12:34VictorVillarIssue Monitored: networkb
2015-08-11 12:34VictorVillarRelationship addedrelated to 0029199
2015-08-11 12:34VictorVillarRelationship addedrelated to 0028939
2015-09-03 17:27vmromanosAssigned ToTriage Finance => dmiguelez
2015-09-03 17:27vmromanosStatusnew => acknowledged
2015-09-18 11:17dmiguelezNote Added: 0080487
2015-09-18 11:17dmiguelezFile Added: dbsourcemanager.jar
2015-09-18 11:17dmiguelezStatusacknowledged => scheduled
2015-09-18 11:18dmiguelezNote Added: 0080488
2015-09-18 11:18dmiguelezStatusscheduled => closed
2015-09-18 11:18dmiguelezResolutionopen => fixed
2015-09-18 12:07dmiguelezNote Edited: 0080487bug_revision_view_page.php?bugnote_id=0080487#r9460

Notes
(0080487)
dmiguelez   
2015-09-18 11:17   
(edited on: 2015-09-18 12:07)
This issue is fixed with the new DbSourceManager implementation.

Attached is the file with the DbSourceManager of PR15Q3.1 that can be applied to Clients that are doing the upgrade to PR15QQ2, where the old DbSourceManager is used. By overriding the old with the new one, this issue can be solved.

DbSourceManager.jar can be found in src-db/database/lib folder.
(0080488)
dmiguelez   
2015-09-18 11:18   
Already fixed with the new DbSourceManager implementation