Openbravo Issue Tracking System - Retail Modules
View Issue Details
0036913Retail ModulesWeb POSpublic2017-09-21 12:402017-10-31 09:41
shuehner 
gorka_gil 
urgentmajorhave not tried
closedfixed 
5
 
RR17Q3.1RR17Q3.1 
marvintm
No
0036913: ant import.sample.data of WhiteValley Sampleata leads to non-working client since ERP Q3
In ERP Q3 a new modulescript PopulateADOrgTreeData was added to populate some internal table (AD_ORG_TREE).

However in the flow of
- Having ERP Database of Q3 without retail sampledata
- Then adding retail sampledata module
- Running ant.import.sample.data (to get the data into the database)

This modulescript will not run.

Effect is that all POS Login (+ probably more things in White Valley Group) client are completely broken.

Because of missing data for this ad_org_tree table breaking any use of ad_isorgincluded pl - function.
install.source Q3 without retail sampledata.
Add retail.sample.data module
ant import.sample.data
Try to do webpos login
As quick and safe fix:
- Fix retail-sampledata to directly include the missing data
- In practice:
  - ant export.sample.data -Dclient="The White Valley Group" -Dmodule=org.openbravo.retail.sampledat
  - revert all changes to sampledata except the file AD_ORG_TREE.xml
No tags attached.
blocks defect 0036912RR17Q4 closed gorka_gil ant import.sample.data of WhiteValley Sampleata leads to non-working client since ERP Q3 
Issue History
2017-09-21 12:41shuehnerTypedefect => backport
2017-09-21 12:41shuehnerTarget VersionRR17Q4 => RR17Q3.1
2017-09-22 13:32gorka_gilAssigned ToRetail => gorka_gil
2017-09-22 13:45hgbotCheckin
2017-09-22 13:45hgbotNote Added: 0099490
2017-09-22 13:45hgbotStatusscheduled => resolved
2017-09-22 13:45hgbotResolutionopen => fixed
2017-09-22 13:45hgbotFixed in SCM revision => http://code.openbravo.com/retail/backports/3.0RR17Q3.1/org.openbravo.retail.sampledata/rev/ac9215baadcd4768316e9ba2f3522a64fd8d6990 [^]
2017-10-31 09:41marvintmReview Assigned To => marvintm
2017-10-31 09:41marvintmStatusresolved => closed
2017-10-31 09:41marvintmFixed in Version => RR17Q3.1

Notes
(0099490)
hgbot   
2017-09-22 13:45   
Repository: retail/backports/3.0RR17Q3.1/org.openbravo.retail.sampledata
Changeset: ac9215baadcd4768316e9ba2f3522a64fd8d6990
Author: Gorka Gil <gorka.gil <at> openbravo.com>
Date: Thu Sep 21 19:07:22 2017 +0200
URL: http://code.openbravo.com/retail/backports/3.0RR17Q3.1/org.openbravo.retail.sampledata/rev/ac9215baadcd4768316e9ba2f3522a64fd8d6990 [^]

Fixed issue 36913: ant import.sample.data of WhiteValley Sampleata leads to non-working client since ERP Q3

Added AD_ORG_TREE.xml

---
A referencedata/sampledata/The_White_Valley_Group/AD_ORG_TREE.xml
---