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

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0036912

Retail Modules

Web POS

public

2017-09-21 12:40

2017-09-22 14:30

Reporter

shuehner

Assigned To

gorka_gil

Priority

urgent

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

RR17Q4

Fixed in Version

RR17Q4

Merge Request Status

Review Assigned To

marvintm

OBNetwork customer

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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

Description

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.

Steps To Reproduce

install.source Q3 without retail sampledata.
Add retail.sample.data module
ant import.sample.data
Try to do webpos login

Proposed Solution

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

Additional Information