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

View Issue DetailsJump 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 
Review Assigned Todmiguelez
Web browser
ModulesCore
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 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