Openbravo Issue Tracking System - POS2
View Issue Details
0045455POS2POSpublic2020-11-17 16:412020-12-17 14:47
jmelin 
Retail 
highmajoralways
closedduplicate 
30Openbravo Appliance 14.04
pi 
 
No
0045455: Import error for order with an auto-completed menu
If the order contains an auto-completed menu (you select products that are automatically converted in a menu they belong), then the order failed to load.

It's because the menu category id is filled with the menu group id.

When selecting and completing a menu, the id is correctly filled.


1. Create a new ticket
2. Select different products that can be converted to a menu
3. When the last product is selected, the menu appears a the POS and the product are part of the menu
4. Pay the order

In the BO, the order is not loaded the exception
org.postgresql.util.PSQLException: ERROR: insert or update on table "obrest_orderline_menu_item" violates foreign key constraint "obrest_ol_mi_menucat"
  Detail: Key (obrest_menu_category_id)=(XXXXXX) is not present in table "obrest_menu_category".
  
  
No tags attached.
duplicate of defect 0045620 closed AugustoMauch Autodiscovery menu process not working properly for menu that contain grouped categories 
pdf Import error for order with an auto-completed menu.pdf (724,375) 2020-11-17 16:41
https://issues.openbravo.com/file_download.php?file_id=15094&type=bug
Issue History
2020-11-17 16:41jmelinNew Issue
2020-11-17 16:41jmelinAssigned To => Retail
2020-11-17 16:41jmelinFile Added: Import error for order with an auto-completed menu.pdf
2020-11-17 16:41jmelinTriggers an Emergency Pack => No
2020-11-25 12:33guilleaerStatusnew => scheduled
2020-11-25 12:33guilleaerAssigned ToRetail => AugustoMauch
2020-12-01 17:25guilleaerStatusscheduled => resolved
2020-12-01 17:25guilleaerResolutionopen => fixed
2020-12-01 17:25guilleaerStatusresolved => new
2020-12-01 17:25guilleaerResolutionfixed => open
2020-12-01 17:25guilleaerAssigned ToAugustoMauch => Retail
2020-12-01 17:47guilleaerTag Attached: P1
2020-12-01 19:06guilleaerTag Detached: P1
2020-12-17 14:47AugustoMauchRelationship addedduplicate of 0045620
2020-12-17 14:47AugustoMauchStatusnew => closed
2020-12-17 14:47AugustoMauchResolutionopen => duplicate

There are no notes attached to this issue.