0058002: Cannot filter by characteristics using the ProductSimple selector

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0058002

Openbravo ERP

A. Platform

public

2025-02-17 12:24

2025-02-17 13:45

Reporter

caristu

Assigned To

Triage Platform Base

Priority

high

Severity

major

Reproducibility

have not tried

Status

new

Resolution

open

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Production - Confirmed Stable

Regression date

Regression introduced in release

3.0PR20Q1

Regression introduced by commit

https://gitlab.com/orisha-group/bu-commerce/openbravo/product/openbravo/-/commit/52847f60c0f58d82cf5add0302aaf1d3bf0b1229 [^]

Triggers an Emergency Pack

Summary

0058002: Cannot filter by characteristics using the ProductSimple selector

Description

Cannot filter by characteristics in the product selector of the Sales Invoice window (ProductSimple), because of the following error:

2025-02-17 11:20:36,507 [http-nio-127.0.0.1-8080-exec-16] ERROR org.openbravo.materialmgmt.ProductCharacteristicsDS - Error building characteristics tree
org.hibernate.QueryException: Named parameter not bound : clients
    at org.hibernate.query.internal.QueryParameterBindingsImpl.verifyParametersBound(QueryParameterBindingsImpl.java:211) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
    at org.hibernate.query.internal.AbstractProducedQuery.beforeQuery(AbstractProducedQuery.java:1511) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
    at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1615) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
    at org.openbravo.materialmgmt.ProductCharacteristicsDS.getAllNodes(ProductCharacteristicsDS.java:292) ~[classes/:?]
    at org.openbravo.materialmgmt.ProductCharacteristicsDS.fetch(ProductCharacteristicsDS.java:105) [classes/:?]
    at org.openbravo.service.datasource.DataSourceServlet.doFetch(DataSourceServlet.java:271) [classes/:?]
    at org.openbravo.service.datasource.DataSourceServlet.doPost(DataSourceServlet.java:324) [classes/:?]

Steps To Reproduce

1) Go to the Sales Invoice window
2) Create a new record in the header
3) Switch to the lines tab, create new record
4) Click on the magnifying glass button on the product selector and try to filter using the characteristics filter. It is not possible and the error mentioned in the description is appearing in the log.

Proposed Solution

Additional Information