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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0008658
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2009-04-21 09:452009-06-03 00:00
ReporteralostaleView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version2.50MP1
StatusclosedFix in branchFixed in SCM revision05a19929e8ca
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0008658: DB inconsistency when installing/updating modules

DescriptionWhen a module is installed or updated two steps must be done independently:
1. Install the module: this step changes information about module in database and copies the module's files to file system.
2. Apply the module, this step loads in database the rest of information for the module, generates code and compiles that code and the manual one.

After step 1 and before step 2 the information for modules in database is not consistent. For example if we are upgrading a module from version 1.0.0 to 2.0.0, database will contain version 2.0.0 for that module whereas the actual running version is 1.0.0.
Proposed SolutionStep 1 shouldn't update actual module tables but an auxiliary one used only for this purpose.
TagsModularity
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0015768)
hgbot (developer)
2009-04-27 12:08

Repository: erp/devel/pi
Changeset: a540c30acbcc3acf7c7f954c4ed902f55dc6b583
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Apr 22 16:29:50 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a540c30acbcc3acf7c7f954c4ed902f55dc6b583 [^]

[issue 8658] Added temporary tables infrastructure

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_TABLE.xml
A src-db/database/model/tables/AD_MODULE_DBPREFIX_INSTALL.xml
A src-db/database/model/tables/AD_MODULE_DEPENDENCY_INST.xml
A src-db/database/model/tables/AD_MODULE_INSTALL.xml
---
(0015769)
hgbot (developer)
2009-04-27 12:08

Repository: erp/devel/pi
Changeset: a9fa99e39194d311da0305d475820da67e1f3ea1
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Apr 22 17:45:02 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a9fa99e39194d311da0305d475820da67e1f3ea1 [^]

[issue 8658] Removed unnecessary check

---
M src-db/database/model/tables/AD_MODULE_INSTALL.xml
---
(0015770)
hgbot (developer)
2009-04-27 12:08

Repository: erp/devel/pi
Changeset: f913a337467a99e213b74a02f0f1d3871e279d8a
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Apr 22 18:08:07 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f913a337467a99e213b74a02f0f1d3871e279d8a [^]

[issue 8658] When installing/updating insert values in new infrastructure

---
M src/org/openbravo/erpCommon/modules/ImportModule.java
M src/org/openbravo/erpCommon/modules/ImportModule_data.xsql
---
(0015771)
hgbot (developer)
2009-04-27 12:08

Repository: erp/devel/pi
Changeset: e20a2252cdf80fc08d68087b74ba67c28f345f09
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Apr 22 18:12:10 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e20a2252cdf80fc08d68087b74ba67c28f345f09 [^]

[issue 8658] Set status I for updated modules

---
M src/org/openbravo/erpCommon/modules/ImportModule.java
---
(0015772)
hgbot (developer)
2009-04-27 12:08

Repository: erp/devel/pi
Changeset: 499281ba7042dca17f012682712e365cddb8010e
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Apr 23 14:52:56 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/499281ba7042dca17f012682712e365cddb8010e [^]

[issue 8658] Show information in temporary tables in module tree

---
M src/org/openbravo/erpCommon/modules/ModuleTree_data.xsql
---
(0015773)
hgbot (developer)
2009-04-27 12:08

Repository: erp/devel/pi
Changeset: bfd6de845afb8372b2d96a814d63ca7893b76677
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Apr 23 15:08:14 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/bfd6de845afb8372b2d96a814d63ca7893b76677 [^]

[issue 8658] Show tree for new modules

---
M src/org/openbravo/erpCommon/modules/ModuleTree_data.xsql
---
(0015774)
hgbot (developer)
2009-04-27 12:08

Repository: erp/devel/pi
Changeset: 7055f88018aab5440ff3dc885009f63d20326968
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Apr 23 15:19:09 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/7055f88018aab5440ff3dc885009f63d20326968 [^]

[issue 8658] Fixed identifier for temporary tables in module tree

---
M src/org/openbravo/erpCommon/modules/ModuleTree_data.xsql
---
(0015775)
hgbot (developer)
2009-04-27 12:08

Repository: erp/devel/pi
Changeset: 1d424b7f7ed52de03ae2349da023a0476d82093d
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Apr 23 15:47:41 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/1d424b7f7ed52de03ae2349da023a0476d82093d [^]

[issue 8658] Fixed model not to have foreing keys for these temporary tables

---
M src-db/database/model/tables/AD_MODULE_DBPREFIX_INSTALL.xml
M src-db/database/model/tables/AD_MODULE_DEPENDENCY_INST.xml
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0015776)
hgbot (developer)
2009-04-27 12:08

Repository: erp/devel/pi
Changeset: 086cb5ae7f2f72adb4c08e21829c53b649bd4e26
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Apr 23 17:09:19 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/086cb5ae7f2f72adb4c08e21829c53b649bd4e26 [^]

[issue 8658] Clean temporary tables before inserting data

---
M src/org/openbravo/erpCommon/modules/ImportModule.java
M src/org/openbravo/erpCommon/modules/ImportModule_data.xsql
---
(0015777)
hgbot (developer)
2009-04-27 12:08

Repository: erp/devel/pi
Changeset: d4825b795c60a1dea6bb394f4de816e791bffca2
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Apr 23 17:51:09 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d4825b795c60a1dea6bb394f4de816e791bffca2 [^]

[issue 8658] Take into account installed but not applied modules when sanning for updates and searching new modules to install

---
M src/org/openbravo/erpCommon/ad_forms/ModuleManagement_data.xsql
M src/org/openbravo/erpCommon/modules/ImportModule_data.xsql
---
(0015778)
hgbot (developer)
2009-04-27 12:08

Repository: erp/devel/pi
Changeset: be14bf9c8ea15593ff68fc39db930eea2a2836d5
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Apr 27 10:30:34 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/be14bf9c8ea15593ff68fc39db930eea2a2836d5 [^]

[issue 8658] updated with pi

---
M src-db/database/build-create.xml
M src-db/database/model/functions/C_INVOICE_CANCEL.xml
M src-db/database/model/functions/C_INVOICE_CREATE.xml
M src-db/database/model/functions/C_INVOICE_POST.xml
M src-db/database/model/functions/C_ORDER_POST1.xml
M src-db/database/model/functions/C_SETTLEMENT_POST.xml
M src-db/database/model/functions/C_VALIDCOMBINATION_GET.xml
M src-db/database/model/functions/MA_COPY_VERSION.xml
M src-db/database/model/functions/MA_GLOBALUSE_DISTRIBUTE.xml
M src-db/database/model/functions/M_INOUT_CREATE.xml
M src-db/database/model/functions/M_PRICELIST_CREATE.xml
M src-db/database/model/tables/C_ORDERLINE_OFFER.xml
M src-db/database/model/triggers/C_INVOICELINE_TRG2.xml
M src-db/database/model/triggers/C_ORDERLINE_TRG2.xml
M src-trl/src/org/openbravo/translate/RTLSkin.java
M src-wad/src/org/openbravo/wad/controls/WADControl.java
M src/build.xml
M src/org/openbravo/base/session/SessionFactoryController.java
M src/org/openbravo/erpCommon/ad_callouts/SE_Expense_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_Budget_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_CreateFromMultiple_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_InOutLine_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_InOut_BPartner.java
M src/org/openbravo/erpCommon/ad_callouts/SL_Inventory_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_Invoice_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_Movement_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_Order_Product.java
M src/org/openbravo/erpCommon/ad_callouts/SL_Production_Product.java
M src/org/openbravo/erpCommon/ad_forms/ShowSessionPreferences.java
M src/org/openbravo/erpCommon/ad_forms/ShowSessionPreferences.xml
M src/org/openbravo/erpCommon/ad_process/ImportAccount_data.xsql
M src/org/openbravo/erpCommon/ad_reports/MInOutTraceReports.html
M src/org/openbravo/erpCommon/ad_reports/MInOutTraceReports.java
M src/org/openbravo/erpCommon/ad_reports/MInOutTraceReports_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportBudgetGenerateExcel.html
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.html
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.java
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournalDetail.java
M src/org/openbravo/erpCommon/ad_reports/ReportOffer.html
M src/org/openbravo/erpCommon/ad_reports/ReportProductionCost.java
M src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportShipper.java
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.html
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.xml
M src/org/openbravo/erpCommon/ad_reports/ReportValuationStock.java
M src/org/openbravo/erpCommon/ad_reports/ReportValuationStock_data.xsql
M src/org/openbravo/erpCommon/ad_reports/SubreportOfferProduct.html
M src/org/openbravo/erpCommon/info/Location_F1.html
M src/org/openbravo/erpCommon/info/Location_F1.xml
M src/org/openbravo/erpCommon/utility/reporting/Template_data.xsql
M src/org/openbravo/service/db/DataImportService.java
M web/js/utils.js
M web/js/windowKeyboard.js
A lib/runtime/db2jcc.jar
A lib/runtime/db2jcc_license_cu.jar
A src-db/database/model/postscript-DB2.sql
A src-db/database/model/prescript-DB2.sql
A src/org/openbravo/base/session/OBDB2v97Dialect.java
---
(0015779)
hgbot (developer)
2009-04-27 12:08

Repository: erp/devel/pi
Changeset: 395c64aeef092d33ec4e8b19775386d2cf6659d1
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Apr 27 10:59:22 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/395c64aeef092d33ec4e8b19775386d2cf6659d1 [^]

[issue 8658] look in temporary tables when applying modules

---
M src/org/openbravo/erpCommon/ad_process/ApplyModules_data.xsql
---
(0015780)
hgbot (developer)
2009-04-27 12:08

Repository: erp/devel/pi
Changeset: 05a19929e8cacbcf9112a5db91dc36137371ab0b
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Apr 27 11:54:14 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/05a19929e8cacbcf9112a5db91dc36137371ab0b [^]

fixed bug 0008658: DB inconsistency when installing/updating modules

---
M src-db/database/lib/dbsourcemanager.jar
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_TABLE.xml
M src/org/openbravo/erpCommon/ad_forms/ModuleManagement_data.xsql
M src/org/openbravo/erpCommon/ad_process/ApplyModules_data.xsql
M src/org/openbravo/erpCommon/modules/ImportModule.java
M src/org/openbravo/erpCommon/modules/ImportModule_data.xsql
M src/org/openbravo/erpCommon/modules/ModuleTree_data.xsql
A src-db/database/model/tables/AD_MODULE_DBPREFIX_INSTALL.xml
A src-db/database/model/tables/AD_MODULE_DEPENDENCY_INST.xml
A src-db/database/model/tables/AD_MODULE_INSTALL.xml
---

- Issue History
Date Modified Username Field Change
2009-04-21 09:45 alostale New Issue
2009-04-21 09:45 alostale Assigned To => alostale
2009-04-21 09:45 alostale Regression testing => No
2009-04-21 09:45 alostale Tag Attached: Modularity
2009-04-22 20:23 psarobe Status new => scheduled
2009-04-22 20:23 psarobe fix_in_branch => pi
2009-04-24 16:53 rafaroda version => pi
2009-04-24 16:53 rafaroda fix_in_branch pi =>
2009-04-27 12:08 hgbot Checkin
2009-04-27 12:08 hgbot Note Added: 0015768
2009-04-27 12:08 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a540c30acbcc3acf7c7f954c4ed902f55dc6b583 [^]
2009-04-27 12:08 hgbot Checkin
2009-04-27 12:08 hgbot Note Added: 0015769
2009-04-27 12:08 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/a540c30acbcc3acf7c7f954c4ed902f55dc6b583 [^] => http://code.openbravo.com/erp/devel/pi/rev/a9fa99e39194d311da0305d475820da67e1f3ea1 [^]
2009-04-27 12:08 hgbot Checkin
2009-04-27 12:08 hgbot Note Added: 0015770
2009-04-27 12:08 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/a9fa99e39194d311da0305d475820da67e1f3ea1 [^] => http://code.openbravo.com/erp/devel/pi/rev/f913a337467a99e213b74a02f0f1d3871e279d8a [^]
2009-04-27 12:08 hgbot Checkin
2009-04-27 12:08 hgbot Note Added: 0015771
2009-04-27 12:08 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/f913a337467a99e213b74a02f0f1d3871e279d8a [^] => http://code.openbravo.com/erp/devel/pi/rev/e20a2252cdf80fc08d68087b74ba67c28f345f09 [^]
2009-04-27 12:08 hgbot Checkin
2009-04-27 12:08 hgbot Note Added: 0015772
2009-04-27 12:08 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/e20a2252cdf80fc08d68087b74ba67c28f345f09 [^] => http://code.openbravo.com/erp/devel/pi/rev/499281ba7042dca17f012682712e365cddb8010e [^]
2009-04-27 12:08 hgbot Checkin
2009-04-27 12:08 hgbot Note Added: 0015773
2009-04-27 12:08 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/499281ba7042dca17f012682712e365cddb8010e [^] => http://code.openbravo.com/erp/devel/pi/rev/bfd6de845afb8372b2d96a814d63ca7893b76677 [^]
2009-04-27 12:08 hgbot Checkin
2009-04-27 12:08 hgbot Note Added: 0015774
2009-04-27 12:08 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/bfd6de845afb8372b2d96a814d63ca7893b76677 [^] => http://code.openbravo.com/erp/devel/pi/rev/7055f88018aab5440ff3dc885009f63d20326968 [^]
2009-04-27 12:08 hgbot Checkin
2009-04-27 12:08 hgbot Note Added: 0015775
2009-04-27 12:08 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/7055f88018aab5440ff3dc885009f63d20326968 [^] => http://code.openbravo.com/erp/devel/pi/rev/1d424b7f7ed52de03ae2349da023a0476d82093d [^]
2009-04-27 12:08 hgbot Checkin
2009-04-27 12:08 hgbot Note Added: 0015776
2009-04-27 12:08 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/1d424b7f7ed52de03ae2349da023a0476d82093d [^] => http://code.openbravo.com/erp/devel/pi/rev/086cb5ae7f2f72adb4c08e21829c53b649bd4e26 [^]
2009-04-27 12:08 hgbot Checkin
2009-04-27 12:08 hgbot Note Added: 0015777
2009-04-27 12:08 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/086cb5ae7f2f72adb4c08e21829c53b649bd4e26 [^] => http://code.openbravo.com/erp/devel/pi/rev/d4825b795c60a1dea6bb394f4de816e791bffca2 [^]
2009-04-27 12:08 hgbot Checkin
2009-04-27 12:08 hgbot Note Added: 0015778
2009-04-27 12:08 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/d4825b795c60a1dea6bb394f4de816e791bffca2 [^] => http://code.openbravo.com/erp/devel/pi/rev/be14bf9c8ea15593ff68fc39db930eea2a2836d5 [^]
2009-04-27 12:08 hgbot Checkin
2009-04-27 12:08 hgbot Note Added: 0015779
2009-04-27 12:08 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/be14bf9c8ea15593ff68fc39db930eea2a2836d5 [^] => http://code.openbravo.com/erp/devel/pi/rev/395c64aeef092d33ec4e8b19775386d2cf6659d1 [^]
2009-04-27 12:08 hgbot Checkin
2009-04-27 12:08 hgbot Note Added: 0015780
2009-04-27 12:08 hgbot Status scheduled => resolved
2009-04-27 12:08 hgbot Resolution open => fixed
2009-04-27 12:08 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/395c64aeef092d33ec4e8b19775386d2cf6659d1 [^] => http://code.openbravo.com/erp/devel/pi/rev/05a19929e8cacbcf9112a5db91dc36137371ab0b [^]
2009-06-02 18:28 psarobe Status resolved => closed
2009-06-03 00:00 anonymous sf_bug_id 0 => 2800232


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker