Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037059Retail ModulesSampledatapublic2017-10-11 17:452018-06-26 13:51
Reportergorka_gil 
Assigned Togorka_gil 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR18Q1 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037059: dbconsistency error in retail sampledata and external modules sampledata
DescriptionIf exported the retail sampledata gives plenty of changes not committed.
Also the same problem in external modules sampledata.
Steps To Reproduce- Get retail pack
- ant install.source
- ant export.sample.data -Dclient="The White Valley Group" -Dmodule=org.openbravo.retail.sampledata
- hg st

Shows plenty of uncommitted changes
Proposed Solution- Push one time all the changes.
- Probably needed to fix somethings, that create inconsistencies in process of import/export.
- Add a check of dbconsistency to try-retail and retail integration
Additional Information
TagsNo tags attached.
Relationships
depends on defect 0037167 closed dmiguelez Modules Table OBWPL_PICKINGLIST missing in the dataset 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-10-11 17:45gorka_gilNew Issue
2017-10-11 17:45gorka_gilAssigned To => gorka_gil
2017-10-11 17:45gorka_gilTriggers an Emergency Pack => No
2017-10-11 17:45gorka_gilStatusnew => scheduled
2017-10-26 13:07gorka_gilRelationship addeddepends on 0037167
2017-10-26 13:11gorka_gilNote Added: 0100083
2017-10-27 12:13hgbotCheckin
2017-10-27 12:13hgbotNote Added: 0100109
2017-10-27 12:13hgbotCheckin
2017-10-27 12:13hgbotNote Added: 0100110
2017-10-27 12:17hgbotCheckin
2017-10-27 12:17hgbotNote Added: 0100112
2017-10-27 12:17hgbotStatusscheduled => resolved
2017-10-27 12:17hgbotResolutionopen => fixed
2017-10-27 12:17hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.testsampledata/rev/e21573be2891983a0aa8d2825b74fe60e7aa500a [^]
2017-10-27 12:34hgbotCheckin
2017-10-27 12:34hgbotNote Added: 0100113
2017-10-27 12:34hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.testsampledata/rev/e21573be2891983a0aa8d2825b74fe60e7aa500a [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.sampledata/rev/03cf1e91e7cbfda080d1a894f630131b0d288dc1 [^]
2017-10-27 12:38gorka_gilNote Added: 0100114
2017-10-27 12:39gorka_gilNote Edited: 0100114bug_revision_view_page.php?bugnote_id=0100114#r16192
2017-10-27 12:53gorka_gilNote Edited: 0100083bug_revision_view_page.php?bugnote_id=0100083#r16194
2017-10-27 12:53gorka_gilNote Edited: 0100083bug_revision_view_page.php?bugnote_id=0100083#r16195
2017-10-27 12:54gorka_gilNote Edited: 0100083bug_revision_view_page.php?bugnote_id=0100083#r16196
2017-10-27 15:26hgbotCheckin
2017-10-27 15:26hgbotNote Added: 0100124
2017-10-27 15:33gorka_gilStatusresolved => new
2017-10-27 15:33gorka_gilResolutionfixed => open
2017-10-27 15:34gorka_gilStatusnew => scheduled
2017-10-27 19:59gorka_gilNote Added: 0100125
2017-10-27 20:02gorka_gilNote Added: 0100126
2017-10-27 20:05gorka_gilNote Added: 0100127
2017-10-30 16:44hgbotCheckin
2017-10-30 16:44hgbotNote Added: 0100158
2017-10-30 16:46hgbotCheckin
2017-10-30 16:46hgbotNote Added: 0100159
2017-10-31 09:52hgbotCheckin
2017-10-31 09:52hgbotNote Added: 0100180
2017-10-31 09:52hgbotStatusscheduled => resolved
2017-10-31 09:52hgbotResolutionopen => fixed
2017-10-31 09:52hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.sampledata/rev/03cf1e91e7cbfda080d1a894f630131b0d288dc1 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.testsampledata/rev/2144e8a4701a3fd27d9a080a06f3bb5fa4d7a62b [^]
2017-10-31 10:10gorka_gilNote Added: 0100182
2017-10-31 12:57gorka_gilNote Added: 0100192
2017-11-17 14:00marvintmReview Assigned To => marvintm
2017-11-17 14:00marvintmStatusresolved => closed
2017-11-17 14:00marvintmFixed in Version => RR18Q1
2018-06-26 11:30hgbotCheckin
2018-06-26 11:30hgbotNote Added: 0105385
2018-06-26 11:30hgbotStatusclosed => resolved
2018-06-26 11:30hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.testsampledata/rev/2144e8a4701a3fd27d9a080a06f3bb5fa4d7a62b [^] => http://code.openbravo.com/retail/backports/3.0RR18Q2.1/modules/org.openbravo.retail.testsampledata/rev/e21573be2891983a0aa8d2825b74fe60e7aa500a [^]
2018-06-26 11:30hgbotCheckin
2018-06-26 11:30hgbotNote Added: 0105386
2018-06-26 11:30hgbotCheckin
2018-06-26 11:30hgbotNote Added: 0105387
2018-06-26 11:30hgbotFixed in SCM revisionhttp://code.openbravo.com/retail/backports/3.0RR18Q2.1/modules/org.openbravo.retail.testsampledata/rev/e21573be2891983a0aa8d2825b74fe60e7aa500a [^] => http://code.openbravo.com/retail/backports/3.0RR18Q2.1/modules/org.openbravo.retail.testsampledata/rev/2144e8a4701a3fd27d9a080a06f3bb5fa4d7a62b [^]
2018-06-26 11:42hgbotCheckin
2018-06-26 11:42hgbotNote Added: 0105425
2018-06-26 11:42hgbotCheckin
2018-06-26 11:42hgbotNote Added: 0105426
2018-06-26 11:42hgbotFixed in SCM revisionhttp://code.openbravo.com/retail/backports/3.0RR18Q2.1/modules/org.openbravo.retail.testsampledata/rev/2144e8a4701a3fd27d9a080a06f3bb5fa4d7a62b [^] => http://code.openbravo.com/retail/backports/3.0RR18Q2.1/modules/org.openbravo.test.mobile.sampledata/rev/06b53fe158c3544ce59658823ae11ce10a7d971a [^]
2018-06-26 11:42hgbotCheckin
2018-06-26 11:42hgbotNote Added: 0105428
2018-06-26 11:42hgbotCheckin
2018-06-26 11:42hgbotNote Added: 0105429
2018-06-26 11:42hgbotCheckin
2018-06-26 11:42hgbotNote Added: 0105430
2018-06-26 11:42hgbotFixed in SCM revisionhttp://code.openbravo.com/retail/backports/3.0RR18Q2.1/modules/org.openbravo.test.mobile.sampledata/rev/06b53fe158c3544ce59658823ae11ce10a7d971a [^] => http://code.openbravo.com/retail/backports/3.0RR18Q2.1/modules/org.openbravo.test.mobile.sampledata/rev/f95b544aa9ab3c655d3bc260931cb36834932e6f [^]
2018-06-26 13:51gorka_gilStatusresolved => closed
2018-06-26 13:51gorka_gilFixed in SCM revisionhttp://code.openbravo.com/retail/backports/3.0RR18Q2.1/modules/org.openbravo.test.mobile.sampledata/rev/f95b544aa9ab3c655d3bc260931cb36834932e6f [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.testsampledata/rev/2144e8a4701a3fd27d9a080a06f3bb5fa4d7a62b [^]
2018-06-26 13:52gorka_gilNote Deleted: 0105385
2018-06-26 13:52gorka_gilNote Deleted: 0105386
2018-06-26 13:52gorka_gilNote Deleted: 0105387
2018-06-26 13:53gorka_gilNote Deleted: 0105425
2018-06-26 13:53gorka_gilNote Deleted: 0105426
2018-06-26 13:53gorka_gilNote Deleted: 0105428
2018-06-26 13:54gorka_gilNote Deleted: 0105429
2018-06-26 13:54gorka_gilNote Deleted: 0105430

Notes
(0100083)
gorka_gil   
2017-10-26 13:11   
(edited on: 2017-10-27 12:54)
For export the external modules sampledata, previous these commits, needed to do these steps:

- mv org.openbravo.test.mobile.sampledata org.openbravo.retail.sampledata
- ant export.sample.data -Dclient="The White Valley Group" -Dmodule=org.openbravo.retail.sampledata
- ant export.sample.data -Dclient="Retail Test" -Dmodule=org.openbravo.retail.testsampledata

As part of this issue also changed the javapackage of pmods-branches/org.openbravo.test.mobile.sampledata to match the name of the folder so, from this commit these are the steps to export the sampledata:

- ant export.sample.data -Dclient="The White Valley Group" -Dmodule=org.openbravo.test.mobile.sampledata
- ant export.sample.data -Dclient="Retail Test" -Dmodule=org.openbravo.retail.testsampledata
(0100109)
hgbot   
2017-10-27 12:13   
Repository: erp/pmods/org.openbravo.retail.discounts.coupons
Changeset: 28a535545da639b47b803444d5e55aa0202b568f
Author: Gorka Gil <gorka.gil <at> openbravo.com>
Date: Thu Oct 26 16:14:31 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.discounts.coupons/rev/28a535545da639b47b803444d5e55aa0202b568f [^]

Related to issue 37059: dbconsistency error in retail sampledata and external modules sampledata

Remove duplicated entry of table OBDISCP_COUPON in the dataset.
This produces to export twice the table and in the insert of the sampledata to fail with duplicated id.

---
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
---
(0100110)
hgbot   
2017-10-27 12:13   
Repository: erp/pmods/org.openbravo.warehouse.pickinglist
Changeset: 230f853355b35e242501d57a3ef327f766f605f0
Author: Gorka Gil <gorka.gil <at> openbravo.com>
Date: Thu Oct 26 18:00:52 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.pickinglist/rev/230f853355b35e242501d57a3ef327f766f605f0 [^]

Fixes issue 37167: Table OBWPL_PICKINGLIST missing in the dataset
Related to issue 37059: dbconsistency error in retail sampledata and external modules sampledata

Added OBWPL_PICKINGLIST to the dataset

---
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
---
(0100112)
hgbot   
2017-10-27 12:17   
Repository: erp/pmods/org.openbravo.retail.testsampledata
Changeset: e21573be2891983a0aa8d2825b74fe60e7aa500a
Author: Gorka Gil <gorka.gil <at> openbravo.com>
Date: Thu Oct 26 17:56:51 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.testsampledata/rev/e21573be2891983a0aa8d2825b74fe60e7aa500a [^]

Fixes issue 37059: dbconsistency error in retail sampledata and external modules sampledata

Huge update of the sampledata with all pending changes

Added preferences to the sampledata for prevent some modulescripts to run again,
since will create modifications in the sampledata:
- IsCustomerBalanceRestoredV2
- Issue28591updateWrongPSD2
- UpdateVariantImage

---
M referencedata/sampledata/Retail_Test/AD_ALERTRULE.xml
M referencedata/sampledata/Retail_Test/AD_CLIENT.xml
M referencedata/sampledata/Retail_Test/AD_CLIENTINFO.xml
M referencedata/sampledata/Retail_Test/AD_CLIENT_ACCTDIMENSION.xml
M referencedata/sampledata/Retail_Test/AD_FORM_ACCESS.xml
M referencedata/sampledata/Retail_Test/AD_ORG.xml
M referencedata/sampledata/Retail_Test/AD_ORGINFO.xml
M referencedata/sampledata/Retail_Test/AD_PREFERENCE.xml
M referencedata/sampledata/Retail_Test/AD_PROCESS_ACCESS.xml
M referencedata/sampledata/Retail_Test/AD_PROCESS_REQUEST.xml
M referencedata/sampledata/Retail_Test/AD_ROLE.xml
M referencedata/sampledata/Retail_Test/AD_SEQUENCE.xml
M referencedata/sampledata/Retail_Test/AD_TREE.xml
M referencedata/sampledata/Retail_Test/AD_USER.xml
M referencedata/sampledata/Retail_Test/AD_WINDOW_ACCESS.xml
M referencedata/sampledata/Retail_Test/C_ACCTSCHEMA_TABLE.xml
M referencedata/sampledata/Retail_Test/C_BPARTNER.xml
M referencedata/sampledata/Retail_Test/C_DOCTYPE.xml
M referencedata/sampledata/Retail_Test/C_POC_DOCTYPE_TEMPLATE.xml
M referencedata/sampledata/Retail_Test/C_TAX.xml
M referencedata/sampledata/Retail_Test/C_TAXCATEGORY.xml
M referencedata/sampledata/Retail_Test/FIN_FINACC_PAYMENTMETHOD.xml
M referencedata/sampledata/Retail_Test/FIN_FINANCIAL_ACCOUNT.xml
M referencedata/sampledata/Retail_Test/M_INVENTORY.xml
M referencedata/sampledata/Retail_Test/M_INVENTORYLINE.xml
M referencedata/sampledata/Retail_Test/M_LOCATOR.xml
M referencedata/sampledata/Retail_Test/M_OFFER.xml
M referencedata/sampledata/Retail_Test/M_PRODUCT.xml
M referencedata/sampledata/Retail_Test/M_STORAGE_DETAIL.xml
M referencedata/sampledata/Retail_Test/M_TRANSACTION.xml
M referencedata/sampledata/Retail_Test/M_WAREHOUSE.xml
M referencedata/sampledata/Retail_Test/M_WAREHOUSE_RULE.xml
M referencedata/sampledata/Retail_Test/OBKMO_WIDGET_CLASS_ACCESS.xml
M referencedata/sampledata/Retail_Test/OBPOS_APPLICATIONS.xml
M referencedata/sampledata/Retail_Test/OBPOS_APP_PAYMENT.xml
M referencedata/sampledata/Retail_Test/OBPOS_APP_PAYMENT_TYPE.xml
M referencedata/sampledata/Retail_Test/OBPOS_TERMINALTYPE.xml
M referencedata/sampledata/Retail_Test/OBUIAPP_PROCESS_ACCESS.xml
M referencedata/sampledata/Retail_Test/OBUIAPP_VIEW_ROLE_ACCESS.xml
A referencedata/sampledata/Retail_Test/AD_ALERTRECIPIENT.xml
A referencedata/sampledata/Retail_Test/AD_ORG_TREE.xml
---
(0100113)
hgbot   
2017-10-27 12:34   
Repository: erp/pmods/org.openbravo.retail.sampledata
Changeset: 03cf1e91e7cbfda080d1a894f630131b0d288dc1
Author: Gorka Gil <gorka.gil <at> openbravo.com>
Date: Thu Oct 26 18:17:03 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.sampledata/rev/03cf1e91e7cbfda080d1a894f630131b0d288dc1 [^]

Fixes issue 37059: dbconsistency error in retail sampledata and external modules sampledata

Huge update of the sampledata with all pending changes

Added preferences to the sampledata for prevent some modulescripts to run again,
since will create modifications in the sampledata:
- IsCustomerBalanceRestoredV2
- Issue28591updateWrongPSD2
- UpdateVariantImage

---
M referencedata/sampledata/The_White_Valley_Group/AD_CLIENT.xml
M referencedata/sampledata/The_White_Valley_Group/AD_IMAGE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_ORG.xml
M referencedata/sampledata/The_White_Valley_Group/AD_PREFERENCE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_PROCESS_ACCESS.xml
M referencedata/sampledata/The_White_Valley_Group/AD_ROLE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_SEQUENCE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_WINDOW_ACCESS.xml
M referencedata/sampledata/The_White_Valley_Group/C_BPARTNER.xml
M referencedata/sampledata/The_White_Valley_Group/C_DOCTYPE_TRL.xml
M referencedata/sampledata/The_White_Valley_Group/C_ORDER.xml
M referencedata/sampledata/The_White_Valley_Group/C_POC_DOCTYPE_TEMPLATE.xml
M referencedata/sampledata/The_White_Valley_Group/C_POC_EMAILDEFINITION.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_FINACC_PAYMENTMETHOD.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_PAYMENT_SCHEDULEDETAIL.xml
M referencedata/sampledata/The_White_Valley_Group/M_COSTING.xml
M referencedata/sampledata/The_White_Valley_Group/M_INOUT.xml
M referencedata/sampledata/The_White_Valley_Group/M_INVENTORYLINE.xml
M referencedata/sampledata/The_White_Valley_Group/M_LOCATOR.xml
M referencedata/sampledata/The_White_Valley_Group/M_PRODUCT.xml
M referencedata/sampledata/The_White_Valley_Group/M_PRODUCT_ACCT.xml
M referencedata/sampledata/The_White_Valley_Group/OBKMO_WIDGET_CLASS_ACCESS.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_APP_CASHUP.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_APP_PAYMENT_TYPE.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_TERMINALTYPE.xml
M referencedata/sampledata/The_White_Valley_Group/OBUIAPP_NOTE.xml
M referencedata/sampledata/The_White_Valley_Group/OBUIAPP_PROCESS_ACCESS.xml
---
(0100114)
gorka_gil   
2017-10-27 12:38   
(edited on: 2017-10-27 12:39)
Repository: pmods-branches/org.openbravo.test.mobile.sampledata
Changeset: 30bf4239a40c
Author: Gorka Gil <gorka.gil <at> openbravo.com>
Date: Thu Oct 26 16:47:06 2017 +0200
URL: https://code.openbravo.com/erp/pmods-branches/org.openbravo.test.mobile.sampledata/rev/30bf4239a40c [^] [^]

Related to issue 37059: dbconsistency error in retail sampledata and external modules sampledata

Change sampledata javapackage so it matchs with the folder name,
so the export sampledata is done in the folder of the module

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0100124)
hgbot   
2017-10-27 15:26   
Repository: erp/pmods/org.openbravo.retail.testsampledata
Changeset: ab19e27f60448e9c7c490b330eb7dd712687e9cf
Author: Gorka Gil <gorka.gil <at> openbravo.com>
Date: Fri Oct 27 15:26:02 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.testsampledata/rev/ab19e27f60448e9c7c490b330eb7dd712687e9cf [^]

Related to issue 37059: dbconsistency error in retail sampledata and external modules sampledata

Backed out changeset e21573be2891, since breaks some tests in try-retail

---
M referencedata/sampledata/Retail_Test/AD_ALERTRULE.xml
M referencedata/sampledata/Retail_Test/AD_CLIENT.xml
M referencedata/sampledata/Retail_Test/AD_CLIENTINFO.xml
M referencedata/sampledata/Retail_Test/AD_CLIENT_ACCTDIMENSION.xml
M referencedata/sampledata/Retail_Test/AD_FORM_ACCESS.xml
M referencedata/sampledata/Retail_Test/AD_ORG.xml
M referencedata/sampledata/Retail_Test/AD_ORGINFO.xml
M referencedata/sampledata/Retail_Test/AD_PREFERENCE.xml
M referencedata/sampledata/Retail_Test/AD_PROCESS_ACCESS.xml
M referencedata/sampledata/Retail_Test/AD_PROCESS_REQUEST.xml
M referencedata/sampledata/Retail_Test/AD_ROLE.xml
M referencedata/sampledata/Retail_Test/AD_SEQUENCE.xml
M referencedata/sampledata/Retail_Test/AD_TREE.xml
M referencedata/sampledata/Retail_Test/AD_USER.xml
M referencedata/sampledata/Retail_Test/AD_WINDOW_ACCESS.xml
M referencedata/sampledata/Retail_Test/C_ACCTSCHEMA_TABLE.xml
M referencedata/sampledata/Retail_Test/C_BPARTNER.xml
M referencedata/sampledata/Retail_Test/C_DOCTYPE.xml
M referencedata/sampledata/Retail_Test/C_POC_DOCTYPE_TEMPLATE.xml
M referencedata/sampledata/Retail_Test/C_TAX.xml
M referencedata/sampledata/Retail_Test/C_TAXCATEGORY.xml
M referencedata/sampledata/Retail_Test/FIN_FINACC_PAYMENTMETHOD.xml
M referencedata/sampledata/Retail_Test/FIN_FINANCIAL_ACCOUNT.xml
M referencedata/sampledata/Retail_Test/M_INVENTORY.xml
M referencedata/sampledata/Retail_Test/M_INVENTORYLINE.xml
M referencedata/sampledata/Retail_Test/M_LOCATOR.xml
M referencedata/sampledata/Retail_Test/M_OFFER.xml
M referencedata/sampledata/Retail_Test/M_PRODUCT.xml
M referencedata/sampledata/Retail_Test/M_STORAGE_DETAIL.xml
M referencedata/sampledata/Retail_Test/M_TRANSACTION.xml
M referencedata/sampledata/Retail_Test/M_WAREHOUSE.xml
M referencedata/sampledata/Retail_Test/M_WAREHOUSE_RULE.xml
M referencedata/sampledata/Retail_Test/OBKMO_WIDGET_CLASS_ACCESS.xml
M referencedata/sampledata/Retail_Test/OBPOS_APPLICATIONS.xml
M referencedata/sampledata/Retail_Test/OBPOS_APP_PAYMENT.xml
M referencedata/sampledata/Retail_Test/OBPOS_APP_PAYMENT_TYPE.xml
M referencedata/sampledata/Retail_Test/OBPOS_TERMINALTYPE.xml
M referencedata/sampledata/Retail_Test/OBUIAPP_PROCESS_ACCESS.xml
M referencedata/sampledata/Retail_Test/OBUIAPP_VIEW_ROLE_ACCESS.xml
R referencedata/sampledata/Retail_Test/AD_ALERTRECIPIENT.xml
R referencedata/sampledata/Retail_Test/AD_ORG_TREE.xml
---
(0100125)
gorka_gil   
2017-10-27 19:59   
Repository: erp/pmods-branches/org.openbravo.test.mobile.sampledata
Changeset: 06b53fe158c3
Author: Gorka Gil <gorka.gil <at> openbravo.com>
Date: Thu Oct 26 17:54:20 2017 +0200
URL: http://code.openbravo.com/erp/pmods-branches/org.openbravo.test.mobile.sampledata/rev/06b53fe158c3 [^]

Fixes issue 37059: dbconsistency error in retail sampledata and external modules sampledata

Huge update of the sampledata with all pending changes

Added preferences to the sampledata for prevent some modulescripts to run again,
since will create modifications in the sampledata:
- IsCustomerBalanceRestoredV2
- Issue28591updateWrongPSD2
- UpdateVariantImage

---
M referencedata/sampledata/The_White_Valley_Group/AD_CLIENT.xml
M referencedata/sampledata/The_White_Valley_Group/AD_IMAGE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_ORG.xml
M referencedata/sampledata/The_White_Valley_Group/AD_ORG_TREE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_PREFERENCE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_PROCESS_ACCESS.xml
M referencedata/sampledata/The_White_Valley_Group/AD_PROCESS_REQUEST.xml
M referencedata/sampledata/The_White_Valley_Group/AD_ROLE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_SEQUENCE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_TREENODE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_USER.xml
M referencedata/sampledata/The_White_Valley_Group/AD_WINDOW_ACCESS.xml
M referencedata/sampledata/The_White_Valley_Group/C_BPARTNER.xml
M referencedata/sampledata/The_White_Valley_Group/C_BP_VENDOR_ACCT.xml
M referencedata/sampledata/The_White_Valley_Group/C_DOCTYPE.xml
M referencedata/sampledata/The_White_Valley_Group/C_GLITEM.xml
M referencedata/sampledata/The_White_Valley_Group/C_ORDER.xml
M referencedata/sampledata/The_White_Valley_Group/C_ORDERLINE.xml
M referencedata/sampledata/The_White_Valley_Group/C_PERIODCONTROL.xml
M referencedata/sampledata/The_White_Valley_Group/C_POC_DOCTYPE_TEMPLATE.xml
M referencedata/sampledata/The_White_Valley_Group/C_POC_EMAILDEFINITION.xml
M referencedata/sampledata/The_White_Valley_Group/FACT_ACCT.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_FINACC_PAYMENTMETHOD.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_FINANCIAL_ACCOUNT.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_FINANCIAL_ACCOUNT_ACCT.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_PAYMENT.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_PAYMENT_SCHEDULEDETAIL.xml
R referencedata/sampledata/The_White_Valley_Group/GCNV_GIFTCARD_INST.xml
R referencedata/sampledata/The_White_Valley_Group/GCNV_GIFTCARD_REASON.xml
R referencedata/sampledata/The_White_Valley_Group/LVLPR_LEVELPRODUCTPRICE.xml
R referencedata/sampledata/The_White_Valley_Group/LVLPR_RANGE.xml
M referencedata/sampledata/The_White_Valley_Group/M_CHARACTERISTIC.xml
M referencedata/sampledata/The_White_Valley_Group/M_COSTING.xml
M referencedata/sampledata/The_White_Valley_Group/M_INOUT.xml
M referencedata/sampledata/The_White_Valley_Group/M_INVENTORY.xml
M referencedata/sampledata/The_White_Valley_Group/M_INVENTORYLINE.xml
M referencedata/sampledata/The_White_Valley_Group/M_LOCATOR.xml
M referencedata/sampledata/The_White_Valley_Group/M_OFFER.xml
M referencedata/sampledata/The_White_Valley_Group/M_PRODUCT.xml
M referencedata/sampledata/The_White_Valley_Group/M_PRODUCTPRICE.xml
M referencedata/sampledata/The_White_Valley_Group/M_PRODUCT_CATEGORY_ACCT.xml
M referencedata/sampledata/The_White_Valley_Group/M_PRODUCT_CH.xml
M referencedata/sampledata/The_White_Valley_Group/M_STORAGE_DETAIL.xml
M referencedata/sampledata/The_White_Valley_Group/M_TRANSACTION.xml
M referencedata/sampledata/The_White_Valley_Group/M_TRANSACTION_COST.xml
M referencedata/sampledata/The_White_Valley_Group/OBKMO_WIDGET_CLASS_ACCESS.xml
M referencedata/sampledata/The_White_Valley_Group/OBMPR_CONFIGURATION.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_APPLICATIONS.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_APP_PAYMENT_TYPE.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_TERMINALTYPE.xml
M referencedata/sampledata/The_White_Valley_Group/OBRETCO_CMEVENTS.xml
M referencedata/sampledata/The_White_Valley_Group/OBRETCO_PROL_PRODUCT.xml
M referencedata/sampledata/The_White_Valley_Group/OBUIAPP_PROCESS_ACCESS.xml
---
(0100126)
gorka_gil   
2017-10-27 20:02   
Repository: erp/pmods-branches/org.openbravo.test.mobile.sampledata
Changeset: ea0b073b7be1
Author: Gorka Gil <gorka.gil <at> openbravo.com>
Date: Fri Oct 27 15:24:38 2017 +0200
URL: http://code.openbravo.com/erp/pmods-branches/org.openbravo.test.mobile.sampledata/rev/ea0b073b7be1 [^]

Related to issue 37059: dbconsistency error in retail sampledata and external modules sampledata


Backed out changeset 06b53fe158c3, since it breaks some tests in try-retail

---
M referencedata/sampledata/The_White_Valley_Group/AD_CLIENT.xml
M referencedata/sampledata/The_White_Valley_Group/AD_IMAGE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_ORG.xml
M referencedata/sampledata/The_White_Valley_Group/AD_ORG_TREE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_PREFERENCE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_PROCESS_ACCESS.xml
M referencedata/sampledata/The_White_Valley_Group/AD_PROCESS_REQUEST.xml
M referencedata/sampledata/The_White_Valley_Group/AD_ROLE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_SEQUENCE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_TREENODE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_USER.xml
M referencedata/sampledata/The_White_Valley_Group/AD_WINDOW_ACCESS.xml
M referencedata/sampledata/The_White_Valley_Group/C_BPARTNER.xml
M referencedata/sampledata/The_White_Valley_Group/C_BP_VENDOR_ACCT.xml
M referencedata/sampledata/The_White_Valley_Group/C_DOCTYPE.xml
M referencedata/sampledata/The_White_Valley_Group/C_GLITEM.xml
M referencedata/sampledata/The_White_Valley_Group/C_ORDER.xml
M referencedata/sampledata/The_White_Valley_Group/C_ORDERLINE.xml
M referencedata/sampledata/The_White_Valley_Group/C_PERIODCONTROL.xml
M referencedata/sampledata/The_White_Valley_Group/C_POC_DOCTYPE_TEMPLATE.xml
M referencedata/sampledata/The_White_Valley_Group/C_POC_EMAILDEFINITION.xml
M referencedata/sampledata/The_White_Valley_Group/FACT_ACCT.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_FINACC_PAYMENTMETHOD.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_FINANCIAL_ACCOUNT.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_FINANCIAL_ACCOUNT_ACCT.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_PAYMENT.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_PAYMENT_SCHEDULEDETAIL.xml
A referencedata/sampledata/The_White_Valley_Group/GCNV_GIFTCARD_INST.xml
A referencedata/sampledata/The_White_Valley_Group/GCNV_GIFTCARD_REASON.xml
A referencedata/sampledata/The_White_Valley_Group/LVLPR_LEVELPRODUCTPRICE.xml
A referencedata/sampledata/The_White_Valley_Group/LVLPR_RANGE.xml
M referencedata/sampledata/The_White_Valley_Group/M_CHARACTERISTIC.xml
M referencedata/sampledata/The_White_Valley_Group/M_COSTING.xml
M referencedata/sampledata/The_White_Valley_Group/M_INOUT.xml
M referencedata/sampledata/The_White_Valley_Group/M_INVENTORY.xml
M referencedata/sampledata/The_White_Valley_Group/M_INVENTORYLINE.xml
M referencedata/sampledata/The_White_Valley_Group/M_LOCATOR.xml
M referencedata/sampledata/The_White_Valley_Group/M_OFFER.xml
M referencedata/sampledata/The_White_Valley_Group/M_PRODUCT.xml
M referencedata/sampledata/The_White_Valley_Group/M_PRODUCTPRICE.xml
M referencedata/sampledata/The_White_Valley_Group/M_PRODUCT_CATEGORY_ACCT.xml
M referencedata/sampledata/The_White_Valley_Group/M_PRODUCT_CH.xml
M referencedata/sampledata/The_White_Valley_Group/M_STORAGE_DETAIL.xml
M referencedata/sampledata/The_White_Valley_Group/M_TRANSACTION.xml
M referencedata/sampledata/The_White_Valley_Group/M_TRANSACTION_COST.xml
M referencedata/sampledata/The_White_Valley_Group/OBKMO_WIDGET_CLASS_ACCESS.xml
M referencedata/sampledata/The_White_Valley_Group/OBMPR_CONFIGURATION.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_APPLICATIONS.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_APP_PAYMENT_TYPE.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_TERMINALTYPE.xml
A referencedata/sampledata/The_White_Valley_Group/OBPOS_TERMINALTYPE.xml.orig
M referencedata/sampledata/The_White_Valley_Group/OBRETCO_CMEVENTS.xml
M referencedata/sampledata/The_White_Valley_Group/OBRETCO_PROL_PRODUCT.xml
M referencedata/sampledata/The_White_Valley_Group/OBUIAPP_PROCESS_ACCESS.xml
---
(0100127)
gorka_gil   
2017-10-27 20:05   
Repository: erp/pmods-branches/org.openbravo.test.mobile.sampledata
Changeset: d9f14a1c94cf
Author: Gorka Gil <gorka.gil <at> openbravo.com>
Date: Fri Oct 27 19:20:45 2017 +0200
URL: http://code.openbravo.com/erp/pmods-branches/org.openbravo.test.mobile.sampledata/rev/d9f14a1c94cf [^]

