Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024648Openbravo ERPA. Platformpublic2013-09-02 10:342013-09-02 18:18
Reporteralostale 
Assigned Toalostale 
PriorityimmediateSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP27Fixed in Version3.0MP27 
Merge Request Status
Review Assigned Toshankarb
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelPre packaging ( pi )
Regression date2013-07-19
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/7d6d644b9b9e3b9ca55c7be357af7bb86a257263 [^]
Triggers an Emergency PackNo
Summary0024648: Open/Close Period Control window is not working
DescriptionWhen trying to open Open/Close Period Control window an exception is raised and no data is shown in grid.

Error
Exception when creating query select e from FinancialMgmtPeriod as e left join e.year as join_0 left join join_0.calendar as join_1 where ( e.organization.id = ad_org_getperiodcontrolallow(:alias_0) and e.status not in ('P','C') ) and e.organization.id in ('E443A31992CB4635AFCAEABE7183CE85', '0', 'DC206C91AA6A4897B44DA897936E0EC3', '7BABA5FF80494CAFA54DEBD22EC46F01', 'BAE22373FEBE4CCCA24517E23F0C8A48', '19404EAD144C49A0AF37D54377CF452D', 'B843C30461EA4501935CB1D125C9C25A', '2E60544D37534C0B89E765FE29BC0B43') and e.client.id in ('23C59575B9CF467C9620760EB255B389', '0')order by e.startingDate,e.id
Steps To ReproduceOpen Open/Close Period Control window
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
has duplicate design defect 00241043.0MP27 closed alostale Unnecessary evaluation of computed columns 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-09-02 10:34alostaleNew Issue
2013-09-02 10:34alostaleAssigned To => alostale
2013-09-02 10:34alostaleModules => Core
2013-09-02 10:34alostaleTriggers an Emergency Pack => No
2013-09-02 10:36alostaleRelationship addedhas duplicate 0024104
2013-09-02 10:37alostaleRegression level => Pre packaging ( pi )
2013-09-02 10:37alostaleRegression date => 2013-07-19
2013-09-02 10:37alostaleRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/7d6d644b9b9e3b9ca55c7be357af7bb86a257263 [^]
2013-09-02 10:38alostaleDescription Updatedbug_revision_view_page.php?rev_id=4989#r4989
2013-09-02 10:41alostaleReview Assigned To => shankarb
2013-09-02 11:00hgbotCheckin
2013-09-02 11:00hgbotNote Added: 0060854
2013-09-02 11:00hgbotStatusnew => resolved
2013-09-02 11:00hgbotResolutionopen => fixed
2013-09-02 11:00hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6e5c3a83e2b53c3ee2bca58f774068669adbe1c0 [^]
2013-09-02 12:39shankarbNote Added: 0060857
2013-09-02 12:39shankarbStatusresolved => closed
2013-09-02 12:39shankarbFixed in Version => 3.0MP27
2013-09-02 18:18hudsonbotCheckin
2013-09-02 18:18hudsonbotNote Added: 0060874

Notes
(0060854)
hgbot   
2013-09-02 11:00   
Repository: erp/devel/pi
Changeset: 6e5c3a83e2b53c3ee2bca58f774068669adbe1c0
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Sep 02 10:57:15 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6e5c3a83e2b53c3ee2bca58f774068669adbe1c0 [^]

fixed bug 24648: Open/Close Period Control window is not working

  Using computed column as part of tab's HQL where clause through _computedColumns
  virtual property.

---
M src-db/database/sourcedata/AD_TAB.xml
---
(0060857)
shankarb   
2013-09-02 12:39   
Code reviewed and tested in pi changeset 6e5c3a83e2b5
(0060874)
hudsonbot   
2013-09-02 18: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/58951728ad3a [^]

Maturity status: Test