Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002576Openbravo ERPA. Platformpublic2008-01-31 11:442008-11-26 13:54
Reporterrafaroda 
Assigned Tomarvintm 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40alpha-r2 
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
Summary0002576: SampleData and MetaData files and filters need a revision
Description*Environment
OS: Ubuntu 7.04
DB: Oracle XE 10g
OB: Trunk source dode 2196
Web browser: Firefox 2

*Steps to reproduce
1. Checkout 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. Perform a create.database Ant task: ant create.database
4. Export metadata (sourcedata) from database: ant export.database.data
5. Go to 'database/sourcedata'.
6. Perform a 'svn diff' and log it to a file: svn diff > /path_where_you_want_to_put_the_log_file/sourcedata-diff.log

Open the log file and notice that C_CURRENCY.xml, C_UOM.xml, C_CURRENCY_TRL.xml, C_UOM_TRL.xml and C_COUNTRY.xml files inside '/database/sourcedata/' folder have change (see attach).

Differences between revision and working copy correspond to the differences between those files inside 'sourcedata' and 'sampledata'. For instance, compare 'database/sourcedata/C_UOM.xml' and 'database/sampledata/C_UOM.xml' for AD_CLIENT_ID=0.

Solution:
1. Records containing AD_CLIENT_ID=0 should be removed from those files inside 'database/sampledata'.
2. New clauses concerning those files have to be added to 'OpenbravoDataFilter.java' file inside 'src-db/src/com/openbravo/db' path. Those clauses have to look like 'addTable("C_UOM", "AD_CLIENT_ID <> 0");' and need to be complementary with clauses inside 'OpenbravoMetadataFilter.java' file.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0003619 closed marvintm SampleData and MetaData files and filters need a 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-11-26 13:54psarobeRegression testing => No
2008-11-26 13:54psarobeStatusresolved => closed

Notes
(0006165)
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=1883392 [^]
(0003129)
marvintm   
2008-04-14 09:32   
(edited on: 2008-06-12 09:24)
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.
(0003130)
marvintm   
2008-04-14 09:32   
(edited on: 2008-06-12 09:24)
Logged In: YES
user_id=1952914
Originator: NO

This problem has been fixed by creating a third type of data (masterdata), and fine-tuning the previous filters.