Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0048098 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Web POS | critical | always | 2021-11-17 20:26 | 2022-01-03 09:47 | |||
| Reporter | dromero | View Status | public | |||||
| Assigned To | ranjith_qualiantech_com | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0048098: Error when importing orders from tpv with attributes | |||||||
| Description | Is reproduced in livebuilds: https://livebuilds.openbravo.com/retail_mp_3.0RR21Q4.1/web/org.openbravo.retail.posterminal/?terminal=VBS-1#login [^] I forgot to comment in the video that it happens with products without stock of the attribute entered and that you have to activate the preference Web POS Enable support for product attributes. | |||||||
| Steps To Reproduce | Video explaining how to reproduce the error: https://watch.screencastify.com/v/KpdUH8F5GbGDMk5dzbMF [^] 1.- Check the preference "Web POS Enable support for product attributes" where the field "Value" has to be "Y" 2.- Create an "Attribute Set" with the configuration shown in the video and with an "Attribute" that is of type "Instance Attribute" and has the "Mandatory" checkbox checked. 3.- Go to a product that has not been in stock before and uncheck the "Grouped Product" checkbox. 4.- Go to the Web POS, add the product twice and assign it an attribute 5.- Complete the ticket with above product. Order is not saved in backoffice. Eror Occured org.openbravo.base.exception.OBException: Error in OrderLoader: Error when creating the shipment: Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "m_storage_detail" violates foreign key constraint "m_storage_detail_m_attributese" Detail: Key (m_attributesetinstance_id)=(D2FD04C1E75C47E4947CD020A2630087) is not present in table "m_attributesetinstance". | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0133375) dromero (reporter) 2021-11-25 21:05 |
Hello, Any update? |
|
(0133505) ivazquez (developer) 2021-12-06 16:25 |
Hello Team, Will you have any news? Regards, Ignacio Vazquez |
|
(0133536) hgbot (developer) 2021-12-09 08:50 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/652 [^] |
|
(0133557) hgbot (developer) 2021-12-09 11:55 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^] Changeset: 0e5246cc08e6dc8bd6c1aec7c8f21b4062af9b29 Author: Ranjith S R <ranjith@qualiantech.com> Date: 2021-12-09T10:54:43+00:00 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/0e5246cc08e6dc8bd6c1aec7c8f21b4062af9b29 [^] Fixed ISSUE-48098: OrderLine AttributeSet should be used to create Shipment lines --- M src/org/openbravo/retail/posterminal/utility/ShipmentUtils.java --- |
|
(0133558) hgbot (developer) 2021-12-09 11:55 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/652 [^] |
|
(0133936) swathi_kamal (developer) 2021-12-24 08:26 |
The error continues to reproduce, the case that it did not recreate the attributetesetinstance and that it would use the one from the order line has been solved. But the problem that there is is if there has never been stock of that attribute with which the attributesetinstance does not exist and when the order is processed it gives the same error again. Solved it by adding a flush after creating the attribute. |
|
(0134089) hgbot (developer) 2022-01-02 18:54 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.oms.retail/-/merge_requests/5 [^] |
|
(0134095) hgbot (developer) 2022-01-03 09:47 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.oms.retail [^] Changeset: b47cdf586f22a370fa9883c1be7a31f161d0aaeb Author: Ranjith S R <ranjith@qualiantech.com> Date: 02-01-2022 11:44:01 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.oms.retail/-/commit/b47cdf586f22a370fa9883c1be7a31f161d0aaeb [^] Fixed ISSUE-48098: Data should be saved for every stock transaction * If Product with different attribute value, Stock transaction should be saved for every record --- M src/org/openbravo/oms/retail/hook/StockByWarehouseHook.java --- |
|
(0134096) hgbot (developer) 2022-01-03 09:47 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.oms.retail/-/merge_requests/5 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2021-11-17 20:26 | dromero | New Issue | |
| 2021-11-17 20:26 | dromero | Assigned To | => Retail |
| 2021-11-17 20:26 | dromero | Regression date | => 2021-12-01 |
| 2021-11-17 20:26 | dromero | Triggers an Emergency Pack | => No |
| 2021-11-17 20:34 | Practics | Issue Monitored: Practics | |
| 2021-11-25 21:05 | dromero | Note Added: 0133375 | |
| 2021-12-01 16:46 | egoitz | Regression date | 2021-12-01 => |
| 2021-12-04 06:49 | ranjith_qualiantech_com | Assigned To | Retail => ranjith_qualiantech_com |
| 2021-12-06 16:25 | ivazquez | Note Added: 0133505 | |
| 2021-12-07 12:09 | ranjith_qualiantech_com | Status | new => scheduled |
| 2021-12-07 12:37 | ranjith_qualiantech_com | Steps to Reproduce Updated | View Revisions |
| 2021-12-09 08:50 | hgbot | Note Added: 0133536 | |
| 2021-12-09 11:55 | hgbot | Resolution | open => fixed |
| 2021-12-09 11:55 | hgbot | Status | scheduled => closed |
| 2021-12-09 11:55 | hgbot | Fixed in Version | => RR22Q1 |
| 2021-12-09 11:55 | hgbot | Note Added: 0133557 | |
| 2021-12-09 11:55 | hgbot | Note Added: 0133558 | |
| 2021-12-24 08:26 | swathi_kamal | Note Added: 0133936 | |
| 2021-12-24 08:26 | swathi_kamal | Status | closed => new |
| 2021-12-24 08:26 | swathi_kamal | Resolution | fixed => open |
| 2021-12-24 08:26 | swathi_kamal | Fixed in Version | RR22Q1 => |
| 2022-01-02 07:14 | ranjith_qualiantech_com | Status | new => scheduled |
| 2022-01-02 18:54 | hgbot | Note Added: 0134089 | |
| 2022-01-03 09:47 | hgbot | Resolution | open => fixed |
| 2022-01-03 09:47 | hgbot | Status | scheduled => closed |
| 2022-01-03 09:47 | hgbot | Note Added: 0134095 | |
| 2022-01-03 09:47 | hgbot | Note Added: 0134096 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |