0054468: Print Product Labels: Impossible to add products, product categories in product label option in the POS

Openbravo Issue Tracking System - POS2

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0054468

POS2

[Retail Modules] Web POS

public

2024-01-25 09:59

2024-02-01 14:42

Reporter

nicola_uva

Assigned To

SABARINATH P

Priority

high

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Gold

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.product.label.printing/-/merge_requests/28 [^]

Triggers an Emergency Pack

Summary

0054468: Print Product Labels: Impossible to add products, product categories in product label option in the POS

Description

On the webpos when we call

org.openbravo.mobile.core.service.jsonrest/org.openbravo.pos2.product.label.printing.master.ProductExtension?$timeout=5000

We got following error “Syntax error“:

org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: , near line 1, column 331

When createStockProductHql is called at the end is added “,“ but if printProductLabelHQLProperties.getHqlSelect() return null/empty we added a new “,“ and that cause the SQL QuerySyntaxException.

NOTE:
To reproduce the error you should NOT install org.openbravo.product.label.printing.commercialoperations

Steps To Reproduce

1. Configure print product labels
2. On WEBPOS click on the menu item "Print Product Labels"
3. full fill the form
4. type the product you want to print
5. Error is showed in the POS

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

duplicate of

defect

0053502

closed

ranjith_qualiantech_com

org.openbravo.pos2.product.label.printing module fails to load products

Attached Files