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

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

0016360: BuildValidation UnpostRefundPayments accesses table fin_payment 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_payment which did not exist in 2.50


[java] 732 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.advpaymentmngt.buildvalidation.UnpostRefundPayments
     [java] 735 [main] ERROR org.openbravo.advpaymentmngt.buildvalidation.UnpostRefundPaymentsData - SQL error in query: SELECT count(*) AS EXISTING FROM fin_payment p, fin_payment_detail pd WHERE p.fin_payment_id = pd.fin_payment_id AND p.posted = 'Y' AND pd.refund = 'Y' AND pd.isprepayment = 'N'Exception:org.postgresql.util.PSQLException: ERROR: relation "fin_payment" does not exist
     [java] 736 [main] ERROR org.openbravo.buildvalidation.BuildValidationHandler - The build validation failed.
     [java] 736 [main] ERROR org.openbravo.buildvalidation.BuildValidationHandler - Error executing build-validation org.openbravo.advpaymentmngt.buildvalidation.UnpostRefundPayments: @CODE=0@ERROR: relation "fin_payment" does not exist
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 ]
related to defect 0016325 closedmirurita BuildValidation UniquePaymentForTransaction accesses table fin_finaccc_transaction which is not guaranteed to exist 
depends on backport 0016428 closedmirurita BuildValidation UnpostRefundPayments accesses table fin_payment which is not guaranteed to exist 

-  Notes
(0035151)
hgbot (developer)
2011-03-22 16:36

 Repository: erp/devel/pi
Changeset: c0468108be7ab83bbb3f30ef563ea79f31198392
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Tue Mar 22 16:35:36 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/c0468108be7ab83bbb3f30ef563ea79f31198392 [^]

Fixes issue 16360: prevent upgrade error in UnpostRefundPayments buildvalidation

---
M modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/buildvalidation/UnpostRefundPayments.class
M modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/buildvalidation/UnpostRefundPaymentsData.class
M modules/org.openbravo.advpaymentmngt/src-util/buildvalidation/src/org/openbravo/advpaymentmngt/buildvalidation/UnpostRefundPayments.java
M modules/org.openbravo.advpaymentmngt/src-util/buildvalidation/src/org/openbravo/advpaymentmngt/buildvalidation/UnpostRefundPayments_data.xsql
M modules/org.openbravo.advpaymentmngt/src-util/buildvalidation/src/src/org/openbravo/advpaymentmngt/buildvalidation/UnpostRefundPaymentsData.java
---

- Issue History
Date Modified Username Field Change
2011-03-17 13:01 shuehner New Issue
2011-03-17 13:01 shuehner Assigned To => mirurita
2011-03-17 13:01 shuehner Modules => Core
2011-03-17 13:02 shuehner Relationship added related to 0016325
2011-03-22 16:24 mirurita Status new => scheduled
2011-03-22 16:24 mirurita fix_in_branch => pi
2011-03-22 16:36 hgbot Checkin
2011-03-22 16:36 hgbot Note Added: 0035151
2011-03-22 16:36 hgbot Status scheduled => resolved
2011-03-22 16:36 hgbot Resolution open => fixed
2011-03-22 16:36 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c0468108be7ab83bbb3f30ef563ea79f31198392 [^]
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