Related to issue 37059: dbconsistency error in retail sampledata and external modules sampledata


Fix the rebase done for the backed out

---
M referencedata/sampledata/The_White_Valley_Group/OBPOS_TERMINALTYPE.xml
R referencedata/sampledata/The_White_Valley_Group/OBPOS_TERMINALTYPE.xml.orig
---
(0100158)
hgbot   
2017-10-30 16:44   
Repository: erp/pmods/org.openbravo.pricing.levelpricing
Changeset: 99e7e708f5970b5d2a9c7742271b505be265a430
Author: Gorka Gil <gorka.gil <at> openbravo.com>
Date: Mon Oct 30 16:44:05 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.pricing.levelpricing/rev/99e7e708f5970b5d2a9c7742271b505be265a430 [^]

Related to issue 37059: dbconsistency error in retail sampledata and external modules sampledata

Added missing tables to the dataset, so the sampledata is exported correctly:
- LVLPR_LEVELPRODUCTPRICE
- LVLPR_RANGE

---
A src-db/database/sourcedata/AD_DATASET_TABLE.xml
---
(0100159)
hgbot   
2017-10-30 16:46   
Repository: erp/pmods/org.openbravo.retail.giftcards
Changeset: 660d4879f2ac85e19f9d3c39708c927514db8fb9
Author: Gorka Gil <gorka.gil <at> openbravo.com>
Date: Mon Oct 30 16:45:40 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.giftcards/rev/660d4879f2ac85e19f9d3c39708c927514db8fb9 [^]

Related to issue 37059: dbconsistency error in retail sampledata and external modules sampledata

Added missing tables to the dataset, so the sampledata is exported correctly:
- GCNV_GIFTCARD_INST
- GCNV_GIFTCARD_REASON

---
A src-db/database/sourcedata/AD_DATASET_TABLE.xml
---
(0100180)
hgbot   
2017-10-31 09:52   
Repository: erp/pmods/org.openbravo.retail.testsampledata
Changeset: 2144e8a4701a3fd27d9a080a06f3bb5fa4d7a62b
Author: Gorka Gil <gorka.gil <at> openbravo.com>
Date: Mon Oct 30 18:12:15 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.testsampledata/rev/2144e8a4701a3fd27d9a080a06f3bb5fa4d7a62b [^]

Fixes issue 37059: dbconsistency error in retail sampledata and external modules sampledata

Huge update of the sampledata with all pending changes, second try

Added preferences to the sampledata for prevent some modulescripts to run again,
since will create modifications in the sampledata:
- IsCustomerBalanceRestoredV2
- Issue28591updateWrongPSD2
- UpdateVariantImage

---
M referencedata/sampledata/Retail_Test/AD_ALERTRULE.xml
M referencedata/sampledata/Retail_Test/AD_CLIENT.xml
M referencedata/sampledata/Retail_Test/AD_CLIENTINFO.xml
M referencedata/sampledata/Retail_Test/AD_CLIENT_ACCTDIMENSION.xml
M referencedata/sampledata/Retail_Test/AD_FORM_ACCESS.xml
M referencedata/sampledata/Retail_Test/AD_ORG.xml
M referencedata/sampledata/Retail_Test/AD_ORGINFO.xml
M referencedata/sampledata/Retail_Test/AD_PROCESS_ACCESS.xml
M referencedata/sampledata/Retail_Test/AD_PROCESS_REQUEST.xml
M referencedata/sampledata/Retail_Test/AD_ROLE.xml
M referencedata/sampledata/Retail_Test/AD_SEQUENCE.xml
M referencedata/sampledata/Retail_Test/AD_TREE.xml
M referencedata/sampledata/Retail_Test/AD_USER.xml
M referencedata/sampledata/Retail_Test/AD_WINDOW_ACCESS.xml
M referencedata/sampledata/Retail_Test/C_ACCTSCHEMA_TABLE.xml
M referencedata/sampledata/Retail_Test/C_BPARTNER.xml
M referencedata/sampledata/Retail_Test/C_DOCTYPE.xml
M referencedata/sampledata/Retail_Test/C_POC_DOCTYPE_TEMPLATE.xml
M referencedata/sampledata/Retail_Test/C_TAX.xml
M referencedata/sampledata/Retail_Test/C_TAXCATEGORY.xml
M referencedata/sampledata/Retail_Test/FIN_FINACC_PAYMENTMETHOD.xml
M referencedata/sampledata/Retail_Test/FIN_FINANCIAL_ACCOUNT.xml
M referencedata/sampledata/Retail_Test/M_INVENTORY.xml
M referencedata/sampledata/Retail_Test/M_INVENTORYLINE.xml
M referencedata/sampledata/Retail_Test/M_LOCATOR.xml
M referencedata/sampledata/Retail_Test/M_OFFER.xml
M referencedata/sampledata/Retail_Test/M_PRODUCT.xml
M referencedata/sampledata/Retail_Test/M_STORAGE_DETAIL.xml
M referencedata/sampledata/Retail_Test/M_TRANSACTION.xml
M referencedata/sampledata/Retail_Test/M_WAREHOUSE.xml
M referencedata/sampledata/Retail_Test/M_WAREHOUSE_RULE.xml
M referencedata/sampledata/Retail_Test/OBKMO_WIDGET_CLASS_ACCESS.xml
M referencedata/sampledata/Retail_Test/OBPOS_APPLICATIONS.xml
M referencedata/sampledata/Retail_Test/OBPOS_APP_PAYMENT.xml
M referencedata/sampledata/Retail_Test/OBPOS_APP_PAYMENT_TYPE.xml
M referencedata/sampledata/Retail_Test/OBPOS_TERMINALTYPE.xml
M referencedata/sampledata/Retail_Test/OBUIAPP_PROCESS_ACCESS.xml
M referencedata/sampledata/Retail_Test/OBUIAPP_VIEW_ROLE_ACCESS.xml
A referencedata/sampledata/Retail_Test/AD_ALERTRECIPIENT.xml
A referencedata/sampledata/Retail_Test/AD_ORG_TREE.xml
---
(0100182)
gorka_gil   
2017-10-31 10:10   
Repository: erp/pmods-branches/org.openbravo.test.mobile.sampledata
Changeset: f95b544aa9ab
Author: Gorka Gil <gorka.gil <at> openbravo.com>
Date: Mon Oct 30 18:11:33 2017 +0100
URL: http://code.openbravo.com/erp/pmods-branches/org.openbravo.test.mobile.sampledata/rev/f95b544aa9ab [^]

Fixes issue 37059: dbconsistency error in retail sampledata and external modules sampledata

Huge update of the sampledata with all pending changes, second try

Added preferences to the sampledata for prevent some modulescripts to run again,
since will create modifications in the sampledata:
- IsCustomerBalanceRestoredV2
- Issue28591updateWrongPSD2
- UpdateVariantImage

---
M referencedata/sampledata/The_White_Valley_Group/AD_CLIENT.xml
M referencedata/sampledata/The_White_Valley_Group/AD_IMAGE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_ORG.xml
M referencedata/sampledata/The_White_Valley_Group/AD_ORG_TREE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_PREFERENCE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_PROCESS_ACCESS.xml
M referencedata/sampledata/The_White_Valley_Group/AD_PROCESS_REQUEST.xml
M referencedata/sampledata/The_White_Valley_Group/AD_ROLE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_SEQUENCE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_TREENODE.xml
M referencedata/sampledata/The_White_Valley_Group/AD_USER.xml
M referencedata/sampledata/The_White_Valley_Group/AD_WINDOW_ACCESS.xml
M referencedata/sampledata/The_White_Valley_Group/C_BPARTNER.xml
M referencedata/sampledata/The_White_Valley_Group/C_BP_VENDOR_ACCT.xml
M referencedata/sampledata/The_White_Valley_Group/C_DOCTYPE.xml
M referencedata/sampledata/The_White_Valley_Group/C_GLITEM.xml
M referencedata/sampledata/The_White_Valley_Group/C_ORDER.xml
M referencedata/sampledata/The_White_Valley_Group/C_ORDERLINE.xml
M referencedata/sampledata/The_White_Valley_Group/C_PERIODCONTROL.xml
M referencedata/sampledata/The_White_Valley_Group/C_POC_DOCTYPE_TEMPLATE.xml
M referencedata/sampledata/The_White_Valley_Group/C_POC_EMAILDEFINITION.xml
M referencedata/sampledata/The_White_Valley_Group/FACT_ACCT.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_FINACC_PAYMENTMETHOD.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_FINANCIAL_ACCOUNT.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_FINANCIAL_ACCOUNT_ACCT.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_PAYMENT.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_PAYMENT_SCHEDULEDETAIL.xml
M referencedata/sampledata/The_White_Valley_Group/GCNV_GIFTCARD_INST.xml
M referencedata/sampledata/The_White_Valley_Group/GCNV_GIFTCARD_REASON.xml
M referencedata/sampledata/The_White_Valley_Group/M_CHARACTERISTIC.xml
M referencedata/sampledata/The_White_Valley_Group/M_COSTING.xml
M referencedata/sampledata/The_White_Valley_Group/M_INOUT.xml
M referencedata/sampledata/The_White_Valley_Group/M_INVENTORY.xml
M referencedata/sampledata/The_White_Valley_Group/M_INVENTORYLINE.xml
M referencedata/sampledata/The_White_Valley_Group/M_LOCATOR.xml
M referencedata/sampledata/The_White_Valley_Group/M_OFFER.xml
M referencedata/sampledata/The_White_Valley_Group/M_PRODUCT.xml
M referencedata/sampledata/The_White_Valley_Group/M_PRODUCTPRICE.xml
M referencedata/sampledata/The_White_Valley_Group/M_PRODUCT_CATEGORY_ACCT.xml
M referencedata/sampledata/The_White_Valley_Group/M_PRODUCT_CH.xml
M referencedata/sampledata/The_White_Valley_Group/M_STORAGE_DETAIL.xml
M referencedata/sampledata/The_White_Valley_Group/M_TRANSACTION.xml
M referencedata/sampledata/The_White_Valley_Group/M_TRANSACTION_COST.xml
M referencedata/sampledata/The_White_Valley_Group/OBKMO_WIDGET_CLASS_ACCESS.xml
M referencedata/sampledata/The_White_Valley_Group/OBMPR_CONFIGURATION.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_APPLICATIONS.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_APP_PAYMENT_TYPE.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_TERMINALTYPE.xml
M referencedata/sampledata/The_White_Valley_Group/OBRETCO_CMEVENTS.xml
M referencedata/sampledata/The_White_Valley_Group/OBRETCO_PROL_PRODUCT.xml
M referencedata/sampledata/The_White_Valley_Group/OBUIAPP_PROCESS_ACCESS.xml
---
(0100192)
gorka_gil   
2017-10-31 12:57   
The process to update the sampledata followed was:
- Install.source and export
- Temp commit to check diferences
- Install.source & export again
- Identify missing preferences and tables in the datasets
- Fix the datasets
- Revert sampledata to original version, delete temp commit
- Install.source and export
- Place the preferences manually, since they are created in client 0 and so are not exported.

This process is done with the idea of run once all the modulescripts before create the preference, to ensure at least once are executed.