Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0037353 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Retail Modules] StoreServer | major | always | 2017-11-22 11:21 | 2017-12-13 22:18 | |||
Reporter | ioritzCia | View Status | public | |||||
Assigned To | AugustoMauch | |||||||
Priority | high | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | 83f73488abc9 | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Linux 64 bit | Database | PostgreSQL | Java version | 8.x | |||
OS Version | CentOS 6 | Database version | 9.5.x | Ant version | 1.9.x | |||
Product Version | SCM revision | |||||||
Review Assigned To | mtaal | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0037353: EM_OBRETCO_RETAILORGTYPE column for orgs not in natural tree dataset should be excluded | |||||||
Description | Dataset 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 Reproduce | In 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 Solution | Dataset for organizations not in natural tree should exclude EM_OBRETCO_RETAILORGTYPE column | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | ||||||||
|
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 |