Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015973Openbravo ERPA. Platformpublic2011-02-14 13:152013-07-18 16:23
Reporterdalsasua 
Assigned ToAugustoMauch 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionout of date 
PlatformOS20OS VersionUbuntu 10.10
Product Versionpi 
Target VersionFixed in Version 
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
Summary0015973: ant export.sample.data gives distinct output in oracle than in postgresql
Descriptionant export.sample.data gives distinct output in oracle than in postgresql
Steps To ReproduceDo Install.source and Export.Sample.Data in postgresql (there is no change)
Do Install.source and Export.Sample.Data in Oracle, and this diff is obtained:
--- a/referencedata/sampledata/F_B_International_Group.xml
+++ b/referencedata/sampledata/F_B_International_Group.xml
@@ -17,7 +17,7 @@
     <amount>0.02</amount>
     <refund>false</refund>
     <active>true</active>
- <writeoffAmount>0.00</writeoffAmount>
+ <writeoffAmount>0</writeoffAmount>
     <gLItem xsi:nil="true"/>
     <isprepayment>false</isprepayment>
   </FIN_Payment_Detail>
@@ -29,7 +29,7 @@
     <amount>85.79</amount>
     <refund>false</refund>
     <active>true</active>
- <writeoffAmount>0.00</writeoffAmount>
+ <writeoffAmount>0</writeoffAmount>
     <gLItem xsi:nil="true"/>
     <isprepayment>false</isprepayment>
   </FIN_Payment_Detail>
@@ -41,7 +41,7 @@
     <amount>164.92</amount>
     <refund>false</refund>
     <active>true</active>
- <writeoffAmount>0.00</writeoffAmount>
+ <writeoffAmount>0</writeoffAmount>
     <gLItem xsi:nil="true"/>
     <isprepayment>false</isprepayment>
   </FIN_Payment_Detail>
@@ -53,7 +53,7 @@
     <amount>191.12</amount>
     <refund>false</refund>
     <active>true</active>
- <writeoffAmount>0.00</writeoffAmount>
+ <writeoffAmount>0</writeoffAmount>
     <gLItem xsi:nil="true"/>
     <isprepayment>false</isprepayment>
   </FIN_Payment_Detail>
@@ -65,7 +65,7 @@
     <amount>168.22</amount>
     <refund>false</refund>
     <active>true</active>
... ( and thosand of lines more with same type of changes (removing extra zeros in the right )
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0016320 closed marvintm Failure ordering changes when exporting datasets. 
related to design defect 00242713.0MP26 closed shuehner ant import.sample.data uses way to much memory and is very slow 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-02-14 13:15dalsasuaNew Issue
2011-02-14 13:15dalsasuaAssigned To => marvintm
2011-02-14 13:15dalsasuaModules => Core
2011-02-14 13:15dalsasuaOBNetwork customer => No
2011-02-14 19:05jpabloaeIssue Monitored: jpabloae
2011-02-21 08:25alostaleStatusnew => scheduled
2011-02-21 08:25alostalefix_in_branch => pi
2011-07-14 15:18shuehnerRelationship addedrelated to 0016320
2012-08-20 16:08marvintmAssigned Tomarvintm => AugustoMauch
2012-09-25 15:49AugustoMauchAssigned ToAugustoMauch => jecharri
2012-10-05 23:24hgbotCheckin
2012-10-05 23:24hgbotNote Added: 0053087
2012-10-05 23:24hgbotStatusscheduled => resolved
2012-10-05 23:24hgbotResolutionopen => fixed
2012-10-05 23:24hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6982d4d3602824682e62219a24106fa10fe53ae4 [^]
2012-10-08 13:48jecharriStatusresolved => new
2012-10-08 13:48jecharriResolutionfixed => open
2012-10-08 13:49jecharriNote Added: 0053110
2012-10-08 13:49jecharriNote Deleted: 0053110
2012-10-08 13:49jecharriNote Added: 0053111
2012-10-08 13:49jecharriAssigned Tojecharri => AugustoMauch
2012-10-08 18:45jecharriNote Added: 0053131
2012-10-09 05:20hgbotCheckin
2012-10-09 05:20hgbotNote Added: 0053141
2012-10-11 07:50hudsonbotCheckin
2012-10-11 07:50hudsonbotNote Added: 0053242
2012-10-11 07:50hudsonbotCheckin
2012-10-11 07:50hudsonbotNote Added: 0053262
2013-07-18 16:22alostaleRelationship addedrelated to 0024271
2013-07-18 16:23alostaleNote Added: 0060099
2013-07-18 16:23alostaleStatusnew => closed
2013-07-18 16:23alostaleResolutionopen => out of date

Notes
(0053087)
hgbot   
2012-10-05 23:24   
Repository: erp/devel/pi
Changeset: 6982d4d3602824682e62219a24106fa10fe53ae4
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Thu Oct 04 17:41:28 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6982d4d3602824682e62219a24106fa10fe53ae4 [^]

Fixes issue 15973: ant export.sample.data gives distinct output in oracle than in postgresql

---
M referencedata/sampledata/F_B_International_Group.xml
M referencedata/sampledata/QA_Testing.xml
M src/org/openbravo/base/model/domaintype/BigDecimalDomainType.java
---
(0053111)
jecharri   
2012-10-08 13:49   
[junit] Testcase: testFKDelete took 0.721 sec
    [junit] Testcase: testNonBooleanCheck took 0.597 sec
    [junit] Testcase: testPGSpanish took 0.23 sec
    [junit] Testcase: testExportImportClient1000000 took 0.229 sec
    [junit] Testcase: testDeleteClient took 300.831 sec
    [junit] Testcase: testAPaymentTerm took 3.042 sec
    [junit] Testcase: testBPaymentTerm took 0.977 sec
    [junit] Testcase: testCPaymentTerm took 0.661 sec
    [junit] FAILED
    [junit] expected:<0> but was:<2>
    [junit] junit.framework.AssertionFailedError: expected:<0> but was:<2>
    [junit] at org.openbravo.test.xml.EntityXMLImportTestBusinessObject.testCPaymentTerm(EntityXMLImportTestBusinessObject.java:134)
    [junit] at org.openbravo.test.base.BaseTest.runTest(BaseTest.java:306)
    [junit]
    [junit] Testcase: testDPaymentTerm took 0.723 sec
    [junit] FAILED
    [junit] expected:<2> but was:<3>
    [junit] junit.framework.AssertionFailedError: expected:<2> but was:<3>
    [junit] at org.openbravo.test.xml.EntityXMLImportTestBusinessObject.testDPaymentTerm(EntityXMLImportTestBusinessObject.java:170)
    [junit] at org.openbravo.test.base.BaseTest.runTest(BaseTest.java:306)
    [junit]
    [junit] Testcase: testEPaymentTerm took 0.642 sec
    [junit] FAILED
    [junit] expected:<2> but was:<1>
    [junit] junit.framework.AssertionFailedError: expected:<2> but was:<1>
    [junit] at org.openbravo.test.xml.EntityXMLImportTestBusinessObject.testEPaymentTerm(EntityXMLImportTestBusinessObject.java:219)
    [junit] at org.openbravo.test.base.BaseTest.runTest(BaseTest.java:306)
    [junit]
    [junit] Testcase: testFPaymentTerm took 0.305 sec
    [junit] Testcase: testGPaymentTerm took 0.863 sec
    [junit] Testcase: testHPaymentTerm took 0.296 sec
    [junit] Testcase: testZPaymentTerm took 0.587 sec
    [junit] Testcase: test1Warehouse took 0.282 sec
    [junit] Testcase: test2Warehouse took 0.301 sec
    [junit] Testcase: test3Warehouse took 0.253 sec
    [junit] Testcase: test4Warehouse took 0.259 sec
    [junit] Testcase: testImportNoUpdate took 0.128 sec
    [junit] Testcase: test1Greeting took 1.346 sec
(0053131)
jecharri   
2012-10-08 18:45   
backout is in changeset:
https://code.openbravo.com/erp/devel/pi/rev/3c81c6408c19 [^]
(0053141)
hgbot   
2012-10-09 05:20   
Repository: erp/devel/pi
Changeset: 3c81c6408c19db2cf96c6b31e5cf3806837b335a
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Mon Oct 08 14:38:03 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/3c81c6408c19db2cf96c6b31e5cf3806837b335a [^]

Fixes issue 21871: int-full-oracle /view.php?id=4034 is failing, issue 15973:backout changeset 6982d4d36028

---
M referencedata/sampledata/F_B_International_Group.xml
M referencedata/sampledata/QA_Testing.xml
M src/org/openbravo/base/model/domaintype/BigDecimalDomainType.java
---
(0053242)
hudsonbot   
2012-10-11 07:50   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/63dfc135f2a1 [^]

Maturity status: Test
(0053262)
hudsonbot   
2012-10-11 07:50   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/63dfc135f2a1 [^]

Maturity status: Test
(0060099)
alostale   
2013-07-18 16:23   
Sample data exportation process has been changed by issue 0024271 and also its format is not different, as now it uses dbsm there shouldn't be differences between ora and pg exportation