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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0020745
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementcriticalsometimes2012-06-13 12:142012-07-02 17:37
Reportereduardo_ArgalView Statuspublic 
Assigned Toeduardo_Argal 
PriorityimmediateResolutionfixedFixed in Version3.0MP13
StatusclosedFix in branchFixed in SCM revisionc57255020226
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression levelPre packaging ( pi )
Regression date2012-05-31
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/e1e23b382aa1e15d3c56bf96d3256265f2e22322 [^]
Triggers an Emergency PackNo
Summary

0020745: GL Journal Post process failing due to wrong change which causes a regression

DescriptionFix for bug 020183: gl journal is checked like posted when there is not lines introduces a regression.
new select into introduced by this change set is causing a regression as GL Journal can not be completed in oracle.
Steps To Reproduce1) create a GL Journal
2) Process it
3) Mind the error

Remember to execute this script in oracle!!!!!!!
Proposed SolutionFix the sql adding the missing join
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0020183 closedioritzCia gl journal is checked like posted when there is not lines 

-  Notes
(0049807)
hgbot (developer)
2012-06-13 12:49

 Repository: erp/devel/pi
Changeset: c5725502022695884fc4d25486fe5057ec9933c2
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Wed Jun 13 12:24:01 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c5725502022695884fc4d25486fe5057ec9933c2 [^]

Fixes bug 20745: GL Journal Post process failing due to wrong change which causes a regression

---
M src-db/database/model/functions/GL_JOURNAL_POST.xml
---
(0050322)
mirurita (developer)
2012-07-02 17:35

 The fix related to this issue does not work on oracle because SELECT INTO statement will fail because it can return more than one row.

The following issue 0020183 solves the problem.
(0050323)
vmromanos (manager)
2012-07-02 17:37

 Tested in Oracle and PostgreSQL

- Issue History
Date Modified Username Field Change
2012-06-13 12:14 eduardo_Argal New Issue
2012-06-13 12:14 eduardo_Argal Assigned To => ioritzCia
2012-06-13 12:14 eduardo_Argal Modules => Core
2012-06-13 12:21 eduardo_Argal Regression level => Pre packaging ( pi )
2012-06-13 12:21 eduardo_Argal Regression date => 2012-05-31
2012-06-13 12:21 eduardo_Argal Regression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/e1e23b382aa1e15d3c56bf96d3256265f2e22322 [^]
2012-06-13 12:22 eduardo_Argal Status new => scheduled
2012-06-13 12:22 eduardo_Argal fix_in_branch => pi
2012-06-13 12:22 eduardo_Argal Relationship added related to 0020183
2012-06-13 12:49 hgbot Checkin
2012-06-13 12:49 hgbot Note Added: 0049807
2012-06-13 12:49 hgbot Status scheduled => resolved
2012-06-13 12:49 hgbot Resolution open => fixed
2012-06-13 12:49 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c5725502022695884fc4d25486fe5057ec9933c2 [^]
2012-07-02 12:18 shuehner Assigned To ioritzCia => eduardo_Argal
2012-07-02 12:18 shuehner fix_in_branch pi =>
2012-07-02 17:35 mirurita Note Added: 0050322
2012-07-02 17:35 mirurita Status resolved => closed
2012-07-02 17:35 mirurita Fixed in Version => 3.0MP13
2012-07-02 17:37 vmromanos Note Added: 0050323

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker