Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016325Openbravo ERP09. Financial managementpublic2011-03-16 13:212011-05-24 10:55
Reportershuehner 
Assigned Tomirurita 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesAdvanced Payables and Receivables Mngmt
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0016325: 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
Additional Information
TagsclosingMay2011
Relationships
depends on backport 0016359 closed mirurita BuildValidation UniquePaymentForTransaction accesses table fin_finaccc_transaction which is not guaranteed to exist 
related to defect 0016360 closed mirurita BuildValidation UnpostRefundPayments accesses table fin_payment which is not guaranteed to exist 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-03-16 13:21shuehnerNew Issue
2011-03-16 13:21shuehnerAssigned To => eduardo_Argal
2011-03-16 13:21shuehnerModules => Advanced Payables and Receivables Mngmt
2011-03-16 16:16shuehnerNote Added: 0034945
2011-03-16 16:42jpabloaeIssue Monitored: jpabloae
2011-03-17 12:29miruritaAssigned Toeduardo_Argal => mirurita
2011-03-17 12:29miruritaStatusnew => scheduled
2011-03-17 12:29miruritafix_in_branch => pi
2011-03-17 12:30hgbotCheckin
2011-03-17 12:30hgbotNote Added: 0034994
2011-03-17 12:30hgbotStatusscheduled => resolved
2011-03-17 12:30hgbotResolutionopen => fixed
2011-03-17 12:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6c90872d798fc941edf658161cc956d2d555f4ed [^]
2011-03-17 13:02shuehnerRelationship addedrelated to 0016360
2011-05-24 10:12dalsasuaTag Attached: closingMay2011
2011-05-24 10:55dalsasuaStatusresolved => closed

Notes
(0034945)
shuehner   
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   
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
---