Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0054790
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[POS2] POSmajoralways2024-02-28 15:022024-03-21 11:41
ReporterngarciaView Statuspublic 
Assigned ToSABARINATH P 
PriorityurgentResolutionfixedFixed in Version24Q2
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0054790: Errors While Importing POS Data due to the address length higher than 60

DescriptionErrors While Importing POS Data due to the address length higher than 60.

In the customer instance (24Q1) the Order is the one that gets stuck in EWI:

Error in OrderLoader: Location.addressLine1: Value too long. Length ..., maximum allowed 60

In https://livebuilds.openbravo.com/context/retail_pos2_pgsql/security/Login [^] the Business Partner Location is not stuck in Errors While Importing POS Data but the business partner is created without location
Steps To ReproduceIn https://livebuilds.openbravo.com/context/retail_pos2_pgsql/security/Login [^]

Create a New Customer
Assign an address with more than 60 characters. Set it as Shipping and Invoicing Address
Add a product, pay it and done

In the backoffice:
The Order gets stuck in Errors While Importing POS Data with the following error:

org.postgresql.util.PSQLException: ERROR: insert or update on table "c_order" violates foreign key constraint "c_order_billto"
  Detail: Key (billto_id)=(...) is not present in table "c_bpartner_location".

The business partner is created without location and the log shows:

2024-02-28 09:07:52,646 [Import Entry - 1] ERROR org.openbravo.retail.posterminal.CustomerAddrLoader - Exception while creating BPartner Address
org.openbravo.base.validation.ValidationException: Location.addressLine1: Value too long. Length ..., maximum allowed 60 [...]
    at org.openbravo.base.model.Property.checkIsValidValue(Property.java:835) ~[classes/:?]
Proposed SolutionTwo things should be reviewed here:

1) a record in Errors While Importing POS Data should be created if the import of a location fails
2) it should be controlled if the address is higher than the column size. It can be when creating a new address but also when using an alternate invoicing feature
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0162248)
hgbot (developer)
2024-03-18 06:15

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2505 [^]
(0162419)
hgbot (developer)
2024-03-20 13:46

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.sampledata/-/merge_requests/81 [^]
(0162463)
hgbot (developer)
2024-03-21 11:40

 Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.sampledata [^]
Changeset: a64f04993914e128e1dbfeb3557de869f630d44c
Author: Sabarinath <sabarinath.palanisamy.ext@openbravo.com>
Date: 20-03-2024 18:13:21
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.sampledata/-/commit/a64f04993914e128e1dbfeb3557de869f630d44c [^]

Related ISSUE-54790: Added sample data for CRM customer address name.

---
M referencedata/sampledata/The_White_Valley_Group/C_EXTBP_CONFIG_PROPERTY.xml
---
(0162464)
hgbot (developer)
2024-03-21 11:40

 Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.sampledata/-/merge_requests/81 [^]
(0162465)
hgbot (developer)
2024-03-21 11:41

 Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^]
Changeset: 52f95936526a50a5b73532c1a77b03ffdf38561e
Author: sabarinath palanisamy <sabarinath.palanisamy.ext@openbravo.com>
Date: 21-03-2024 10:41:01
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/52f95936526a50a5b73532c1a77b03ffdf38561e [^]

Fixed ISSUE-54790: Added regx for address property to limit addressname length < 60

---
M referencedata/standard/CRM_Connector_for_Openbravo_Customers.xml
M src-db/database/sourcedata/AD_DATASET.xml
---
(0162466)
hgbot (developer)
2024-03-21 11:41

 Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2505 [^]

- Issue History
Date Modified Username Field Change
2024-02-28 15:02 ngarcia New Issue
2024-02-28 15:02 ngarcia Assigned To => Retail
2024-02-28 15:02 ngarcia Triggers an Emergency Pack => No
2024-02-28 15:02 ngarcia Issue Monitored: networkb
2024-03-04 05:47 SABARINATH P Assigned To Retail => SABARINATH P
2024-03-14 12:48 SABARINATH P Status new => scheduled
2024-03-18 06:15 hgbot Note Added: 0162248
2024-03-20 13:46 hgbot Note Added: 0162419
2024-03-21 11:40 hgbot Note Added: 0162463
2024-03-21 11:40 hgbot Note Added: 0162464
2024-03-21 11:41 hgbot Resolution open => fixed
2024-03-21 11:41 hgbot Status scheduled => closed
2024-03-21 11:41 hgbot Fixed in Version => 24Q2
2024-03-21 11:41 hgbot Note Added: 0162465
2024-03-21 11:41 hgbot Note Added: 0162466

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker