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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0022974
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementcriticalhave not tried2013-02-05 11:082013-02-07 11:59
ReportershuehnerView Statuspublic 
Assigned Toeduardo_Argal 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisionb721b6ed25cb
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

0022974: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0022717 closededuardo_Argal When updating to MP18 or higher, update.database fails when user1 and user2 were implemented 

-  Notes
(0056149)
shuehner (administrator)
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 (administrator)
2013-02-05 11:24

 Note: This problem only happens in a very special case: if you update from 2.50MP <12
(0056174)
hgbot (developer)
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 (viewer)
2013-02-05 17:10

 Code Review + Testing OK
(0056180)
hgbot (developer)
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 (viewer)
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 (viewer)
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 (viewer)
2013-02-07 11:59

 Code Review + Testing OK

- Issue History
Date Modified Username Field Change
2013-02-05 11:08 shuehner New Issue
2013-02-05 11:08 shuehner Assigned To => dmiguelez
2013-02-05 11:08 shuehner Modules => Core
2013-02-05 11:08 shuehner OBNetwork customer => No
2013-02-05 11:08 shuehner Triggers an Emergency Pack => No
2013-02-05 11:09 shuehner Relationship added related to 0022717
2013-02-05 11:12 shuehner Regression level => Production - Confirmed Stable
2013-02-05 11:12 shuehner Regression date => 2013-01-03
2013-02-05 11:12 shuehner Regression introduced by commit => http://code.openbravo.com/erp/devel/pi/rev/7165387824d3d9eba3904ef7ba1e6dad8c56546e [^]
2013-02-05 11:12 shuehner Note Added: 0056149
2013-02-05 11:24 shuehner Note Added: 0056152
2013-02-05 16:50 eduardo_Argal Status new => scheduled
2013-02-05 16:50 eduardo_Argal Assigned To dmiguelez => eduardo_Argal
2013-02-05 16:50 eduardo_Argal fix_in_branch => pi
2013-02-05 16:51 hgbot Checkin
2013-02-05 16:51 hgbot Note Added: 0056174
2013-02-05 16:51 hgbot Status scheduled => resolved
2013-02-05 16:51 hgbot Resolution open => fixed
2013-02-05 16:51 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/518e41079d8635631c489ef90645d96f25b695f4 [^]
2013-02-05 17:10 dmiguelez Review Assigned To => dmiguelez
2013-02-05 17:10 dmiguelez Note Added: 0056176
2013-02-05 17:10 dmiguelez Status resolved => closed
2013-02-05 17:52 hgbot Checkin
2013-02-05 17:52 hgbot Note Added: 0056180
2013-02-05 17:52 hgbot Status closed => resolved
2013-02-05 17:52 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/518e41079d8635631c489ef90645d96f25b695f4 [^] => http://code.openbravo.com/erp/devel/pi/rev/b721b6ed25cb2ef0697b2eb2bafa454cb5095adf [^]
2013-02-07 00:11 hudsonbot Checkin
2013-02-07 00:11 hudsonbot Note Added: 0056236
2013-02-07 00:11 hudsonbot Checkin
2013-02-07 00:11 hudsonbot Note Added: 0056237
2013-02-07 11:59 dmiguelez Note Added: 0056250
2013-02-07 11:59 dmiguelez Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker