Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0008658 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | always | 2009-04-21 09:45 | 2009-06-03 00:00 | |||
| Reporter | alostale | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.50MP1 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 05a19929e8ca | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0008658: DB inconsistency when installing/updating modules | |||||||
| Description | When 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 Solution | Step 1 shouldn't update actual module tables but an auxiliary one used only for this purpose. | |||||||
| Tags | Modularity | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
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 --- |
|
Notes |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |