Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016360Openbravo ERP09. Financial managementpublic2011-03-17 13:012011-05-24 10:55
Reportershuehner 
Assigned Tomirurita 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0016360: 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
Additional Information
TagsclosingMay2011
Relationships
related to defect 0016325 closed mirurita BuildValidation UniquePaymentForTransaction accesses table fin_finaccc_transaction which is not guaranteed to exist 
depends on backport 0016428 closed mirurita BuildValidation UnpostRefundPayments accesses table fin_payment which is not guaranteed to exist 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-03-17 13:01shuehnerNew Issue
2011-03-17 13:01shuehnerAssigned To => mirurita
2011-03-17 13:01shuehnerModules => Core
2011-03-17 13:02shuehnerRelationship addedrelated to 0016325
2011-03-22 16:24miruritaStatusnew => scheduled
2011-03-22 16:24miruritafix_in_branch => pi
2011-03-22 16:36hgbotCheckin
2011-03-22 16:36hgbotNote Added: 0035151
2011-03-22 16:36hgbotStatusscheduled => resolved
2011-03-22 16:36hgbotResolutionopen => fixed
2011-03-22 16:36hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c0468108be7ab83bbb3f30ef563ea79f31198392 [^]
2011-05-24 10:12dalsasuaTag Attached: closingMay2011
2011-05-24 10:55dalsasuaStatusresolved => closed

Notes
(0035151)
hgbot   
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
---