Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0035563 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| design defect | [Openbravo ERP] 09. Financial management | major | have not tried | 2017-03-17 16:41 | 2017-04-18 09:45 | ||||||
| Reporter | egoitz | View Status | public | ||||||||
| Assigned To | vmromanos | ||||||||||
| Priority | urgent | Resolution | open | Fixed in Version | |||||||
| Status | acknowledged | Fix in branch | Fixed in SCM revision | ||||||||
| Projection | none | ETA | none | Target Version | |||||||
| OS | Any | Database | Any | Java version | |||||||
| OS Version | Database version | Ant version | |||||||||
| Product Version | SCM revision | ||||||||||
| Merge Request Status | |||||||||||
| Review Assigned To | |||||||||||
| OBNetwork customer | OBPS | ||||||||||
| Web browser | |||||||||||
| Modules | Core | ||||||||||
| Support ticket | 45781 | ||||||||||
| Regression level | |||||||||||
| Regression date | |||||||||||
| Regression introduced in release | |||||||||||
| Regression introduced by commit | |||||||||||
| Triggers an Emergency Pack | No | ||||||||||
| Summary | 0035563: Trial Balance report takes long to be printed on xls. | ||||||||||
| Description | The Trial Balance report takes few minutes to be printed on envirionment with big amount of data even when printing only 1 month. | ||||||||||
| Steps To Reproduce | -Execute the trial report balance in excel on an environment with big amount of data. It takes more than 10 minutes to print 1 month of data. | ||||||||||
| Tags | No tags attached. | ||||||||||
| Attached Files | |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0096048) vmromanos (viewer) 2017-04-18 09:45 |
Moved to design defect. Problem is to calculate the initial balance, which requires a seq. scan over the fact_acct table to get data from the very beginning to the first date in range. We have tried a query redesign with some new indexes and the performance is improved but not enough to assume the risk for the fix. This issue requires a full refactor in trial balance, using aggregated data to easily get the initial balance, as explained in 0031740 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2017-03-17 16:41 | egoitz | New Issue | |
| 2017-03-17 16:41 | egoitz | Assigned To | => Triage Finance |
| 2017-03-17 16:41 | egoitz | OBNetwork customer | => Yes |
| 2017-03-17 16:41 | egoitz | Modules | => Core |
| 2017-03-17 16:41 | egoitz | Support ticket | => 45781 |
| 2017-03-17 16:41 | egoitz | Resolution time | => 1491516000 |
| 2017-03-17 16:41 | egoitz | Triggers an Emergency Pack | => No |
| 2017-03-20 19:25 | markmm82 | Assigned To | Triage Finance => AtulOpenbravo |
| 2017-03-27 10:12 | vmromanos | Assigned To | AtulOpenbravo => vmromanos |
| 2017-03-27 10:12 | vmromanos | Status | new => acknowledged |
| 2017-04-18 09:45 | vmromanos | Resolution time | 1491516000 => |
| 2017-04-18 09:45 | vmromanos | Note Added: 0096048 | |
| 2017-04-18 09:45 | vmromanos | Type | defect => design defect |
| 2017-04-18 09:45 | vmromanos | Relationship added | has duplicate 0031740 |
| 2017-06-02 12:39 | aferraz | Relationship added | related to 0036070 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |