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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0026137
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajorhave not tried2014-04-01 20:382014-05-07 18:12
ReportershuehnerView Statuspublic 
Assigned Toeduardo_Argal 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision11602bd040b1
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2012-08-29
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/78585c145c1f [^]
Triggers an Emergency PackNo
Summary

0026137: ant compile.buildvalidation -Dmodule=org.openbravo.advpaymentmngt fails

Descriptioncompiling the buildvalidation for aprm fails

     [java] 295 [main] INFO org.openbravo.data.Sqlc - File: /home/huehner/ob/branches/pi_retail_pg/modules/org.openbravo.advpaymentmngt/src-util/buildvalidation/src/org/openbravo/advpaymentmngt/buildvalidation/WrongPaymentScheduleDetailsCheck_data.xsql processed
     [java] 312 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: SELECT count(*) AS existing
     [java] FROM (
     [java] SELECT o.c_order_id, o.documentno
     [java] FROM c_order o
     [java] JOIN fin_payment_schedule pso ON o.c_order_id = pso.c_order_id
     [java] WHERE EXISTS (SELECT 1
     [java] FROM c_invoice i
     [java] JOIN c_invoiceline il ON il.c_invoice_id = i.c_invoice_id
     [java] JOIN c_orderline ol ON il.c_orderline_id = ol.c_orderline_id
     [java] WHERE ol.c_order_id = o.c_order_id
     [java] AND i.docstatus = 'CO'
     [java] AND NOT EXISTS (SELECT 1 FROM fin_payment_scheduledetail psd
     [java] JOIN fin_payment_schedule psi ON psd.fin_payment_schedule_invoice = psi.fin_payment_schedule_id
     [java] WHERE il.c_invoice_id = psi.c_invoice_id
     [java] AND psd.fin_payment_schedule_order = pso.fin_payment_schedule_id)
     [java] GROUP BY il.c_invoice_id
     [java] HAVING sum(il.linenetamt +coalesce(c_getinvoiceline_taxamount(il.c_invoiceline_id),0)) != 0)
     [java] AND EXISTS (SELECT 1 FROM fin_payment_scheduledetail psdo
     [java] WHERE psdo.fin_payment_schedule_order = pso.fin_payment_schedule_id)) o
     [java] JOIN c_orderline ol ON ol.c_order_id = o.c_order_id
     [java] JOIN c_invoiceline il ON il.c_orderline_id = ol.c_orderline_id
     [java] JOIN c_invoice i ON i.c_invoice_id = il.c_invoice_id
     [java] WHERE i.docstatus <> 'VO'
     [java] AND NOT EXITS (SELECT 1 FROM c_invoice_reverse WHERE c_invoice_reverse.c_invoice_id = inv.c_invoice_id)
     [java]
     [java] org.postgresql.util.PSQLException: ERROR: syntax error at or near "SELECT"
     [java] Position: 1535
     [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
Steps To Reproducepostgresql9.1 + install.source of pi
rm -rf modules/org.openbravo.advpaymentmngt/src-util/buildvalidation/src/src/
ant compile.buildvalidation -Dmodule=org.openbravo.advpaymentmngt
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0001443 closeduser71 Create Accounting Report window not well formated 

-  Notes
(0066061)
shuehner (administrator)
2014-04-02 12:17

 First found:
last line of that sql
has typo: EXITS instead of EXISTS

  AND NOT EXITS (SELECT 1 FROM c_invoice_reverse WHERE c_invoice_reverse.c_invoice_id = inv.c_invoice_id)


but when fixing that on pgsql9.1 getting more errors:
ERROR: missing FROM-clause entry for table "inv"
LINE 24: ...ce_reverse WHERE c_invoice_reverse.c_invoice_id = inv.c_invo...
(0066063)
shuehner (administrator)
2014-04-02 12:18

 the wrong exit line has been added in this change (2012).

So it is a regression:
changeset: 17810:78585c145c1f
user: Ioritz Cia <ioritz.cia@openbravo.com>
date: Wed Aug 29 12:04:22 2012 +0200
files: modules/org.openbravo.advpaymentmngt/src-util/buildvalidation/src/org/openbravo/advpaymentmngt/buildvalidation/WrongPaymentScheduleDetailsCheck_data.xsql
description:
Fixes issue 1443: 'Wrong payment plan on invoiced orders' alert.
Query needs to be corrected.
(0066644)
hgbot (developer)
2014-04-28 11:45

 Repository: erp/devel/pi
Changeset: 11602bd040b152826474e0b02d16aff4a60d5e7c
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Mon Apr 28 11:45:02 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/11602bd040b152826474e0b02d16aff4a60d5e7c [^]

Fixes bug 26137: ant compile.buildvalidation fails

---
M modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/buildvalidation/WrongPaymentScheduleDetailsCheckData.class
M modules/org.openbravo.advpaymentmngt/src-util/buildvalidation/src/org/openbravo/advpaymentmngt/buildvalidation/WrongPaymentScheduleDetailsCheck_data.xsql
M modules/org.openbravo.advpaymentmngt/src-util/buildvalidation/src/src/org/openbravo/advpaymentmngt/buildvalidation/WrongPaymentScheduleDetailsCheckData.java
---
(0066835)
Sandrahuguet (viewer)
2014-05-06 11:09

 Code review + testing ok
(0066980)
hudsonbot (viewer)
2014-05-07 18:12

 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/02ca2648bcdc [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2014-04-01 20:38 shuehner New Issue
2014-04-01 20:38 shuehner Assigned To => dmiguelez
2014-04-01 20:38 shuehner Modules => Core
2014-04-01 20:38 shuehner OBNetwork customer => No
2014-04-01 20:38 shuehner Triggers an Emergency Pack => No
2014-04-02 12:17 shuehner Note Added: 0066061
2014-04-02 12:18 shuehner Note Added: 0066063
2014-04-02 12:19 shuehner Regression level => Production - Confirmed Stable
2014-04-02 12:19 shuehner Regression date => 2012-08-29
2014-04-02 12:19 shuehner Regression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/78585c145c1f [^]
2014-04-02 13:43 shuehner Relationship added related to 0001443
2014-04-28 11:43 eduardo_Argal Status new => scheduled
2014-04-28 11:43 eduardo_Argal Assigned To dmiguelez => eduardo_Argal
2014-04-28 11:43 eduardo_Argal fix_in_branch => pi
2014-04-28 11:45 hgbot Checkin
2014-04-28 11:45 hgbot Note Added: 0066644
2014-04-28 11:45 hgbot Status scheduled => resolved
2014-04-28 11:45 hgbot Resolution open => fixed
2014-04-28 11:45 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/11602bd040b152826474e0b02d16aff4a60d5e7c [^]
2014-05-05 18:29 Sandrahuguet Review Assigned To => Sandrahuguet
2014-05-06 11:09 Sandrahuguet Note Added: 0066835
2014-05-06 11:09 Sandrahuguet Status resolved => closed
2014-05-07 18:12 hudsonbot Checkin
2014-05-07 18:12 hudsonbot Note Added: 0066980

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker