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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0037059
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Sampledataminoralways2017-10-11 17:452018-06-26 13:51
Reportergorka_gilView Statuspublic 
Assigned Togorka_gil 
PrioritynormalResolutionfixedFixed in VersionRR18Q1
StatusclosedFix in branchFixed in SCM revision2144e8a4701a
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0037059: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on defect 0037167 closeddmiguelez Modules Table OBWPL_PICKINGLIST missing in the dataset 

-  Notes
(0100083)
gorka_gil (administrator)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (administrator)
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 (developer)
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 (administrator)
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 (administrator)
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 (administrator)
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 (developer)
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 (developer)
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 (developer)
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 (administrator)
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 (administrator)
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.

- Issue History
Date Modified Username Field Change
2017-10-11 17:45 gorka_gil New Issue
2017-10-11 17:45 gorka_gil Assigned To => gorka_gil
2017-10-11 17:45 gorka_gil Triggers an Emergency Pack => No
2017-10-11 17:45 gorka_gil Status new => scheduled
2017-10-26 13:07 gorka_gil Relationship added depends on 0037167
2017-10-26 13:11 gorka_gil Note Added: 0100083
2017-10-27 12:13 hgbot Checkin
2017-10-27 12:13 hgbot Note Added: 0100109
2017-10-27 12:13 hgbot Checkin
2017-10-27 12:13 hgbot Note Added: 0100110
2017-10-27 12:17 hgbot Checkin
2017-10-27 12:17 hgbot Note Added: 0100112
2017-10-27 12:17 hgbot Status scheduled => resolved
2017-10-27 12:17 hgbot Resolution open => fixed
2017-10-27 12:17 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.testsampledata/rev/e21573be2891983a0aa8d2825b74fe60e7aa500a [^]
2017-10-27 12:34 hgbot Checkin
2017-10-27 12:34 hgbot Note Added: 0100113
2017-10-27 12:34 hgbot Fixed in SCM revision http://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:38 gorka_gil Note Added: 0100114
2017-10-27 12:39 gorka_gil Note Edited: 0100114 View Revisions
2017-10-27 12:53 gorka_gil Note Edited: 0100083 View Revisions
2017-10-27 12:53 gorka_gil Note Edited: 0100083 View Revisions
2017-10-27 12:54 gorka_gil Note Edited: 0100083 View Revisions
2017-10-27 15:26 hgbot Checkin
2017-10-27 15:26 hgbot Note Added: 0100124
2017-10-27 15:33 gorka_gil Status resolved => new
2017-10-27 15:33 gorka_gil Resolution fixed => open
2017-10-27 15:34 gorka_gil Status new => scheduled
2017-10-27 19:59 gorka_gil Note Added: 0100125
2017-10-27 20:02 gorka_gil Note Added: 0100126
2017-10-27 20:05 gorka_gil Note Added: 0100127
2017-10-30 16:44 hgbot Checkin
2017-10-30 16:44 hgbot Note Added: 0100158
2017-10-30 16:46 hgbot Checkin
2017-10-30 16:46 hgbot Note Added: 0100159
2017-10-31 09:52 hgbot Checkin
2017-10-31 09:52 hgbot Note Added: 0100180
2017-10-31 09:52 hgbot Status scheduled => resolved
2017-10-31 09:52 hgbot Resolution open => fixed
2017-10-31 09:52 hgbot Fixed in SCM revision http://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:10 gorka_gil Note Added: 0100182
2017-10-31 12:57 gorka_gil Note Added: 0100192
2017-11-17 14:00 marvintm Review Assigned To => marvintm
2017-11-17 14:00 marvintm Status resolved => closed
2017-11-17 14:00 marvintm Fixed in Version => RR18Q1
2018-06-26 11:30 hgbot Checkin
2018-06-26 11:30 hgbot Note Added: 0105385
2018-06-26 11:30 hgbot Status closed => resolved
2018-06-26 11:30 hgbot Fixed in SCM revision http://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:30 hgbot Checkin
2018-06-26 11:30 hgbot Note Added: 0105386
2018-06-26 11:30 hgbot Checkin
2018-06-26 11:30 hgbot Note Added: 0105387
2018-06-26 11:30 hgbot Fixed in SCM revision http://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:42 hgbot Checkin
2018-06-26 11:42 hgbot Note Added: 0105425
2018-06-26 11:42 hgbot Checkin
2018-06-26 11:42 hgbot Note Added: 0105426
2018-06-26 11:42 hgbot Fixed in SCM revision http://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:42 hgbot Checkin
2018-06-26 11:42 hgbot Note Added: 0105428
2018-06-26 11:42 hgbot Checkin
2018-06-26 11:42 hgbot Note Added: 0105429
2018-06-26 11:42 hgbot Checkin
2018-06-26 11:42 hgbot Note Added: 0105430
2018-06-26 11:42 hgbot Fixed in SCM revision http://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:51 gorka_gil Status resolved => closed
2018-06-26 13:51 gorka_gil Fixed in SCM revision http://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:52 gorka_gil Note Deleted: 0105385
2018-06-26 13:52 gorka_gil Note Deleted: 0105386
2018-06-26 13:52 gorka_gil Note Deleted: 0105387
2018-06-26 13:53 gorka_gil Note Deleted: 0105425
2018-06-26 13:53 gorka_gil Note Deleted: 0105426
2018-06-26 13:53 gorka_gil Note Deleted: 0105428
2018-06-26 13:54 gorka_gil Note Deleted: 0105429
2018-06-26 13:54 gorka_gil Note Deleted: 0105430


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker