0022974: Buildvalidation User1ReadyData is breaking updates from 2.50

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0022974

Openbravo ERP

09. Financial management

public

2013-02-05 11:08

2013-02-07 11:59

Reporter

shuehner

Assigned To

eduardo_Argal

Priority

immediate

Severity

critical

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

dmiguelez

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Production - Confirmed Stable

Regression date

2013-01-03

Regression introduced in release

Regression introduced by commit

http://code.openbravo.com/erp/devel/pi/rev/7165387824d3d9eba3904ef7ba1e6dad8c56546e [^]

Triggers an Emergency Pack

Summary

0022974: Buildvalidation User1ReadyData is breaking updates from 2.50

Description

build-validations are run before running update.database.

In case of updating from 2.50 to 3.0 the 3.0 buildvalidations run against a 2.50 database.

So they need to check the existence of any table not in 2.50 before using it.

The User1ReadyData does use the fin_finacc_transaction table which does no exists in 2.50 so breaks all 2.50 -> 3.0 updates

[java] 707 [main] ERROR org.openbravo.buildvalidation.User1ReadyData - SQL error in query: SELECT COUNT(1) AS RECORDS FROM DUAL WHERE EXISTS (SELECT 1 FROM A_Amortization WHERE USER1_ID IS NOT NULL OR USER2_ID IS NOT NULL) OR EXISTS (SELECT 1 FROM C_BudgetLine WHERE USER1_ID IS NOT NULL OR USER2_ID IS NOT NULL) OR EXISTS (SELECT 1 FROM C_Cash WHERE USER1_ID IS NOT NULL OR USER2_ID IS NOT NULL) OR EXISTS (SELECT 1 FROM C_DP_Management WHERE USER1_ID IS NOT NULL OR USER2_ID IS NOT NULL) OR EXISTS (SELECT 1 FROM C_Invoice WHERE USER1_ID IS NOT NULL OR USER2_ID IS NOT NULL) OR EXISTS (SELECT 1 FROM C_InvoiceLine_AcctDimension WHERE USER1_ID IS NOT NULL OR USER2_ID IS NOT NULL) OR EXISTS (SELECT 1 FROM C_Order WHERE USER1_ID IS NOT NULL OR USER2_ID IS NOT NULL) OR EXISTS (SELECT 1 FROM C_Settlement WHERE USER1_ID IS NOT NULL OR USER2_ID IS NOT NULL) OR EXISTS (SELECT 1 FROM C_ValidCombination WHERE USER1_ID IS NOT NULL OR USER2_ID IS NOT NULL) OR EXISTS (SELECT 1 FROM FIN_Finacc_Transaction WHERE USER1_ID IS NOT NULL OR USER2_ID IS NOT NULL) OR EXISTS (SELECT 1 FROM FIN_Payment WHERE USER1_ID IS NOT NULL OR USER2_ID IS NOT NULL) OR EXISTS (SELECT 1 FROM Fact_Acct WHERE USER1_ID IS NOT NULL OR USER2_ID IS NOT NULL) OR EXISTS (SELECT 1 FROM GL_Journal WHERE USER1_ID IS NOT NULL OR USER2_ID IS NOT NULL) OR EXISTS (SELECT 1 FROM GL_JournalLine WHERE USER1_ID IS NOT NULL OR USER2_ID IS NOT NULL) OR EXISTS (SELECT 1 FROM M_InOut WHERE USER1_ID IS NOT NULL OR USER2_ID IS NOT NULL) OR EXISTS (SELECT 1 FROM M_Inventory WHERE USER1_ID IS NOT NULL OR USER2_ID IS NOT NULL) OR EXISTS (SELECT 1 FROM M_Movement WHERE USER1_ID IS NOT NULL OR USER2_ID IS NOT NULL) OR EXISTS (SELECT 1 FROM M_Production WHERE USER1_ID IS NOT NULL OR USER2_ID IS NOT NULL)Exception:org.postgresql.util.PSQLException: ERROR: relation "fin_finacc_transaction" does not exist

Steps To Reproduce

Install 2.50
install update to 3.0
try to rebuild
Notice update.database fails with the exception mentioned above.

Proposed Solution

Additional Information