Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040495Retail ModulesStoreServerpublic2019-03-29 13:402019-05-15 23:23
ReporterAugustoMauch 
Assigned ToAugustoMauch 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tomtaal
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0040495: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0039466 closed AugustoMauch Allow the specify the column to use in the GenericBusinessPartnerSegmentationEventHandler to select the organization 
depends on feature request 0040664 closed AugustoMauch Allow the specify the column to use in the GenericBusinessPartnerSegmentationEventHandler to select the business partner 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-03-29 13:40AugustoMauchNew Issue
2019-03-29 13:40AugustoMauchAssigned To => guillermogil
2019-03-29 13:40AugustoMauchTriggers an Emergency Pack => No
2019-03-29 13:47AugustoMauchAssigned Toguillermogil => AugustoMauch
2019-04-02 09:45mtaalNote Added: 0110959
2019-04-24 09:32AugustoMauchStatusnew => scheduled
2019-04-24 09:37AugustoMauchRelationship addedrelated to 0039466
2019-04-24 10:47AugustoMauchRelationship addeddepends on 0040664
2019-04-24 10:51hgbotCheckin
2019-04-24 10:51hgbotNote Added: 0111258
2019-04-24 10:51hgbotStatusscheduled => resolved
2019-04-24 10:51hgbotResolutionopen => fixed
2019-04-24 10:51hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.contactinfoforproduct.synchronization/rev/727806010fe3c581eb10bac167477f88f20a60e4 [^]
2019-04-24 10:51AugustoMauchReview Assigned To => mtaal
2019-05-15 23:23mtaalNote Added: 0111696
2019-05-15 23:23mtaalStatusresolved => closed

Notes
(0110959)
mtaal   
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   
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   
2019-05-15 23:23   
reviewed