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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0012247
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagermajorhave not tried2010-02-12 13:222010-03-10 18:29
ReportermarvintmView Statuspublic 
Assigned Tomarvintm 
PrioritynormalResolutionfixedFixed in Version2.50MP12
StatusclosedFix in branchFixed in SCM revisionc269b393c523
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012247: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0024206)
hgbot (developer)
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 (developer)
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 (administrator)
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.

- Issue History
Date Modified Username Field Change
2010-02-12 13:22 marvintm New Issue
2010-02-12 13:22 marvintm Assigned To => marvintm
2010-02-12 13:23 hgbot Checkin
2010-02-12 13:23 hgbot Note Added: 0024206
2010-02-12 13:23 hgbot Status new => resolved
2010-02-12 13:23 hgbot Resolution open => fixed
2010-02-12 13:23 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c269b393c523e4f8c34112497357c4df34300fb3 [^]
2010-02-15 17:39 hudsonbot Checkin
2010-02-15 17:39 hudsonbot Note Added: 0024361
2010-02-16 17:53 shuehner Note Added: 0024432
2010-02-16 17:53 shuehner Status resolved => closed
2010-02-16 17:53 shuehner Fixed in Version => 2.50MP12
2010-02-17 00:01 anonymous sf_bug_id 0 =>
2010-03-10 18:29 anonymous sf_bug_id => 2968058


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker