Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009454 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Y. DBSourceManager | critical | have not tried | 2009-06-12 12:04 | 2009-06-20 00:00 | |||
| Reporter | marvintm | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | pi | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 37f18c5d10d4 | ||||
| Projection | none | ETA | none | Target Version | 2.50MP2 | |||
| OS | Any | Database | PostgreSQL | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 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 | 0009454: Recreation of tables in modules could lead to loss of views in PostgreSQL | |||||||
| Description | When an update.database is performed in PostgreSQL, sometimes tables are recreated. When this happens, the original table is at some point removed from the database (and later created again), which leads to dependant objects being also removed. Specifically, views are dropped. To fix this, the full update.database recreates all the views at the end of the process. However, update.database.mod doesn't load the views if they don't belong to a module, and therefore, doesn't recreate them. This means that if some Core views depend on a Core table that is recreated during the installation of a module (which happens, for example, if a module adds columns to C_BPARTNER), those views will be lost. | |||||||
| Steps To Reproduce | Install module Human Capital Management in PostgreSQL. 20 Core views will be dropped and not recreated. | |||||||
| Proposed Solution | DBSM needs to take this into account. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0017250) hgbot (developer) 2009-06-12 12:53 |
Repository: dbsourcemanager Revision: 335 Author: marvintm Date: 2009-06-12 12:53:56 +0200 (Fri, 12 Jun 2009) Fixed issue 9454. Core views should no longer be dropped when applying a module. --- U trunk/src/org/apache/ddlutils/Platform.java U trunk/src/org/apache/ddlutils/platform/PlatformImplBase.java U trunk/src/org/openbravo/ddlutils/task/AlterDatabaseDataMod.java --- https://dev.openbravo.com/websvn/dbsourcemanager/?rev=335&sc=1 [^] |
|
(0017251) hgbot (developer) 2009-06-12 12:55 |
Repository: erp/devel/pi Changeset: 37f18c5d10d4954bd35698ac5e10abe26dceeb2e Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Fri Jun 12 12:54:21 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/37f18c5d10d4954bd35698ac5e10abe26dceeb2e [^] Fixed issue 9454. Core views should no longer be dropped when applying a module. --- M src-db/database/lib/dbsourcemanager.jar --- |
|
(0017260) AinhoaPagola (viewer) 2009-06-12 13:50 |
I've retested the issue with Human Capital Management module and it is working fine. |
|
(0017477) sureshbabu (viewer) 2009-06-19 12:58 |
Tested in the pi context |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-06-12 12:04 | marvintm | New Issue | |
| 2009-06-12 12:04 | marvintm | Assigned To | => marvintm |
| 2009-06-12 12:04 | marvintm | OBNetwork customer | => No |
| 2009-06-12 12:48 | AinhoaPagola | Issue Monitored: AinhoaPagola | |
| 2009-06-12 12:53 | hgbot | Checkin | |
| 2009-06-12 12:53 | hgbot | Note Added: 0017250 | |
| 2009-06-12 12:53 | hgbot | Status | new => resolved |
| 2009-06-12 12:53 | hgbot | Resolution | open => fixed |
| 2009-06-12 12:55 | hgbot | Checkin | |
| 2009-06-12 12:55 | hgbot | Note Added: 0017251 | |
| 2009-06-12 12:55 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/37f18c5d10d4954bd35698ac5e10abe26dceeb2e [^] |
| 2009-06-12 13:50 | AinhoaPagola | Note Added: 0017260 | |
| 2009-06-19 12:58 | sureshbabu | Status | resolved => closed |
| 2009-06-19 12:58 | sureshbabu | Note Added: 0017477 | |
| 2009-06-19 12:58 | sureshbabu | Fixed in Version | => pi |
| 2009-06-20 00:00 | anonymous | sf_bug_id | 0 => 2809277 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |