Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0028111 | Openbravo ERP | 04. Warehouse management | public | 2014-11-06 12:14 | 2015-03-20 12:35 |
|
| Reporter | umartirena | |
| Assigned To | umartirena | |
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | 3.0PR15Q2 | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | eduardo_Argal |
| OBNetwork customer | No |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0028111: InitializeMTransCostDateacctData modulescript has several performance issues |
| Description | "InitializeMTransCostDateacctData" modulescript has several performance issues with big amount of data. This happens because modulescripts are executed when the indexes of database are not created yet. |
| Steps To Reproduce | Execute update.database on a database with big amount of data. |
| Proposed Solution | Remove the "InitializeMTransCostDateacctData" modulescript and implement that functionality in the "Costing Background process". Create a preference when the process has been executed in order to control that only is executed once.
Add a verification on "Valued Stock Report" and on "Sales Invoice Dimensional Report" to be able to run it only after the execution of "Costing Background process". |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | depends on | backport | 0028951 | 3.0PR15Q1.1 | closed | umartirena | InitializeMTransCostDateacctData modulescript has several performance issues | | causes | defect | 0029440 | 3.0PR15Q3 | closed | umartirena | In a environment with costs not calculated the user can not get the sales invoice dimensional report |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2014-11-06 12:14 | umartirena | New Issue | |
| 2014-11-06 12:14 | umartirena | Assigned To | => umartirena |
| 2014-11-06 12:14 | umartirena | OBNetwork customer | => No |
| 2014-11-06 12:14 | umartirena | Modules | => Core |
| 2014-11-06 12:14 | umartirena | Triggers an Emergency Pack | => No |
| 2014-11-06 12:14 | umartirena | Status | new => scheduled |
| 2014-11-06 12:14 | umartirena | fix_in_branch | => pi |
| 2015-02-02 10:46 | umartirena | Target Version | 3.0PR14Q4 => 3.0PR15Q2 |
| 2015-02-02 10:46 | umartirena | fix_in_branch | pi => |
| 2015-02-16 12:29 | plujan | Status | scheduled => acknowledged |
| 2015-02-16 12:30 | plujan | Status | acknowledged => scheduled |
| 2015-02-16 12:30 | plujan | fix_in_branch | => pi |
| 2015-02-16 16:02 | hgbot | Checkin | |
| 2015-02-16 16:02 | hgbot | Note Added: 0074515 | |
| 2015-02-16 16:02 | hgbot | Status | scheduled => resolved |
| 2015-02-16 16:02 | hgbot | Resolution | open => fixed |
| 2015-02-16 16:02 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/7a7b3954ec5964e56e2ef8e2d3c5d1589204dc4a [^] |
| 2015-02-17 10:30 | hgbot | Checkin | |
| 2015-02-17 10:30 | hgbot | Note Added: 0074544 | |
| 2015-02-18 11:48 | hgbot | Checkin | |
| 2015-02-18 11:48 | hgbot | Note Added: 0074589 | |
| 2015-02-18 14:06 | hgbot | Checkin | |
| 2015-02-18 14:06 | hgbot | Note Added: 0074601 | |
| 2015-02-23 05:11 | hudsonbot | Checkin | |
| 2015-02-23 05:11 | hudsonbot | Note Added: 0074763 | |
| 2015-02-23 05:11 | hudsonbot | Checkin | |
| 2015-02-23 05:11 | hudsonbot | Note Added: 0074769 | |
| 2015-02-23 05:11 | hudsonbot | Checkin | |
| 2015-02-23 05:11 | hudsonbot | Note Added: 0074781 | |
| 2015-02-23 05:11 | hudsonbot | Checkin | |
| 2015-02-23 05:11 | hudsonbot | Note Added: 0074784 | |
| 2015-03-10 09:57 | dmitry_mezentsev | Note Added: 0075365 | |
| 2015-03-13 10:37 | dmitry_mezentsev | Note Added: 0075525 | |
| 2015-03-18 10:21 | umartirena | Review Assigned To | => eduardo_Argal |
| 2015-03-18 10:21 | umartirena | fix_in_branch | pi => |
| 2015-03-20 12:35 | eduardo_Argal | Note Added: 0075789 | |
| 2015-03-20 12:35 | eduardo_Argal | Status | resolved => closed |
| 2015-03-27 16:33 | dmitry_mezentsev | Relationship added | causes 0029440 |
|
Notes |
|
|
(0074515)
|
|
hgbot
|
|
2015-02-16 16:02
|
|
Repository: erp/devel/pi
Changeset: 7a7b3954ec5964e56e2ef8e2d3c5d1589204dc4a
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Mon Feb 16 16:00:25 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/7a7b3954ec5964e56e2ef8e2d3c5d1589204dc4a [^]
Fixes bug 28111, Fixes bug 28951: InitCostDateacct modulescript has been removed
The functionality that was being implemented in the modulescript now will be done in Costing Background process. An oncreatedefault has been added in dateacct column because it has a constraint of not null. The date set to the column will be 01-01-1970, and this date will be used as a reference while updating it in Costing Background process
---
M src-db/database/model/tables/M_TRANSACTION_COST.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
M src/org/openbravo/costing/CostingBackground.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportValuationStock.java
A build/javasqlc/src/org/openbravo/costing/InitializeCostingMTransCostDateacctData.java
A src/org/openbravo/costing/InitializeCostingMTransCostDateacct_data.xsql
R src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeMTransCostDateacct.class
R src-util/modulescript/build/classes/org/openbravo/modulescript/InitializeMTransCostDateacctData.class
R src-util/modulescript/src/org/openbravo/modulescript/InitializeMTransCostDateacct.java
R src-util/modulescript/src/org/openbravo/modulescript/InitializeMTransCostDateacct_data.xsql
---
|
|
|
|
(0074544)
|
|
hgbot
|
|
2015-02-17 10:30
|
|
Repository: erp/devel/pi
Changeset: e2e44617a15698fd1dbc40a7d50888784bfb41db
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Tue Feb 17 10:28:34 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/e2e44617a15698fd1dbc40a7d50888784bfb41db [^]
Related to bug 28111,related to bug 28951: Remove xsql Data class file
---
R build/javasqlc/src/org/openbravo/costing/InitializeCostingMTransCostDateacctData.java
---
|
|
|
|
(0074589)
|
|
hgbot
|
|
2015-02-18 11:48
|
|
Repository: erp/devel/pi
Changeset: bb5fb83de69573b861872d87fcd01da7a6bf169f
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Wed Feb 18 11:46:11 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/bb5fb83de69573b861872d87fcd01da7a6bf169f [^]
Related to bug 28111,related to bug 28951: Fix on oncreatedefault
oncreatedefault statement of dateacct has been changed in order to work both in oracle and postgres with different date formats.
Also to_date has been removed from background process in order to allways the filter work.
---
M src-db/database/model/tables/M_TRANSACTION_COST.xml
M src/org/openbravo/costing/InitializeCostingMTransCostDateacct_data.xsql
---
|
|
|
|
(0074601)
|
|
hgbot
|
|
2015-02-18 14:06
|
|
Repository: erp/devel/pi
Changeset: 50eefca6fdf24dce85e7fd364e57c85a7b551d73
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Wed Feb 18 14:02:30 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/50eefca6fdf24dce85e7fd364e57c85a7b551d73 [^]
Related to bug 28111,related to bug 28951: Fix on where clause
Filter m_transaction_cost records in Costing Background process using same dateformat that has been used in oncreatedefault to insert values
---
M src/org/openbravo/costing/InitializeCostingMTransCostDateacct_data.xsql
---
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The issue is resolved but not yet closed for 22 days. |
|
|
|
|
|
|
|
|
|
Code Reviewed and tested. No module script is run and background process for costing does the computation for dateacct |
|