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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015711
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] A. Platformmajoralways2011-01-20 09:462023-08-17 13:57
ReporterrgorisView Statuspublic 
Assigned ToTriage Platform Base 
PrioritynormalResolutionout of dateFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0RC3SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015711: Install updates and rebuild fails in case of local changes. Instance breaks.

DescriptionI have tried to install RC4 updates into my RC3 instance. The rebuild fails without telling me why, resulting in a broken and useless instance. It even does not tell me how to fix it and recover.

This is a very serious issue that will piss off customers or evaluators. Especially now, with us pushing customer to upgrade to RC4, this is unacceptable.

Although colleagues tell me this has always been the case, this issue is a critical defect IMO.
Steps To ReproduceCreate a module (e.g. for widgets) and keep them in status development. Scan for updates, install all RC4 stuff and rebuild.

Here is my log:


set.code.rev:

code.rev:

init:

core.lib:

init:

compile:

build.jar:

build:

copy.core.lib:

database.lib:

init:
[mkdir] Created dir: /opt/OpenbravoERP/src-db/build/classes
[mkdir] Created dir: /opt/OpenbravoERP/src-db/build/lib
[mkdir] Created dir: /opt/OpenbravoERP/src-db/docs

compile:
[javac] Compiling 4 source files to /opt/OpenbravoERP/src-db/build/classes

build.jar:
[jar] Building jar: /opt/OpenbravoERP/src-db/build/lib/dbmanager.jar

jar:
[copy] Copying 1 file to /opt/OpenbravoERP/src-db/database/lib

buildvalidation:
[sql] Executing commands
[sql] 2 of 2 SQL statements executed successfully

buildvalidation:
[java] 0 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.Cbpvendoracct
[java] 766 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.DuplicatedJavaPackage
[java] 930 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.PaymentGLItemCheck
[java] 1223 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.PreferenceConflict
[java] 1382 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.advpaymentmngt.buildvalidation.UnpostRefundPayments

update.database:
[sql] Executing commands
[sql] 2 of 2 SQL statements executed successfully

