0047489: Uncheck the Shipping Address in the customer generates EWI when a purchase is done

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0047489

Retail Modules

Web POS

public

2021-08-03 11:20

2021-08-24 07:35

Reporter

hector_hernaez

Assigned To

rqueralta

Priority

high

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

RR21Q4

Merge Request Status

approved

Review Assigned To

OBNetwork customer

Gold

Support ticket

26838

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0047489: Uncheck the Shipping Address in the customer generates EWI when a purchase is done

Description

An EWI arises in the Backoffice when the purchase is done by a customer that has the 'Shipment address' unchecked in the 'Edit Customer Address' window.

Error:
org.postgresql.util.PSQLException: ERROR: insert or update on table "c_order" violates foreign key constraint "c_order_c_bpartner_location1"
  Detail: Key (c_bpartner_location_id)=(null) is not present in table "c_bpartner_location".
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285)

Steps To Reproduce

These steps were reproduced in 'Livebuilds - Retail with modules'

- Create a new customer.
- Create a new ticket.
- In the select customer window, go manage address option in the costumer and
after, to edit in the address.
- Uncheck 'Shipping Address'.
- Complete a purchase with that customer.
- Go to 'Error while importing POS data' window in backoffice.
- You will see an error related to that order.

Proposed Solution

Additional Information