Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037045Retail ModulesStoreServerpublic2017-10-10 13:102017-10-18 23:23
ReporterAugustoMauch 
Assigned ToAugustoMauch 
PrioritynormalSeverityminorReproducibilityhave 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
Summary0037045: Some records for user Openbravo are not excluded when ad_user_roles is exported
DescriptionThe where clause of the ad_user_roles dataset table [1] meant to exclude the entries related with the users '0' (System) and '100' (Openbravo). The problem is that those records are only excluded if those users do not a have a business partner associated (first part of the union clause), and there is no rule that says the those users cannot have a business partner.

[1] https://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/file/1bb389c58094/src-db/database/sourcedata/AD_DATASET_TABLE.xml#l1773 [^]
Steps To Reproduce- Assign a business partner to the Openbravo user
- Export a store
- Check that the ad_user_roles table is not imported, it failed because it tried to import an entry that had already been imported as source data
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-10-10 13:10AugustoMauchNew Issue
2017-10-10 13:10AugustoMauchAssigned To => AugustoMauch
2017-10-10 13:10AugustoMauchTriggers an Emergency Pack => No
2017-10-10 13:21AugustoMauchReview Assigned To => mtaal
2017-10-10 13:21hgbotCheckin
2017-10-10 13:21hgbotNote Added: 0099852
2017-10-10 13:21hgbotStatusnew => resolved
2017-10-10 13:21hgbotResolutionopen => fixed
2017-10-10 13:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/rev/ee0f523dd606c172d31be7acf03dcd63afe49deb [^]
2017-10-18 23:23mtaalNote Added: 0099950
2017-10-18 23:23mtaalStatusresolved => closed

Notes
(0099852)
hgbot   
2017-10-10 13:21   
Repository: erp/pmods/org.openbravo.retail.storeserver.synchronization
Changeset: ee0f523dd606c172d31be7acf03dcd63afe49deb
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Tue Oct 10 13:06:24 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/rev/ee0f523dd606c172d31be7acf03dcd63afe49deb [^]

Fixes issue 37045: ad_role_users for role 0 and client 0, 100 are not exported

Those records are part of the source data, so it must be ensured that they are not included in the store data.

---
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
---
(0099950)
mtaal   
2017-10-18 23:23   
Reviewed