update.database.java:
[java] Executing database update process without checking changes in local files.
[java] 1 INFO - Database connection: jdbc:postgresql://localhost:5432/openbravo. [^] User: tad
[java] 24749 INFO - Executing full update.database
[java] 24818 INFO - Reading tables...
[java] 48713 INFO - Reading views...
[java] 119947 INFO - Reading sequences...
[java] 120071 INFO - Reading triggers...
[java] 126567 INFO - Reading functions...
[java] 133690 INFO - Sorting foreign keys, indexes and checks...
[java] 137741 INFO - Starting function and trigger standardization.
[java] 222540 INFO - Checking datatypes from the model loaded from the database
[java] 222553 INFO - Original model loaded from database.
[java] 234945 INFO - Checking datatypes from the model loaded from XML files
[java] 239420 INFO - Loading data from XML files
[java] Checking if database structure was modified locally.
[java] Checking if data has changed in the application dictionary.
[java] 326282 INFO - Change detected in table: AD_Module
[java] 326289 INFO - Database has local changes. Update.database will not be done. You should export your changed modules before doing update.database, so that your Application Dictionary changes are preserved.
[java] Database has local changes. Update.database not done.
[java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:143)
[java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
[java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38)
[java] Exception in thread "main" Database has local changes. Update.database not done.
[java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:225)
[java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
[java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38)
[java] Caused by: Database has local changes. Update.database not done.
[java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:143)
[java] ... 2 more
[java] --- Nested Exception ---
[java] Database has local changes. Update.database not done.
[java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:143)
[java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
[java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38)
Proposed SolutionWarn upfront that installing updates and rebuilding is not possible (or will lead to problems) when something is in development (something was changed in AD) and that you need to export (or whatever you need to do).

If user then decided to continue, it is on his own risk but although the AD changes will not be preserved, this is still not a reason to let the rebuild fail.

In case of errors, provide a solution to recover.
TagsNo tags attached.
Attached Filespng file icon FAIL.png [^] (102,749 bytes) 2011-01-20 09:46


png file icon ErrorNoViewFOund.png [^] (48,435 bytes) 2011-01-21 12:14

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0015976 closedthirumalaik Set module in development detected as change 
related to defect 0015839 closedalostale Rebuild Error 

-  Notes
(0033806)
rgoris (viewer)
2011-01-21 12:13
edited on: 2011-01-21 12:14

 Not giving up, i tried again from scratch. This time another problem appeared. I get slowly frustrated because i need to test a widget.

I just want to run a virtual appliance with the latest RC4 widgets

Here is what I did:

- Created a clean virgin virtual appliance of RC3. Did not touch anything, nor installed modules.
- Update all available modules via the module manager (scan for updates etc.)
- Rebuild happened fine, with one warning (link to more detail took me to the generic http://wiki.openbravo.com/wiki/ERP/2.50/Update_Tips [^] page)
- System gave me options to reload: i chose to reload Openbravo.
- Error occured, see image
- Logging out and in, gives me a GUI without any widgets or forms or grids. Instance seems useless now and I lost 1.5 hours.

See second attached image for error message.
(0033812)
shuehner (administrator)
2011-01-21 13:41

 Note for the initially described problem. You did local development and did not export those changes.

This will stop the upgrade in the beginning, as when it would not do this. Would kill/delete all the changes you did not export.

This is intentional and not a bug. If you do any development you need to know how this works which includes exporting your changes...

note that your comment seems to describe a completely different issue so please do not mix it with the initial request here but create another defect for that..
(0040592)
jonalegriaesarte (viewer)
2011-08-31 11:29

 Due to the load with other issues we were not able to research this one for MP3, are planning MP4 for it now.
(0052460)
AugustoMauch (administrator)
2012-09-24 23:23

 Effort: 15
Impact: mid
Plan: mid
(0153595)
shuehner (administrator)
2023-08-17 13:57

 Installing updating (via MMC) is blocked with a message when having local changes (for several years).

- Issue History
Date Modified Username Field Change
2011-01-20 09:46 rgoris New Issue
2011-01-20 09:46 rgoris Assigned To => alostale
2011-01-20 09:46 rgoris File Added: FAIL.png
2011-01-20 09:46 rgoris Modules => Core
2011-01-20 09:46 rgoris OBNetwork customer => No
2011-01-20 09:49 rgoris Proposed Solution updated
2011-01-20 23:43 jpabloae Issue Monitored: jpabloae
2011-01-21 12:13 rgoris Note Added: 0033806
2011-01-21 12:14 rgoris File Added: ErrorNoViewFOund.png
2011-01-21 12:14 rgoris Note Edited: 0033806 View Revisions
2011-01-21 13:41 shuehner Note Added: 0033812
2011-01-24 08:18 alostale Status new => scheduled
2011-02-10 16:40 alostale Target Version 3.0RC4 => 3.0
2011-02-14 16:19 alostale Severity critical => major
2011-02-14 16:20 alostale Relationship added depends on 0015976
2011-02-14 16:20 alostale Relationship replaced related to 0015976
2011-04-29 10:30 rgoris Relationship added related to 0015839
2011-05-17 09:15 iperdomo Priority high => normal
2011-06-02 10:53 dmitry_mezentsev Target Version 3.0MP0 => 3.0MP1
2011-06-22 19:57 dmitry_mezentsev Target Version 3.0MP1 => 3.0MP2
2011-06-23 20:04 dmitry_mezentsev Summary Install updates and rebuild fails in case of modules in development: Instance breaks => Install updates and rebuild fails in case of local changes. Instance breaks.
2011-07-28 08:27 alostale Target Version 3.0MP2 => 3.0MP3
2011-08-31 11:29 jonalegriaesarte Note Added: 0040592
2011-08-31 11:29 jonalegriaesarte Target Version 3.0MP3 => 3.0MP4
2011-09-27 13:03 alostale Target Version 3.0MP4 => 3.0MP5
2011-10-28 20:26 dmitry_mezentsev Type defect => design defect
2011-10-31 14:28 alostale Target Version 3.0MP5 => 3.0MP6
2011-11-15 08:55 alostale Target Version 3.0MP6 =>
2012-09-24 23:23 AugustoMauch Note Added: 0052460
2017-03-31 14:36 alostale Status scheduled => acknowledged
2017-04-10 14:34 alostale Assigned To alostale => platform
2022-02-01 08:08 alostale Assigned To platform => Triage Platform Base
2023-08-17 13:56 shuehner Status acknowledged => scheduled
2023-08-17 13:57 shuehner Note Added: 0153595
2023-08-17 13:57 shuehner Status scheduled => closed
2023-08-17 13:57 shuehner Resolution open => out of date

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker