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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0016325
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajorhave not tried2011-03-16 13:212011-05-24 10:55
ReportershuehnerView Statuspublic 
Assigned Tomirurita 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision6c90872d798f
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesAdvanced Payables and Receivables Mngmt
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0016325: BuildValidation UniquePaymentForTransaction accesses table fin_finaccc_transaction which is not guaranteed to exist

DescriptionWhen updating from 2.50 to latest main (which adds aprm module) this buildvalidation fails as it queries the table fin_finacc_transaction which did not exist in 2.50

     [java] 1020 [main] ERROR org.openbravo.advpaymentmngt.buildvalidation.UniquePaymentForTransactionData - SQL error in query: SELECT ad_column_identifier('fin_payment', t.fin_payment_id, 'en_US') as documentno, t.fin_payment_id, p.isreceipt, p.ad_client_id, p.ad_org_id FROM fin_finacc_transaction t join fin_payment p on (t.fin_payment_id=p.fin_payment_id) GROUP BY t.fin_payment_id, p.isreceipt, p.ad_client_id, p.ad_org_id HAVING count(t.fin_finacc_transaction_id) > 1Exception:org.postgresql.util.PSQLException: ERROR: relation "fin_finacc_transaction" does not exist
     [java] 1021 [main] ERROR org.openbravo.buildvalidation.BuildValidationHandler - The build validation failed.
     [java] 1021 [main] ERROR org.openbravo.buildvalidation.BuildValidationHandler - Error executing build-validation org.openbravo.advpaymentmngt.buildvalidation.UniquePaymentForTransaction: @CODE=0@ERROR: relation "fin_finacc_transaction" does not exist
     [java] The build validation couldn't be properly executed
Steps To Reproducehg clone -r 2.50 pristine/main
install.source
hg pull -u
ant update.database
Proposed Solutioncheck for the tables existence and if it does not exist skip the check completely as it the table didn't exist in the old-db i can't have invalid data in that table
TagsclosingMay2011
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0016359 closedmirurita BuildValidation UniquePaymentForTransaction accesses table fin_finaccc_transaction which is not guaranteed to exist 
related to defect 0016360 closedmirurita BuildValidation UnpostRefundPayments accesses table fin_payment which is not guaranteed to exist 

-  Notes
(0034945)
shuehner (administrator)
2011-03-16 16:16

 Note: a new jenkins job (weekly) verifies 2.50 -> pi updates so can be used to check result of a fix.
http://builds.openbravo.com/view/weekly/job/up-2.50topi-pgsql [^]
(0034994)
hgbot (developer)
2011-03-17 12:30

 Repository: erp/devel/pi
Changeset: 6c90872d798fc941edf658161cc956d2d555f4ed
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Thu Mar 17 12:28:25 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/6c90872d798fc941edf658161cc956d2d555f4ed [^]

Fixes issue 16325: prevent upgrade error in UniquePaymentForTransaction buildvalidation

---
M modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/buildvalidation/UniquePaymentForTransaction.class
M modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/buildvalidation/UniquePaymentForTransactionData.class
M modules/org.openbravo.advpaymentmngt/src-util/buildvalidation/src/org/openbravo/advpaymentmngt/buildvalidation/UniquePaymentForTransaction.java
M modules/org.openbravo.advpaymentmngt/src-util/buildvalidation/src/org/openbravo/advpaymentmngt/buildvalidation/UniquePaymentForTransaction_data.xsql
M modules/org.openbravo.advpaymentmngt/src-util/buildvalidation/src/src/org/openbravo/advpaymentmngt/buildvalidation/UniquePaymentForTransactionData.java
---

- Issue History
Date Modified Username Field Change
2011-03-16 13:21 shuehner New Issue
2011-03-16 13:21 shuehner Assigned To => eduardo_Argal
2011-03-16 13:21 shuehner Modules => Advanced Payables and Receivables Mngmt
2011-03-16 16:16 shuehner Note Added: 0034945
2011-03-16 16:42 jpabloae Issue Monitored: jpabloae
2011-03-17 12:29 mirurita Assigned To eduardo_Argal => mirurita
2011-03-17 12:29 mirurita Status new => scheduled
2011-03-17 12:29 mirurita fix_in_branch => pi
2011-03-17 12:30 hgbot Checkin
2011-03-17 12:30 hgbot Note Added: 0034994
2011-03-17 12:30 hgbot Status scheduled => resolved
2011-03-17 12:30 hgbot Resolution open => fixed
2011-03-17 12:30 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6c90872d798fc941edf658161cc956d2d555f4ed [^]
2011-03-17 13:02 shuehner Relationship added related to 0016360
2011-05-24 10:12 dalsasua Tag Attached: closingMay2011
2011-05-24 10:55 dalsasua Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker