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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0037353
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] StoreServermajoralways2017-11-22 11:212017-12-13 22:18
ReporterioritzCiaView Statuspublic 
Assigned ToAugustoMauch 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision83f73488abc9
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version8.x
OS VersionCentOS 6Database version9.5.xAnt version1.9.x
Product VersionSCM revision 
Review Assigned Tomtaal
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0037353: EM_OBRETCO_RETAILORGTYPE column for orgs not in natural tree dataset should be excluded

DescriptionDataset for organizations not in natural tree should exclude EM_OBRETCO_RETAILORGTYPE column. Stores that are not in naturall tree are exported excluding EM_OBRETCO_C_BPARTNER_ID and EM_OBRETCO_C_BP_LOCATION_ID columns and there is EM_OBRETCO_ORG_POS_CHK check constraing which does not allow for EM_OBRETCO_RETAILORGTYPE = 'S' rows to have them empty. This makes install.source in the store server to give an error.

Remember to exclude from symmetric synchronization.
Steps To ReproduceIn a multiserver environment with more than one store not in the same natural tree.
Export one store
Import it with install source
This error appears in the install source:
SQL Command failed with: ERROR: check constraint "em_obretco_org_pos_chk" is violated by some row

-- END

ALTER TABLE AD_ORG

    ADD CONSTRAINT EM_OBRETCO_ORG_POS_CHK CHECK (EM_OBRETCO_RETAILORGTYPE = 'S' AND EM_OBRETCO_C_BPARTNER_ID IS NOT NULL AND EM_OBRETCO_C_BP_LOCATION_ID IS NOT NULL OR EM_OBRETCO_RETAILORGTYPE <> 'S')
Proposed SolutionDataset for organizations not in natural tree should exclude EM_OBRETCO_RETAILORGTYPE column
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
caused by defect 0037204 closedAugustoMauch Anonymous customer and its location should be excluded for orgs not in natural org tree 

-  Notes
(0100828)
mtaal (manager)
2017-11-30 11:30

The change in 37204 has been backed out for now so the cause of this issue has been resolved. However, it is better to revisit the complete topic.
(0101016)
hgbot (developer)
2017-12-13 15:20

Repository: erp/pmods/org.openbravo.retail.storeserver.synchronization
Changeset: 83f73488abc97cb62861dd2fb137e08ab1f994c1
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Wed Dec 13 15:20:34 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/rev/83f73488abc97cb62861dd2fb137e08ab1f994c1 [^]

Fixes issue 37204, fixes issue 37353: Excludes columns from ad_org

The following columns are excluded from ad_org for those orgs not included in the org natural tree of the store being exported:
- EM_Obretco_C_Bpartner_ID
- EM_Obretco_C_bp_Location_ID
- EM_OBRETCO_RETAILORGTYPE

This way, the EM_OBRETCO_ORG_POS_CHK constraint is no longer working when installing the new store.

---
M src-db/database/sourcedata/AD_DATASET_COLUMN.xml
---
(0101026)
mtaal (manager)
2017-12-13 22:18

Reviewed

- Issue History
Date Modified Username Field Change
2017-11-22 11:21 ioritzCia New Issue
2017-11-22 11:21 ioritzCia Assigned To => StoreServer
2017-11-22 11:21 ioritzCia Resolution time => 1512687600
2017-11-22 11:21 ioritzCia Triggers an Emergency Pack => No
2017-11-22 11:21 ioritzCia OS Version Openbravo Appliance 14.04 => CentOS 6
2017-11-22 11:37 ioritzCia Description Updated View Revisions
2017-11-30 11:29 mtaal Relationship added caused by 0037204
2017-11-30 11:30 mtaal Note Added: 0100828
2017-11-30 11:30 mtaal Assigned To StoreServer => AugustoMauch
2017-12-13 15:20 hgbot Checkin
2017-12-13 15:20 hgbot Note Added: 0101016
2017-12-13 15:20 hgbot Status new => resolved
2017-12-13 15:20 hgbot Resolution open => fixed
2017-12-13 15:20 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization/rev/83f73488abc97cb62861dd2fb137e08ab1f994c1 [^]
2017-12-13 21:54 mtaal Review Assigned To => mtaal
2017-12-13 22:18 mtaal Note Added: 0101026
2017-12-13 22:18 mtaal Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker