Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0037059 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Sampledata | minor | always | 2017-10-11 17:45 | 2018-06-26 13:51 | |||
| Reporter | gorka_gil | View Status | public | |||||
| Assigned To | gorka_gil | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | RR18Q1 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 2144e8a4701a | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | marvintm | |||||||
| OBNetwork customer | No | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0037059: dbconsistency error in retail sampledata and external modules sampledata | |||||||
| Description | If 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||
|
|||||||||
 Relationships |
|
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. |
|
Notes |
|
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 | OBNetwork customer | => No |
| 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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |