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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0016923
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Java Client POS] (No Category)majoralways2011-04-28 16:342011-12-02 15:24
ReporteradrianromeroView Statuspublic 
Assigned Toadrianromero 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisione89f6ef6cc7c
ProjectionnoneETAnoneTarget Version2.40
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0016923: When synchronizing master data from ERP to POS, a deleted and re-created record in ERP raises an error in the process

DescriptionIn the current synchronization process when synchronizing master data: Customers, Products, ... If a record is deleted and created again in ERP with the same same an error is raised when synchronizing master data because the process will find a record with the same name but different id, in this case the process will try to insert a new record with the same name and an the unique index for names will fail.
Steps To Reproduce1.- Create a master record in Openbravo ERP. For example one business partner and set as customer.
2.- Synchronize master data with Openbravo POS, a new customer will be created in the POS database
3.- Delete the business partner in Openbravo ERP and create new one with the same name
4.- Synchronize master data again with Openbravo POS and see that the process fails because the unique index form customer names will fail
Proposed SolutionWhen synchronizing master data if a record is beign to be synchronized and there exists in the POS a record with the same name but different id, and this id does not exist in ERP, then delete it first in the POS database.

It is supposed that this delete action is a legal action because if the record has been deleted in the ERP is because there are no relation ships to any document or data and for instance it will not be any relation ship in the POS. Fi for some reason the relation ship exists in POS but not in ERP. For example a receipt has been created in the POS that has not been synchronized to the ERP, the synchronization process will fail too.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0019320 closedadrianromero Modules When synchronizing Products. If a search key has been modified in ERP, an error appears. 

-  Notes
(0036577)
hgbot (developer)
2011-05-09 19:08

 Repository: erp/pmods/org.openbravo.pos.sync
Changeset: e89f6ef6cc7c80f9f4af22cd6948d222d7f316a3
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon May 09 19:00:29 2011 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.pos.sync/rev/e89f6ef6cc7c80f9f4af22cd6948d222d7f316a3 [^]

Fixes issue 0016923: When synchronizing master data from ERP to POS, a deleted and re-created record in ERP raises an error in the process
It has been modified the update/insert step to use the field Search Key instead of ID. This change allows recreated elements with the same search key in Openbravo ERP to be properly synchronized to POS

---
M resources/Customers.ktr
M resources/Products.ktr
M resources/Taxes.ktr
---
(0036578)
adrianromero (manager)
2011-05-09 19:25

 * Testing the issue

Synchronize Openbravo POS and Openbravo ERP following the documentation and using the new published module.http://wiki.openbravo.com/wiki/Openbravo_POS_Integration. [^] An verify it works.

Create a new product in ERP an synchronize, verify that the new product has been created

Delete the product in ERP and create it again with the new search key

Syncrhonize again and verify that the new product has been properly synchronized updating the previous product created with the same key.

* Other areas affected

No other areas affected, only the synchronization jobs.
(0036914)
adrianromero (manager)
2011-05-12 18:46

 With the modifications done to fix this issue, now Products and Business partners are synchronized by "Search Key" this means for example that Products with the same search key in ERP and POS have the same search key value will be considered the same product.

- Issue History
Date Modified Username Field Change
2011-04-28 16:34 adrianromero New Issue
2011-04-28 16:34 adrianromero Assigned To => mirurita
2011-04-28 16:38 adrianromero Proposed Solution updated
2011-04-28 16:38 adrianromero Assigned To mirurita => adrianromero
2011-04-28 16:38 adrianromero Status new => scheduled
2011-04-28 16:38 adrianromero Target Version => 2.40
2011-04-28 16:39 adrianromero Summary When synchronizing master data from ERP to POS, a deleted and created record in ERP raises an error in the process => When synchronizing master data from ERP to POS, a deleted and re-created record in ERP raises an error in the process
2011-05-09 19:08 hgbot Checkin
2011-05-09 19:08 hgbot Note Added: 0036577
2011-05-09 19:08 hgbot Status scheduled => resolved
2011-05-09 19:08 hgbot Resolution open => fixed
2011-05-09 19:08 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.pos.sync/rev/e89f6ef6cc7c80f9f4af22cd6948d222d7f316a3 [^]
2011-05-09 19:25 adrianromero Note Added: 0036578
2011-05-12 18:46 adrianromero Note Added: 0036914
2011-06-03 10:57 dalsasua Assigned To adrianromero => dalsasua
2011-06-03 12:22 dalsasua Assigned To dalsasua => adrianromero
2011-12-02 15:24 adrianromero Status resolved => closed
2011-12-16 11:37 adrianromero Relationship added related to 0019320
2012-11-07 09:40 priyam Category 02 - ERP-POS Integration => (No Category)

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker