0037167: Table OBWPL_PICKINGLIST missing in the dataset

Description

Table OBWPL_PICKINGLIST missing in the dataset so is not exported in the sampledata.

Steps To Reproduce

- Having a retail instance with all the external modules
- install.source
- ant export.sample.data -Dclient="The White Valley Group" -Dmodule=org.openbravo.retail.sampledata
- install.source again

Note that install source fails because a reference of EM_OBWPL_PICKINGLIST_ID doesn't exists.

Proposed Solution

Add OBWPL_PICKINGLIST to the dataset of the module

Tags

No tags attached.

Attached Files

add_table_OBWPL_PICKINGLIST_to_dataset.diff [^] (1,801 bytes) 2017-10-26 13:06 [Show Content] [Hide Content]

diff -r cb3a7b7cc689 src-db/database/sourcedata/AD_DATASET_TABLE.xml
--- a/src-db/database/sourcedata/AD_DATASET_TABLE.xml	Thu Sep 28 13:37:37 2017 +0200
+++ b/src-db/database/sourcedata/AD_DATASET_TABLE.xml	Thu Oct 26 12:01:34 2017 +0200
@@ -1,5 +1,19 @@
 <?xml version='1.0' encoding='UTF-8'?>
 <data>
+<!--1DA8993AC6E94A47816F8B5A1617ABAE--><AD_DATASET_TABLE>
+<!--1DA8993AC6E94A47816F8B5A1617ABAE-->  <AD_DATASET_TABLE_ID><![CDATA[1DA8993AC6E94A47816F8B5A1617ABAE]]></AD_DATASET_TABLE_ID>
+<!--1DA8993AC6E94A47816F8B5A1617ABAE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--1DA8993AC6E94A47816F8B5A1617ABAE-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--1DA8993AC6E94A47816F8B5A1617ABAE-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--1DA8993AC6E94A47816F8B5A1617ABAE-->  <AD_DATASET_ID><![CDATA[D81C5C810AEF47C690E4F688ABC8AAC8]]></AD_DATASET_ID>
+<!--1DA8993AC6E94A47816F8B5A1617ABAE-->  <AD_TABLE_ID><![CDATA[54EE30513CF04C31A4DF4B876CC7BDA4]]></AD_TABLE_ID>
+<!--1DA8993AC6E94A47816F8B5A1617ABAE-->  <INCLUDEALLCOLUMNS><![CDATA[Y]]></INCLUDEALLCOLUMNS>
+<!--1DA8993AC6E94A47816F8B5A1617ABAE-->  <WHERECLAUSE><![CDATA[client.id=:ClientID]]></WHERECLAUSE>
+<!--1DA8993AC6E94A47816F8B5A1617ABAE-->  <EXCLUDEAUDITINFO><![CDATA[N]]></EXCLUDEAUDITINFO>
+<!--1DA8993AC6E94A47816F8B5A1617ABAE-->  <ISBUSINESSOBJECT><![CDATA[N]]></ISBUSINESSOBJECT>
+<!--1DA8993AC6E94A47816F8B5A1617ABAE-->  <AD_MODULE_ID><![CDATA[E3691C8A5B114769BB2C5254AFFF3E26]]></AD_MODULE_ID>
+<!--1DA8993AC6E94A47816F8B5A1617ABAE--></AD_DATASET_TABLE>
+
 <!--59BF6F08E8F245FBB5942C896B7B5657--><AD_DATASET_TABLE>
 <!--59BF6F08E8F245FBB5942C896B7B5657-->  <AD_DATASET_TABLE_ID><![CDATA[59BF6F08E8F245FBB5942C896B7B5657]]></AD_DATASET_TABLE_ID>
 <!--59BF6F08E8F245FBB5942C896B7B5657-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0037059

closed

gorka_gil

Retail Modules

dbconsistency error in retail sampledata and external modules sampledata

Notes
(0100111) 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 ---

(0100157) dmiguelez (developer) 2017-10-30 16:38	Code Review + Testing Ok

Issue History
Date Modified	Username	Field	Change
2017-10-26 13:05	gorka_gil	New Issue
2017-10-26 13:05	gorka_gil	Assigned To	=> dmiguelez
2017-10-26 13:06	gorka_gil	File Added: add_table_OBWPL_PICKINGLIST_to_dataset.diff
2017-10-26 13:07	gorka_gil	Relationship added	blocks 0037059
2017-10-27 12:13	hgbot	Checkin
2017-10-27 12:13	hgbot	Note Added: 0100111
2017-10-27 12:13	hgbot	Status	new => resolved
2017-10-27 12:13	hgbot	Resolution	open => fixed
2017-10-27 12:13	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.pickinglist/rev/230f853355b35e242501d57a3ef327f766f605f0 [^]
2017-10-30 16:38	dmiguelez	Review Assigned To	=> dmiguelez
2017-10-30 16:38	dmiguelez	Note Added: 0100157
2017-10-30 16:38	dmiguelez	Status	resolved => closed