Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008658Openbravo ERPA. Platformpublic2009-04-21 09:452009-06-03 00:00
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version2.50MP1 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0008658: 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.
Steps To Reproduce
Proposed SolutionStep 1 shouldn't update actual module tables but an auxiliary one used only for this purpose.
Additional Information
TagsModularity
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-04-21 09:45alostaleNew Issue
2009-04-21 09:45alostaleAssigned To => alostale
2009-04-21 09:45alostaleRegression testing => No
2009-04-21 09:45alostaleTag Attached: Modularity
2009-04-22 20:23psarobeStatusnew => scheduled
2009-04-22 20:23psarobefix_in_branch => pi
2009-04-24 16:53rafarodaversion => pi
2009-04-24 16:53rafarodafix_in_branchpi =>
2009-04-27 12:08hgbotCheckin
2009-04-27 12:08hgbotNote Added: 0015768
2009-04-27 12:08hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a540c30acbcc3acf7c7f954c4ed902f55dc6b583 [^]
2009-04-27 12:08hgbotCheckin
2009-04-27 12:08hgbotNote Added: 0015769
2009-04-27 12:08hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/a540c30acbcc3acf7c7f954c4ed902f55dc6b583 [^] => http://code.openbravo.com/erp/devel/pi/rev/a9fa99e39194d311da0305d475820da67e1f3ea1 [^]
2009-04-27 12:08hgbotCheckin
2009-04-27 12:08hgbotNote Added: 0015770
2009-04-27 12:08hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/a9fa99e39194d311da0305d475820da67e1f3ea1 [^] => http://code.openbravo.com/erp/devel/pi/rev/f913a337467a99e213b74a02f0f1d3871e279d8a [^]
2009-04-27 12:08hgbotCheckin
2009-04-27 12:08hgbotNote Added: 0015771
2009-04-27 12:08hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/f913a337467a99e213b74a02f0f1d3871e279d8a [^] => http://code.openbravo.com/erp/devel/pi/rev/e20a2252cdf80fc08d68087b74ba67c28f345f09 [^]
2009-04-27 12:08hgbotCheckin
2009-04-27 12:08hgbotNote Added: 0015772
2009-04-27 12:08hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/e20a2252cdf80fc08d68087b74ba67c28f345f09 [^] => http://code.openbravo.com/erp/devel/pi/rev/499281ba7042dca17f012682712e365cddb8010e [^]
2009-04-27 12:08hgbotCheckin
2009-04-27 12:08hgbotNote Added: 0015773
2009-04-27 12:08hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/499281ba7042dca17f012682712e365cddb8010e [^] => http://code.openbravo.com/erp/devel/pi/rev/bfd6de845afb8372b2d96a814d63ca7893b76677 [^]
2009-04-27 12:08hgbotCheckin
2009-04-27 12:08hgbotNote Added: 0015774
2009-04-27 12:08hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/bfd6de845afb8372b2d96a814d63ca7893b76677 [^] => http://code.openbravo.com/erp/devel/pi/rev/7055f88018aab5440ff3dc885009f63d20326968 [^]
2009-04-27 12:08hgbotCheckin
2009-04-27 12:08hgbotNote Added: 0015775
2009-04-27 12:08hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/7055f88018aab5440ff3dc885009f63d20326968 [^] => http://code.openbravo.com/erp/devel/pi/rev/1d424b7f7ed52de03ae2349da023a0476d82093d [^]
2009-04-27 12:08hgbotCheckin
2009-04-27 12:08hgbotNote Added: 0015776
2009-04-27 12:08hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/1d424b7f7ed52de03ae2349da023a0476d82093d [^] => http://code.openbravo.com/erp/devel/pi/rev/086cb5ae7f2f72adb4c08e21829c53b649bd4e26 [^]
2009-04-27 12:08hgbotCheckin
2009-04-27 12:08hgbotNote Added: 0015777
2009-04-27 12:08hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/086cb5ae7f2f72adb4c08e21829c53b649bd4e26 [^] => http://code.openbravo.com/erp/devel/pi/rev/d4825b795c60a1dea6bb394f4de816e791bffca2 [^]
2009-04-27 12:08hgbotCheckin
2009-04-27 12:08hgbotNote Added: 0015778
2009-04-27 12:08hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/d4825b795c60a1dea6bb394f4de816e791bffca2 [^] => http://code.openbravo.com/erp/devel/pi/rev/be14bf9c8ea15593ff68fc39db930eea2a2836d5 [^]
2009-04-27 12:08hgbotCheckin
2009-04-27 12:08hgbotNote Added: 0015779
2009-04-27 12:08hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/be14bf9c8ea15593ff68fc39db930eea2a2836d5 [^] => http://code.openbravo.com/erp/devel/pi/rev/395c64aeef092d33ec4e8b19775386d2cf6659d1 [^]
2009-04-27 12:08hgbotCheckin
2009-04-27 12:08hgbotNote Added: 0015780
2009-04-27 12:08hgbotStatusscheduled => resolved
2009-04-27 12:08hgbotResolutionopen => fixed
2009-04-27 12:08hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/395c64aeef092d33ec4e8b19775386d2cf6659d1 [^] => http://code.openbravo.com/erp/devel/pi/rev/05a19929e8cacbcf9112a5db91dc36137371ab0b [^]
2009-06-02 18:28psarobeStatusresolved => closed
2009-06-03 00:00anonymoussf_bug_id0 => 2800232

Notes
(0015768)
hgbot   
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   
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   
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   
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   
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   
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   
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   
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   
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   
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   
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   
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   
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
---