Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015833Openbravo ERPJ. Demo datapublic2011-02-01 16:112011-05-24 10:56
Reporterdalsasua 
Assigned Todalsasua 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 10.10
Product Versionpi 
Target VersionFixed in Versionpi 
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
Summary0015833: DB Inconsistency in Sample Data
DescriptionSample Data cannot be exported
Steps To ReproducePerform install.source and, even before launching tomcat, export.sample.data. Realize that hundreds of lines are changed.
Proposed Solution
Additional Information
TagsclosingMay2011
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-02-01 16:11dalsasuaNew Issue
2011-02-01 16:11dalsasuaAssigned To => dalsasua
2011-02-01 16:11dalsasuaModules => Core
2011-02-01 18:39dalsasuaStatusnew => scheduled
2011-02-01 18:39dalsasuafix_in_branch => pi
2011-02-02 02:20hgbotCheckin
2011-02-02 02:20hgbotNote Added: 0033992
2011-02-02 02:20hgbotCheckin
2011-02-02 02:20hgbotNote Added: 0033993
2011-02-02 02:21hgbotCheckin
2011-02-02 02:21hgbotNote Added: 0033994
2011-02-02 02:21hgbotCheckin
2011-02-02 02:21hgbotNote Added: 0033995
2011-02-02 02:22dalsasuaStatusscheduled => resolved
2011-02-02 02:22dalsasuaFixed in Version => pi
2011-02-02 02:22dalsasuaFixed in SCM revision => 99f6fa0c1059
2011-02-02 02:22dalsasuaResolutionopen => fixed
2011-02-07 09:52hgbotCheckin
2011-02-07 09:52hgbotNote Added: 0034063
2011-02-07 09:52hgbotFixed in SCM revision99f6fa0c1059 => http://code.openbravo.com/erp/devel/pi/rev/3ec8fa8b6742b75fd8a48e335efdb3e972238f2c [^]
2011-05-24 10:08dalsasuaTag Attached: closingMay2011
2011-05-24 10:56dalsasuaStatusresolved => closed

Notes
(0033992)
hgbot   
2011-02-02 02:20   
Repository: erp/devel/pi
Changeset: 8b43579700c5d527cbc6c499c51514bdc72daddc
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Tue Feb 01 16:17:18 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/8b43579700c5d527cbc6c499c51514bdc72daddc [^]

Issue 15833: DB Inconsistency in Sample Data. Step 1.
Dataset Definition changed, so exported tables are the same than in the original environment -the one where F&B client was created-, and in the same order.
Added changes to F&B Client xml file for:
- New Table FIN_Finacc_Transaction
- New Window Payment Priority
- New Process Update Payment Plan
- fINPaymentPriority and updatePaymentPlan new columns in FIN_Payment_Schedule table
- fINPaymentPriority column in Order and Invoice tables
- createdByAlgorithm column in FIN_Payment and FIN_Finacc_Transaction tables

---
M referencedata/sampledata/F_B_International_Group.xml
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
---
(0033993)
hgbot   
2011-02-02 02:20   
Repository: erp/devel/pi
Changeset: d8e596990146cd83f2e927844a660436ff445a6b
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Wed Feb 02 01:14:21 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/d8e596990146cd83f2e927844a660436ff445a6b [^]

Issue 15833: DB Inconsistency in Sample Data. Step 2.
- Created new regions, no present in core, but in Spanish Regions modules
- Removed passwords from users of the client

---
M referencedata/sampledata/F_B_International_Group.xml
---
(0033994)
hgbot   
2011-02-02 02:21   
Repository: erp/devel/pi
Changeset: fe93148fa4a79a4e74bace63027b6f36248fa828
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Wed Feb 02 01:35:22 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/fe93148fa4a79a4e74bace63027b6f36248fa828 [^]

Issue 15833: DB Inconsistency in Sample Data. Step 3.
- Posted the not-posted documents

---
M referencedata/sampledata/F_B_International_Group.xml
---
(0033995)
hgbot   
2011-02-02 02:21   
Repository: erp/devel/pi
Changeset: 99f6fa0c105924bf0665e3db7962e61dfbc2b102
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Wed Feb 02 01:39:09 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/99f6fa0c105924bf0665e3db7962e61dfbc2b102 [^]

Issue 15833: DB Inconsistency in Sample Data. Step 4.
- Added the AdClientModule entry for core dataset.

---
M referencedata/sampledata/F_B_International_Group.xml
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
---
(0034063)
hgbot   
2011-02-07 09:52   
Repository: erp/devel/pi
Changeset: 3ec8fa8b6742b75fd8a48e335efdb3e972238f2c
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Sun Feb 06 17:34:56 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/3ec8fa8b6742b75fd8a48e335efdb3e972238f2c [^]

Fixes issue 15833. DB Inconsistency in Sample Data
Dataset Definition changed, so exported tables are the same than in the original environment -the one where F&B client was created-, and in the same order.
Added changes to F&B Client xml file for:
- New Table FIN_Finacc_Transaction
- New Window Payment Priority
- New Process Update Payment Plan
- fINPaymentPriority and updatePaymentPlan new columns in FIN_Payment_Schedule table
- fINPaymentPriority column in Order and Invoice tables
- createdByAlgorithm column in FIN_Payment and FIN_Finacc_Transaction tables
- Created new regions, no present in core, but in Spanish Regions modules
- Removed passwords from users of the client
- Posted the not-posted documents
- Added the AdClientModule entry for core dataset.
Also fixed some jUnit tests that relay it's successful execution on demo data content
Also src/build.xml fixed, so QA_Testing client can be exported.

---
M referencedata/sampledata/F_B_International_Group.xml
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
M src-test/org/openbravo/test/base/BaseTest.java
M src-test/org/openbravo/test/xml/EntityXMLImportTestReference.java
M src-test/org/openbravo/test/xml/EntityXMLImportTestSingle.java
M src-test/org/openbravo/test/xml/EntityXMLImportTestWarning.java
M src-test/org/openbravo/test/xml/XMLBaseTest.java
M src/build.xml
---