Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027745Openbravo ERP09. Financial managementpublic2014-10-02 17:482015-03-24 17:42
Reportereduardo_Argal 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritycriticalReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR14Q3Fixed in Version 
Merge Request Status
Review Assigned Togorkaion
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression levelProduction - QA Approved
Regression date2014-05-30
Regression introduced in release3.0PR14Q3
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/diff/138b5b704cb6/modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/utility/APRMApplicationInitializer.java [^]
Triggers an Emergency PackNo
Summary0027745: Add Payment fails using Oracle versions: 11.1 y 10
DescriptionDeclared function (hqlagg - inside APRMApplicationInitializer) in hibernate is wrong. It is missing a parenthesis which makes the query crash after being translated
Steps To ReproduceCreate a new purchase invoice
create a line selecting any product and a price different than zero
process invoice
Click on Add Payment button and realize the grid is never loaded while created invoice should be present
ERROR org.openbravo.service.datasource.DataSourceServlet - could not execute query
org.hibernate.exception.SQLGrammarException: could not execute queryERROR org.hibernate.util.JDBCExceptionReporter - ORA-00907: falta el paréntesis derecho
Proposed SolutionFix getAggregationSQL inside APRMApplicationInitializer and add missing parenthesis.

Review fix attached
Additional Information
TagsNo tags attached.
Relationships
caused by feature request 0029391 closed Sandrahuguet Add Payment refactor project 
Attached Filesdiff APRMApplicationInitializer.diff (833) 2014-10-02 17:48
https://issues.openbravo.com/file_download.php?file_id=7296&type=bug
Issue History
Date ModifiedUsernameFieldChange
2014-10-02 17:48eduardo_ArgalNew Issue
2014-10-02 17:48eduardo_ArgalAssigned To => gorkaion
2014-10-02 17:48eduardo_ArgalFile Added: APRMApplicationInitializer.diff
2014-10-02 17:48eduardo_ArgalOBNetwork customer => No
2014-10-02 17:48eduardo_ArgalModules => Core
2014-10-02 17:48eduardo_ArgalRegression level => Production - QA Approved
2014-10-02 17:48eduardo_ArgalRegression date => 2014-05-30
2014-10-02 17:48eduardo_ArgalRegression introduced in release => 3.0PR14Q3
2014-10-02 17:48eduardo_ArgalRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/diff/138b5b704cb6/modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/utility/APRMApplicationInitializer.java [^]
2014-10-02 17:48eduardo_ArgalTriggers an Emergency Pack => No
2014-10-03 16:24eduardo_ArgalAssigned Togorkaion => eduardo_Argal
2014-10-03 16:24eduardo_ArgalStatusnew => scheduled
2014-10-03 16:24eduardo_Argalfix_in_branch => pi
2014-10-03 16:26hgbotCheckin
2014-10-03 16:26hgbotNote Added: 0070702
2014-10-03 16:26hgbotStatusscheduled => resolved
2014-10-03 16:26hgbotResolutionopen => fixed
2014-10-03 16:26hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/19f4597ee9594d4ee036849eb7d8471b001e9774 [^]
2014-10-06 10:44gorkaionReview Assigned To => gorkaion
2014-10-06 10:44gorkaionNote Added: 0070730
2014-10-06 10:44gorkaionStatusresolved => closed
2014-12-30 23:22hudsonbotCheckin
2014-12-30 23:22hudsonbotNote Added: 0072891
2015-03-24 17:42aferrazRelationship addedcaused by 0029391

Notes
(0070702)
hgbot   
2014-10-03 16:26   
Repository: erp/devel/pi
Changeset: 19f4597ee9594d4ee036849eb7d8471b001e9774
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Fri Oct 03 16:26:24 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/19f4597ee9594d4ee036849eb7d8471b001e9774 [^]

Fixes bug 27745: Add Payment fails using Oracle versions: 11.1 y 10

Adds missing parenthesis in declaration of function which was root cause of wrong query parsing

---
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/utility/APRMApplicationInitializer.java
---
(0070730)
gorkaion   
2014-10-06 10:44   
code review done.
(0072891)
hudsonbot   
2014-12-30 23:22   
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/6525fe229e06 [^]
Maturity status: Test