Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022974Openbravo ERP09. Financial managementpublic2013-02-05 11:082013-02-07 11:59
Reportershuehner 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2013-01-03
Regression introduced in release
Regression introduced by commithttp://code.openbravo.com/erp/devel/pi/rev/7165387824d3d9eba3904ef7ba1e6dad8c56546e [^]
Triggers an Emergency PackNo
Summary0022974: Buildvalidation User1ReadyData is breaking updates from 2.50
Descriptionbuild-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 ReproduceInstall 2.50
install update to 3.0
try to rebuild
Notice update.database fails with the exception mentioned above.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0022717 closed eduardo_Argal When updating to MP18 or higher, update.database fails when user1 and user2 were implemented 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-02-05 11:08shuehnerNew Issue
2013-02-05 11:08shuehnerAssigned To => dmiguelez
2013-02-05 11:08shuehnerModules => Core
2013-02-05 11:08shuehnerOBNetwork customer => No
2013-02-05 11:08shuehnerTriggers an Emergency Pack => No
2013-02-05 11:09shuehnerRelationship addedrelated to 0022717
2013-02-05 11:12shuehnerRegression level => Production - Confirmed Stable
2013-02-05 11:12shuehnerRegression date => 2013-01-03
2013-02-05 11:12shuehnerRegression introduced by commit => http://code.openbravo.com/erp/devel/pi/rev/7165387824d3d9eba3904ef7ba1e6dad8c56546e [^]
2013-02-05 11:12shuehnerNote Added: 0056149
2013-02-05 11:24shuehnerNote Added: 0056152
2013-02-05 16:50eduardo_ArgalStatusnew => scheduled
2013-02-05 16:50eduardo_ArgalAssigned Todmiguelez => eduardo_Argal
2013-02-05 16:50eduardo_Argalfix_in_branch => pi
2013-02-05 16:51hgbotCheckin
2013-02-05 16:51hgbotNote Added: 0056174
2013-02-05 16:51hgbotStatusscheduled => resolved
2013-02-05 16:51hgbotResolutionopen => fixed
2013-02-05 16:51hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/518e41079d8635631c489ef90645d96f25b695f4 [^]
2013-02-05 17:10dmiguelezReview Assigned To => dmiguelez
2013-02-05 17:10dmiguelezNote Added: 0056176
2013-02-05 17:10dmiguelezStatusresolved => closed
2013-02-05 17:52hgbotCheckin
2013-02-05 17:52hgbotNote Added: 0056180
2013-02-05 17:52hgbotStatusclosed => resolved
2013-02-05 17:52hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/518e41079d8635631c489ef90645d96f25b695f4 [^] => http://code.openbravo.com/erp/devel/pi/rev/b721b6ed25cb2ef0697b2eb2bafa454cb5095adf [^]
2013-02-07 00:11hudsonbotCheckin
2013-02-07 00:11hudsonbotNote Added: 0056236
2013-02-07 00:11hudsonbotCheckin
2013-02-07 00:11hudsonbotNote Added: 0056237
2013-02-07 11:59dmiguelezNote Added: 0056250
2013-02-07 11:59dmiguelezStatusresolved => closed

Notes
(0056149)
shuehner   
2013-02-05 11:12   
The issue 22717 introducing this regression was pushed into MP19 but also backported to MP18.2 so it applies to a version in status CS.
(0056152)
shuehner   
2013-02-05 11:24   
Note: This problem only happens in a very special case: if you update from 2.50MP <12
(0056174)
hgbot   
2013-02-05 16:51   
Repository: erp/devel/pi
Changeset: 518e41079d8635631c489ef90645d96f25b695f4
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Tue Feb 05 16:51:04 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/518e41079d8635631c489ef90645d96f25b695f4 [^]

Fixes bug 22974

---
M src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/User1Ready.class
M src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/User1ReadyData.class
M src-util/buildvalidation/src/org/openbravo/buildvalidation/User1Ready.java
M src-util/buildvalidation/src/org/openbravo/buildvalidation/User1Ready_data.xsql
---
(0056176)
dmiguelez   
2013-02-05 17:10   
Code Review + Testing OK
(0056180)
hgbot   
2013-02-05 17:52   
Repository: erp/devel/pi
Changeset: b721b6ed25cb2ef0697b2eb2bafa454cb5095adf
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Tue Feb 05 17:51:50 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/b721b6ed25cb2ef0697b2eb2bafa454cb5095adf [^]

Fixes bug 22974 II: it was missing some parameter

---
M src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/User1Ready.class
M src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/User1ReadyData.class
M src-util/buildvalidation/src/org/openbravo/buildvalidation/User1Ready.java
M src-util/buildvalidation/src/org/openbravo/buildvalidation/User1Ready_data.xsql
---
(0056236)
hudsonbot   
2013-02-07 00:11   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/47073b14c368 [^]

Maturity status: Test
(0056237)
hudsonbot   
2013-02-07 00:11   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/47073b14c368 [^]

Maturity status: Test
(0056250)
dmiguelez   
2013-02-07 11:59   
Code Review + Testing OK