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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0014540
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Java Client POS] (No Category)majoralways2010-09-14 13:092014-04-02 09:03
ReporteradrianromeroView Statuspublic 
Assigned Toadrianromero 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision6f12c0e28420
ProjectionnoneETAnoneTarget Version2.40
OSAnyDatabaseAnyJava version
OS VersionDatabase versionDerbyAnt version
Product Version2.30.1SCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0014540: Synchronization transformations do not work in Derby

DescriptionThe synchronization transformation Inventory.ktr does not work in Derby because Derby does not implement the function ROUND used in the Inventory.ktr transformation
Steps To ReproduceJust try to synchronize the inventory between Openbravo ERP and Openbravo POS using Derby as database engine in Openbravo POS.
Proposed SolutionReplace the ROUND function by a math expression that can be executed by all supported Openbravo POS database engines
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0031033)
hgbot (developer)
2010-09-14 13:11

 Repository: erp/mods/org.openbravo.pos.sync.trans
Changeset: 6f12c0e284207916c3ffa1ca9eee2cb5464f3f61
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Tue Sep 14 13:10:59 2010 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.pos.sync.trans/rev/6f12c0e284207916c3ffa1ca9eee2cb5464f3f61 [^]

Fixes issue 0014540: Synchronization transformations do not work in Derby
It has been replaced the ROUND function by the expression FLOOR(? * 100 + 0.5)/ 100

---
M transformations/Inventory.ktr
---
(0031034)
adrianromero (manager)
2010-09-14 13:12

 * Testing of the issue

Test the synchronization using Derby. All other supported database engines must be tested too.

* Other areas affected.

Only the synchronization is affected.
(0031321)
hgbot (developer)
2010-09-23 13:11

 Repository: erp/pmods/org.openbravo.pos.sync.trans
Changeset: 6f12c0e284207916c3ffa1ca9eee2cb5464f3f61
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Tue Sep 14 13:10:59 2010 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.pos.sync.trans/rev/6f12c0e284207916c3ffa1ca9eee2cb5464f3f61 [^]

Fixes issue 0014540: Synchronization transformations do not work in Derby
It has been replaced the ROUND function by the expression FLOOR(? * 100 + 0.5)/ 100

---
M transformations/Inventory.ktr
---
(0065969)
plujan (manager)
2014-04-02 09:03

 Closed as it was in Resolved for too long

- Issue History
Date Modified Username Field Change
2010-09-14 13:09 adrianromero New Issue
2010-09-14 13:09 adrianromero Assigned To => adrianromero
2010-09-14 13:11 hgbot Checkin
2010-09-14 13:11 hgbot Note Added: 0031033
2010-09-14 13:11 hgbot Status new => resolved
2010-09-14 13:11 hgbot Resolution open => fixed
2010-09-14 13:11 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.pos.sync.trans/rev/6f12c0e284207916c3ffa1ca9eee2cb5464f3f61 [^]
2010-09-14 13:12 adrianromero Note Added: 0031034
2010-09-23 13:11 hgbot Checkin
2010-09-23 13:11 hgbot Note Added: 0031321
2010-09-23 13:11 hgbot Fixed in SCM revision http://code.openbravo.com/erp/mods/org.openbravo.pos.sync.trans/rev/6f12c0e284207916c3ffa1ca9eee2cb5464f3f61 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.pos.sync.trans/rev/6f12c0e284207916c3ffa1ca9eee2cb5464f3f61 [^]
2011-06-03 10:59 dalsasua Assigned To adrianromero => dalsasua
2011-06-03 12:22 dalsasua Assigned To dalsasua => adrianromero
2012-11-07 09:40 priyam Category 02 - ERP-POS Integration => (No Category)
2014-04-02 09:03 plujan Note Added: 0065969
2014-04-02 09:03 plujan Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker