Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008878Openbravo ERPY. DBSourceManagerpublic2009-05-04 16:112009-07-27 00:00
Reportermarvintm 
Assigned Tomarvintm 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.50MP3 
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
Summary0008878: update.database throws an exception when upgrading from r2.50 to r2.50mp1
Descriptionupdate.database throws the following exception when upgrading from r2.50 to r2.50mp1:

 There was a problem when deleting install table content.
[alterdatabasedataall] org.postgresql.util.PSQLException: ERROR: no existe la relación «ad_module_install»
[alterdatabasedataall] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
[alterdatabasedataall] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
[alterdatabasedataall] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
...

The reason for this error is that update.database now uses the new _install tables to improve the install process of the modules. However, these tables do not existed yet in 2.50.
Steps To Reproduce
Proposed SolutionDBSM should check if the tables exist before trying to use them.
Additional Information
Tags250MP1, 250MP3releasecandidate
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-05-04 16:11marvintmNew Issue
2009-05-04 16:11marvintmAssigned To => marvintm
2009-05-04 16:11marvintmRegression testing => No
2009-05-04 17:51marvintmTag Attached: 250MP1
2009-05-04 17:52hgbotCheckin
2009-05-04 17:52hgbotNote Added: 0016018
2009-05-04 17:52hgbotStatusnew => resolved
2009-05-04 17:52hgbotResolutionopen => fixed
2009-05-04 17:53hgbotCheckin
2009-05-04 17:53hgbotNote Added: 0016021
2009-05-04 17:53hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/92211af53fe4d200e5df7ef843a8edb1d2cecb3a [^]
2009-06-22 11:09psarobeFixed in Version2.50MP1 => main
2009-07-03 13:14hgbotCheckin
2009-07-03 13:14hgbotNote Added: 0017863
2009-07-03 13:14hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/92211af53fe4d200e5df7ef843a8edb1d2cecb3a [^] => http://code.openbravo.com/erp/devel/pi/rev/dc1879495677c234f1c78da119cfa0ef9be72e7b [^]
2009-07-21 16:24psarobeFixed in Versionmain => 2.50MP3
2009-07-21 16:26psarobeTag Attached: 250MP3releasecandidate
2009-07-26 21:36psarobeStatusresolved => closed
2009-07-27 00:00anonymoussf_bug_id0 => 2827478

Notes
(0016018)
hgbot   
2009-05-04 17:52   
Repository: dbsourcemanager
Revision: 309
Author: marvintm
Date: 2009-05-04 17:52:02 +0200 (Mon, 04 May 2009)

Fixed issue 8878. Now there shouldn't be an exception if the _INSTALL tables do not yet exist in database when doing update.database.

---
U trunk/src/org/openbravo/ddlutils/task/AlterDatabaseDataAll.java
U trunk/src/org/openbravo/ddlutils/util/DBSMOBUtil.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=309&sc=1 [^]
(0016021)
hgbot   
2009-05-04 17:53   
Repository: erp/devel/pi
Changeset: 92211af53fe4d200e5df7ef843a8edb1d2cecb3a
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Mon May 04 17:52:45 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/92211af53fe4d200e5df7ef843a8edb1d2cecb3a [^]

Fixed issue 8878. Now there shouldn't be an exception if the _INSTALL tables do not yet exist in database when doing update.database.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0017863)
hgbot   
2009-07-03 13:14   
Repository: erp/devel/pi
Changeset: dc1879495677c234f1c78da119cfa0ef9be72e7b
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Mon May 04 17:52:45 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/dc1879495677c234f1c78da119cfa0ef9be72e7b [^]

Fixed issue 8878. Now there shouldn't be an exception if the _INSTALL tables do not yet exist in database when doing update.database.

---
M src-db/database/lib/dbsourcemanager.jar
---