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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0040495
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] StoreServermajorhave not tried2019-03-29 13:402019-05-15 23:23
ReporterAugustoMauchView Statuspublic 
Assigned ToAugustoMauch 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision727806010fe3
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomtaal
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0040495: Synchronization error when the c_orderline.em_obrcifp_c_bp_location_id column is filled

DescriptionThis week a couple of sync errors occurred in a multiserver client, caused by a data inconsistency problem regarding the business partner and location referenced by the em_obrcifp_c_bpartner_id and em_obrcifp_c_bp_location_id columns of c_orderline.

The sync error happens because the c_orderline is synchronized to a store server where the business partner or the location is not present.

This is a common problem that is solved by adding the problematic table to the Auto Add Business Partner to Store Tables window.
Steps To ReproduceTo be filled in, but should be something like:
- Create and order for an organization that has a store server
- In one of its order lines, fill in the em_obrcifp_c_bpartner_id with a business partner that is not part of the target store.
- Save the orderline, and the sync error should be reproducible
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 0039466 closedAugustoMauch Allow the specify the column to use in the GenericBusinessPartnerSegmentationEventHandler to select the organization 
depends on feature request 0040664 closedAugustoMauch Allow the specify the column to use in the GenericBusinessPartnerSegmentationEventHandler to select the business partner 

-  Notes
(0110959)
mtaal (manager)
2019-04-02 09:45

it is a field which is used for the following usecase: when you buy a television in France it needs to be registered who will use the television including address. This field (and its related business partner field on the orderline) is used to store this information.

So it is not the most critical information to have in the store. On the other hand if we don't sync this field then when the orderline would get updated in the store server it would be synced back with an empty field for this info. But this seems an unlikely scenario (that an existing orderline gets changed in the store server).
So my take at the moment is if we encounter any difficulty/complexities in the replication definition we should ignore it.
(0111258)
hgbot (developer)
2019-04-24 10:51

Repository: erp/pmods/org.openbravo.retail.contactinfoforproduct.synchronization
Changeset: 727806010fe3c581eb10bac167477f88f20a60e4
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Wed Apr 24 10:51:22 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.contactinfoforproduct.synchronization/rev/727806010fe3c581eb10bac167477f88f20a60e4 [^]

Fixes issue 40495: Add bp to store if referenced in contactinfoforproduct

---
A src-db/database/sourcedata/OBSTSYN_AUTO_ADD_BP_STORE.xml
---
(0111696)
mtaal (manager)
2019-05-15 23:23

reviewed

- Issue History
Date Modified Username Field Change
2019-03-29 13:40 AugustoMauch New Issue
2019-03-29 13:40 AugustoMauch Assigned To => guillermogil
2019-03-29 13:40 AugustoMauch Triggers an Emergency Pack => No
2019-03-29 13:47 AugustoMauch Assigned To guillermogil => AugustoMauch
2019-04-02 09:45 mtaal Note Added: 0110959
2019-04-24 09:32 AugustoMauch Status new => scheduled
2019-04-24 09:37 AugustoMauch Relationship added related to 0039466
2019-04-24 10:47 AugustoMauch Relationship added depends on 0040664
2019-04-24 10:51 hgbot Checkin
2019-04-24 10:51 hgbot Note Added: 0111258
2019-04-24 10:51 hgbot Status scheduled => resolved
2019-04-24 10:51 hgbot Resolution open => fixed
2019-04-24 10:51 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.contactinfoforproduct.synchronization/rev/727806010fe3c581eb10bac167477f88f20a60e4 [^]
2019-04-24 10:51 AugustoMauch Review Assigned To => mtaal
2019-05-15 23:23 mtaal Note Added: 0111696
2019-05-15 23:23 mtaal Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker