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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015973
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2011-02-14 13:152013-07-18 16:23
ReporterdalsasuaView Statuspublic 
Assigned ToAugustoMauch 
PriorityurgentResolutionout of dateFixed in Version
StatusclosedFix in branchpiFixed in SCM revision6982d4d36028
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.6.0_21
OS VersionUbuntu 10.10Database version11.2.0 SEAnt version1.8.0
Product VersionpiSCM revisionf3e48926a5b2 
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
Summary

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

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0016320 closedmarvintm Failure ordering changes when exporting datasets. 
related to design defect 00242713.0MP26 closedshuehner ant import.sample.data uses way to much memory and is very slow 

-  Notes
(0053087)
hgbot (developer)
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 (viewer)
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 (viewer)
2012-10-08 18:45

 backout is in changeset:
https://code.openbravo.com/erp/devel/pi/rev/3c81c6408c19 [^]
(0053141)
hgbot (developer)
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 (viewer)
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 (viewer)
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 (viewer)
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

- Issue History
Date Modified Username Field Change
2011-02-14 13:15 dalsasua New Issue
2011-02-14 13:15 dalsasua Assigned To => marvintm
2011-02-14 13:15 dalsasua Modules => Core
2011-02-14 13:15 dalsasua OBNetwork customer => No
2011-02-14 19:05 jpabloae Issue Monitored: jpabloae
2011-02-21 08:25 alostale Status new => scheduled
2011-02-21 08:25 alostale fix_in_branch => pi
2011-07-14 15:18 shuehner Relationship added related to 0016320
2012-08-20 16:08 marvintm Assigned To marvintm => AugustoMauch
2012-09-25 15:49 AugustoMauch Assigned To AugustoMauch => jecharri
2012-10-05 23:24 hgbot Checkin
2012-10-05 23:24 hgbot Note Added: 0053087
2012-10-05 23:24 hgbot Status scheduled => resolved
2012-10-05 23:24 hgbot Resolution open => fixed
2012-10-05 23:24 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6982d4d3602824682e62219a24106fa10fe53ae4 [^]
2012-10-08 13:48 jecharri Status resolved => new
2012-10-08 13:48 jecharri Resolution fixed => open
2012-10-08 13:49 jecharri Note Added: 0053110
2012-10-08 13:49 jecharri Note Deleted: 0053110
2012-10-08 13:49 jecharri Note Added: 0053111
2012-10-08 13:49 jecharri Assigned To jecharri => AugustoMauch
2012-10-08 18:45 jecharri Note Added: 0053131
2012-10-09 05:20 hgbot Checkin
2012-10-09 05:20 hgbot Note Added: 0053141
2012-10-11 07:50 hudsonbot Checkin
2012-10-11 07:50 hudsonbot Note Added: 0053242
2012-10-11 07:50 hudsonbot Checkin
2012-10-11 07:50 hudsonbot Note Added: 0053262
2013-07-18 16:22 alostale Relationship added related to 0024271
2013-07-18 16:23 alostale Note Added: 0060099
2013-07-18 16:23 alostale Status new => closed
2013-07-18 16:23 alostale Resolution open => out of date

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker