Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012247Openbravo ERPY. DBSourceManagerpublic2010-02-12 13:222010-03-10 18:29
Reportermarvintm 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.50MP12 
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
Summary0012247: DBSM incorrectly detects changes in the database
DescriptionUpdate.database sometimes detects changes in the AD_Treenode table, even though the sourcedata rows weren't changed.

The cause for this is that the AD_treenode table is special (some of its rows belong to sourcedata, and some of them do not), and dbsourcemanager needs to take this into account when checking for changes.
Steps To ReproduceIn an update.database, you might encounter this error:

[java] Change detected in table: AD_TreeNode
     [java] Database has local changes. Update.database will not be done. If you want to force the update.database, do: ant update.database -Dforce=true (you will lose all your changes in the application dictionary if you do it)
     [java] Database has local changes. Update.database not done.
     [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.execute(AlterDatabaseDataAll.java:142)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:34)
     [java] Exception in thread "main" Database has local changes. Update.database not done.
     [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.execute(AlterDatabaseDataAll.java:196)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:34)
     [java] Caused by: Database has local changes. Update.database not done.
     [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.execute(AlterDatabaseDataAll.java:142)
     [java] ... 1 more
     [java] --- Nested Exception ---
     [java] Database has local changes. Update.database not done.
     [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.execute(AlterDatabaseDataAll.java:142)
     [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:34)
Proposed SolutionDBSM will be changed to address this problem.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-02-12 13:22marvintmNew Issue
2010-02-12 13:22marvintmAssigned To => marvintm
2010-02-12 13:22marvintmOBNetwork customer => No
2010-02-12 13:23hgbotCheckin
2010-02-12 13:23hgbotNote Added: 0024206
2010-02-12 13:23hgbotStatusnew => resolved
2010-02-12 13:23hgbotResolutionopen => fixed
2010-02-12 13:23hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c269b393c523e4f8c34112497357c4df34300fb3 [^]
2010-02-15 17:39hudsonbotCheckin
2010-02-15 17:39hudsonbotNote Added: 0024361
2010-02-16 17:53shuehnerNote Added: 0024432
2010-02-16 17:53shuehnerStatusresolved => closed
2010-02-16 17:53shuehnerFixed in Version => 2.50MP12
2010-02-17 00:01anonymoussf_bug_id0 =>
2010-03-10 18:29anonymoussf_bug_id => 2968058

Notes
(0024206)
hgbot   
2010-02-12 13:23   
Repository: erp/devel/pi
Changeset: c269b393c523e4f8c34112497357c4df34300fb3
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Fri Feb 12 13:23:08 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/c269b393c523e4f8c34112497357c4df34300fb3 [^]

Fixed issue 12247. AD_TREENODE will be correctly taken into account on the method which checks for data changes in the database.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0024361)
hudsonbot   
2010-02-15 17:39   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/c269b393c523 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/2596487a564c [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16391.obx [^]
(0024432)
shuehner   
2010-02-16 17:53   
No further occurences of the issues in hudson have been seen. An exact testcase for the concrete issue is not known/available.