Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0015711 | Openbravo ERP | A. Platform | public | 2011-01-20 09:46 | 2023-08-17 13:57 |
|
| Reporter | rgoris | |
| Assigned To | Triage Platform Base | |
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | out of date | |
| Platform | | OS | 5 | OS Version | |
| Product Version | 3.0RC3 | |
| Target Version | | Fixed in Version | | |
| 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 | 0015711: Install updates and rebuild fails in case of local changes. Instance breaks. |
| Description | I 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 Reproduce | Create 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 Solution | Warn 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 | |
| Tags | No 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 Files |  FAIL.png (102,749) 2011-01-20 09:46
https://issues.openbravo.com/file_download.php?file_id=3519&type=bug
ErrorNoViewFOund.png (48,435) 2011-01-21 12:14
https://issues.openbravo.com/file_download.php?file_id=3529&type=bug
|
|
| 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 | bug_revision_view_page.php?bugnote_id=0033806#r1438 |
| 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 |
|
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.
|
|
|
|
|
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. |
|
|
|
|
Effort: 15
Impact: mid
Plan: mid |
|
|
|
|
|
Installing updating (via MMC) is blocked with a message when having local changes (for several years). |
|