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 
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
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 (viewer)
2014-10-06 10:44

 code review done.
(0072891)
hudsonbot (viewer)
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 OBNetwork customer => No
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