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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0008878
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagerminorhave not tried2009-05-04 16:112009-07-27 00:00
ReportermarvintmView Statuspublic 
Assigned Tomarvintm 
PrioritynormalResolutionfixedFixed in Version2.50MP3
StatusclosedFix in branchFixed in SCM revisiondc1879495677
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0008878: 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.
Proposed SolutionDBSM should check if the tables exist before trying to use them.
Tags250MP1, 250MP3releasecandidate
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

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

- Issue History
Date Modified Username Field Change
2009-05-04 16:11 marvintm New Issue
2009-05-04 16:11 marvintm Assigned To => marvintm
2009-05-04 16:11 marvintm Regression testing => No
2009-05-04 17:51 marvintm Tag Attached: 250MP1
2009-05-04 17:52 hgbot Checkin
2009-05-04 17:52 hgbot Note Added: 0016018
2009-05-04 17:52 hgbot Status new => resolved
2009-05-04 17:52 hgbot Resolution open => fixed
2009-05-04 17:53 hgbot Checkin
2009-05-04 17:53 hgbot Note Added: 0016021
2009-05-04 17:53 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/92211af53fe4d200e5df7ef843a8edb1d2cecb3a [^]
2009-06-22 11:09 psarobe Fixed in Version 2.50MP1 => main
2009-07-03 13:14 hgbot Checkin
2009-07-03 13:14 hgbot Note Added: 0017863
2009-07-03 13:14 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/92211af53fe4d200e5df7ef843a8edb1d2cecb3a [^] => http://code.openbravo.com/erp/devel/pi/rev/dc1879495677c234f1c78da119cfa0ef9be72e7b [^]
2009-07-21 16:24 psarobe Fixed in Version main => 2.50MP3
2009-07-21 16:26 psarobe Tag Attached: 250MP3releasecandidate
2009-07-26 21:36 psarobe Status resolved => closed
2009-07-27 00:00 anonymous sf_bug_id 0 => 2827478


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker