Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002420Openbravo ERPA. Platformpublic2007-12-27 12:542008-06-12 09:43
Reporterrafaroda 
Assigned Tomarvintm 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
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
Summary0002420: 'export.database' changes database XML files
Description*Environment
OS: Unbuntu 7.04
DB: Oracle XE 10g
OB: Trunk source code revision 1870
Web browser: Firefox 2

*Steps
1. Check out trunk source code: svn co https://dev.openbravo.com/svn/openbravo/trunk [^] openbravo
2. Configure Openbravo.properties file: http://wiki.openbravo.com/wiki/index.php/Installation_and_setup_of_Eclipse_IDE#Openbravo.properties_file [^]
3. Create database, build and install Openbravo ERP: ant install.source
4. Without any change in database, perform 'export.database' Ant task: ant export.database
5. Type in your 'openbravo' (main) folder: svn status

Notice that many files inside 'database/model/triggers' , 'database/model/functions', 'database/model/triggers' and some files inside 'database/sourcedata' have 'M' (modified) status. If you perform a commit, these files will try to check in to SVN repository.

Perform: svn diff -r HEAD

You will see that there are (slight) differences between the head revision and the working copy even if no changes have been done in database.

When performing an 'export.database' without changes done in database, files in head revision and working copy should be exactly the same.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange

Notes
(0006009)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1858892 [^]
(0002874)
rafaroda   
2007-12-27 15:08   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1892190
Originator: YES

Changes inside 'database/model/triggers' and 'database/model/functions' are the addition of a blank line near the end of the file.

Changes inside 'database/model/tables' are due to exchanges of position between lines.
(0002875)
rafaroda   
2008-01-10 11:08   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1892190
Originator: YES

Inside 'database/model/triggers', there is also an addition of a blank line near the start of the file.
(0002876)
rafaroda   
2008-01-10 12:06   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1892190
Originator: YES

Using Oracle XE, inside 'database/sourcedata', there are additions of 'COALESCE( )' inside 'AD_TABLE.XML' file.
(0002877)
gorkaion   
2008-01-24 18:06   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1500690
Originator: NO

Fixed AD_TABLE.xml on revision 2112.

The SQL_RECORD_IDENTIFIERS have been updated after the changes in AD_COLUMN_IDENTIFIER_REF_SQL function to fix the bug 1864067.
(0002878)
rafaroda   
2008-02-08 15:20   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1892190
Originator: YES

There are also changes inside 'database/model/views'.
(0002879)
marvintm   
2008-05-07 11:35   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1952914
Originator: NO

We have tested this bug in the subversion repository and it has just been fixed.

Note that the only supported version of the application is the one in subversion. So it is possible that this was a bug in a previous version that is already fixed.
(0002880)
marvintm   
2008-05-07 11:35   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1952914
Originator: NO

This problems were related to an old version of dbsourcemanager. Current version appears to work well, and these problems don't happen anymore.