Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0033020
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Multi-Dimensional Profit And Lossmajoralways2016-05-23 10:162016-06-01 10:55
ReporterJONHMView Statuspublic 
Assigned ToSanjota 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision8b994770861c
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toaferraz
Support ticket41946
OBNetwork customerOBPS
Regression introduced in release
Summary

0033020: Process "Generate Profit and Loss Fact Act" fails in a cube with more than 1000 accounts

DescriptionIn cubes having more than 1000 accounts the process fails.
Steps To Reproduce** First of all we need to install the module "Multi-Dimensional Profit And Loss Report"

1) We need to generate the cube. As System Administrator go to "Cube Definition" and generate a cube for "DPL - P&L Template" for user "F&B International Group"
2) Change role to "F&B International Group Admin". Go to "Cube Definition" and select the new cube "DPL - P&L - F&B España, S.A. US_A_Euro". Navigate to tab Cube Reports/Cube Report Dimension/Cube Report Dimension Element and configure the cube like in the attached image.
3) Go to "Process Request" and create a new process "Generate Profit and Loss Fact Act" and schedule that process.

*** The process ends with an error
Proposed SolutionOn file GuenrateProfitAndLossFactAcctTable.java, at line 81 the last iteration fails because maxLength become a negative value. We need to override that line with this one:

- } else {
- maxLenght = pAndLAccounts.size() - (i * 1000);
- }

+ } else {
+ maxLenght = pAndLAccounts.size();
+ }
TagsNo tags attached.
Attached Filespng file icon DefinicionCuentas.png [^] (103,706 bytes) 2016-05-23 10:16

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0032840 closedAtulOpenbravo Generate Profit and Loss Fact Acct process creates records in obdpl_fact_acct_pl although there are no accounts defined in cube 

-  Notes
(0086732)
Sanjota (viewer)
2016-05-25 11:09

 1. Install the module "Multi-Dimensional Profit And Loss Report".
2. As System Administrator go to "Cube Definition" and generate a cube for "DPL - P&L Template" for user "F&B International Group"
3. Change role to "F&B International Group Admin" and Organization to "F&B España, S.A".
4. Go to "Cube Definition" and select the new cube "DPL - P&L - F&B España, S.A. US_A_Euro". Navigate to tab Cube Reports/Cube Report Dimension/Cube Report Dimension Element and configure the cube like in the attached image.
5. Go to "Process Request" and create a new process "Generate Profit and Loss Fact Act" (Not required if it already exist) and schedule that process.

***Check that the process completes with success status.
(0086885)
hgbot (developer)
2016-06-01 10:46

 Repository: erp/pmods/org.openbravo.financial.dimensionalpandlreport
Changeset: 8b994770861cb0a60e41f78d460ddb1f1f9c39e5
Author: Sanjota <sanjota.nelagi <at> promantia.com>
Date: Wed May 25 16:03:49 2016 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.financial.dimensionalpandlreport/rev/8b994770861cb0a60e41f78d460ddb1f1f9c39e5 [^]

Fixes issue 33020: Process "Generate Profit and Loss Fact Act" fails

In cubes having more than 1000 accounts the process fails.

---
M src/org/openbravo/financial/dimensionalpandlreport/GenerateProfitAndLossFactAcctTable.java
---
(0086886)
hgbot (developer)
2016-06-01 10:46

 Repository: erp/pmods/org.openbravo.financial.dimensionalpandlreport
Changeset: 41603e7b2a80b4bcf37d70e087bfb1f560b94809
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Jun 01 10:41:15 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.financial.dimensionalpandlreport/rev/41603e7b2a80b4bcf37d70e087bfb1f560b94809 [^]

Related to issue 33020: Update module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0086889)
hgbot (developer)
2016-06-01 10:55

 Repository: erp/pmods/org.openbravo.financial.dimensionalpandlreport
Changeset: 0ffd6967024244af95e704d65a8ca2943ba25f45
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Jun 01 10:53:42 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.financial.dimensionalpandlreport/rev/0ffd6967024244af95e704d65a8ca2943ba25f45 [^]

Related to issue 33020: Update module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0086890)
aferraz (viewer)
2016-06-01 10:55

 Code review + Testing OK

- Issue History
Date Modified Username Field Change
2016-05-23 10:16 JONHM New Issue
2016-05-23 10:16 JONHM Assigned To => Triage Finance
2016-05-23 10:16 JONHM File Added: DefinicionCuentas.png
2016-05-23 10:16 JONHM Regression date => 2016-06-20
2016-05-23 10:16 JONHM Support ticket => 41946
2016-05-23 10:16 JONHM OBNetwork customer => Yes
2016-05-23 10:57 JONHM Regression date 2016-06-20 =>
2016-05-23 10:57 JONHM Resolution time => 1466373600
2016-05-23 11:27 aferraz Relationship added related to 0032840
2016-05-23 11:27 aferraz Assigned To Triage Finance => Sanjota
2016-05-25 09:46 Sanjota Status new => scheduled
2016-05-25 11:09 Sanjota Note Added: 0086732
2016-06-01 10:46 hgbot Checkin
2016-06-01 10:46 hgbot Note Added: 0086885
2016-06-01 10:46 hgbot Status scheduled => resolved
2016-06-01 10:46 hgbot Resolution open => fixed
2016-06-01 10:46 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.financial.dimensionalpandlreport/rev/8b994770861cb0a60e41f78d460ddb1f1f9c39e5 [^]
2016-06-01 10:46 hgbot Checkin
2016-06-01 10:46 hgbot Note Added: 0086886
2016-06-01 10:55 hgbot Checkin
2016-06-01 10:55 hgbot Note Added: 0086889
2016-06-01 10:55 aferraz Review Assigned To => aferraz
2016-06-01 10:55 aferraz Note Added: 0086890
2016-06-01 10:55 aferraz Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker