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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0027745
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementcriticalsometimes2014-10-02 17:482015-03-24 17:42
Reportereduardo_ArgalView Statuspublic 
Assigned Toeduardo_Argal 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision19f4597ee959
ProjectionnoneETAnoneTarget Version3.0PR14Q3
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Togorkaion
Web browser
ModulesCore
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
Summary

0027745: 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
TagsNo tags attached.
Attached Filesdiff file icon APRMApplicationInitializer.diff [^] (833 bytes) 2014-10-02 17:48 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]
caused by feature request 0029391 closedSandrahuguet Add Payment refactor project 

-  Notes
(0070702)
hgbot (developer)
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 (developer)
2014-10-06 10:44

 code review done.
(0072891)
hudsonbot (developer)
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

- Issue History
Date Modified Username Field Change
2014-10-02 17:48 eduardo_Argal New Issue
2014-10-02 17:48 eduardo_Argal Assigned To => gorkaion
2014-10-02 17:48 eduardo_Argal File Added: APRMApplicationInitializer.diff
2014-10-02 17:48 eduardo_Argal Modules => Core
2014-10-02 17:48 eduardo_Argal Regression level => Production - QA Approved
2014-10-02 17:48 eduardo_Argal Regression date => 2014-05-30
2014-10-02 17:48 eduardo_Argal Regression introduced in release => 3.0PR14Q3
2014-10-02 17:48 eduardo_Argal Regression 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:48 eduardo_Argal Triggers an Emergency Pack => No
2014-10-03 16:24 eduardo_Argal Assigned To gorkaion => eduardo_Argal
2014-10-03 16:24 eduardo_Argal Status new => scheduled
2014-10-03 16:24 eduardo_Argal fix_in_branch => pi
2014-10-03 16:26 hgbot Checkin
2014-10-03 16:26 hgbot Note Added: 0070702
2014-10-03 16:26 hgbot Status scheduled => resolved
2014-10-03 16:26 hgbot Resolution open => fixed
2014-10-03 16:26 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/19f4597ee9594d4ee036849eb7d8471b001e9774 [^]
2014-10-06 10:44 gorkaion Review Assigned To => gorkaion
2014-10-06 10:44 gorkaion Note Added: 0070730
2014-10-06 10:44 gorkaion Status resolved => closed
2014-12-30 23:22 hudsonbot Checkin
2014-12-30 23:22 hudsonbot Note Added: 0072891
2015-03-24 17:42 aferraz Relationship added caused by 0029391

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker