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 
Review Assigned ToSandrahuguet
Web browser
ModulesCore
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 (developer)
2014-05-06 11:09

 Code review + testing ok
(0066980)
hudsonbot (developer)
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 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