Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015711Openbravo ERPA. Platformpublic2011-01-20 09:462023-08-17 13:57
Reporterrgoris 
Assigned ToTriage Platform Base 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionout of date 
PlatformOS5OS Version
Product Version3.0RC3 
Target VersionFixed in Version 
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
Summary0015711: 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.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0015976 closed thirumalaik Set module in development detected as change 
related to defect 0015839 closed alostale Rebuild Error 
Attached Filespng FAIL.png (102,749) 2011-01-20 09:46
https://issues.openbravo.com/file_download.php?file_id=3519&type=bug
png

png ErrorNoViewFOund.png (48,435) 2011-01-21 12:14
https://issues.openbravo.com/file_download.php?file_id=3529&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2011-01-20 09:46rgorisNew Issue
2011-01-20 09:46rgorisAssigned To => alostale
2011-01-20 09:46rgorisFile Added: FAIL.png
2011-01-20 09:46rgorisModules => Core
2011-01-20 09:49rgorisProposed Solution updated
2011-01-20 23:43jpabloaeIssue Monitored: jpabloae
2011-01-21 12:13rgorisNote Added: 0033806
2011-01-21 12:14rgorisFile Added: ErrorNoViewFOund.png
2011-01-21 12:14rgorisNote Edited: 0033806bug_revision_view_page.php?bugnote_id=0033806#r1438
2011-01-21 13:41shuehnerNote Added: 0033812
2011-01-24 08:18alostaleStatusnew => scheduled
2011-02-10 16:40alostaleTarget Version3.0RC4 => 3.0
2011-02-14 16:19alostaleSeveritycritical => major
2011-02-14 16:20alostaleRelationship addeddepends on 0015976
2011-02-14 16:20alostaleRelationship replacedrelated to 0015976
2011-04-29 10:30rgorisRelationship addedrelated to 0015839
2011-05-17 09:15iperdomoPriorityhigh => normal
2011-06-02 10:53dmitry_mezentsevTarget Version3.0MP0 => 3.0MP1
2011-06-22 19:57dmitry_mezentsevTarget Version3.0MP1 => 3.0MP2
2011-06-23 20:04dmitry_mezentsevSummaryInstall 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:27alostaleTarget Version3.0MP2 => 3.0MP3
2011-08-31 11:29jonalegriaesarteNote Added: 0040592
2011-08-31 11:29jonalegriaesarteTarget Version3.0MP3 => 3.0MP4
2011-09-27 13:03alostaleTarget Version3.0MP4 => 3.0MP5
2011-10-28 20:26dmitry_mezentsevTypedefect => design defect
2011-10-31 14:28alostaleTarget Version3.0MP5 => 3.0MP6
2011-11-15 08:55alostaleTarget Version3.0MP6 =>
2012-09-24 23:23AugustoMauchNote Added: 0052460
2017-03-31 14:36alostaleStatusscheduled => acknowledged
2017-04-10 14:34alostaleAssigned Toalostale => platform
2022-02-01 08:08alostaleAssigned Toplatform => Triage Platform Base
2023-08-17 13:56shuehnerStatusacknowledged => scheduled
2023-08-17 13:57shuehnerNote Added: 0153595
2023-08-17 13:57shuehnerStatusscheduled => closed
2023-08-17 13:57shuehnerResolutionopen => out of date

Notes
(0033806)
rgoris   
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   
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   
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   
2012-09-24 23:23   
Effort: 15
Impact: mid
Plan: mid
(0153595)
shuehner   
2023-08-17 13:57   
Installing updating (via MMC) is blocked with a message when having local changes (for several years).